Intermediate Microsoft Excel Training for Business Professionals

Our Intermediate Excel training for business professionals shows you the essential skills that you need to start analyzing, processing and modeling business information using formulas, worksheet functions like VLOOKUP and Excel's data processing tools.

Our 1-day hands-on intermediate Excel training focuses on useful formula design for data processing and modeling; using Excel's built-in range features like data validation and conditional formatting; using worksheet functions like VLOOKUP, COUNTIF and SUMIF; and applying Excel's data analysis tools and worksheet functions to analyze data on the worksheet. We teach you how to first develop the problem on the worksheet and then how to apply the proper Excel tools to create a unique solution.

Intermediate Microsoft Excel Training for Business Professionals

Intermediate Microsoft Excel Training
for Business Professionals

Intermediate Microsoft Excel Training for Business Professionals

Our Intermediate Excel training for business professionals shows you the essential skills that you need to start analyzing business information using formulas, worksheet functions like VLOOKUP and Excel's data processing tools.

Click Dates|Signup
Dates | Signup

Intermediate Excel Training Description, Requirements and Topics

Intermediate Microsoft Excel Training Description
Description:

Excel Training Description

Our 1-day hands-on intermediate Microsoft Excel training for business professionals gives you the essential Excel skills that apply to analyzing business information. Topics include cell and range naming, building formulas using functions like VLOOKUP, SUMIF and IF; linking and managing worksheet information; organizing and analyzing worksheet data with Excel's data tools and functions; building professional charts; building basic pivot tables and pivot charts; cleaning worksheet text and working with text files; and linking Excel to other programs like Word and PowerPoint. Also discussed are the basics of creating models on the worksheet.

Key Skills Learned in Our Intermediate Microsoft Excel Training
Key Skills: Key Skills You'll Learn in Our Intermediate Microsoft Excel Training

Key Excel Skills Learned

  • General review of how to build worksheet formulas and debug them
  • Intermediate Excel methods for naming worksheet cells and ranges, the key to building sophisticated, self-adjusting Microsoft Excel formulas
  • How to build worksheet tables, the key to using Microsoft Excel's data tools and creating advanced data storage systems
  • How to use common intermediate Excel features like Data Validation and Conditional Formatting
  • How to use common intermediate Excel features like Group, Sort, Advanced Filter and AutoFilter to filter Excel worksheet data
  • How to use intermediate Excel worksheet functions like SUM, MIN, MAX, COUNTA, AVERAGE and SUBTOTAL in ways you have not seen before
  • How to look up and merge worksheet data using key intermediate Excel worksheet functions like VLOOKUP, MATCH, INDEX and INDIRECT
  • How to use intermediate Excel functions for summarizing data like SUMIF, SUMIFS, COUNTIF and COUNTIFS
  • How to use common intermediate Excel features like Text to Columns, Text Wizard and the Remove Duplicates features
  • How to use intermediate Excel functions like LEFT, RIGHT, MID, SEARCH, SUBSITUTE, LEN, REPLACE, TRIM and CLEAN for data mining worksheet text
  • How to create professional business charts including combining different chart types in one chart
  • How to create, control and format pivot tables and pivot charts including slicers and timelines
Intermediate Excel Training Skill Requirements
Required Skills: Intermediate Excel Training Skill Requirements

Required Excel Skills

Select this Excel training if you or your group have:

  • Opened and saved a workbook file
  • Learned about worksheets, cells and cell references like A1
  • Copied and pasted worksheet data
  • Performed basic cell formatting tasks like coloring a cell, bolding, aligning...
  • Typed data in worksheet cells and built basic formulas like =A1+A2
  • Used a worksheet function like =Sum(A1:A10) in a formula or have seen it before
Intermediate Microsoft Excel Training Topics Outline
Training Topics:
Important: We focus our intermediate Excel training on what our customers need. When training begins, we analyze those needs and shift our intermediate 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.

Intermediate Excel Worksheet Formula, Cell Naming and Sheet Linking Review

  • A review of how to create basic formulas on the worksheet that add, subtract, multiply and divide
  • How to debug your formula errors and map how your formulas relate to each other
  • How to name a cell or range so the name can be used in a formula instead of a cell reference like A1
  • How to manage cell and range name editing and deletion in your workbook
  • How to manage and link sheet information in your workbook using names and cell references
