unlock

How to Create & Use Excel Macros (Real world example)

0:00
↔️ ↕️

Timecodes:

Why use Excel Macros?

Well, if you want to automate boring tasks,

like copying and pasting data from one place to another,

creating reports or update formatting of your reports

then Macros are going to help you do that with one click.

So let's say you received this dataset on a weekly basis,

and sometimes it's shorter, sometimes it's longer,

but every time you need to create a chart

that looks like this.

Now every time you have to remember and apply to same steps.

What you could do instead is to record those steps once,

so that every other time you just have

to click a button to get it all done.

That's what Excel Macros can do.

Let me show you.

(upbeat music)

Here, I have information about the position,

the average salary and the company average salary.

Now, I have this information by different departments

each is sitting in its own tab

but notice sometimes I have more data


Related queries:


how to remove excel password protected file
how to open excel password protected file online free
how to unlock excel password protected sheet
how to remove excel password protected sheet
how to get into excel password protected file
how to open ms excel password protected file
how to unlock excel 2007 password protected sheet
how to unlock password protected excel file without software used
how to unlock password protected excel 2003 file