Microsoft Excel Introduction
Aims: Introduces the workings and concepts of spreadsheets in Excel including simple formulas and formatting
Pre-requisites: Attendance of a Windows Introduction or a good understanding of the Windows Environment
Duration: One day
Excel Introduction
Spreadsheeting concepts
Using the keyboard and mouse
The Excel Screen
The Excel Ribbon
Working with the Tabs
Using the Quick Access Toolbar
Excel Basics
Creating new workbooks
Saving files
Opening and closing workbooks
Basic Spreadsheet Work
Moving around the worksheet
Entering data into the worksheet
Selecting areas of the worksheet
Using AutoFill and Custom lists
Using the Office Clipboard
Using drag-and-drop
Creating Formulas
Common mathematical symbols
Using the AutoSum feature
Statistical functions
The AutoCalculate facility
Relative and Absolute cell references
|
Worksheet Appearance
Changing the appearance of cells
The Format Painter
Working with Rows and Columns
Printing
Previewing the worksheet
Using Page Setup
Working with Headers and Footers
An Introduction to Charting
Creating a basic chart
Changing chart types
Formatting and enhancing a chart
Using Chart Themes
Printing a chart
Printing a chart with associated data
|
For further information on our Microsoft Excel Introduction Course, please contact us via the contact page, or alternatively telephone the office on 0113 243 2226
