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
courses
1091
Views
12/12/2018 Last update