Microsoft Excel Introduction

This one day course has been designed for new users to Excel who need to understand the basic fundamentals. By the end of the course, you will be confident in using the essential features of Excel to create and alter simple spreadsheets, using formulae.

The Fundamentals

• Starting Excel
• Understanding the Excel Program Screen
• Understanding the Ribbon
• Using the Office Button and Quick Access Toolbar
• Using Keyboard Commands
• Using Contextual Menus and the Mini Toolbar
• Using Help
• Exiting Excel

Worksheet Basics

• Creating a New Workbook
• Opening a Workbook
• Navigating a Worksheet
• Entering Labels
• Entering Values
• Selecting a Cell Range
• Overview of Formulas and Using AutoSum
• Entering Formulas
• Using AutoFill
• Understanding Absolute and Relative Cell References
• Using Undo and Redo
• Saving a Workbook
• Previewing and Printing a Worksheet
• Closing a Workbook

Editing a Worksheet

• Editing Cell Contents
• Cutting, Copying, and Pasting Cells
• Moving and Copying Cells Using the Mouse
• Using the Office Clipboard
• Inserting Cells, Rows, and Columns
• Deleting Cells, Rows, and Columns
• Using Find and Replace
• Using Cell Comments

Formatting a Worksheet

• Formatting Labels
• Formatting Values
• Adjusting Row Height and Column Width
• Modifying Cell Alignment
• Adding Cell Borders, Background Colour and Fill Pattern

Introduction to Charting

• Creating a Chart
• Resizing and Moving a Chart
• Changing Chart Type
• Applying Built-in Chart Layouts and Styles