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