Excel Online Training

We provide leading-edge online training in Microsoft® Excel

Excel 1 Course – Basic

20 Course Hours  |  Course Fee: $220 + Tax

Excel 1 Details
Registration
Microsoft Excel 101 Online Training

Topics Covered:

  • Excel Fundamentals and Terminology
  • Navigating and Understanding the Structure of Excel
  • Creating, Saving and Closing Workbooks and Worksheets
  • Customizing Excel Options
  • Entering and Editing Text, Numbers and Formulas
  • Using Undo/Redo, Find and Replace, and Go To Commands
  • Working with Ranges
  • Using Copy, Cut, Paste Commands
  • Manipulating Rows and Columns
  • Using the AutoFill and Flash Fill Commands
  • Formatting Text and Cells
  • Using the Format Cells Dialog Box
  • Hiding/Unhiding and Freezing/Unfreezing Rows and Columns
  • Adjusting Margins, Orientation and Paper Size
  • Defining Print Areas and Printing a Worksheet
  • Inserting and Editing Headers and Footer
  • Understanding Relative, Absolute and Mixed References
  • Using the AutoSum Command
  • Using the Insert Function Command for Basic Commands
  • Modifying Worksheets and Workbooks
  • Copying, Renaming, Grouping and Repositioning Worksheets
  • Adding and Deleting Worksheets
  • Changing Worksheet Tab Colours
  • Using 3D Referencing in Formulas
  • Excel Fundamentals and Terminology
  • Navigating and Understanding the Structure of Excel
  • Creating, Saving and Closing Workbooks and Worksheets
  • Customizing Excel Options
  • Entering and Editing Text, Numbers and Formulas
  • Using Undo/Redo, Find and Replace, and Go To Commands
  • Working with Ranges
  • Using Copy, Cut, Paste Commands
  • Manipulating Rows and Columns
  • Using the AutoFill and Flash Fill Commands
  • Formatting Text and Cells
  • Using the Format Cells Dialog Box
  • Hiding/Unhiding and Freezing/Unfreezing Rows and Columns
  • Adjusting Margins, Orientation and Paper Size
  • Defining Print Areas and Printing a Worksheet
  • Inserting and Editing Headers and Footer
  • Understanding Relative, Absolute and Mixed References
  • Using the AutoSum Command
  • Using the Insert Function Command for Basic Commands
  • Modifying Worksheets and Workbooks
  • Copying, Renaming, Grouping and Repositioning Worksheets
  • Adding and Deleting Worksheets
  • Changing Worksheet Tab Colours
  • Using 3D Referencing in Formulas

Excel 2 Course – Intermediate

20 Course Hours  |  Course Fee: $220 + Tax

Excel 2 Details
Registration
Microsoft Excel 102 Online Training

Topics Covered:

  • Excel Terminology
  • Creating, Entering and Formatting Tables
  • Inserting and Deleting Rows and Columns in a Table
  • Totalling and Sorting Data in a Table
  • Using Auto Filter and Creating Custom Filters
  • Converting a Table into a Range
  • Creating, Moving and Resizing Charts
  • Formatting Chart Layouts, Styles, Text, and Elements
  • Changing Chart Types
  • Customizing Axis
  • Creating Advanced Charts: Pie, Maps, Funnels
  • Moving Charts to Different Worksheets
  • Saving Chart Templates
  • Using and Customizing Sparklines
  • Inserting Pictures, Shapes, Icons and 3D Models into a Worksheet
  • Inserting WordArt and SmartArt
  • Taking a Screenshot in Excel
  • Inserting Simple and Complex Equations
  • Introduction to Logical and Financial Functions
  • Using IF, Nested IF and IFS Functions
  • Using AND and OR Functions
  • Using PMT, FV, and PV functions
  • Using the Auto Calculate feature
  • Introduction to Date and Time Functions
  • Adding and Subtracting Dates
  • Calculating Time Intervals
  • Emailing a Workbook
  • Converting Worksheets to Webpages
  • Inserting Hyperlinks and Comments
  • Creating, Editing and Using Workbook Templates
  • Showing and Hiding Workbook Elements
  • Creating a Workspace
  • Comparing Workbooks Side by Side
  • Saving Workbooks in Multiple File Formats
  • Using Data Consolidation
  • Excel Terminology
  • Creating, Entering and Formatting Tables
  • Inserting and Deleting Rows and Columns in a Table
  • Totalling and Sorting Data in a Table
  • Using Auto Filter and Creating Custom Filters
  • Converting a Table into a Range
  • Creating, Moving and Resizing Charts
  • Formatting Chart Layouts, Styles, Text, and Elements
  • Changing Chart Types
  • Customizing Axis
  • Creating Advanced Charts: Pie, Maps, Funnels
  • Moving Charts to Different Worksheets
  • Saving Chart Templates
  • Using and Customizing Sparklines
  • Inserting Pictures, Shapes, Icons and 3D Models into a Worksheet
  • Inserting WordArt and SmartArt
  • Taking a Screenshot in Excel
  • Inserting Simple and Complex Equations
  • Introduction to Logical and Financial Functions
  • Using IF, Nested IF and IFS Functions
  • Using AND and OR Functions
  • Using PMT, FV, and PV functions
  • Using the Auto Calculate feature
  • Introduction to Date and Time Functions
  • Adding and Subtracting Dates
  • Calculating Time Intervals
  • Emailing a Workbook
  • Converting Worksheets to Webpages
  • Inserting Hyperlinks and Comments
  • Creating, Editing and Using Workbook Templates
  • Showing and Hiding Workbook Elements
  • Creating a Workspace
  • Comparing Workbooks Side by Side
  • Saving Workbooks in Multiple File Formats
  • Using Data Consolidation