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

Extensive Advanced Excel
(16 hours total)

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

NEED A PROPOSAL FOR COMPANY?
EMAIL [email protected]

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.

1. Basic to Advanced MS Excel Functions
  • Text Functions
    • Combining Texts (CONCATENATE)
    • Extracting Values from Texts (LEFT, RIGHT, MID)
    • Changing Case (UPPER, LOWER, PROPER)
    • Accessory Text Functions (TRIM, VALUE, SUBSTITUTE)
  • Logical Functions
    • Basic IF Statements
    • Nested and Series IF Statements
    • Logic 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
    • Calculating Working Days
    • Calculating Age and Other Date-Related Problems
  • Shortening Long Formulas with Arrays
  • Lookup Functions
    • VLOOKUP
    • Advanced Usage of VLOOKUP
    • INDEX and MATCH


2. Data Tab and Other Tools
  • Worksheet Formatting Tools (Sort, Filter, Format, Merge, etc.)
  • Text-to-Columns
  • 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
  • Worksheet Security: Locking Cells and File Passwords


3. Data Visualizations with Charts
  • Basic Charts
  • Combination Charts
  • Sparklines
  • Using INDIRECT to Create Dynamic Charts
  • Special Chart Types
4. Analyzing and Presenting Data Using PivotTables and Pivot Charts
  • Basic PivotTable Features
    • Refresh and Change Data Source
    • Creating Calculated Fields
  • Constructing Reports using PivotTables
    • Grouping Data
    • Using Slicers
  • Creating Pivot Charts
  • Creating Dashboards using PivotCharts


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


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


7. Data Modeling using PowerPivot (Combining and Analyzing Multiple Data Sources)
  • Getting External Data using Power Query
  • Getting Data from File
  • Consolidating Files in a Folder
  • Data Modeling in PowerPivot
  • Creating PivotTables from PowerPivot

Related Courses

Basic MS Excel

MS PowerBI for Beginners

Advanced MS Excel

Macros and VBA Programming

​Excel for Data Analytics
Download Outline
Find Public Class
Send Email

Home

Courses

Public Classes

Contact

Copyright © 2022