Intermediate Excel Training

Intermediate Microsoft Excel Training Description

Our 1-day intermediate Excel training will show you how to effectively use Excel to process business data. Key topics include cell and range naming, building formulas using functions like VLOOKUP, COUNTIF, 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 and organizing models on the worksheet.

Where and When is Our are Intermediate Excel Training Held (Public Event and Live Online)

EMAGENIT public events for Intermediate Excel training are held in Thousand Oaks, CA. Our training starts at 8:30 AM PT and ends at 4:30 PM PT. We are in the vicinity of Simi Valley, CA; Oxnard, CA; Ventura, CA; Santa Barbara, CA; Carpentaria, CA; Calabasas, CA; Agoura Hills, CA; Studio City, CA; Sherman Oaks, CA; Encino, CA; Woodland Hills, CA; Westwood, CA, Santa Paula, CA; Valencia, CA; Santa Monica, CA and Los Angeles, CA. California counties within morning commute of our area include Santa Barbara county, Ventura county, Los Angeles county and Orange county. Our Intermediate Excel training is also held live online and is broadcast all over the US, Canada, Mexico and the Caribbean. We can also broadcast to any part of the globe. We travel all over the US, Canada and Europe for our in person onsites.

Key Skills Learned in Our Intermediate Excel Training

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

Key intermediate Excel skills learned:

Intermediate Excel review of how to build worksheet formulas and debug them
How to name worksheet cells and ranges, the key to building sophisticated, self-adjusting Microsoft Excel formulas
How to build proper worksheet tables, the key to using Microsoft Excel's data tools and creating data storage systems
How to design and build useful worksheet forms
How to turn a worksheet range into an Excel table and use it in formulas
How to use intermediate Excel features like Data Validation to protect cell data entry and Conditional Formatting to color cells based on logic
How to use Group, Sort, Advanced Filter, AutoFilter and Subtotal to manipulate 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 Excel worksheet functions like VLOOKUP, MATCH, INDEX and INDIRECT
How to use intermediate Excel functions to summarize data like SUMIF, SUMIFS, COUNTIF and COUNTIFS
How to parse text on a worksheet using 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 parsing 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
How to link Excel with PowerPoint and Word to create reports

Intermediate Excel Training Skill Requirements

Select this intermediate Excel training if you or your group:

Have opened and saved a workbook file
Know the basics about worksheets, cells and using cell references like A1
Have copied and pasted worksheet data
Have performed basic cell formatting tasks like coloring a cell, bolding, aligning...
Have typed data in worksheet cells and built basic formulas like =A1+A2
Have used a worksheet function like =Sum(A1:A10) in a formula or have seen it before

Intermediate Microsoft Excel Training Topics Outline

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 Review of Worksheet Formulas, Cell Naming and Sheet Linking

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

Using Data Validation to Control Your Worksheet Data Entry

Intermediate Excel 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

Key Things Intermediate Excel Users Need to Know About Building Tables on the Worksheet

The difference between a report and a table on a worksheet 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 Excel tables and use their structured references in your formulas

Worksheet Formatting and Form Construction

How to use formatting, pictures and drawing shapes to give your worksheet a professional business look
How to use drawing shapes to create different types of worksheet diagrams
How to design and format useful worksheet forms that your associates can use to store work related data
How to use data validation and worksheet protection to lock down your form entries ensuring data integrity

Key Worksheet Function Review for the Intermediate Excel User

Function Basics, Arguments and Nesting

What is a worksheet function, how does it work and what is an argument list
Review of how to use basic functions in your formulas like SUM, COUNTA, AVERAGE, MAX, MIN, SUBTOTAL
How to use range references, cell references, names, constants and Excel table structured references in your worksheet function formulas
How to nest Microsoft Excel worksheet functions to create powerful formulas

Intermediate Excel Online Course Details

Key Lookup Worksheet Functions for the Intermediate Excel User

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

Key Logical Worksheet Functions for the Intermediate Excel User

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

Essential Data Analysis Worksheet Functions for the Intermediate Excel User

How to Use Key Worksheet Functions That Use Logic to Analyze 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

Must Know Text Analysis Techniques for the Intermediate Excel user

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

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

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...)

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

How to Create Pivot Tables and Pivot Charts on the Worksheet

What is a pivot table and pivot chart?
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

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

Audience: Business Professionals
Time: 8:30 AM - 4:30 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 Training Workshop
- Live Online Course. We broadcast our Excel public training as a live hands-on online courses so even though you cannot travel to us, you can still take the course as if sitting in the room with us
- Company Onsite
- For self-study, purchase Microsoft Excel Business Essentials. For company onsite information, please contact us 1.866.924.6244
Additional Training:

Public Event / Live Online Course Signup

Click Dates|Signup

Dates | Signup

Intermediate Excel Training Contact Information

Contact EMAGENIT Directly

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

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 training workshop information
	Send me self-study manual information
	Send me live online course information

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