Excel 2007 Introduction

About this course

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

You’ll learn how to

  • create new workbooks and input values, labels and dates
  • open and move between workbooks
  • find files using Windows Search
  • use selection techniques
  • move and copy data between worksheets and workbooks
  • use the Paste Options Smart Tag
  • insert and delete columns and rows
  • use 'Find and Replace' and identify search options
  • enter and copy formulas
  • work with Absolute References and apply percentage values
  • enter Functions, use AutoSum and apply the IF Function
  • create simple charts and pie charts

Modules

There are 19 modules in this course:

  • Starting Excel and Help
  • Screen Components
  • Navigating Workbooks
  • Splitting, Freezing and Options
  • Creating Workbooks
  • Opening, Saving and Closing
  • Selection Techniques
  • Moving and Copying Data
  • Adding and Removing Cells
  • Searching and Sorting
  • Formulas and Referencing
  • Working with Functions
  • Formatting Cells
  • Handling Worksheets
  • Creating and Modifying Charts
  • Working with Chart Objects
  • Proofing Tools
  • Headers, Previewing and Page Setup
  • Printing Worksheets

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