Excel 2007/2010 Intermediate

Course details

Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates.

Objectives

This course demonstrates how to work more efficiently with workbooks, enhance the appearance of data, worksheets and use the tables and filtering features to manage and analyze data. On the course you will be introduced to many of the topics required for the Microsoft Office Specialist (MOS) Core and Expert level.

Content

Basic Workbook Tasks

• Using File Management Tools
• Creating Basic Formulas
• Using the AutoSum
• Relative & Absolute Cell References
• Using Statistical Functions e.g. AVERAGE, MAX,
• MIN, COUNT and COUNTA

Using Multiple Worksheets and Workbooks

• Linking Multiple Worksheets and Workbooks
• Manage Multiple Workbooks
• Inserting and Deleting Worksheets
• Copying and Moving Data between Worksheets
• and Workbooks

Working With Advanced Formulas and Functions:

• Date and Time
• Financial
• Logical e.g. IF, Nested IF
• Lookup – Hlookup
• Working with Array Formulas

Working With Graphic Objects:

• Insert graphics
• Create AutoShapes
• Adding Text Boxes
• Inserting Pictures and ClipArt
• Using Screenshot Tool

Managing Tables

• Working with Data Tables
• Working with Records and Fields
• Working with Filters and Sorting Data
• Cleaning up Duplicate Records
• Data Validation using Lists and Formulas

Creating and Modifying Charts

• Adding and Editing Sparkline’s
• Adding Symbols, Equations, and Shapes
• Inserting and Formatting SmartArt

Prerequisites

It is also recommended that proposed delegates have attended a Microsoft Excel 2010 Introduction course or have obtained comparable knowledge from the workplace.

Who should attend?

• This course is designed for Microsoft Excel users who have basic skill levels and understanding of Excel
• Those who wish to extend their knowledge and skills beyond building simple workbooks. This course is suitable for people who use or who will use Excel in their daily role.