inquire@insightsmanila.com
0977.103.1800

Extensive MS Excel Training

This training includes a thorough review of the basics and a thorough discussion of the advanced topics.  There are more exercises and participants will be exposed to various practical and complicated scenarios.

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.)
  • Handling Date and Time Problems
Shortening Long Formulas with Arrays
Lookup Functions
  • VLOOKUP
  • Advanced Usage of VLOOKUP
  • INDEX and MATCH

Part 2. Data Management Tools
Text-to-Columns
  • Delimited
  • Fixed Width
Conditional Formatting
  • Basic Conditional Formatting
  • Formula-Based Format
Data Validation
  • Basic Dropdown Menus and Cell Validations
  • Advanced Dropdown Menus
  • Advanced Data Validation Scenarios
Subtotal Tool
 
Part 3.  Charts
  • Basic Charts
  • Combination Charts
  • Other Charting Options in Excel
  • Sparklines
  • Using INDIRECT to Create Dynamic Charts
 
Part 4. Analyzing and Presenting Data Using PivotTables
  • Basic PivotTable Features
  • Refresh and Change Data Source
  • Creating Calculated Fields
  • Constructing Reports using PivotTables
  • Grouping Data
  • Using Slicers
  • PivotCharts
  • Creating Dashboards using PivotCharts

Part 5.  Error Handling
  • Understanding Errors in Formulas
  • Solving Errors in Formulas

Part 6.  Introduction to Macros
  • Understanding Macro Security
  • Macro Recording
  • Assigning Macros to Images and Buttons

Related Courses

Basic MS Excel

MS PowerBI for Beginners

Advanced MS Excel

Macros and VBA Programming

​Excel for Data Analytics

    We get booked fast.  Request a quote now.