Microsoft Office Excel - Introduction
1 Day Duration
Overview
This introductory course is aimed at users who have little or no previous working knowledge of Microsoft Office Excel. This will provide delegates with hands on experience of creating spreadsheets from scratch, printing and page set up options, as well as chart creation. Delegates will leave with the ability to work confidently within Microsoft Office Excel.
Introducing Excel
Menus
Toolbars – standard and formatting
Formula Bar
Status Bar and scroll bars
Columns, rows, cells and ranges
Navigating through cells
Getting started
Selecting cells, rows, columns and ranges
Entering text and numbers into cells
Moving cell contents
Editing cell contents
Deleting cell contents
Formula Creation
BODMAS theory
Creating formulas using the keyboard and mouse
Copying formulas across ranges
Introducing simple functions
SUM
AVERAGE
MIN
MAX
COUNT
Chart Creation
Chart types – choosing the right chart for your data
Working through the chart wizard
Chart type
Source data
Chart options
Chart location
Formatting chart elements
Altering chart elements
One key chart creation
Preparing to Print
Page set up options
Headers and footers
Printing options
Saving Spreadsheets
Saving spreadsheets for the first time
Saving changes
Choosing file locations
Choosing file names