Excel 2007 Advanced

This course takes you step by step through advanced spreadsheet tasks using Excel 2007. Together with our Excel 2007 introductory and intermediate levels, this course also supports the background learning for the Microsoft Certified Application Specialist (MCAS) exam (77-602).

Special offer: buy together with our Excel 2007 Introductory and Intermediate courses and save 20%.

You'll learn how to:

• use and customise templates
• create links between worksheets and spreadsheets
• consolidate workbooks and use destination cells and Source Data References
• use advanced functions including VLOOKUP
• understand, use and apply Time, Mathematical, Financial, Logical, Text and Database functions
• use collaboration features to share, protect and track changes in Workbooks

Modules:

There are 15 modules in this course:

• Templates
• Linking Data
• Consolidating Workbooks
• Validating Data
• Working with Hyperlinks
• Lookup Functions
• Time and Mathematical Functions
• Financial Functions and Data Tables
• Logical and Informational Functions
• Text Functions
• Database Functions
• Using Comments
• Sharing and Protecting Workbooks
• Tracking Changes in Workbooks
• Document Inspector

Course features:

• Simulation training replicates the software you're learning, providing a realistic learning experience.
• Learn how to perform tasks at your own pace and interactively by following easy step-by-step actions.
• Reinforce your knowledge at the end of each lesson by completing interactive and multiple choice quiz questions.
• Lessons can be completed within 30 minutes so you can do your training in bitesize pieces.
• Bookmarking allows you to dip in and out, so you can learn whenever suits you.
• Course navigation features allow you to jump directly to specific topics of interest quickly and easily.
• Designed for people who require initial and refresher training activities.

You'll have access to this course for six months from the date of purchase - giving you plenty of time to finish your course.

How this course can help your business:

• Use information to assess and evaluate business performance
• Make sound business decisions based on accurate data
• Forecast and plan more accurately and effectively
• Improve communication by providing staff with better access to information

Course Code: 104461BT016