Advanced Microsoft Excel Training |
Advanced Excel Training

Advanced Microsoft Excel Training | Advanced Excel Training

for Business Professionals

Our Advanced Excel training shows you how to create advanced, adaptive, smart data processing, analysis and dashboard business tools.

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, worksheet functions, logic, ActiveX controls, conditional formatting, data validation, Pivot Tables, MS Query and charts. 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).
Next Date Click Signup

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 design worksheet tables that can be used with advanced formulas
  • How to import and work with text files into Excel
  • How to integrate business data in Excel by linking with external data using MS Query, XML and Text Wizard
  • How to link Microsoft Excel with other applications like Word and PowerPoint
  • How to create advanced Excel pivot tables and pivot charts
  • An introduction to VBA macros including creating your own custom worksheet functions to replace large cumbersome worksheet formulas

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
  • How to manage your names in Excel
  • How to manage and link sheet information in your workbook using names and cell references
  • The difference between a report and a table that stores data
  • Different types of tables, how they impact your analysis approach in Excel
  • Proper header and data column design for your worksheet tables

How to Create Advanced Excel Logical Formulas

  • Logic, the key to advanced tool construction in Excel
  • How to use logic in general, figure out the strategies, build multiple decisions and figure out logical triggers
  • How to build logic formulas using the relational operators: <, >, <=, >=, < >, =
  • How to build logic formulas using the IF, AND, OR logical worksheet functions
  • How to protect your formulas from errors using the IF and the IS functions
  • How to create formulas that appear and disappear when needed using the IF and IS functions
  • How to tie logical formulas into Excel's data validation and conditional formatting tools
  • How to use advanced logic in your data processing formulas

How to Create and Integrate ActiveX Controls with Your Advanced Excel Worksheets

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

How to Create Advanced Excel Program Displays on the Worksheet

  • How to use Data Validation to control your advanced Excel displays
  • How to use ActiveX controls to control your Excel formulas
  • How to use Conditional Formatting to flag worksheet cells and use as displays
  • How to create the logic for the Data Validation and Conditional Formatting features
  • How to use drawing shapes and pictures to create Excel dashboard displays
  • How to put it all together for that professional dashboard look
  • How to use the Conditional Formatting feature as a dashboard system (i.e. graphical bars, icons...)

How to Create Advanced Excel Data Processing and Analysis Formulas

  • Writing formulas that adjust to changing data, the key to developing self-adjusting Excel solutions
  • How to use INDIRECT, ADDRESS, MATCH, ROW, COLUMN, OFFSET, COUNTA, cell names and string concatenation to construct formulas that adjust to changing data
  • How to use these functions inside your SUMIFS, COUNTIFS, VLOOKUPS,...
  • How to construct advanced Excel formulas that can automatically toggle between tables
  • How to use advanced logic in your formulas to merge and lookup table data
  • How to construct advanced Excel formulas that know when to start, stop and find specific data

Integrating Data in Excel: How to Link to Text Files, Databases, Word, The Web and PowerPoint to Excel

  • Going after data that is not in Excel workbook, think of Excel as an integration platform
  • How to import various text file formats into Microsoft Excel
  • How to connect to external data sources including the web using the Data Connection wizard
  • How to connect to workbooks, text files and databases using Microsoft Query
  • Basic linking between the Excel, Word and PowerPoint programs with copying and pasting
  • How to link cells, ranges and charts with Word and PowerPoint

How to Create Advanced Excel Pivot Tables

  • Advanced Excel pivot table construction methods
  • How to retrieve data from a pivot table using formulas and logic
  • How to add custom calculations to a pivot table
  • How to group in a pivot table
  • How to use pivot charts in your dashboards

Introduction to Excel VBA Macros

  • What is VBA?
  • What are a Sub and Function procedure and how are they used?
  • How to command Exce 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 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

Next Date Click 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