Excel Introduction
Aims:
Introduces the workings and concepts of spreadsheets in Excel including simple formulas and formatting
Prerequisites:Attendance of a Windows Introduction or a good understanding of the Windows environment
Duration:One Day
Fees:Course fees for this particular course will depend on your chosen Training solution. Please click on the links below for corresponding course fees:
PDF Course Download
You can download a PDF version of the course.
Download Microsoft Excel Introduction course outline.
If you don't have Adobe Acrobat Reader, this can be downloaded from the www.adobe.com web site.
If you are interested in our Excel Introduction course call us on
0113 243 2226
Enquire about
this course Now
Course Dates
| Available dates |
|---|
| 11th June 2012 |
| 2nd July 2012 |
| 1st August 2012 |
| 3rd September 2012 |
Course Outline:
An Introduction to Excel
- Spreadsheeting concepts
- The Excel screen
- Using the keyboard and mouse
- Using the toolbars
- Working with menus
- Help and the Office Assistant
Excel Basics
- Creating new workbooks
- Saving file
- Using the Places Bar
- 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
- Moving data with Cut, Copy and Paste
- Using Drag-and-Drop
- Understanding the Undo feature
- Creating formulas
- Using the AutoSum feature
- Relative vs. Absolute cell addressing
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
- Printing the worksheet
An Introduction to Charting
- Creating a basic Chart
- Changing chart types
- Formatting and enhancing a Chart
- Printing a Chart
- Printing a chart with associated data
