 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 2007 Intermediate
Course Aims
This course is designed to help you to develop your skills in using the spreadsheet tool Microsoft Excel. You will learn to use more advanced functions and create more complex formulas. You will learn to manage and link together multiple worksheets. You will also learn to apply more advanced formatting to charts and use basic reviewing tools, such as the spelling checker and comments. |
Assumed Knowledge
Ideally, you will have completed the course "Microsoft Excel 2007 Introduction". You should be able to use Microsoft Excel to create, edit, format, and print a spreadsheet incorporating simple formulas and charts. |
Course Audience
Those wanting to develop their skills in using Excel to design spreadsheets to solve basic accounting and data analysis tasks. |
|
Table of Contents
|
Advanced File Tasks
|
Using my computer within Excel
|
|
Working with Functions and Formulas
|
|
Exploring Excel Functions
|
|
Working with Names and Ranges
|
|
Working with Array Formulas
|
|
|
|
Managing Tables
|
Working with Records and Fields
|
|
Working with Tables and Filters
|
|
Using Excel as a Database
|
|
|
Enhancing your Workbook
|
Customizing your Workbook
|
|
|
|
Finalizing Your Workbook
|
Protectiong your Workbook
|
|
Using Excel with other Programs and Files
|
|
|
|
|
|
