Excel Training, Excel VBA Training, Excel Software Design

Advanced Excel Classes
for Business Professionals

Advanced Excel Classes for Business Professionals
Click Signup Seminar/Webinar Signup

Our advanced Excel classes for business professionals show you how to use advanced Excel data tools, formulas and Excel's visual tools to crunch business data and build displays.

Our 1-day "hands-on" advanced Excel classes for business professionals show you advanced Excel skills that apply to creating smart adaptive Excel business tools. Our advanced Excel classes 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 advanced Excel classes also discuss the advanced aspects of these elements and how to assemble them in sophisticated ways. Our class 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. Available as Live Hands-on Webinar, Onsite and Public Seminar.

Advanced Excel Classes:  Key Skills You'll Learn

Advanced Excel Classes:  Key Skills You'll Learn
  • Advanced Excel review of formula design, cell naming and workbook/worksheet linking
  • Advanced Excel technqiues for constructing Microsoft Excel displays using ActiveX controls on the Excel worksheet
  • Advanced Excel methods for creating complex business displays using advanced formulas, charts, drawing shapes, Data Validation, Conditional Formatting and ActiveX controls
  • How to create advanced data processing formulas that use advanced logic and can adjust to changing data automatically
  • How to build advanced logic for Conditional Formatting and Data Validation
  • Advanced Excel construction methods for building and using array formulas
  • How to create and use Excel tables that can be used with advanced formulas and visual displays
  • Advanced Excel methods for integrating 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 create and use relationships to build advanced pivot tables and pivot charts
  • Advanced Excel skills for building 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

Advanced Excel Classes:  Basic Skill Requirements

Advanced Excel Classes:  Basic Skill Requirements

Select this class 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 Excel:  Class Outline

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

Advanced Excel Methods for Cell Naming, Table Construction and Workbook Linking

Advanced Excel Classes: Free Repeats Policy
  • Advanced Microsoft Excel 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

Advanced Microsoft Excel Methods for Creating and Using 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
  • Advanced Excel strategies for storing data in workbooks

Advanced Excel Methods for Creating Advanced Logic and 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 Excel logic in your data processing formulas including how to make nested IF formulas and use NOT
  • How to use advanced Microsoft Excel 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

Advanced Microsoft Excel Methods for Using ActiveX Controls, Advanced Excel Displays and Advanced Conditional Formatting

Advanced Excel Classes: 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

Advanced Excel Methods for Creating and Using 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

Advanced Microsoft Excel Methods for Creating Advanced 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

Advanced Excel Classes:  Additional Information and Signup

Additional Advanced Excel Class Information

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

Included in Our Advanced Excel Classes

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

Advanced Excel Class Formats

Click Signup Seminar/Webinar Signup

Advanced Excel Classes: 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