Brand New Course Exclusively by Office Instructor
Prerequisites
To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Intermediate Level (Code: 20135)
Goal
Learn how to create a dynamic worksheet that summarises thousands of records in just few cells. You will also learn advanced Conditional Formatting to take your worksheets to the next level.
Among the Course Topics
1. Create a Searchable Drop List
2. Create Dependent Drop lists
3. Pivot Tables and Drop lists
4. Create multiple drop lists in one cell.
5. Switch functions with drop lists.
6. Tips and Tricks with Conditional Formatting
7. Conditional Formatting in Charts
8. Multicolor Data Bar
9. Create a Comparison Dashboard
10.Dynamic Arrays with Drop Lists
11.Create 6 Levels of Dependency
12.Conditional Formatting with Functions
13.Tips and Tricks in Conditional Formatting.
14.Conditional Formatting in Pivot Tables.
15.Chart Title Drop List.
