Course Objectives
- Use Excel to structure your data.
- Perform automatic calculations.
- Improve the appearance of your work with basic formatting.
- Produce simple charts.
- Produce well presented printouts of data, text and graphs.
- Save your work and retrieve it for future reference or changes.
Course Content
ntroducing Excel 2007
An overview of the benefits of spreadsheets.
Basic spreadsheet structure.
Tour of the Excel screen, including the new 2007 Ribbon and toolbars.
Getting HELP!
Spreadsheet Basics
Entering and editing your data using some quick techniques.
Using undo and redo
Saving & Retrieving
Securing your work through Saving.
Understanding Excel 2007 file types.
Retrieving files.
Organising work directories, using Windows Vista Explorer
Calculations
Basic Excel functions including Sum and Average.
Using the Insert Function tool to assist with more complex calculations.
Changing the Appearance
Changing typeface style and size.
Aligning, bordering and shading your data.
Using Excel Themes and cell Styles to quickly alter the look of your data.
Setting row and column heights.
Working with Spreadsheet Data
Moving, copying and deleting sections of your spreadsheet.
Using Autofill to copy and enter information.
Checking your spelling and correcting mistakes.
Using the Find and Replace tools to quickly make changes to your spreadsheet.
Absolute Cell References
Understand the use of Absolute Cell references within formulas or functions.
Charts & Graphs
Use Excel's powerful charting capability to create and edit bar charts, pie charts and line graphs.
Printing
Previewing work.
Changing the page layout.
Printing all or part of your work.
Database Functionality
Rules for Creating Database Tables.
Sorting and filtering data.
Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.
