Excel Training: Cells, Workbooks and Graphs


Course Delivery

Live Instructor-Led Training

Course Description

The course Cells, Workbooks and Graphs (Excel Training) teaches you how to work efficiently with cells, worksheets & workbooks. The training includes working with multiple worksheets, useful keyboard shortcuts & functions, absolute & relative references and custom functions. You learn to set your data so that it can be easily sorted and filtered. The course also covers how to create, edit & format graphs in MS Excel. Maximum productivity is within your grasp with Microsoft Excel.

Course Dates and Pricing


Apr 30 - May 1, 2018$1,150.00May 28 - 29, 2018$1,150.00Jun 25 - 26, 2018$1,150.00

Course Outline

Introduction to Microsoft Excel

The Major Elements of Excel: Workbooks, Worksheets and Cells
Identifying and Referencing Cells
Working with Cells, Rows and Columns
Working with Multiple Cells
Adding and Removing Cells, Rows and Columns
Naming Cells and Cell Ranges
Naming Worksheets
Adding and Removing Worksheets
Setting Project Information
Saving and Opening Workbooks
Exercise: Working with Cells and Workbooks

Working with Cell Contents

Entering Numeric Cell Data
Modifying Cell Data
Formatting Numbers: Integers, Decimals, Currency and Percentages
Entering Textual Cell Data
Formatting Textual Data: Font, Size, Weight and Presentation
Working with Dates
Working with Currencies
Creating Custom Formats
Working with Auto-Fill
Creating Custom Auto-Fill Data Sets
Exercise: Adding Content to a Excel Worksheet

Formatting Cells

General Principles of Cell Formatting
Formatting Cells for Vertical and Horizontal Alignment
Formatting Cells for Fill Pattern and Colour
Formatting Cells for Border Style and Thickness
Formatting Cells for Text Behaviour: Wrap and Continue
Working with Multiple Workbooks
Enabling and Disabling Cell Protection
Exercise: Formatting Data for Presentation Purposes

Working with Formulas

The Anatomy of an Excel Function: Parameters and Return Values
Referencing Cells: The Magic of Relative References
Using Absolute References to Pin Down Cell References
Using Named Cells to Pin Down Cell References
Using Arithmetic Operators: Addition, Subtraction, Multiplication and Division
Introduction to Statistical Functions: Count, Average and Median (And maybe variance)
Introduction to Financial Functions: Payments and their Characteristics
Exercise: Creating a Data Summary Sheet with Excel Functions

Business Graphics

Setting Up the Worksheet
Choosing the Right Type of Graph
Creating the Graph
Modifying the Axis Labels
Modifying the Title
Modifying the Legend
Changing the Graph Type
Exercise: Creating a Presentation Graphic with Impact

Course Locations

  • Ottawa

  • Montreal

  • Toronto

Related Microsoft Excel Training

Excel Training: Data Analysis for Business Users

The course Data Analysis for Business Users (Excel Training) teaches you to organize, analyze, validate and present data using Microsoft Excel. Starting with data layout, the course explores basic and advanced functions. The training includes a detailed discussion of conditional, math & logic functions, PivotTables, Charts and a comprehensive introduction to Macro development. Training course titled Excel Training: Data Analysis for Business Users that will allow you to hone your professional skills.

Apr 16 - 17, 2018$1,150.00May 14 - 15, 2018$1,150.00Jun 11 - 12, 2018$1,150.00

Excel Training: Analysis & Reporting for Finance

The course Analysis & Reporting for Finance (Excel Training) teaches you how to use MS Excel to present, analyze and format financial data. The training includes data layout, basic math & financial functions and advanced financial analysis with MS Excel. You learn about present value and future value, WACC, IRR, cash flow calculations & interest considerations. Become a financial wizard with MS Excel. Training course titled Excel Training: Analysis & Reporting for Finance that will allow you to hone your professional skills.

Mar 6 - 9, 2018$2,775.00Apr 10 - 13, 2018$2,775.00May 8 - 11, 2018$2,775.00Jun 5 - 8, 2018$2,775.00

Excel Training: Data Analysis & Reporting

The course Data Analysis & Reporting (Excel Training) teaches you to analyze & report on data using Microsoft Excel. The course covers data layout using multiple Excel worksheets and custom & advanced functions. The training includes Excel graphs, PivotTables and the use of custom functions, sorting & filtering to analyze & report on data. Training course titled Excel Training: Data Analysis & Reporting that will allow you to hone your professional skills.

Apr 23 - 24, 2018$1,150.00May 22 - 23, 2018$1,150.00Jun 18 - 19, 2018$1,150.00

Excel Training: Mastering Task Automation

The course Mastering Task Automation (Excel Training) provides business participants with the skills they need to automate almost any business task. Starting with a review of essential concepts in data analysis using Microsoft Excel, the course quickly proceeds to a complete and in depth study of macros and VBA development. The course covers every aspect of VBA development including the Excel object model, looping, functions, conditional logic and database access amongst others. If you need to use Microsoft Excel to automate your business tasks, this SETC certified course will teach you the skills you need. SETC Training - Formation SETC provides advanced Microsoft Excel training in Ottawa, Montreal, Toronto, Quebec and Calgary. Training course titled Excel Training: Mastering Task Automation that will allow you to hone your professional skills.

Apr 25 - 27, 2018$1,675.00May 23 - 25, 2018$1,675.00Jun 20 - 22, 2018$1,675.00