Course Outline

MS Excel 2013

This is a typical 1 day course split up into 5-10 minute lessons so you can follow the outline in sequence or jump to the topic you want to learn about. Typically, a course outline will contain on average 35 Bite Size lessons. Remember to practice your new found skills. This will help to reinforce the learning and retain your skills.

Go to your Learning Tips for the Course Objectives.
Getting Started
Lesson not Started  Spreadsheet Terminology
Lesson not Started  The Excel Environment
Lesson not Started  Getting Help
Lesson not Started  Navigating a Worksheet
Lesson not Started  The Ribbon
Lesson not Started  Customising the Ribbon
Lesson not Started  Backstage View
Lesson not Started  Live Preview
Lesson not Started  Quick Access Toolbar
Lesson not Started  Mini Toolbar
Lesson not Started  File Formats

Entering and Editing Data
Lesson not Started  Creating,Saving and Closing Workbooks
Lesson not Started  Entering and Editing Text and Values
Lesson not Started  Entering and Editing Text Formulas
Lesson not Started  Working With Pictures
Lesson not Started  Saving and Updating Workbooks

Modifying a Worksheet
Lesson not Started  Moving and Copying Data
Lesson not Started  Moving and Copying Formulas
Lesson not Started  Absolute and Relative References
Lesson not Started  Transpose Columns and Rows

Entering Formulas and Functions
Lesson not Started  Order of Calculation
Lesson not Started  Understanding Formulas
Lesson not Started  Entering Functions
Lesson not Started  Autosum
Lesson not Started  Minimum and Maximum Functions
Lesson not Started  Average Function
Lesson not Started  Count Function

Inserting/Deleting Rows/Columns
Lesson not Started  Inserting Rows and Columns
Lesson not Started  Deleting Rows and Columns
Lesson not Started  Inserting and Deleting Ranges

Formatting Worksheets
Lesson not Started  Format Font and Size Type
Lesson not Started  Font Formatting
Lesson not Started  Aligning Data in a Cell
Lesson not Started  Text Wrapping
Lesson not Started  Merge and Centre Data
Lesson not Started  Text Orientation
Lesson not Started  Row and Column Formatting
Lesson not Started  Formatting Numbers
Lesson not Started  Conditional Formatting
Lesson not Started  Working with Comments
Lesson not Started  Format Painter
Lesson not Started  Clearing Formatting

Printing
Lesson not Started  Preparing to Print
Lesson not Started  Page Setup Options
Lesson not Started  Printing Worksheets

Creating Charts
Lesson not Started  Chart Basics
Lesson not Started  Formatting Charts

Managing Large Worksheets
Lesson not Started  Viewing Large Worksheets
Lesson not Started  Printing Large Worksheets
Lesson not Started  Working with Multiple Worksheets