Customer Service Training Course

Microsoft Excel 2016 Course

Let’s get started

  • Overview of Excel 2016. What you can use Excel for.
  • Let's get started with Excel 2016
  • What is new in Excel 2016?

How To use the Excel 2016 Ribbons

  • How to use the File Menu in Excel 2016
  • How to use the Home ribbon
  • How to use the Insert ribbon
  • How to use the Page Layout ribbon
  • How to use the Formulas ribbon
  • How to use the Data ribbon
  • How to use the Review ribbon
  • How to use the View ribbon
  • How to move/customize the Quick Access toolbar
  • How To find Help Inside Excel 2016
  • How To speed up Excel 2016 Performance

How to use your working files

  • Download your working files
  • How to use your working files

How To use Workbooks and Worksheets in Excel 2016

  • The difference between a worksheet and a workbook
  • How to use workbooks and worksheets
  • How to create a new workbook
  • How to Save a Workbook. Different file formats.
  • How and why to Save As
  • How to find your way around a workbook
  • How to view recent workbooks
  • How to work with columns and rows
  • How to change cell properties of an entire worksheet
  • How to format a worksheet
  • How to name and rename worksheet tabs
  • How to move worksheets within a workbook
  • How to move worksheets between workbooks
  • How to Insert (add) worksheets
  • How to Delete worksheets
  • How to View multiple workbooks
  • How and why to Hide or Unhide a worksheet

How To Enter and Select Data

  • How to enter text in a workbook cell
  • How to enter numbers in a workbook cell
  • How to enter dates and times in a workbook cell
  • How to undo and redo an action
  • How to edit a cell in a workbook
  • How to cut, copy and paste in a workbook
  • How to use the fill handle
  • How and why to use undo and redo
  • How to use Zoom
  • How to insert and delete Columns
  • How to insert and delete Rows
  • How to insert and delete Cells
  • How to Wrap text in Cells
  • How and why to change column Widths
  • How and why to change row Heights
  • How and why to Hide and Unhide a Column
  • How and why to Hide and Unhide a Row
  • How to use the Go To commands
  • How to use Spellcheck
  • How to use the Replace command
  • How to use the Find command
  • How and why to use the Format Painter
  • How to Drag and Drop Cells

Math Basics

  • Getting Started with Formulas
  • Order Of Operation with BODMAS
  • Introduction To Formulas
  • Copying Formulas and Functions
  • Displaying Formulas On a Worksheet

How To Format Your Workbooks and Worksheets

  • How to select cells for formatting
  • How to merge and wrap cells
  • How to change fonts, font sizes, font colors, bold, italics and underlining
  • How to apply different number formats
  • How to align and orientate cell contents
  • How to change the Direction of text in a cell
  • How to add or remove Borders in cells or cell ranges
  • How to apply a Date format to a cell or a cell range
  • How to clear Cell Contents
  • How to find and replace a Format
  • How to use the Format Painter
  • Clearing cell contents versus clearing the cell formatting
  • How and why to use Themes in your worksheets
  • How to use the Comments function
  • How to create an Auto Fill list
  • How to turn data into a table
  • How to get data from a website
  • How to edit more than one worksheet at a time

Workbook and Worksheet Management

  • Worksheet Navigation and Coloured Worksheet Tabs
  • Moving Or Copying Worksheets Within and Between Workbooks
  • Viewing and Scrolling Multiple Workbooks At the Same Time
  • Hiding and Un-Hiding Sheets
  • Modifying More Than One Worksheet At a Time

How to print with Excel 2016

  • How to Preview printing
  • How to choose the correct Printer
  • How to Print
  • Using a Print Area
  • Paper Size and Orientation.
  • Scaling options
  • How to print a range of cells
  • How and why to adjust your page Margins
  • How to add a Headers or Footer
  • How to use the Page Break view
  • How to use print Titles for large worksheets
  • How to print with Gridlines
  • How to use the Page Layout view
  • Controlling most print settings in one place

How To Calculate with Excel 2016

  • Why use Excel Calculations?
  • How to Add using a Formula
  • How to Subtract using a Formula
  • How to Multiply using a Formula
  • How to Divide using a Formula
  • How to use Exponent using a Formula
  • How to use Operations with BODMAS
  • How to use SUM in Excel Formulae
  • How to use Average, Min, and Max
  • How to Copy Formulas and Functions
  • How to Display Formulae
  • How to use Counting Functions
  • What is Absolute Referencing?
  • Using formulas across worksheets
  • What is 3D Referencing?
  • Making use of named cells and ranges

Managing Security in Excel 2016

  • How to Password Protect and Unprotect a Worksheet
  • How to protect part of a worksheet to aid data entry
  • How to password protect the whole workbook

Excel 2016 Templates

  • Using the 2016 Templates
  • Creating and Using Your Own Template

Using Graphics

  • Obtaining and Inserting Online Images
  • Using SmartArt Graphics
  • Inserting Shapes and Screenshots
  • Formatting Graphical Objects
  • The Stacking Order
  • Grouping Multiple Objects Together
  • Using Graphical Objects and Mathematical Formulas

Creating a Chart in Excel

  • The Charts Option
  • Create a Chart using the long or the short method
  • Formatting a Chart with the 2016 Shortcut options
  • Modifying the chart Type
  • Formatting Chart Elements
  • Adding a Trendline
  • The Pie Chart in Detail
  • Mini Graphs: Sparklines

Conditional Formatting in Excel 2016

  • What Is Conditional Formatting? What do I use it for?
  • How to create a Formatting Rule
  • How To Change or delete Conditional Formatting Rules
  • How To Highlight Duplicate Values with Conditional Formatting
  • How To Identify the Top Or Bottom Percentage Of Ranges
  • How To use Data Bars
  • How To use Colour Scales
  • How To apply An Icon Set