Course Content
Microsoft Excel 2016 Essentials
    About Lesson

    After completing this course, participants will have learned to:

    Topic 1

    Getting started

    • Workshop Objectives Explained
    • Pre-Assignment

    Topic 2

    Excel Essentials

    • Objectives
    • Starting Excel
      • Starting Excel
      • Starting Excel in Windows 8 Only
    • What is a Worksheet?
    • What is a Workbook?
    • Identifying Parts of the Screen
    • The Ribbon
    • Using Selection Techniques
      • Selecting a Cell
    • Selecting a Range of Cells
    • Selecting Nonadjacent Cells and Ranges
    • Selecting an Entire Worksheet
    • Entering Data
      • Identifying Types of Data
    • Entering Text Data into a Cell
    • Entering Values
    • Entering Data into a Range
    • Quickly Adjusting a Column Width
    • Finishing a Workbook
      • Saving a New Workbook
    • Saving a Named Workbook
    • Printing a Worksheet
    • Closing a Workbook and Exiting from Excel
    • Assignment

    Topic 3

    Modifying a Workbook

    • Opening a Workbook
      • Opening an Existing Workbook
    • Creating a New Workbook
    • Opening a Recently Used Workbook
    • Creating Simple Formulas
      • Creating a Formula by Typing
    • Creating a Formula by Pointing
    • Using Functions
    • Using the SUM Function
    • Using the AutoSum Button
    • Using AutoSum
    • Using the Formula Palette
    • Editing Data on the Worksheet
    • Replacing the Data in a Cell
    • Editing the Data in a Cell
    • Editing a Formula
    • Clearing the Contents from a Cell or Range
    • Using Undo and Redo
    • Assignment

    Topic 4

    Managing the Worksheet

    • Navigating in a Worksheet
      • Using Special Navigation Keys
    • Using the Scroll Bars and Boxes
    • Moving One Screen
      • Moving to the End of the Worksheet
    • Changing Worksheets
    • Using Go To
    • Changing the Worksheet Structure
      • Inserting Cells, Rows and Columns
    • Deleting Cells, Rows, and Columns
    • Performing a Simple Sort
    • Creating and Using Named Ranges
      • Naming Ranges
    • Automatically Naming Ranges
    • Navigating with Named Ranges
    • Using Range Names in Formulas
    • Pasting a List of Named Ranges
    • Deleting and Editing Range Names
    • Creating Named Constants
    • Assignment

    Topic 5

    Formatting the Worksheet

    • Moving and Copying Data
      • Moving Data
    • Copying Data
    • Copying Data with AutoFill
    • Creating a Series with AutoFill
    • Defining Relative, Mixed, and Absolute References
    • Copying Formulas
    • Changing the Appearance of Data
      • Changing Column Width
    • Changing Row Height
    • Formatting Numbers
    • Fonts
    • Adding Enhancements
      • Using Font Style Attributes
    • Aligning Data in Cells
    • Merging and Centre Cells
    • Rotating and Indenting Text
    • Adding Borders and Shading
    • Assignment

    Topic 6

    Printing the Worksheet

    • Printing a Single Worksheet
      • Using the Print Dialog Box
    • Using Print Preview
    • Creating Headers and Footers
    • Removing the Grid
    • Printing a Workbook
      • Printing a Whole Workbook
    • Printing a Selection
    • Using Print Areas
    • Using Advanced Printing Techniques
      • Changing Page Layout
    • Aligning the Printout
    • Fitting a Document onto a Desired Number of Pages
    • Working with Page Breaks
    • Working with Page Breaks in Normal View
    • Setting Print Titles
    • Removing Print Titles
    • Assignment

    Topic 7

    Course Wrap Up

    • Words from the Wise
    • Lessons Learned