Excel 2007 Introduction

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

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'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: 104461BT018