Excel 2007 Intermediate

About the course

This course takes you step by step through intermediate-level spreadsheet tasks using Excel 2007.

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

The course modules are

  • 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 are 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.
  • Assess your skills at any time by undertaking the Course Test.
  • Lessons can be completed within 30 minutes so training can be undertaken in “bite” size pieces.
  • Bookmarking allows you to learn in multiple training sessions.
  • 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.
  • Available on-line 24 hours a day.
  • Version for Mobile Devices.
  • Review course content with eBooks