Intermediate Microsoft Excel Training for Business Free Repeats

Intermediate Microsoft Excel Methods for Using Data Validation to Control Your Worksheet Data Entry

  • The uses of Data Validation
  • How to use Data Validation to control what number, text or date a person types in a worksheet cell
  • How to create a list in a worksheet cell using Data Validation

Intermediate Excel Methods for Building Tables on the Worksheet

  • 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

Intermediate Microsoft Excel Methods for Using Key Excel Worksheet Functions to Analyze Your Data

Function Basics

  • What is a worksheet function, how does it work and what is an argument list
  • How to use basic functions in your formulas like SUM, COUNTA, AVERAGE, MAX, MIN, SUBTOTAL
  • How to use ranges in your worksheet functions including ranges that resize
  • How to nest Microsoft Excel worksheet functions to create powerful formulas
Intermediate Excel Training Webinar Details

How to Use Key Worksheet Functions That Lookup and Merge Table Data

  • Review of the VLOOKUP, HLOOKUP, MATCH and INDEX functions
  • How to use VLOOKUP to lookup table information and merge it
  • How to use MATCH, INDIRECT and INDEX to perform table lookups that VLOOKUP cannot
  • How to nest Microsoft Excel worksheet functions to create powerful formulas

Intermediate Excel Methods for Creating Logical Formulas in Excel

Logic Overview , Formula Syntax and Key Logic Worksheet Functions

  • Logic, the key to advanced tool construction in Excel
  • How to use logic in general 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 Use Key Worksheet Functions That Use Logic to Process and Summarize Your Worksheet Data

  • How to use SUMIF and SUMIFS to summarize your worksheet data
  • How to use COUNTIF and COUNTIFS to count how many instances you have in your worksheet data

Intermediate Microsoft Excel Methods for Using the Group, Advance Filter and Sort Tools on Your Worksheet Tables

  • How to hide and unhide worksheet rows using the Group feature
  • How to use the Sort feature to sort tables based on text and colors
  • How to use the Advanced Filter to build advanced table filters

Intermediate Excel Methods for Using Conditional Formatting to Flag Your Data

  • The uses of conditional formatting
  • How to use the Conditional Formatting feature to flag data in tables and in visual displays
  • How to use the Conditional Formatting feature as a dashboard system (i.e. graphical bars, icons...)

Intermediate Microsoft Excel Methods for Analyzing Text on the Worksheet

  • How to analyze, split and clean worksheet text using the text worksheet functions like RIGHT, MID, LEFT, SUBSTITUTE, TRIM, CLEAN, SEARCH and REPLACE
  • How to use the Text to Columns feature to separate delimited data into separate worksheet columns
  • How to use Text Wizard to import text files
  • How to use the Remove Duplicates feature to retrieve unique names from a column

Intermediate Excel Methods for Creating Business Charts

  • How to create charts that have a professional look
  • Chart formatting tips including picture placement, data labels and professional coloring
  • How to combine two or more chart types into one chart

Intermediate Microsoft Excel Methods for Creating Pivot Tables and Pivot Charts

  • How to arrange and name worksheet data for a pivot table to use
  • How to create pivot tables from worksheet data
  • How to control pivot tables using filtering and grouping
  • How to refresh and remap pivot table data
  • How to create different pivot table summary types
  • How to format a pivot table using styles and the Format Cells dialog box
  • How to make slicers and timelines for pivot tables
  • How to format and control the options for timelines and slicers
  • How to construct, edit and format pivot charts
  • How to use the filters on a pivot chart and arrange them
  • How to use the pivot tables, pivot charts, slicers and timelines to create dashboards and reports

Intermediate Excel Methods for Linking Excel with Word and PowerPoint

  • Basic linking between the programs with copying and pasting
  • How to link cells, ranges and charts with Word and PowerPoint

Intermediate 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:  Advanced Microsoft Excel, 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: int_excel_question@emagenit.com

Intermediate 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