Xu Juntai's "21 Excel Function Lessons, Complete a Day's Work in 5 Minutes"

The EXCEL workplace office series of courses starts from the work needs of office staff and, with a large number of typical examples, comprehensively and systematically explains the office applications of EXCEL in secretarial work, human resources, statistics, finance, marketing and other fields, helping you to complete various tasks easily and efficiently. The content is easy to understand and highly practical.

Xu Juntai's "21 Excel Function Lessons, Get a Day's Work Done in 5 Minutes" Course Catalog:

00 Preliminary Course - Table ≠ Excel, Excel is a magical tool if used well, but just a table if not used well.mp4 34.94M

[Easter Egg Lesson 1] - The most powerful analysis tool - Pivot Table, a skill learning tool for young people.mp4 258.99M

[Easter Egg Lesson 2] - Summary of Pivot Table Skills - How to Use Pivot Tables for Data Analysis - A Skill Learning Tool for Young People.mp4 171.05M

[Easter Egg Lesson 3] - Excel's most complete shortcut keys are a great tool for young people to learn skills.mp4 191.15M

Lesson 01 - Grammar: Easy to understand and not to forget, 1 logic applies to 10 formulas.mp4 219.93M

Lesson 02 - Quote: Copy formulas without mistakes to avoid wasted efforts and rework.mp4 38.38M

Lesson 03 - Format Conversion: Unify different data formats? "Shua" to automatically standardize in an instant.mp4 76.35M

Lesson 04 - Text Processing: Master these functions and complete text processing in 10 seconds.mp4 90.62M

Lesson 05 - Data Summary: A few simple steps to make even the most complex data clear at a glance.mp4 83.04M

Lesson 06 - Conditional Statistics: Mastering conditional statistics allows you to see the essence through data.mp4 66.11M

Lesson 07-Time Function: Without looking at the calendar, a few functions can help you calculate the date.mp4 89.30M

Lesson 08 - Data rounding: rounding problems in functions, helping you quickly determine when to take a large or small value.mp4 37.38M

Lesson 09 - Data Matching (1): VLOOKUP, the fighter among functions, teaches you all the tricks in one lesson.mp4 124.04M

Lesson 10 - Data Matching (2): Better and simpler than VLOOKUP, these query functions are just as useful..mp4 163.27M

Lesson 11 - Logical Function: People with confused thinking don't know the N secrets of structured thinking...mp4 80.75M

Lesson 12 - Array Calculation: Simplify operations and save time, complete 10 groups of operations in one step! A skill learning tool for young people...mp4 70.19M

Lesson 13 - A function that conquers the world: Sumproduct function is more powerful than you can imagine. A magical tool for young people to learn skills...mp4 116.75M

Lesson 14 - King of Summarization: The most powerful statistical function Subtotal, you will know its power after using it. A great tool for young people to learn skills...mp4 114.84M

Lesson 15 - King of Summarization: Subtotal function summarizes hidden reports, one specialty, multiple functions, easy to handle.mp4 44.77M

Lesson 16 - Database Functions: Constructing Conditional Areas and Flexibly Processing Report Statistics.mp4 51.90M

Lesson 17 - Indirect function: Using indirect reference to achieve cross-table calculation and secondary menu production.mp4 150.16M

Lesson 18 - Micro chart simulation: Using indirect reference to achieve cross-table calculation and secondary menu production.mp4 67.44M

Lesson 19 - Macro table function: Do you know how convenient the functions in the name manager are?.mp4 67.50M

Lesson 20 - Case Application 1: Writing a one-to-many work email, does it take 1 hour to select the primary and cc?.mp4 103.19M

Lesson 21 - Case Application 2: Public account historical article extraction and reading trend statistics young people's skill learning tool.mp4 71.69M