MS Excel - Introduction
One Day Training Course / £150 plus VAT
Introduction
This one-day instructor led course is designed to give a thorough introduction to the basic skills needed to use Excel effectively. By the end of the course delegates will be able to create, modify and format Excel spreadsheets including designing basic formulas and charts.
Course Objectives
- Understand the terminology used in Excel
- Open, close, save and print Excel worksheets
- Enter, edit and format data
- Use formulas and functions to calculate in Excel
- Create and format a simple chart
Pre-requisites
We recommend that all those who attend are able to:
- Use the mouse to select and open menus and icons
- Identify and use the Shift, Ctrl, TAB and Home keys on the keyboard
Course Content
|
Excel Basics
|
Printing
|
|
|
- Exploring the Excel window
|
- Preparing to print
|
|
|
- Spreadsheet terminology
|
- Page set up options
|
|
|
- Opening and Closing workbooks
|
|
|
|
- Navigating around a worksheet
|
Formatting and Manipulating Worksheets
|
|
|
- Keyboard Shortcuts and Menu Items
|
- Formatting text
|
|
|
|
- Formatting rows and columns
|
|
|
Entering and Editing Data
|
- Formatting numbers
|
|
|
- Creating a new Excel workbook
|
- Inserting rows and columns
|
|
|
- Entering and editing labels and values
|
- Deleting rows and columns
|
|
|
- Selecting cells and data ranges
|
- Freezing panes
|
|
|
- Moving and copying data
|
- Splitting the screen
|
|
|
- Linking worksheets in a workbook
|
|
|
|
- Saving and updating a workbook
|
Sorting and Filtering
|
|
|
|
- Using Quick Sort buttons
|
|
|
Formulas and Functions
|
- Using AutoFilter
|
|
|
- Creating new formulas
|
|
|
|
- Using SUM function
|
Charts
|
|
|
- Using AVERAGE, MIN, MAX and COUNT
|
- Creating a simple chart using Chart Wizard
|
|
|
- Copying formulas and functions
|
- Formatting a chart
|
|
|
- Understanding Absolute and Relative references
|
|
|
|
- Editing formulas and functions
|
|
|