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 |
<<: How did we gain 1.5 million new WeChat followers through one event?
>>: The secrets of Douyin App's operation and promotion routines
This article is compiled from the open course joi...
When it comes to radiation, many people will thin...
Leonardo da Vinci's "Mona Lisa" is ...
If you ask “What is the hottest keyword on the In...
1. Introduction I have to sigh that the architect...
At present, short videos, as a dark horse in traf...
[[244605]] The first commercial version of Androi...
I wish you all a happy Labor Day. Here are the mo...
Recently at the Guangzhou Auto Show, Tesla releas...
This is a relatively hardcore article. In additio...
Itch is the main theme of summer I can't get ...
Android Directory Structure data app: User-instal...
The working dogs we hear more about in our lives ...
All methods of gaining traffic are designed as ba...
Everyone must have heard the debate about which i...