How to make money in 2021? A course to earn 70,000 yuan a month with Excel!

25 exquisite video lessons, with real teachers teaching on camera, daily scenarios + underlying logic + solutions + question answering, teaching you how to use 20 commonly used functions. Easily master the solutions to 30 common problems, learn 80 Excel knowledge points without realizing it, thoroughly master the 8 major Excel usage principles, cultivate data thinking, and comprehensively analyze and solve problems

Course Catalog:

01. Table principle: Understand this logic, even a novice can play with Excel

02. Data entry: ID number and date are garbled? Here's why

03. Date functions: 4 functions help you automatically calculate various date problems

04. Data security: encryption, hiding, and anti-modification, easily protecting important data

05. Conditional formatting: automatically mark table colors to highlight data

06. Calculation principle: If you calculate the money correctly, it will be difficult for your boss not to give you a raise.

07. Naming control: Data names are not uniform? Drop-down menu naming is key

08. Data matching: 5 tips to solve VLOOKUP function errors

09. Approximate matching: Use the VLOOKUP function to search for data quickly and accurately

10. Multi-condition search: one-to-one and many-to-one search, easy to complete

11. Dynamic charts: 2 functions to automatically switch between reports and data sources

12. Sorting numbers: Use the COUNT family of functions to handle various rankings

13. Find summary: hide #NA, delete duplicates, and make the table tidy

14. Data linkage: Teach you step by step to create a high-end secondary linkage menu

15. Automatic filtering: a commendable data search technique, simple and practical

16. Advanced filtering: Become an expert in seconds, and make even the most complex data simple

17. Batch operation: record macros to help you complete repetitive tasks with one click

18. Classification summary: quickly view the summary of different categories at a glance

19. Positioning conditions: fill in duplicate data with one click, and restore the table with one move

20. Pivot table: interactive data analysis, making reports visual

21. Classification and combination: automatically analyze and count dates according to year, month and day

22. One table for multiple reports: One table can be turned into multiple reports in just 10 seconds

23. Dynamic data sources: let your pivot table automatically update

24. Create charts: Set up all common charts in one sentence

25. Answering questions: 5 common mistakes to help you avoid detours