Extensive MS Excel Training

PHP 1,200.00
PHP 1,200.00
Unavailable
per item
SKU:
No Paypal, no problem! Pls email inquire@insightsmanila.com or chat www.facebook.com/InsightsManila for other payment options.


This training is on January 27-29, 1:30PM-5PM via Zoom.
Outline:


Part 1. Basic to Advanced MS Excel Functions

 
  • Text Functions
  • Combining Texts
  • Changing Case
  • Other Accessory Text Functions
  • Logical Functions
  • Basic IF Statements
  • Nested and Series IF Statements
  • Combining IF with Other Functions
  • Math and Date Functions
  • Basic Math Functions
  • Named Ranges
  • Conditional Math Functions
  • Shortening Long Formulas with Arrays
  • Advanced Lookup Functions
  • VLOOKUP
  • Advanced Usage of VLOOKUP
  • INDEX and MATCH

     
Part 2. Advanced Functions

 
  • Creating Array Formulas
  • Dealing with Complex Problems in Excel
  • Using Lookup Functions Beyond INDEX and MATCH

     
Part 3. Exploring the Data Tab Tools

 
  • Conditional Formatting
  • Basic Conditional Formatting
  • Formula-Based Formatting
  • Data Validation
  • Creating Basic Dropdown Menus and Cell Validations
  • Advanced Dropdown Menus
  • Creating Formula-Based Data Validation
  • Subtotal Tool
  • Text-to-Columns
  • Data Analysis Tools (Goal Seek, What If Analysis, Scenario Manager)

     
Part 4. Analyzing Data Using PivotTables

 
  • Basic PivotTable Features
  • Tables
  • Grouping Data
  • Using Slicers
  • Calculated Fields
  • PivotCharts

     
Part 5. Advanced Charting

 
  • Review of Basic Charts
  • Modifying Chart Elements
  • Creating Combination Charts
  • Creating Complex Charts
  • Creating Dynamic Charts using Functions