Advanced Microsoft Excel Training for Business Professionals

Our advanced Microsoft Excel training for business professionals shows you how to use advanced Excel data tools, formulas and Excel's visual tools to crunch business data, build displays, and build models.

Our 1-day hands-on advanced Excel training focuses on creating sophisticated Excel analysis and data processing tools using advanced formulas, ActiveX controls, dashboards, database queries, pivot tables, charts and integrating Excel with MS Word and MS PowerPoint. We teach you how to develop these advanced solutions on the worksheet then how to assemble the proper Excel tools in ways you have never thought of before. It also provides an introduction to macros (VBA).

Advanced Microsoft Excel Training for Business Professionals

Advanced Microsoft Excel Training
for Business Professionals

Advanced Microsoft Excel Training for Business Professionals

Our advanced Microsoft Excel training for business professionals shows you how to use advanced Excel data tools, formulas and Excel's visual tools to crunch business data, build displays, and build models.

Click Dates|Signup
Dates | Signup

Advanced Excel Training Description, Requirements and Topics

Advanced Microsoft Excel Training Description
Description:

Excel Training Description

Our 1-day hands-on advanced Microsoft Excel training for business professionals shows you advanced Excel skills that apply to creating smart adaptive Excel business tools. Our advanced Excel 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 advanced Excel training also discusses the advanced aspects of these elements and how to assemble them in sophisticated ways including modeling. Our training 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 Skills Learned in Our Advanced Microsoft Excel Training
Key Skills: Key Skills You'll Learn in Our Advanced Microsoft Excel Training

Key Excel Skills Learned

  • Advanced Excel review of formula design, cell naming and workbook/worksheet linking
  • Advanced Excel techniques 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 Training Skill Requirements
Required Skills: Advanced Excel Training Skill Requirements

Required Excel Skills

Select this Excel training 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 Topics Outline
Training Topics:
Important: We focus our advanced Excel training on what our customers need. When training begins, we analyze those needs and shift our advanced Excel training outline appropriately. We will stress topics or add topics that our customers want. No two training sessions are ever the same with EMAGENIT.

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

  • 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 Training for Business Free Repeats

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 Excel Training Webinar Details

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

  • 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 Microsoft Excel Training Details

Training Details
Audience: Business Professionals
Time: 8:30 AM - 5:00 PM
# of Days: 1-day
Type: hands-on, live, instructor taught training
Manual: 2000 + page Microsoft Excel-Aided Business manual full of Excel tips and how-to-do topics included with the training
Platform: Windows 7 - Windows 10, Mac users welcome
Excel Versions: 2007-2016, Windows and Mac
Free Repeats: Repeat your Excel training as many times as you like, no date or limit, click here for details
Examples: We review our attendees personal examples in our training instruction
Training Formats: Public Seminar, Live Webinar, Company Onsite, and Self Study. For self-study, purchase Microsoft Excel Business Essentials. For company onsite information, please contact us 1.866.924.6244
Price: Live Hands-On Public Seminar: $190.00, Live Broadcast Hands-On Public Webinar: $150.00
Additional Training: Beginning Excel VBA, Intermediate Excel VBA, Advanced Excel VBA and Microsoft Excel Dashboards
Public Seminar / Webinar Signup
Click Dates|Signup
Dates | Signup

Contact EMAGENIT Directly

Our Contact Information
Phone Number: 1.866.924.6244
Business Hours: 8:30 - 5:00 PM PT
email: adv_excel_question@emagenit.com

Advanced Excel Training Question Form

Your Contact Information

*Name:
Company:
Company Web:
Country:
Phone #:
Ext:
*e-mail:
Contact me directly by
phone when this is received

*Required information to complete form. Privacy Policy

Workshop Questions

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

Request Workshop Information and Submit

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

Before clicking the Submit button, please fill in at least your name and email under Your Contact Information. Privacy Policy

LinkedIn
Facebook
Twitter
Information
Need Help? Please call us at 1.866.924.6244

Copyright © 2002-2017

EMAGENIT All Rights Reserved