Microsoft Excel Training Courses

Microsoft Excel Training

Learn Microsoft Office Excel

Microsoft Excel Training Courses

Microsoft Office Excel is a spreadsheet application that works with text, numbers, and date information. It gives you the ability to manipulate data easily, to your disposal. You can perform basic calculations, create tables, charts, and pivot tables.

Excel is widely used for organization of information and tracking data as in a list of sales leads, contact list, or inventory levels. Excel is also useful for statistical analysis with large data sets using graphing and charting tools.

This powerful program can analyze data that you have imported from or exported to other applications. Excel gives the user the option of using VBA (Visual Basic Application) to code directly using the Visual Basic Editor.

Microsoft Office programs are integrated into almost every type of business/corporation. From entrepreneurs to Government offices, proficiency in programs such as Word, Excel, and Outlook are usually required qualifications for any job description. Maximize your chances of employment by being familiar with the most current Microsoft Office version.

What We Offer

check below for our course descriptions

We offer courses in Excel Level 1, Excel Level 2, Excel Level 3, Excel Level 4, and Custom Excel courses. Courses can be delivered in 3-hour blocks, and scheduled in the morning, afternoon, or early evenings. Yes, we also provide weekend training classes.

Microsoft Excel - Level 1

Who should attend: This course is intended for new Microsoft Excel users.

Prerequisites: Windows 7, Windows 8, or Windows 10.

Duration: 6 Hours

Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:

Create, save, open, close and move around in an Excel workbook to learn navigation skills necessary for creating and using Excel worksheets.
Organize columns and rows to accommodate information and edit the contents of cells to organize the information in your worksheet.
Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute cell reference, create formulas by typing functions or build more complex formulas using the Insert Function dialog box.
Format worksheets and use view features to more effectively review large worksheets.
Use views to determine the layout of a worksheet, change the page setup, and preview/print workbooks.

Course Content

Getting Started with Excel:

Understanding Spreadsheet Concepts
Creating and Saving Workbooks
Opening and Closing Workbooks

Modifying Worksheets:

Working with Columns and Rows
Working with Cell Contents

Using Formulas and Functions:

Creating and Using Formulas
Creating and Using Functions
Using Absolute Cell References
Inserting Functions

Formatting and Viewing Worksheets:

Formatting Worksheets
Viewing Worksheets

Printing Workbooks:

Using Workbook Views
Changing the Page Setup
Previewing and Printing Workbooks

Microsoft Excel - Level 2

Who should attend: This course is intended for participants who are familiar with Microsoft Excel.

Prerequisites: Microsoft Excel – Level 1 or Equivalent.

Duration: 6 Hours

Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:

Organize, protect, and display data using various tools.
Use the IF function, create linking formulas, and manage links.
Manage and arrange multiple workbooks, insert and manage multiple worksheets within a workbook, and consolidate data from multiple sources.
Create and modify charts to present data effectively; customize charts to enhance their appearance.
Create, apply and modify styles to format worksheets consistently and quickly; use comments, text boxes to annotate worksheets, and Sparklines to highlight and explain data.

Course Content

Worksheet Organization:

Managing Range Names
Creating and Using Workbook Templates
Applying Worksheet Security
Creating and Using Outlines

Advanced Formulas:

Using the IF Function
Linking Formulas
Modifying and Restoring Links

Using Multiple Workbooks and Worksheets:

Working with Multiple Workbooks
Working with Multiple Worksheets
Consolidating Data

Working with Charts:

Creating Charts
Changing Chart Data
Modifying Chart Elements
Creating Custom Charts

Applying Formatting:

Working with Styles
Annotating Worksheets
Using Sparklines

Microsoft Excel - Level 3 Datasheet Management

Who should attend: This course is intended for participants who are familiar with Microsoft Excel.

Prerequisites: Microsoft Excel – Level 2 or Equivalent.

Duration: 6 Hours

Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:

Create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form, as well as look up data.
Sort records in a data list using a variety of methods.
Filter data in a list using a variety of methods, as well as work with filtered data.
Create and work with subtotalled lists, as well as use various database functions to summarize data.
Create, modify, and work with PivotTables, PivotCharts, and Slicers.
Import external data from a variety of sources into Excel.

