Microsoft Excel Advanced (Part 2) 2003/2007

Microsoft Excel 2007 or 2003 Advanced Part 2 Course Overview:

To give users an extended knowledge of Excel's advanced features. Delegates will gain practical knowledge on how to analyse and share spreadsheet data and create spreadsheet databases.

Microsoft Excel 2007 or 2003 Advanced Part 2 Course Duration and Location :1 day in London

Fee: £264 per delegate

Course Dates : 15 Mar 12, 12 April 12, 22 May 12, 15 June 12, 18 July 12

Who should attend? This course is suitable for existing users of Excel who want to gain further in-depth knowledge on how to manage and audit spreadsheets in a short space of time. Participants on this course should have a good working knowledge of Excel, gained from prior attendance on an “Excel Advanced” course or from a user environment.

Delegates will gain practical knowledge on how to analyse and share spreadsheet data and create spreadsheet databases.

Excel Expert

Review Exercise

Auditing a Worksheet

Using Worksheet Auditing Tools

Data Entry Validation

Validating the Whole Worksheet

Auditing Data Dependency

Finding and Replacing Data

Working with Data Lists

Setting Up Lists

Sorting Lists

Filtering Lists

Using Forms

Data Management

Searching for Data with Advanced Filters

Compiling Consolidations

Summarising Data with Outlines

Querying a Database

Data Sources

Refreshing External Data

PivotTables

Creating a PivotTable

Modifying a PivotTable

Creating a PivotTable Chart

Creating Interactive PivotTables for the Web

Using Analysis Tools

Goal Seeking

Using Solver

The Scenario Manager

Scenario Summaries

Merging Scenarios

Collaborating with Workgroups

Applying Worksheet Protection

Password Protecting a File

Shared Workbooks

Tracking Changes

Resolving Conflicts

Merging Workbooks

E-mailing Workbooks for Review

Here's what Evolia clients are saying ...

"Excellent ! The trainer was patient with everybody and the course was well structured. I will recommend Evolia Training’s Personal Development courses to my colleagues."

Mark C.
London, UK

"The Business Writing Skills course was perfectly tailored to my needs. I am confident that I can now apply these new skills at work. Excellent facilities and good location!"

Sam B.
Manchester, UK

"The trainer was experienced to deal with overseas delegates and we were all well looked after. Lunch arrangements were excellent and the training course was well structured.

I can now go back to Africa and use what I have learned."

James K.
Nairobi, Kenya

"Perfect! This is my first training course with Evolia Training but I will definitely use them again in the future."

Ali E.
Dubai, UAE

" Modern and well-equipped facilities and excellent location. The training course was very practical and customized to meet my training needs."

Yacine D.
Algiers, Algeria

" Very approachable trainer and was made to feel welcome. Booking process was easy and efficient."

Abike O.
Abuja, Nigeria

" Very knowledgeable and competent trainer. All my questions were answered and the trainer was always ready to go the extra mile."
"I will definitely use Evolia training for my next IFRS course."

Jokoh A.
Lagos, Nigeria