 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 2007 Advanced
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 get the most from your data and use Excel with the Internet. |
Assumed Knowledge
Ideally, you will have completed the course "Microsoft Excel 2007 Intermediate". 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 Topics
|
|
|
Getting the Most From Your Data
|
Getting The Most From Your Data
|
|
|
|
Excel and the Internet
|
Saving Workbooks as Web Pages
|
|
Getting Data from the Internet
|
|
|
Advanced Excel Tasks
|
Creating and Using Shared Workbooks
|
|
Using Custom AutoFill Lists
|
|
Linking, Consolidating and Combining Workbooks
|
|
|
|
|
|
