Menu
Insights Training
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2019 Class Pics/ Clients
    • 2018 Class Pics / Clients
    • 2017 Class Pics / Clients
  • Testimonials
  • Self-Paced
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Laptops for Rent
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • DBSC Upload
  • Upload_infinitovba032021
  • upload_asurion
  • Upload Excel Public Class
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2019 Class Pics/ Clients
    • 2018 Class Pics / Clients
    • 2017 Class Pics / Clients
  • Testimonials
  • Self-Paced
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Laptops for Rent
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • DBSC Upload
  • Upload_infinitovba032021
  • upload_asurion
  • Upload Excel Public Class

Extensive Advanced Excel
(16 hours total)

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

Join a public class

    We get booked fast.  Request a quote now.

Submit
Powered by Create your own unique website with customizable templates.