Microsoft Excel - Introduction
Course Description
This is a Microsoft Excel Introduction course. The teaching approach contains a mix of lectures, practical and one-to-one work and varies according to the people attending. For the most part, candidates are able to work at a pace which best suits them, and emphasis is placed upon quality of learning, rather than quantity.
Course Duration
1 day
Course Objectives
The course provides candidates with practical experience of the topics listed in the course outline below. On completion, candidates should have an excellent knowledge of the basic concepts of Excel.
Course Content
A FIRST LOOK AT EXCEL
Starting the Excel program
What is the Active Cell?
The Excel cell referencing system
Worksheets and Workbooks
Saving a workbook
Opening a workbook
HELP
Getting help
The Help Table of Contents
Printing a Help topic
Alt key help
SELECTION TECHNIQUES
Selecting a cell
Selecting a range of connecting cells
Selecting a range of non-connecting cells
Selecting the entire worksheet
Selecting a row
Selecting a column
MANIPULATING ROWS AND COLUMNS
Inserting rows into a worksheet
Inserting columns into a worksheet
Deleting rows within a worksheet
Deleting columns within a worksheet
Modifying column widths
Modifying column widths using drag and drop
Automatically resizing the column width to fit contents
Modifying row heights
COPYING, MOVING AND DELETING
Copying the cell or range contents
Deleting cell contents
Moving the contents of a cell or range
Editing cell content
Undo and Redo
AutoFill
Sorting a cell range
MANIPULATING WORKSHEETS
Switching between worksheets
Renaming a worksheet
Inserting a new worksheet
Deleting a worksheet
Moving a worksheet
FONT FORMATTING
Font type
Font size
Bold, italic, underline formatting
Cell border formatting
Formatting the background colour
Formatting the font colour
NUMBER FORMATTING
Number formatting
Decimal point display
Comma formatting
Currency symbol
Date styles
Percentages
FREEZING ROW AND COLUMN TITLES
Freezing row and column titles
FORMULAS
Creating formulas
Operators
CELL REFERENCING
Relative cell referencing within in formulas
Absolute cell referencing within formulas
FUNCTIONS
What is a function?
Common functions
Sum function
Average function
Max function
Min function
Count function
What are IF functions?
Using the IF function
WORKSHEET SETUP
Worksheet margins
Worksheet orientation
Headers and Footers
Scaling your worksheet to fit a page(s)
PREPARING TO PRINT A WORKSHEETS
Visually check your calculations
Previewing a worksheet
Zooming the views
Starting the Excel program
What is the Active Cell?
The Excel cell referencing system
Worksheets and Workbooks
Saving a workbook
Opening a workbook
HELP
Getting help
The Help Table of Contents
Printing a Help topic
Alt key help
SELECTION TECHNIQUES
Selecting a cell
Selecting a range of connecting cells
Selecting a range of non-connecting cells
Selecting the entire worksheet
Selecting a row
Selecting a column
MANIPULATING ROWS AND COLUMNS
Inserting rows into a worksheet
Inserting columns into a worksheet
Deleting rows within a worksheet
Deleting columns within a worksheet
Modifying column widths
Modifying column widths using drag and drop
Automatically resizing the column width to fit contents
Modifying row heights
COPYING, MOVING AND DELETING
Copying the cell or range contents
Deleting cell contents
Moving the contents of a cell or range
Editing cell content
Undo and Redo
AutoFill
Sorting a cell range
MANIPULATING WORKSHEETS
Switching between worksheets
Renaming a worksheet
Inserting a new worksheet
Deleting a worksheet
Moving a worksheet
FONT FORMATTING
Font type
Font size
Bold, italic, underline formatting
Cell border formatting
Formatting the background colour
Formatting the font colour
NUMBER FORMATTING
Number formatting
Decimal point display
Comma formatting
Currency symbol
Date styles
Percentages
FREEZING ROW AND COLUMN TITLES
Freezing row and column titles
FORMULAS
Creating formulas
Operators
CELL REFERENCING
Relative cell referencing within in formulas
Absolute cell referencing within formulas
FUNCTIONS
What is a function?
Common functions
Sum function
Average function
Max function
Min function
Count function
What are IF functions?
Using the IF function
WORKSHEET SETUP
Worksheet margins
Worksheet orientation
Headers and Footers
Scaling your worksheet to fit a page(s)
PREPARING TO PRINT A WORKSHEETS
Visually check your calculations
Previewing a worksheet
Zooming the views
Who should attend?
This is a course with a high level of practical content, aimed at those who have not used Microsoft Excel for Windows before. It is designed for candidates with widely differing experience and skill levels.
Pre-requisites
No previous experience of Microsoft Excel for Windows is necessary, but candidates should have a good understanding of computer basics and be familiar with the Windows operating system.
