Call us at:   1.805.498.7162     1.805.558.9277

Microsoft Excel training options for business, engineering and science Innovative Microsoft Excel software design View our customer list from our over 14 years in business Phone numbers, email address and contact form Learn about EMAGENIT Home page containing upcoming Microsoft Excel classes and other EMAGENIT services Self-study Microsoft Excel manuals for business, engineering and science Microsoft Excel consulting services Microsoft Excel training schedule and prices

Home > Microsoft Excel Workshops > Intermediate Microsoft Excel Training for Business Professionals

  Contact EMAGENIT About Your Questions EMAGENIT Newsletter Signup - Discounts
Intermediate Microsoft Excel Training

Intermediate Microsoft Excel Training Outline for Business Professionals

Learn real world Microsoft Excel skills that will save you time and effort in your Excel business tasks. Our 1-day "hands-on" Excel training discusses how to use Excel’s data processing and analysis tools to solve a multitude of business tasks. Our workshop starts out with a general review of formulas, debugging and how to use worksheet functions. It then discusses how to use key functions like VLOOKUP, INDIRECT, MATCH, INDEX, IF, COUNTIFS, SUMIFS... to build powerful data processing and analysis formulas that can think. Our workshop also focuses on worksheet function nesting, how to use Excel's built-in data processing tools like AutoFilter, how to build pivot tables, how to process text and text files, how to link to Word and PowerPoint and how to build basic dashboards using data validation, conditional formatting, ActiveX controls and charts. Our workshop also discusses how to use cell and range names to properly manage formulas and their data and how to build correct tables on the worksheet.

Goto to the workshop signup, view different signup options

Free Workshop Repeats

Microsoft Excel Workshops -  Free RepeatsAll of our workshops come with free repeats. We believe learning is an iterative process and not just a one time event. Details

EMAGENIT Customers and Awards

At EMAGENIT, we have trained customers like:

  • Janus Capital, HSBC, Deutsche Bank, Google, Apple, BMW, Capital One and Disney (View More)

We have also trained organizations like ICE, NASA, The US Army, Navy, Air Force and Marines and develop custom Excel software for the likes of Caterpillar and NASA (Award). Our diverse training background and software projects ensure you get the best Excel training drawn from real world experience not academia. We show you what you actually need to succeed.

Why Not Go Online For Your Training

Why Not Go Online For Your TrainingOur live "hands-on" webinars enable us to train you and your company employees at different sites all over the country at once without having to collect them in one room. You can sign up for the webinar below. View Our Webinar Details Page

 

 

 

About Our Workshop

 

Real World Intermediate Excel Skills You Learn

  • Real World Intermediate Excel Skills You LearnHow to build basic worksheet formulas and correct them

  • How to create names for single cells and ranges

  • How to use the data validation and conditional formatting worksheet features

  • How to analyze business data using key Microsoft Excel worksheet functions like VLOOKUP and SUMIFS

  • How to construct formulas that adjust to shifting table size and header positions

  • How to clean and analyze worksheet text data using formulas and Excel tools

  • How to use Microsoft Excel's built-in analysis tools (sort, Advanced Filter, AutoFilter...) to analyze worksheet data

  • How to create business dashboards on the worksheet

  • How to create and use Microsoft Excel pivot tables and charts

  • How to link Microsoft Excel to Word and PowerPoint to create powerful report generation tools

 

Who Should Take This Workshop (Prerequisites)

Select this workshop 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

  • 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

 

Microsoft Excel Versions Taught in Workshop

  • Our workshops cover Excel versions 2000-2013 including Excel for Mac and discuss differences when necessary.

 

Included in Our Intermediate Excel Workshop

  • Free Repeats

  • 1800+ page manual filled with key Excel strategies, examples and tips

  • Hands-on training

  • Personal questions answered

 

Workshop Training Choices

Available: Public Seminar, Live Online Webinar, Company Onsite, Self-Study Manual

  • Public Seminar, Live Online Webinar and Self-Study signup buttons below

  • For company onsite information or if you have any questions, please contact us 1.805.498.7162 or 1.805.558.9277.

 

