Topic 1

Getting Started with Microsoft Excel 2016

• Identify the Elements of the Excel Interface
• Create a Basic Worksheet
• Use the Help System

Topic 2

Performing Calculations

• Create Formulas in a Worksheet
• Insert Functions in a Worksheet
• Reuse Formulas

Topic 3

Modifying a Worksheet

• Manipulate Data
• Insert, Manipulate, and Delete Cells, Columns, and Rows
• Search for and Replace Data
• Spell Check a Worksheet

Topic 4

Formatting a Worksheet

• Modify Fonts
• Add Borders and Colours to Cells
• Apply Number Formats
• Align Cell Contents
• Apply Cell Styles

Topic 5

Printing Workbook Contents

• Define the Basic Page Layout for a Workbook
• Refine the Page Layout and Apply Print Options

Topic 6

Managing Large Workbooks

• Format Worksheet Tabs
• Manage Worksheets
• Manage the View of Worksheets and Workbooks

Topic 7

Customizing the Excel Environment

• Customize General and Language Options
• Customize Formula Options
• Customize Proofing and Save Options
• Customize the Ribbon and Quick Access Toolbar
• Customize the Functionality of Excel by Enabling Add-Ins
• Customize Advanced and Trust Centre Options