Advanced Microsoft Excel Training | Advanced Excel Training
for Business Professionals

Advanced Microsoft Excel Training | Advanced Excel Training
Click Signup Seminar/Webinar Signup

Our advanced Excel training shows you how to use advanced Excel data tools, formulas and Excel visual tools to crunch business data and build displays.

Our 1-day "hands-on" advanced Excel training shows you advanced Excel skills that apply to creating smart adaptive Excel business tools. Our training focuses on creating Excel analysis and data processing tools using advanced formulas, array formulas, logic, ActiveX controls, conditional formatting, data validation, pivot tables, pivot charts, Excel tables, relationships, and MS Query. Our workshop discusses the advanced aspects of these elements and how to assemble them in advanced ways. Our workshop also stresses how to create the advanced logic that allows these tools to operate autonomously and adapt to changing data. It also provides an introduction to macros (VBA). Excel for Mac users welcome.

Key Advanced Excel Training Skills Learned

Key Advanced Excel Training Skills You'll Learn
  • A full formula, cell naming and workbook | worksheet linking review
  • How to construct and use ActiveX controls on the Excel worksheet
  • How to create advanced Excel business displays using advanced formulas, charts, drawing shapes, data validation, conditional formatting and ActiveX controls
  • How to create advanced Excel data processing formulas that use advanced logic and can adjust to changing data automatically
  • How to build advanced logic for conditional formatting
  • How to build and use array formulas
  • How to design Excel tables that can be used with advanced formulas and visual displays
  • How to integrate business data in Excel by linking with external data using MS Query, Excel tables and Text Wizard
  • How to create advanced Excel pivot tables and pivot charts including calculated fields, calculated items and styles
  • How to use create and use relationships to build pivot tables and pivot charts
  • How to build pivot tables and pivot charts directly from external data sources like Access, SQL Server and text files
  • An introduction to VBA macros including creating your own custom worksheet functions to replace large cumbersome worksheet mega formulas, the real calculation power house

Who Should Take This Advanced Excel Training Workshop

Who Should Take This Advanced Excel Training Workshop

Select this workshop if you or your group have:

  • Formatted a worksheet using colors and fonts before
  • Typed in general formulas and used basic worksheet functions like VLOOKUP, IF, MAX, MIN, COUNTIF...
  • Have used conditional formatting and data validation before
  • Built a table before and performed drag and fill operations on formulas (little black dot bottom right hand-side of a cell)
  • Used logic before in general and know the relational operators <, >, <=, >=, <>, =
  • Used basic Excel features like Sort, AutoFilter and have built charts
  • A desire to push Excel to its limit and know what you can do

Advanced Microsoft Excel Training Workshop Outline

Important: We focus our training on what our customers need. When class begins, we analyze those needs and shift our workshop training outline appropriately. We will stress topics or add topics that our customers want. No two workshops are ever the same with EMAGENIT.

Cell Naming, Table Construction and Workbook Linking

Free Repeats Policy
  • Advanced methods for naming cells and ranges, the key to making advanced Excel tools
  • How to manage your names in Excel
  • How to manage and link information in your workbook and between different workbooks using cell references and names
  • How to create proper tables in Excel that can be used with its advanced data analysis tools like Excel tables

How to Create and Use Excel Tables to Process and Manage Data

  • What is an Excel table and how to use them to manage data and enhance data processing tasks
  • How to create an Excel table using worksheet data
  • How to add, edit and delete Excel table data
  • How to control Excel tables and use their quick summary tools to analyze data
  • How to format Excel tables including creating custom table styles
  • How to create calculated columns in Excel tables
  • How to create formulas that automatically adjust to data resizing using Excel tables
  • How to use Microsoft Query to query external data and create an Excel table
  • How to create an Excel table quickly from external data sources like databases and text files
  • How Excel tables are used with pivot tables and in relationships

How to Create Advanced Logic and Advanced Excel Data Processing Formulas

  • Logic review including relational operators: <, >, <=, >=, < >, = and the IF, AND, OR logical worksheet functions
  • How to use string concatenation to build self-adjusting relational logic (i.e. ">=" & A1)  for functions like SUMIFS, COUNTIFS...
  • How to use advanced logic in your data processing formulas including how to make nested IF formulas and use NOT
  • How to use advanced logic to control when formulas start and stop on your worksheet
  • How to use INDIRECT, INDEX, ADDRESS, MATCH, ROW, COLUMN, OFFSET, COUNTA, cell names and string concatenation to construct formulas that adjust to changing data
  • How to create dynamic adjustable cell and range names that react to changing data size using COUNTA, OFFSET and INDIRECT
  • How to construct advanced Excel formulas that can automatically toggle between tables
  • How to create useful formulas that merge and lookup table data

How to Build ActiveX Controls, Advanced Excel Displays and Advanced Conditional Formatting

Webinar Details
  • The difference between ActiveX controls and Form controls
  • How to create and use combo boxes, spinners, scroll bars, option buttons, check boxes and toggle buttons
  • How to integrate these controls with your advanced Excel formulas, charts and drawing shapes
  • How to use conditional formatting feature in different ways to create advanced Excel displays
  • How to create advanced logic formulas for use in the data validation and conditional formatting features
  • How to use drawing shapes and pictures to create advanced Excel displays
  • For advanced displays, see our Dashboards workshop

How to Create and Use Array Formulas

  • Overview of array formulas and their use
  • How to construct simple array formulas that use basic relational operators and basic math
  • How to create array formulas that find, return and track table information
  • How to create advanced array formulas that use logic functions like IF to perform calculations

How to Create Advanced Excel Pivot Tables and Pivot Charts

  • How to create a connection to a database, text file, Excel table... for use in a pivot table
  • How to use text files and databases in your pivot tables
  • How to create running totals, % OF, differences and ranks in your pivot tables
  • How to create calculated fields in a pivot table
  • How to group and ungroup in a pivot table
  • How to create advanced formulas that reference pivot table data including how to use GETPIVOTDATA
  • How to create custom table styles for a pivot table
  • How to create a data model for use in a pivot table
  • How to create and use relationships from Excel tables and external data sources to build a pivot table and pivot chart
  • How to create advanced pivot charts

Introduction to Excel VBA Macros

  • What is VBA?
  • What are a Sub and Function procedure and how are they used?
  • How to command Excel using VBA
  • What are variables, loops and logic and how do you use them in your computer code
  • How to create custom worksheet functions that replace your mega formulas on the worksheet

Additional Training Information and Signup

Additional Advanced Excel Training Information

  • Duration: 1-day
  • Our workshops cover Excel versions 2007-2013 including Excel for Mac and discuss differences when necessary.

Included in Our Advanced Excel Training

  • Free Repeats
  • 1800+ page manual filled with key Excel strategies, examples and tips
  • Hands-on training
  • Personal questions answered

Training Formats

Click Signup Seminar/Webinar Signup

Advanced Excel Training Question Form

Instructions: Please fill in your contact information.

Company Web:
Phone #:
Contact me directly by phone

Please fill out the box below with your workshop questions and EMAGENIT will contact you.

Request Workshop Information (Optional)

Send me on-site workshop information Send me self-study manual information
Send me public seminar workshop information Send me live online webinar information

Privacy Policy

Site Map

Copyright © 2002-2015

EMAGENIT All Rights Reserved