LOOKING FOR RATES AND SCHEDULES
​TO JOIN A PUBLIC CLASS?
CLICK HERE.

NEED A PROPOSAL FOR COMPANY?
EMAIL INQUIRE@INSIGHTSMANILA.COM

Advanced MS Excel Training

This training includes a thorough discussion of the advanced topics.  Participants will be exposed to various practical and complicated scenarios.

Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Office 365, Microsoft 365

Part 1.  Basic to Advanced MS Excel Functions
Text Functions
  • Combining Texts (CONCATENATE)
  • Extracting Values from Texts (LEFT, RIGHT, MID)
  • Changing Case (UPPER, LOWER, PROPER)
  • Other Accessory Text Functions (TRIM, VALUE, SUBSTITUTE)
Logical Functions
  • Basic IF Statements
  • Nested and Series IF Statements
  • Combining Logical Statements with AND and OR
Math Functions
  • Basic Math Functions (SUM, AVERAGE, MAX, MIN, COUNT)
  • Named Ranges
  • Conditional Math Functions (COUNTIF, SUMIF, AVERAGEIFS, etc.)
Shortening Long Formulas with Arrays
Lookup Functions
  • VLOOKUP
  • Advanced Usage of VLOOKUP
  • INDEX and MATCH

Part 2.  Managing Data Using Excel Tools
Conditional Formatting
  • Basic Conditional Formatting
  • Formula-Based Formatting
Data Validation
  • Basic Dropdown Menus and Cell Validations
  • Advanced Dropdown Menus
Subtotal Tool

Part 3. Analyzing and Presenting Data Using PivotTables
  • Basic PivotTable Features
  • Refresh and Change Data Source
  • Grouping Data
  • Using Slicers
  • PivotCharts

Part 4.  Introduction to Macros
  • Understanding Macro Security
  • Macro Recording
 

Related Courses

Extensive MS Excel

Basic MS Excel

​Macros and VBA Programming

​Excel for Data Analytics