Excel 2007 Intermediate

This course takes you step by step through intermediate-level spreadsheet tasks using Excel 2007. Together with our Excel 2007 introductory and advanced 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 Advanced courses and save 20%.

You'll learn how to:

• insert and move multiple rows and columns, and change column width and height
• apply and remove worksheet backgrounds, add images and watermarks
• apply built in, custom and conditional formatting
• create and modify cell styles
• move between open Workbooks and arrange Workbooks on screen
• use Full Screen, Print Preview and Layout views
• add WordArt, graphics and multiple text levels
• sort and Filter data and apply multiple search criteria
• use Trendlines, Auditing Tools and Macros
• import and Export data, and use Pivot Tables, Forms and Queries

Modules:

• Modifying Worksheets
• Formatting Worksheets
• Custom and Conditional Formats
• Cell and Table Styles
• Saving a Workspace
• Excel Views
• Define a Custom View
• Illustrations
• Outlining
• Sorting and Filtering Data
• Trendlines
• Auditing Tools
• Scenario Manager
• Using Macros
• Importing, Exporting and Queries
• Working with PivotTables

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: 104461BT017