Intermediate Excel Workshop Outline

In this 1-day "hands-on" workshop you will cover:

  • Basic Formula Construction: How to create and correct basic formulas on the worksheet

  • Cell / Range Naming: How to create and manage cell and range names so they can be used in formulas instead of cell references. Names are the foundation for successful Excel tool construction.

  • Conditional Formatting / Data Validation: How to use the data validation and conditional formatting worksheet features to limit user cell input and flag important cell data

  • Worksheet Function Review: A review of how to use the basic worksheet functions in your formulas like SUM, COUNTA, AVERAGE, MAX, MIN. Worksheet functions allow you to perform complex business tasks on the worksheet rapidly.

  • Using Ranges: How to use worksheet ranges in your Microsoft Excel worksheet functions

  • Nesting Worksheet Functions: How to nest Microsoft Excel worksheet functions to create powerful analysis formulas

  • Smart Worksheets: How to construct "smart" Microsoft Excel worksheets that can think for themselves using key Excel functions like VLOOKUP, INDEX, MATCH, COUNTIF (s), COUNTA, OFFSET, SUMIF (s), IF, AND, OR, ROUND, IS functions and INDIRECT

  • Self Adjusting Ranges: How to build ranges in formulas that adjust to shifting data size and header positions

  • Self Adjusting Table Formulas: How to build formulas that can automatically toggle between your lookup tables that are placed on different worksheets

  • Databases / Lists: How to create and manage databases in Microsoft Excel

  • Sort / AutoFilter / Advanced Filter Tools: How to use Microsoft Excel's table management tools like the sort, form, AutoFilter and Advanced Filter tools

  • Text Functions: How to analyze, split and clean worksheet text using the text worksheet functions including RIGHT, MID, LEFT, SUBSTITUTE, TRIM, CLEAN, SEARCH and REPLACE

  • String Concatenation: How to perform concatenation in Microsoft Excel worksheet formulas

  • Text to Columns: How to split combined cell text into separate columns on the worksheet

  • Basic Array Formulas: How to use basic array formulas to build summary sheets

  • Basic Dashboard Construction: How to use the Excel skills mentioned above to build a business dashboard

  • Business Chart Construction: How to build professional looking business charts in Microsoft Excel

  • Pivot Tables: How to create and use basic Microsoft Excel pivot tables

  • Link Excel to Word and PowerPoint: Learn the basics of linking Microsoft Excel to Word and PowerPoint for report generation

 

Signup, Pricing and Self-Study

The Public and Webinar buttons below will lead you to our training schedule page listing all possible dates, prices and signups for those training categories. If you are unsure what a webinar is click here. The Self-Study button will lead you to our manual page where you can get the manual pricing and the manual outline. The manual comes with the class.

For our public workshops, you travel to us in Thousand Oaks, CA

Our webinar (webcast) is broadcast live, is voice interactive, hands-on training

Microsoft Excel Business Essentials Self Study, Note: manual supplied with workshop

 

Hotel and Directions Training Location

 

Learn about our onsite workshops Learn about our live Microsoft Excel training webcasts Close Training Areas

 

Typical Workshop Examples

Basic Formula Design

Basic Formula Design Including Naming Cells and Formula Debugging

 

Conditional Formatting and Data Validation Review

Conditional Formatting (Coloring Cells Automatically) and Data Validation (Drop Downs in Cells) Review

 

Table Design and VLOOKUPS

Proper Table Design and Table Lookups Using VLOOKUP, MATCH and INDEX

 

Nesting Worksheet Functions and Building Smart Worksheets

Nesting Worksheet Functions Review Including Constructing Smart Worksheets Using the IF Function

 

Basic Dashboard Construction

Basic Dashboard Construction Using Functions Like SUMIF, COUNTIF and Basic Array Formulas

 

Working with Worksheet Text

Working with Worksheet Text Using the Text Worksheet Functions

 

Working with Text Tools Like Text to Columns and Text Wizard

 

Pivot Table Design

Building and Using Microsoft Excel Pivot Tables

 

 

 

 

Site Map 

Copyright © 2002-2013 EMAGENIT All Rights Reserved