Full steps to make an excel table, table making tutorial introductory video

Impressing the boss with hard work is the biggest lie in the workplace

Recently, there is a hot topic on Zhihu. Will hard-working employees impress the boss?

I looked through nearly 3,000 answers and found that the answers were surprisingly consistent: no!

No boss will be moved by the efforts of employees unless you bring real value;

I can pretend to be moved to orgasm, but make me pay for it, sorry;

If you always work late and do some time-wasting work, I advise you not to impress your boss.

The reason why I talk about this topic is that I found that most people around me often mistakenly think that hard work = result , thinking that if I work hard, I can get a promotion and a salary increase.

Take my former colleague Xiao Li as an example. She is very diligent. In order to calculate the storage and storage, she often works overtime until the early morning .

I'm curious, I'm a small company, do I have so much data to count?

Until one day, I found that Xiao Li couldn't even vlookup, so he typed out an A4 sheet, checked the data one by one against the computer, occasionally encountered formula operations, and tapped on the calculator next to him .

The company checks hundreds of pieces of data every day, so it's no wonder she doesn't work overtime in this way.

Sympathetic to her experience, I decided to teach her a few commonly used formulas.

Unexpectedly, she was already accustomed to the manual method and still operated in a stupid way.

Later, with the layoffs at the end of the year, she was the first to be laid off. Now that several years have passed, she is still doing the basic work when she just graduated.

And Xiao Zhao, who is in her group, can complete the tasks assigned by the leader accurately and efficiently every time because of his mastery of software operation.

It takes less than 3 steps to calculate and never goes wrong:

All the data for the leaders are presented in the report, which is clear at a glance:

In this way, Xiao Zhao not only won the respect of his boss, but also used the time he did not work overtime to read books, do research, and fall in love , realizing a double harvest of career and love.

Those who do better than you without your efforts are the ones that leaders really value.

Being proficient in Excel doesn't necessarily guarantee you a promotion and a salary increase, but the time saved by being proficient in using the tool is enough to allow you to do more powerful personal growth things.

So, do you really dare to write 5 words proficient in Excel on your resume?

I don't think so!

If you encounter a problem, go to Baidu, but you can't understand it for a long time, and you still use the oldest and most stupid method;

Favorites countless shortcut keys, formula functions, but do not know how to use, still lying in the favorites;

After a painful remorse, I signed up for Excel online work. There are too many technical terms, and I can't watch it after a few episodes.

Is Excel really too difficult?

of course not!

The problem is that Excel has a lot of function keys, and it takes a systematic study and understanding of the operating principle to get started.

Between you and Excel, there is only one good teacher who can explain all these problems.

To this end, we have invited Zhang Zhuo , a lecturer of Microsoft Golden Microphone , an Office lecturer of Fortune 500, and a special Office lecturer from the British Embassy, Shanghai Pudong Development Bank, National Bureau of Statistics , and China COSCO , to help you master Excel once and become an overtime worker in the workplace. The group of people who are less, take more money, and grow fast.

From poor student to Excel master

He only spent a month and a half

Don't look at Zhang Zhuo's glamorous appearance now, you would never have imagined that there is a story of a Jedi counterattack hidden behind this.

During the college entrance examination, he was only admitted to a very ordinary university. When he thought about the gap between the future and those famous school classmates, he felt a deep sense of inferiority.

Anxiety didn't solve the problem, and he decided to catch up .

He heard that the basic condition for mastering a high salary is to master proficient computer office skills, so passing the Microsoft engineer certification became his first small goal .

Since then, he has spent all the time others use to play games, go shopping, and take a lunch break to learn the knowledge of network operating systems.

Finally, during the summer vacation of his freshman year, he passed 7 English tests in a row and became one of the earliest MCSE2000 network engineers in the world .

The world's top 5,000 engineers won the exclusive gold card for MCSE2000 engineers

He said that there is nothing I can't do. It took him only one semester to go from a novice to a computer expert, and it took only one and a half months in total.

With strong professional skills and high-quality certificates, he had already received offers from several Fortune 500 companies in Beijing and Shanghai before he graduated.

In the end, he chose the then domestic Microsoft engineer and Office expert certification organization to teach Microsoft Office courses.

Due to the strong operability of this course and the many problems of students, Excel became the most reluctant course for teachers at that time.

However, Zhang Zhuo wrote down the students' questions every time. After returning home, he devoted himself to researching the teaching method until he vividly explained the operation steps.

The originally boring course turned out to be as interesting as a variety show, and the students solved one problem after another in constant laughter.

Once, the headquarters of China Construction International Group invited Zhang Zhuo to do an Office training for employees.

But at the end of the training, with his excellent teaching skills, the corridors were crowded with people. Even the chefs of the hotel stood in the back row and listened to his class with relish , saying that he had never touched a computer before and could understand him Excel, amazing!

This year, Mr. Zhang Zhuo gave more than 100 lectures to Fortune 500 companies, and his annual salary exceeded one million, which was still 11 years ago in 2009.

A succession of companies began to know about this talented teacher who can explain Excel thoroughly, and wanted to hire him with a high salary, of course, including the company he yearned for when he was in college - Microsoft China .

