Class introduction

Becoming an ordinary person with Excel skills,

Specific guidelines for companies to gain time

No wonder Excel is difficult. Strangely enough, if you only learn basic skills Excel is easy I can feel it.

In fact, I only know what was in this lecture.

Nevertheless, I was able to be an Excel instructor in Class 101. I was able to become an Excel instructor as an ordinary person

Short and thick Unveiling all Excel know-howI will.

_{Basic settings you must know when starting Excel}

_{A collection of essential functions in Ilzaler}

_{Know-how to create reports recognized by superiors using Excel}

Dear classmates Are you ready to listen to the course now?

At work”Good at ExcelYou'll hear that.” Reports, fact sheets, and reports produced by the company

Data management and processing are pretty much the same. A kind of 'Excel formulaIf you know ', you can do better than anyone else, right?

The time spent trying to make an Excel strategy book was eventually born as a special strategy book.

We are now releasing a collection of all Excel strategies for people with Excel skills. Surprisingly, there are no advanced techniques that are difficult.

There are only methods that anyone can follow and anyone can do.

You too can become an Excel person.

A 'real Excel' class as evidenced by numerous reviews of the first class

You can definitely get “this” one

• Even beginners who don't know Excel at all 'Excel Strategy Collection'Through 'People with Excel skills'It could be

• Over 90% of office workers can learn how to use know-how and functions that most people don't know.

• You can create your own techniques that anyone can easily follow.

• You can learn all the important and necessary features, important functions, charts and reports, dashboards, and even the basics of macros.

I recommend it to people like this

• People who don't know where to start with Excel

• Those who want to learn Excel from A to Z easily

• Those who want to make difficult and uninteresting Excel fun

• Those who want to become an Excel person for a short period

Notes before taking the course

• This class is available in all versions of Excel. (However, the xlookup function is only available for Excel 2021 or higher and Ms Office 365 versions)

3 reasons this class is special

❶ You've only learned basic deception, but you've become an “Excel person”?

Did you know that you can create your own shortcuts for frequently used functions?

Hover over the top menu each time and click Center Alignment.. If you clicked, you can now easily sort by simply pressing ALT + number.

_{Chapter 1-1. Examples of basic settings you should know when starting Excel}

Also, did you struggle with so many functions?

In fact, even if you only know the three types of functions, you can do “good” reports, data processing, and management, which are difficult.

When I emphasize “well,” I want to share the know-how to be able to work several times faster than others.

(Chapter 2-1. (Examples of functions vlookup/index, match/xlookup, which are essential in Excel)

❷ You think all manual tasks can be automated in a simple way?

Actually, table creation is the most important thing in Excel. Did you know about the automatic table function?

If you create and edit a table, the data will definitely be wrong and there will be missed parts, but now it's much easier to manage even if you only know this.

(Chapters 1-2. (An example of creating the most important table in Excel)

Also, if you just change the value, the cell color, increment display, number color, etc. will automatically change accordingly.

Anyone can create these features with 2 to 3 clicks.

(Chapter 4-2. (An example of a public disclosure of know-how to play with Excel data)

❸ Advanced features are easy to learn?

Are features like charts, reports, and macros difficult? This is definitely not the case.

But you don't think you'll get high quality just because it's easy to learn?

(Chapter 3-1. (Master example of creating a chart in Excel from A to Z)

(Chapter 3-3. (Example of creating a dashboard in Excel Macro No anyone Ok)