Ready to Learn More

Microsoft Excel Training Toronto

Our Microsoft Excel 2013 or 2016 hands on instructor led training courses will make you fully competent to perform your job independently.

Microsoft Excel 2016 ( Beginners)

Overview

If you are new to Excel, this course will teach you the essential skills needed to start using Excel spreadsheets. You will learn to navigate with ease, enter data into spreadsheets, manipulate data, format data and start creating formulas and using functions. At the end of the course, students will be confident to work with the pre-created spreadsheets or create his own spreadsheet.

Course Outline:

Navigating easily in Excel
  • Using the Ribbon – Tabs, Groups and Commands
  • Cells, columns and rows
  • Shortcut Keys combinations
  • Freezing, splitting and zooming the screen
  • Hiding columns and rows
Entering Data
  • Formatting Dates and Times
  • Check spelling
  • Undo / redo
  • Create and modify tables
  • Sorting and Filtering tables
Start Creating Formulas
  • Add,
  • Subtract,
  • divide and
  • multiply
  • What is cell reference
Start Using Built-in Excel Functions
  • Manually type functions
  • Use functions button
  • AutoSum, Average, Count, Min and Max
Moving and Copying Data
  • Cut, Copy and Paste
  • Fill Handle
  • Autofill
  • Flash Fill
  • Smart Tags
Organizing and Working with Multiple worksheets
  • Renaming and coloring tabs
  • Moving, copying and inserting worksheets
  • Margins
  • Headers and Footers
  • Printing Options
Formatting with Excel
  • Adjusting width/height of column/rows
  • Cell alignments
  • Wrapping and merging
  • Formatting numbers

Microsoft Excel 2016 (Intermediate)

Overview

Excel 2016 for Windows has all the functionality and features you're used to, with some added features and enhancements.

Course Outline

Creating and Editing Worksheets
  • Introducing Flash Fill
  • Selecting and Naming Cell Ranges
  • Using Column Headers to define names
  • Moving around the worksheet
  • Copying one or more cells to many
Manipulating Numbers
  • Creating, editing, and copying formulas
  • Using the AutoSum button and built-in function
  • Inserting Functions
  • Using relative, fixed and mixed cell references
  • Using names in formulas and validating cell entries
Working with Text in Excel
  • Combining text from multiple cells into one string
  • Copying cells containing formulas and passing only their resulting values
Analyzing Data
  • Using the Quick Analysis tools
  • Analyzing data from another source
  • Filtering data with tables
  • Adding data to tables
  • Sorting data and creating a custom sort list
PivotTable
  • Creating a PivotTable
  • Editing and modifying a PivotChart
Formatting Worksheets
  • Applying number formatting
  • Formatting with styles
Lookup Functions
  • HLOOKUP
  • VLOOKUP
Introduction to Working with Macros
  • Creating Macro
  • Running Macro
  • Editing Macro

Microsoft Office Excel 2016 (Advanced)

Overview

Excel 2016 for Windows has all advance topics including v-lookup, h-lookup, Pivot table, tables, forms, auto reporting and macros. Here are some of the new and improved features.

Course Outline

Perform calculations on data
  • Name groups of data
  • Define Excel tables
  • Create formulas to calculate values
  • Summarize data that meets specific conditions
  • Set iterative calculation options and enable or disable
  • Automatic calculation
  • Use array formulas
  • Find and correct errors in calculations
Manage worksheet data
  • Limit data that appears on your screen
  • Manipulate worksheet data
  • Define valid sets of values for ranges of cells
Reorder and summarize data
  • Sort worksheet data
  • Sort data by using custom lists
  • Organize data into levels
  • Look up information in a worksheet
Analyze alternative data sets
  • Examine data by using the Quick Analysis Lens
  • Define an alternative data set
  • Define multiple alternative data sets
  • Analyze data by using data tables
  • Vary your data to get a specific result by using Goal Seek
  • Find optimal solutions by using Solver
  • Analyze data by using descriptive statistics
Advanced Functions
  • V-Lookup Advanced
  • V-Lookup with IFERROR – Multiple Match
  • V-Lookup with IFERROR – Multiple Match in Dynamic Tables
  • Compare: Compare and Highlight differences with Conditional Formatting
  • H-Lookup Applying H-Lookup to Multiple Tables
  • Pivot-Tables Creating and Modifying output using Pivot-Tables
  • Dash-Boards Create an Attractive Dynamic Dashboard using Pivot Tables, Pivot Charts & Slicers
  • Summarizing a Multi-sheet Workbook
  • Conditional Formula: Using Logical IF with AND / OR Operators
  • Creating a Macro and Editing in VB Editor
  • Modifying the Macro using the VB Editor to dynamically update the changes in the Data Range
Schedule

Please contact OptionTrain (416)486-6555 or info@optiontrain.com