Apple Mac Excel

Microsoft Excel Training for Apple Mac in London, the UK & Europe

Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.

For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!Excel is one of the most widely used software packages currently in use. The package can be used for variety of tasks.

On a basic level you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.

For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!

Select the version that you’re interested in from the menu on the left and see what you can learn with us.

Please select the version that you’re interested in

Please select the level that you’re interested in

Apple Mac Excel 2011 Advanced

Course Overview

Audience:

This course is aimed at experienced Apple Excel users who need to perform more complex functions, lists analysis, use What-If tools and who would like to start recording basic macros

Prerequisite:

You must have sound Apple Excel skills and understand key concepts of spreadsheets, or equivalent to our Intermediate course level.

Duration:

This is a 1 day Apple Excel Advanced Course. The course starts at 09:30 and runs until 16:30Alternate timings can be arranged upon request. The course can be held on a date that suits you.

Location:

Our Apple Microsoft Excel Advanced course can be run at our training venue near Kings Cross (London) or any preferred location in the UK or Europe.

Excel 2011 Advanced Course Outline

RECAP FUNCTIONS

IF Statements

Nested IF

AND, OR, NOT

Combining IF AND, OR, NOT

SUMIF

Vertical Lookup (VLOOKUP)

Horizontal Lookup (HLOOKUP)

Lookup and Information Functions

MATCH function

INDEX Function

ISTEXT, ISVALUE, ISDATE, ISNULL, ISERR, ISNA

IFERROR

OFFSET

ADVANCED LIST MANAGEMENT

Advanced Filter

Database Functions: DSUM, DMIN, DMAX, DAVERAGE, DCOUNT, DCOUNTA

TEXT FUNCTIONS

UPPER, LOWER, PROPER

CONCATENATE

DATE FUNCTIONS

TODAY()

NOW()

NETWORKDAYS

WEEKDAY

SUMMARISING DATA WITH PIVOT TABLES

Inserting calculated fields

Manipulating Fields

Changing Value Filed Settings

Using Report Filter

Grouping Data containing Dates and Numbers

Formatting Pivot Table

Showing and Hiding the Grand Total

Refreshing Data In Pivot Table

Changing The Scope Of The Data source

Summarizing Values by Sum, Count, Average, Max, and Product 

Show Values As % of Grand Total, % of Column Total, % of Row Tota

Pivot Table Options

Using Slicers for Effective Filtering

Pivot Chart

WHAT IF TOOLS

Scenarios

Custom Views

Goal Seek

Solver

Data Tables

One Input

Two Input

PROTECTING AND COLLABORATION

Sharing a file

Tracking changes

Accepting or rejecting changes

Applying Data validation rules

Inserting comments

Protecting cells, sheets, files

Password protecting a file

Password protecting a cell range

INTRODUCTION TO MACROS

Displaying the Developer Tab

Review And Purpose of Macros

Macros saving locations

Absolute and Relative Macro recording

Running macros

Assigning to –

Quick Access Toolbar

Shapes

Pictures

Keyboard shortcuts

Show more
One to One

(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training

Group for up to 8 learners
The Course outlines on our website are standard, however, we would be happy to tailor them to your specific requirements. Please call us on 020 3696 2796 or send us a message to discuss further.

What Our Clients Say

Extras

This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.