Corporate and Private Computer Training
Online and In-person Training Available
Proudly Canadian - Office in Mississauga, Ontario
Call: (647) 449-9065
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
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
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