About the Event
The Advanced MS Excel Training 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.
Topics:
1. Advanced Functions
- Text Functions
- Logical Functions
- Conditional Math Functions
- Advanced Lookup Functions
2. Data Management
- Text-to-Columns
- Conditional Formatting
- Data Validation
- Subtotal
3. Pivot Tables
- Basic Pivot Table Features
- Advanced Pivot Table Features
4. Macro Recording
Fee: Php2100 (Early Bird), Php2500 (Regular Rate)
For cash or other non-credit card payment types, please email info@insightsmanila.com.
For more details visit Insights Manila.