The Advanced MS Excel course will level up your skill in order to efficiently process data in the spreadsheet. This course goes beyond VLOOKUP-- you will learn to look up data regardless of data orientation. You will also learn how to make advanced pivot table features such as Calculated Fields, Slicers, etc.
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Bring own laptop (or rent for additional Php500)
Inclusions: Colored handout, coffee, WiFi, Certificate, AM and PM Snacks, Lunch
Outline
Review of Basic Excel Functions
Text Functions
Math Functions
Date Functions
Advanced Excel Functions
Logical Functions
Lookup Functions
Data Management
Advanced Conditional Formatting
Data Validation
Basic Dropdowns
Advanced Dropdown Options
Other Data Validation Options
Subtotal Tool
PivotTables
Creating and Using PivotTables
Drill Down
Using Tables
Calculated Fields