Associated Courses




Topics Covered in Excel Advanced

1.  Use Tables
2.  Analyze Data with Pivot Tables
3.  Use Countif and Sumif Functions
4.  Use Advanced Text Functions
5.  Understand the Vlookup Function
6.  Do Magic with the If Funtion
7.  Use the PMT Function
8.  Use Flash Fill
9.  Use Advanced Sorting
10.  Use Advanced Filters
11.  Apply Conditional Formatting
12.  Use Advanced Chart Options
13.  Use Data Tools
14.  Use What-if Tools
15.  Import and Export Data
16.  Auditing Worksheets
17.  Record and Run Macros
18.  Share Workbooks
19.  Compare and Merge Workbooks
20.  Customize the Ribbon