36 lessons to help you become an Excel expert

36 lessons to help you become an Excel expert

Contents: /36 lessons to help you advance from a novice to an expert in Excel (completed)

┣━━Supporting exercises [1.6M]
┃ ┣━━01 Chapter 1 (Note: No exercises are required for this chapter) [0B]
┃ ┣━━02 Chapter 2 [130K]
┃ ┃ ┣━━2.1 Data entry specifications.xlsx [28K]
┃ ┃ ┣━━2.2 Time and date format.xlsx [11K]
┃ ┃ ┣━━2.4 General electronic spreadsheet format.xlsx [48.2K]
┃ ┃ ┣━━2.5 Tips for quick entry and positioning.xlsx [29.4K]
┃ ┃ ┗━━2.7 Case-Sales Data Report.xlsx [13.3K]
┃ ┣━━03 Chapter 3 [79.1K]
┃ ┃ ┣━━3.2 vlooup function.xlsx [12.2K]
┃ ┃ ┣━━3.3 IF function.xlsx [14.4K]
┃ ┃ ┣━━3.4 Match and Index.xlsx [21.1K]
┃ ┃ ┗━━3.5 excel20 functions.xlsx [31.4K]
┃ ┣━━04 Chapter 4 [563.1K]
┃ ┃ ┣━━Highlight data.xlsx [21.4K]
┃ ┃ ┣━━Micro chart.xlsx [23.9K]
┃ ┃ ┗━━SparklinesCn-X64.xlam [517.8K]
┃ ┣━━05 Chapter 5 [249.4K]
┃ ┃ ┣━━PivotTable.xlsx [102.4K]
┃ ┃ ┗━━Application of Pivot Table.xlsx [147K]
┃ ┣━━06 Chapter 6 [423.3K]
┃ ┃ ┣━━Creative chart.xlsx [147K]
┃ ┃ ┣━━Interactive dynamic chart.xlsx [54K]
┃ ┃ ┣━━Enterprise dashboard.xlsx [58.8K]
┃ ┃ ┗━━Excel chart.xlsx [163.6K]
┃ ┣━━07 Chapter 7 [56.4K]
┃ ┃ ┣━━Three tables in one.xlsx [31.3K]
┃ ┃ ┗━━Difficult problems in printing charts.xlsx [25.1K]
┃ ┗━━08 Chapter 8 [136.3K]
┃ ┣━━Financial system.xlsx [30.6K]
┃ ┗━━Bank asset management.xlsx [105.7K]
┣━━Bonus: Excel template.rar [170M]
┣━━Lesson 01 Preliminary Lesson: How to Learn Excel Correctly.mp4 [18.3M]
┣━━Lesson 02 OCR technology fast input.mp4 [20.7M]
┣━━Lesson 03 How to import data from a web page.mp4 [11.3M]
┣━━Lesson 04 How to use Jiandao Cloud to quickly collect data.mp4 [18.8M]
┣━━Lesson 05 Data Standardization: Without Standardization, Everything Is In vain.mp4 [13.4M]
┣━━Lesson 06 What is the correct time format.mp4 [26.4M]
┣━━Lesson 07 Why long strings of numbers are always incomplete.mp4 [14.2M]
┣━━Lesson 08 General format of tables: No more mistakes with this.mp4 [37.9M]
┣━━Lesson 09 Quick Input Method: Be One Step Faster From Now on.mp4 [34.6M]
┣━━Lesson 10 Applying table format: Easily complete data entry.mp4 [31M]
┣━━Lesson 11 Practical Example: How to Standardize Sales Data Table.mp4 [41.3M]
┣━━Lesson 12 Understanding functions: Are there so many functions? Do I have to memorize all of them?.mp4 [20.4M]
┣━━Lesson 13 Vlookup function quickly checks data.mp4 [14.2M]
┣━━Lesson 14 IF function: Let the system make automatic judgments.mp4 [14.4M]
┣━━Lesson 15 index and match functions.mp4 [32.2M]
┣━━Lesson 16 Auxiliary functions: Help you complete your work quickly and well.mp4 [39.8M]
┣━━Lesson 17 Micro charts: Make your data more intuitive.mp4 [11.3M]
┣━━Lesson 18 Custom rules: Make data clearer.mp4 [11.1M]
┣━━Lesson 19 Quickly discover outliers or key points.mp4 [18.5M]
┣━━Lesson 20 Pivot Table: Just click and drag to display it! .mp4 [11.8M]
┣━━Lesson 21 Data is not standardized, and pivot tables are useless.mp4 [18.6M]
┣━━Lesson 22 How to beautify the pivot table to make it clear and beautiful.mp4 [21.1M]
┣━━Lesson 23 Make reports easily, click where you want to see.mp4 [53.1M]
┣━━Lesson 24 Charts: How to make professional charts.mp4 [17.9M]
┣━━Lesson 25 Composite charts: more diverse information presentation! .mp4 [7.9M]
┣━━Lesson 26 The boss will definitely like this beautification of the chart! .mp4 [15.9M]
┣━━Lesson 27 You can also make these awesome creative pictures! .mp4 [21.7M]
┣━━Lesson 28 Interactive Charts Make Your Charts Interactive.mp4 [22.4M]
┣━━Lesson 29 Examples of enterprise-level applications of charts.mp4 [27.2M]


┣━━Lesson 30 Solving the Difficult Problems of Form Printing.mp4 [18.7M]
┣━━Lesson 31 Interaction between charts, PPT and Word.mp4 [10.9M]
┣━━Lesson 32 How to merge multiple tables quickly and effectively.mp4 [8.6M]
┣━━Lesson 33 How to improve the aesthetics of chart beautification.mp4 [16.2M]
┣━━Lesson 34 Practical Case (I): Refined Bank Management.mp4 [56.3M]
┣━━Lesson 35 Practical Case (II): Making a Financial System.mp4 [41.2M]
┗━━Lesson 36 Practical Case (III): Platform Data Analysis.mp4 [119M]

<<:  6.18 is coming, how to make better use of coupons?

>>:  Optimize your information flow by taking these two steps and the effect will increase!

Recommend

[Case sharing] How did she gain 1 million followers in just two months?

1. My date was disrupted I was supposed to go on ...

Analysis of the operational process of Tik Tok advertising promotion model!

How are advertisements for products searched on J...

Give you a complete set of community operation solutions

The value of WeChat groups, QQ groups, and Zhangh...

Does drinking coffee really help you lose weight?

Losing weight seems to be a topic that people are...