Microsoft Excel Training

Excel Intro

Excel Level 1 is a one-day instructor led class providing the basic concepts and skills needed to be productive and efficient in Microsoft Excel. By the end of the class, participants will be able to create and edit worksheets and workbooks; perform basic formulas and functions; and understand how to format, manipulate, print, and protect their data.

  • Navigating and Workbook Basics
  • Basic Formulas and Functions
  • Formatting, Styles and Themes
  • Data Entry Shortcuts
  • Autofill, Linking and Paste Options
  • Inserting, Deleting, Hiding Rows and Columns
  • Protecting Worksheets and Workbooks
  • Importing Data
  • Printing and Saving Options
  • and much more — see class outline

Register Now

Date Time Price
Jun 6, 2022 9am - 4pm Pacific $295.00
Register
New Class Schedule will Announce Soon.
Register

Excel Intermediate

Excel Level 2 is a one-day instructor led class teaching mid-level to advanced features and tools of Microsoft Excel to organize and analyze data. Upon successful completion of the course, participants will be able to perform an array of common tasks more confidently and effectively like working with named ranges, tables, advanced formats, and charts.

  • Customizing the Ribbon, Quick Access Toolbar, Status Bar, Options
  • Inserting, Deleting, Hiding and Rearranging Worksheets
  • Creating and Managing Named Ranges
  • Excel Table Structure
  • Creating a Table
  • Conditional and Custom Formats
  • Graphics
  • Visualization Basics, Charts and Sparklines
  • Introduction to Pivot Tables
  • and much more — see class outline

Register Now

Date Time Price
Jun 8, 2022 9am - 4pm Pacific $295.00
Register
New Class Schedule will Announce Soon.
Register

Lookups and Advanced Functions

Excel Level 3 is a one-day instructor led class that will take participants to an advanced level using formulas and functions in Microsoft Excel. By the end of this course, participants will be able to manipulate large data sets more quickly and easily using a variety of advanced functions and formulas. Participants will also be able to summarize data efficiently using the consolidate and subtotals features.

  • Logical & Lookup Functions
  • IF, AND, OR, NOT, IFS
  • Nesting
  • VLOOKUP, HLOOKUP, XLOOKUP
  • Date/Time & Text Functions
  • Reference Functions
  • Statistical & Financial Functions
  • SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS
  • Advances Formulas and Auditing
  • Data Consolidation
  • and much more — see class outline

Register Now

Date Time Price
May 23, 2022 9am - 4pm Pacific $350.00
Register
Jun 13, 2022 9am - 4pm Pacific $350.00
Register
New Class Schedule will Announce Soon.
Register

Macros and Advanced Features

Excel Level 4 is a one-day instructor led class building upon the Level 3 training that continues teaching the more advanced features, macros, and data visualization in Microsoft Excel. Upon successful completion of this course, participants will be able to use what-if analysis to process data and validation to ensure the data in your workbook is appropriate; build lists; and use Quick Analysis features to automate many common tasks.

  • Recording Macros in Excel
  • Relative vs. Absolute Recording
  • Running Macros using Various Techniques
  • Editing and Deleting Macros
  • What-If Analysis including Solver, Goal Seek and Scenario Manager
  • Data Validation
  • Advanced Import/Export/Linking
  • Custom Lists and Views
  • Saving in Different Formats
  • Creating/Editing/Deleting Hyperlinks
  • Quick Analysis Features and Conditional Formatting
  • Data Visualization including Charts, Totals, Tables and Sparklines
  • and much more — see class outline

Register Now

Date Time Price
May 26, 2022 9am - 4pm Pacific $350.00
Register
Jun 17, 2022 9am - 4pm Pacific $350.00
Register
New Class Schedule will Announce Soon.
Register

Pivot Tables

Excel Pivot Tables is a one-day instructor led course covering Pivot Tables, a powerful feature in Microsoft Excel which enables data manipulation with simple dragging and dropping. At the end of this course, participants will be able to sort, filter, group, summarize, and format data with ease and efficiency using Pivot Tables. Pivot Tables allow the ability to analyze your data in a variety of ways to meet your needs.

  • Creating Pivot Tables in Excel
  • Setting up your Source Data
  • Pivoting your Data
  • Drilling Down
  • Sorting Pivot Table Data
  • Grouping by Rows, Columns and Dates
  • Filtering Pivot Table Data
  • Using Slicers to Visually Filter Data
  • Exploring Report Layouts
  • Calculating Pivot Table Values
  • Generating and Manipulating Pivot Charts
  • Show Commands
  • and much more — see class outline

Register Now

Date Time Price
Jun 1, 2022 9am - 4pm Pacific $350.00
Register
Jun 20, 2022 9am - 4pm Pacific $350.00
Register
New Class Schedule will Announce Soon.
Register

Power Pivot & Power Query

Excel Power Pivot is a one-day instructor led course covering the Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can combine large volumes of data from various sources, perform information analysis rapidly, and share insights easily.

  • Importing Data from Access and Excel
  • Relationships Between Data Tables
  • Creating Hierarchies
  • Shaping the Data Model with Data Analysis Expressions Functions (DAX)
  • Calculated Columns and Measures
  • Customizing DAX Expressions
  • Time Intelligence
  • Creating and Relating to a Data Table
  • and much more — see class outline

Register Now

Date Time Price
Jun 3, 2022 9am - 4pm Pacific $350.00
Register
Jun 22, 2022 9am - 4pm Pacific $350.00
Register
New Class Schedule will Announce Soon.
Register

VBA Coding

Excel VBA Coding is a two-day instructor-led advanced Excel class that shows participants how to take complex and time-consuming tasks and automate them with code. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA’s capabilities and to optimize and debug your code. As far as coding languages go, VBA is one of the easier languages to learn.

  • Introduction to Visual Basic for Applications
  • Recording Macros
  • Excel VBA Programming Fundamentals
  • Writing VBA Code Directly
  • Solving Problems through Code
  • Improving Your VBA Code
  • Debugging Code
  • Error Resolution
  • Controlling How and When Macros Run
  • and much more — see class outline

Register Now

Date Time Price
Jun 13, 2022 - Jun 14, 2022 9am - 4pm Pacific $750.00
Register
New Class Schedule will Announce Soon.
Register
×

Subscribe for 10% OFF