top of page

Excel Basic Course

In this course you will learn:

  • Saving, Opening and Closing Workbooks

  • How to use Autofill

  • Creating Basic Formulas

  • Learn basic functions such as:
    SUM, AVERAGE, and COUNTA

  • Formatting numbers and text

  • How to create a column and pie charts

  • Printing spreadsheets
     

Hire a corporate MS Excel Instructor

Data on a Touch Pad

Microsoft Excel Training

Excel Intermediate Course

 

In this course you will learn:

  • Linking between worksheets and workbooks

  • Text Functions (such as Proper, Concatenate)

  • Sorting and Filtering

  • Creating Tables

  • Pivot Tables and PivotCharts

  • Using Slicers

  • Creating Subtotals

  • Creating Named Ranges

  • Protecting a Worksheet

 

Hire a corporate MS Excel Instructor

Excel Advanced Course

In this course you will learn:

  • Logical Functions (IF, AND, OR)

  • Math Functions (SUMIF, COUNTIF, etc.)

  • VLOOKUP function

  • Data Validation (creating drop down lists)

  • What If Analysis Tools:
    Goal Seek, Data Tables, Scenarios

  • Import Text Data and Convert text to Columns

  • How to create and edit simple Macros
     

Hire a corporate MS Excel Instructor

bottom of page