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:Two Days
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 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 |
|---|
| 7th - 8th April 2010 |
| 5th - 6th May 2010 |
| 2nd - 3rd June 2010 |
| 1st - 2nd July 2010 |
| 2nd - 3rd August 2010 |
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 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
- 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
- Using Cell Comments and Auditing
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
Workbooks
- Concepts of a Workbook
- Moving around a Workbook
- Inserting and deleting worksheets
- Renaming and moving worksheets
- Linking worksheets with formulas
- Workbook defaults
Working with Data Lists
- Concepts of a Data List
- Sorting lists
- Finding data in a list
- An introduction to AutoFilter
- Advanced AutoFilter options
- Using automatic Sub-Totals
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
