Excel Introduction

Lesson 1: Getting Started with Microsoft Excel

·       Identify the Elements of the Excel Interface

·       Create a Basic Workbook

·       Get Help in Excel

 

Lesson 2: Working with Data

·       Create Formulas in a Worksheet

·       Use Formulas and Functions

·       Sort and Filter Data

·       Create and Format Tables

 

Lesson 3: Modifying a Worksheet

·       Edit Data

·       Insert and Delete Cells, Columns and Rows

·       Search For and Replace Data

·       Spell Check a Worksheet

 

Lesson 4: Formatting a Worksheet

·       Format Text

·       Format Cells

·       Align Cell Content

 

Lesson 5: Printing Workbook Contents

·       Define the Basic Page Layout for a Workbook

·       Refine the Page Layout and Apply Print Options

 

Lesson 6: Managing Large Workbooks

·       Format Worksheet Tabs

·       Manage Worksheets

·       Manage the View of Worksheets and Workbooks

 

Lesson 7: Customising the Excel Environment

·       Customise Excel Options

·       Customise the Ribbon and Quick Access Toolbar

·       Customise the Functionality of Excel by Enabling Add-Ins

·       Customise Advanced and Trust Centre Options

 

Lesson 8: Visualising Data with Charts

·       Create Charts

·       Modify and Format Charts

·       Create a Trendline