Course Content

Maintaining Data:

Data List and Excel Table Concepts
Using Data Forms
Using Lookup Tables

Sorting Lists:

Sorting Concepts
Sorting Lists
Custom Sort Orders

Filtering Lists:

Filtering Concepts
Using AutoFilter
Using Advanced Filter
Working with Filtered Data

Summarizing Data:

Automatic Subtotals
Working with Subtotalled Lists
Using Functions to Summarize Data

Working with PivotTables:

Working with External Data:

External Data Concepts
Importing Query Data from Access
Importing Query Data from Web Pages
Importing Query Data from Text Files

Microsoft Excel - Level 3 Spreadsheet Analysis

Who should attend: This course is intended for participants who are familiar with Microsoft Excel.

Prerequisites: Microsoft Excel – Level 2.

Duration: 6 Hours

Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:

Use absolute and mixed references in a formula, as well as using financial functions.
Use the Goal Seek feature and Data Tables.
Create and manage scenarios, as well as create scenario reports.
Define and solve problems with Solver, as well as create reports.
Understand and utilize the various tools used to audit workbooks.

Course Content

Using Functions:

Function Concepts
Absolute and Mixed References
Financial Functions

Projecting Figures:

Goal Seek
Data Tables

Performing What-If Scenarios:

Scenario Concepts
Creating Scenarios
Managing Scenarios
Scenario Reports

Using Solver:

Solver Concepts
Defining the Problem
Solving the Problem
Solver Reports
Solver Options

Auditing Workbooks:

Auditing Concepts
Tracing a Worksheet
Evaluating Formulas
Locating and Correcting Errors in Formulas
Tracking Cells in a Workbook

Microsoft Excel - Level 4 VBA Macros

Who should attend: This course is intended for participants who are familiar with Microsoft Excel.

Prerequisites: Microsoft Excel – Level 3.

Duration: 6 Hours

Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:

Understand key concepts that will be used to build custom solutions using Microsoft Excel VBA Macros.
Become familiar with basic macro techniques for recording, writing, running, and maintaining macros.
Understand how Visual Basic for Applications is incorporated, used, and modified in Microsoft Excel.
Learn how to design and layout a user form and controls to create a customized dialog box to simplify data entry.
Understand how to prepare an Excel Workbook containing macros and toolbars for deployment to other users and machines.
Learn to customize macros with VBA source code to automate data entry tasks and enable source code protection.
Learn to enhance source code with variables, constants, and logical operators.
Learn to handle the three types of errors that can be generated when working with source code.
Learn to access external data by using ActiveX Data Objects.
Learn how to use Excel as an automation server to control Excel objects externally outside of the application.

Course Content

Building Solutions:

Course Overview
Solution Concepts
Data Entry Concepts
Macro Concepts
Programming Concepts

Macro Basics:

Planning Macros
Recording Macros
Executing Macros
Maintaining Macros

VBA Programming Basics:

Understanding Objects
Using the Visual Basic Editor
Understanding VBA Code
Executing VBA Code
VBA Help Reference

VBA User Form Basics:

Planning User Forms
Designing User Forms

Deployment Basics:

Preparing for Deployment
Code Security
Adding Macros to the Quick Access Toolbar
Modifying Quick Access Toolbar Buttons

Customizing Macros:

Prompting for User Input
Automating Data Entry
Recording Absolute vs. Relative References
Protecting VBA Source Code

Enhancing VBA Code:

Writing Source Code
Variables and Constants
Writing Tips
Logical Operators
Flow Control

Handling Errors:

Handling Errors
Syntax Errors
Logical Errors
Run-Time Errors

Accessing External Data:

External References
ActiveX Data Objects Concepts
Connecting to a Database
Retrieving Records from a Database

Excel Automation:

Automation Concepts
Working with Object Models
Excel’s Object Model
Automating Excel with VBScript

One stop
shop for your business

3450 Uptown Boulevard, Suite 301 Victoria BC, V8Z 0B9

250-508-5774

Not the time for Negative Messages

March 31, 2021 No Comments

Over the years I have been involved in many discussions about marketing negative messages to perspective clients. For those who are not aware of what

Find Us Here

2020 Vancouver Island Works Project