Advanced Excel Training - Ortigas

This training is for those who already has an existing knowledge of Basic MS Excel. (You may also join the Basic Excel Training of the previous day to prepare yourself for the Advanced Excel Training-- link here:
Basic Excel in Makati: https://www.eventbrite.com/e/basic-excel-training-makati-tickets-53778436752
_____________________
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
Notes:
1. Bring own laptop
2. Lunch included
3. Handouts and certificate will be given
Outline:
Module 1: Quick Review of Basic Functions
Text Functions UPPER LOWER PROPER LEFT RIGHT MID CONCATENATE
Basic Logical Statements IF
Basic Math Functions SUM AVERAGE
Basic Lookup Functions VLOOKUP
Combining Functions
Module 2: Advanced Excel Functions
Text Functions TRIM, SUBSTITUTE
Combing Logical Tests using AND and OR
Advanced Math Functions SUMIFS, COUNTIFS, AVERAGEIFS
Advanced Lookup Functions: INDEX and MATCH
Module 3: Advanced Data Tools
Creating Own Conditional Formatting
Data Validation with Formulas
Subtotal Tool
Module 4: Advanced PivotTables
Review of Basic PivotTables
Grouping
Slicers
Calculated Fields
PivotCharts
If time permits: Macro Recording