Appointed by Microsoft as Golden Microphone Lecturer

He has helped countless Fortune 500 companies improve efficiency

Entering the mother of Office design - Microsoft, which specializes in Office , isn't this what he dreams of?

At Microsoft, he had the opportunity to go deep into the Office R&D team and understand the design principles and application logic behind each Office component.

With the continuous improvement of his major, he became a Microsoft Certified Tutor (MCT). His humorous teaching style and bilingual teaching level in both Chinese and English made him a very popular Office lecturer in foreign companies.

During this period, he trained more than 500 companies, conducted more than 2,000 training sessions, and won the title of " Microsoft Golden Microphone Lecturer ".

Of course, he is often sent to "get" key clients, or "fight fires."

Once, Alstom, a top 500 company in France at the time, invited him to solve a difficult problem. It turned out that their human resources department often worked overtime for several days at the end of the year and couldn't make a summary.

He came to the scene and asked about the ins and outs, and found that there was a problem with the design idea of this Excel table .

Like most people's mistakes, the watchmakers did not handle the format properly in order to pursue good-looking when making watches, and made a "display cabinet" model.

The table made by this method cannot be used for data analysis at all, and it is a "dead table".

As a big cousin, how could he stand by and help him dismantle the problem immediately, clarify his thoughts, and help users turn corruption into magic, and turn "dead watch" into "live watch" .

Since then, Alstom Group has to work overtime to make several overnight reports at the end of the year, which only takes a few minutes to complete .

This incident also made him understand that whether a table can be done well depends not on how many functions or shortcut keys there are, but on understanding the logic of using Excel as a tool.

Only by killing the problem at the source can you avoid the fuss in the later stage.

such as these

Only by understanding the principle of table types can you avoid building a "dead table";

Understand the principle of format to avoid errors and rework;

Understand the principle of calculation, in order to avoid repeating inefficient operation steps...

You must know that all the functions of Excel are designed for the convenience of people. If you always make mistakes, you must not understand the rules.

The best way to test yourself is to teach people

He is determined to be the most powerful Office trainer in China

Since then, he has realized that the traditional teaching methods such as explaining Excel functions in menu order and explaining functions without application scenarios cannot solve user problems from the root cause, and it is easy to forget them as soon as they learn.

He decided to abandon the traditional way and teach in a "workflow" way, so that students can really get solutions to various Excel common problems and the underlying logic of Excel .

Only the training that allows users to understand the underlying logic and integrates solutions to various problems is truly effective and meaningful.

To this end, he decided to leave Microsoft and devote himself to Office education and training.

His hard work pays off. So far, he has trained more than 800,000 students . Many students have taken his courses. They never memorize various calculation formulas by rote, but they all use vlookup, countif, pivot table, and report. Waiting for various calculation methods to be thoroughly familiar with!

With the continuous spread of his reputation in the industry, he has also become a special Office lecturer for universities, institutions, enterprises and institutions such as the Ministry of Industrial Information , Tsinghua University, China Mobile Research Institute , Chinese Academy of Sciences , Cheung Kong Graduate School of Business, and CIIC Group.

Excel is everywhere

Learn it and your life will be different

Excel has become an essential quality in the contemporary workplace.

To be an administrator, you must be able to make an attendance sheet;

To do finance, you must be able to make financial statements;

To do sales, you must be able to make a sales performance report;

To do operations, you must be able to do data analysis and make operational decisions;

...

In almost any industry, once you know Excel, you will not only do it quickly and well, but also in a clear and organized way.

Of course, not only in the workplace, but in life, if you master it, you will have one more capable assistant.

Teacher Zhang Zhuo's students are still playing like this:

1. Household income and expenditure → Quickly analyze household income and expenditure, and better control expenditure behavior.

After Xia Qing gave birth to her child, she became a housewife at home, but managed every expense at home in an orderly manner through Excel, which made her husband very worry-free and bluntly said that she could not do without her.

Xia Qing's recent family financial statement

In the end, her husband directly entrusted all the money to her , and became an enviable family combination of " you are responsible for making money and supporting your family, and I am responsible for being beautiful and beautiful" .

Xia Qing's recent home decoration budget table

2. Business Assistant → No need to buy industry software at a high price, easily manage customer and incoming and outgoing data.

Xiaoyu started a micro-business on the Internet in order to make more money in her amateur life. At first, she only used a notebook to write down. In the end, she even understood what she wrote down, and she always lost money unknowingly.

After learning the teacher's Excel, I can not only understand the purchase, sales and inventory clearly , but also analyze the purchase strategy . Now I can earn 1,000-2,000 yuan in living expenses every month.

Xiaoyu uses Excel for sales analysis

3. Hobby assistant → travel consumption budget, manual enthusiasts can quickly calculate formula and cost.

Xiao Zhao is a handmade soap entrepreneur. Making essential oil soap requires the saponification reaction of oil and strong alkali. If you manually calculate the results of the chemical reaction, it is very difficult to be accurate.

After being recommended by a friend to learn Excel systematically with Mr. Zhang, I even designed a calculation model of essential oil soap by myself , and experimented with a variety of essential oil soaps, which are now flourishing.