Excel 2007 Power User

Target Audience

Experienced users of Excel. In particular, delegates should be confident with building multiple worksheet and workbook formulas, have a sound understanding of how Excel functions are written, use Range Names in formulas and work with Excel lists.

Pre-requisites

To fully benefit from this course, attendees are expected to be confident users of Excel and be familiar with the topics covered in the Excel Foundation and Intermediate courses

At the completion of the course you should be able to:

• Use the date and time functions to perform calculations
• Use the Find and Replace options
• Overview the range of built-in functions including Financial, Text, Statistical and Maths
• Create, use and modify data tables
• Use data validation and conditional formatting
• Create and work with scenarios and the Scenario Manager
• Use Goal Seek to determine values required to reach a desired result
• Use Solver to resolve complex optimisation problems
• Summarise data using subtotals
• Use outlines to manipulate the worksheet
• Create, modify and work with PivotTables
• Use templates to create consistency in your workbooks
• Create recorded macros in Excel

Outlining

Creating/Working with an Automatic/Manual Outline

Date/Time & Financial Functions

Using The TODAY • NOW & DATE Functions • Using the PMT Function

Data Tables

One & Two-Variable Data Tables

Validations

Input Messages/Error Alerts/ Drop-Down Lists • Conditional Formatting

Scenarios

Creating/Displaying Scenarios • Scenario Summary Report

Goal Seeking & Solver

Using Goal Seek • Solver Reports • Restricting Answers Using Solver Options

Summarising Data

Creating Subtotals/Nested Subtotals • The Conditional Sum Wizard  • Relative Names For Subtotals

PivotTables

CreatingFormatting Simple PivotTables • Page Field in a PivotTable • Formatting a PivotTable • Counting/Percentages with PivotTables • Calculated Fields/Items in PivotTables  • Creating/Modifying a PivotChart

Templates

Creating/Modifying Templates • Inserting a Worksheet from a Template • AutoStart Templates

Recorded Macros

Recording/Running a Simple Macro • Relative Cell References  • Viewing a Macro Module • Assigning/Removing Macros onToolbar/Custom Button

You may also be interested in some of the following related courses below:

Microsoft - Excel 2007 - Foundation
Microsoft - Excel 2007 - Intermediate
Microsoft - Excel 2007 - VBA

Send this course to a friend
 

Course Fee

We have a rolling programme of Scheduled Public sessions for the majority of standard courses – both in IT Productivity and Management & Soft Skills. Group sizes are limited to ensure optimum learning amongst delegates.

Passport Saving Plans

The advertised rates are on a per delegate basis, however if you have more than one attendee you may be entitled to a discount. To maximise your training budget why not email or contact one of our training consultants to see what rates/discounts may apply for your particular requirement.

Alternatively, if you have regular, ongoing training requirements, you may find one of our Training Passports of interest. Each is designed to provide our clients with significant benefits:
• Far better discounts
• Less administrative overhead
• Better control of your training schedules

Scheduled Training Passports
Enables you to pre-purchase training places on any of our standard scheduled courses.

Private Training Passports
Enables you to pre-purchase private training days against any of our standard courses.

Each of the above passports come with substantial discounts.

To maximise your training budget why not email or contact one of our training consultants who will be happy to provide you with the latest offers on any of our Training Passports. See what rates/discounts may apply for your particular requirement.

Please fill out the form below for more details:

First Name
Last Name
Job Title
Company
Office Telephone
E-mail
Brief Details	Characters Left.