Excel Intermediate Tutorial

Deskripsi:

This video provides an intermediate-level tutorial on Microsoft Excel, covering the interface, basic formulas, sorting and filtering techniques, chart creation and formatting, pivot tables, and advanced functions such as XLOOKUP and database functions. It also introduces macros and automation to save time. Start 0:00 Introduction 0:09 Creating Tables 0:54 Flash Fill 7:54 Introduction to Sorting Data 12:01 SORT Function 18:45 SORTBY Function 21:32 UNIQUE Function 23:21 Filters 25:44 Slicers 31:11 Subtotals 34:53 Quick Analysis Tool 40:01 Inserting Charts 41:11 Formatting Charts 43:33 Creating Chart Templates 49:30 Printing Charts 51:15 Using Sparklines 52:29 Introduction to Pivot Tables 56:28 Pivot Charts 1:04:43 Using Slicers with Pivot Tables 1:07:40 Data Validation 1:11:53 Conditional Formatting 1:23:36 Custom Conditional Formatting 1:27:16 Linking Data 1:31:51 Conclusion 1:33:39