Menu
Insights Training
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
    • 2024 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
    • 2024 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools
  • MS Office Training
  • >
  • Extensive MS Excel Training

Extensive MS Excel Training

  • Facebook
  • Twitter
  • Pinterest
  • Google+
₱1,200.00
₱1,200.00
Unavailable
per item
SKU:
Add to Cart
No Paypal, no problem! Pls email [email protected] 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

     

Home

Courses

Public Classes

Contact

Copyright © 2022