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 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 2016 Intermediate

Course Overview

Audience:

This course is designed for users who have basic knowledge of Apple Excel and want to further enhance their skills. It covers more complex formulae, including 3D formulae, linking data and charting your data and protecting worksheets and workbooks.

Prerequisite:

To get the most from this course, you must be able to perform basic Apple Excel actions and create basic formulae and functions.

Duration:

This is a 1 day Apple MS Excel Intermediate 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 Mac Microsoft Excel Intermediate course can be run at our training venue near Kings Cross (London) or any preferred location in the UK or Europe.

Apple Mac Excel 2011 Intermediate Course Outline

RECAPPING BASICS

Absolute, Relative References

Basic calculations

NAMING CELL RANGES

Inserting and deleting sheets

 
Changing the default number of workbook sheets.

NAMING CELL RANGES

Concept and Purpose

Naming Individual Cells

Naming Range of Cells

Deleting and amending

ranges

Using Name Ranges in Formulae

/Functions

Named Ranges for Navigation

LINKING SHEETS AND FILES

Changing the default number of workbook sheets

3D Calculations

Linking sheets in the same file

Linking different Excel files

Using Edit, Links

Viewing Different Files On One Screen

Saving a workspace

Window Split

Freeze Panes

Viewing Different Parts Of The Sheet On One Screen

Watch Window

CONDITIONAL FUNCTIONS

Benefits And Purpose

IF Statements

Nested If

SUMIF And SUMIFS

AVERAGEIF And AVERAGEIFS

COUNTIF and COUNTIFS

ISERROR And IFERROR

Nesting IF WITH AND, OR

 

CREATING TABLES

What is a table?

Why use a table?

Creating a table

Table Tab

Naming a table

Formatting a table

Removing an existing table

WORKING WITH TABLES

Resizing a table

Adding and removing columns

Total Rows and Inbuilt calculations

Frozen first row

Filtering

Pros and Cons

CALCULATIONS IN TABLES

Understanding table references

Basic calculations that auto update

BUilding a calculation in a table

SUMIF, COUNTIF without absolute references

Tables and VLOOKUP’s

Naming part of a table

APPLYING AND MANAGING CONDITIONAL FORMATTING

Data Bars

Colour Scales

Icon Sets

Top/Bottom Basic

Clearing Conditional Formatting

Copying Conditional Formatting to other cells and sheets

LOOKUP FUNCTIONS

Vertical Lookup (VLOOKUP)

Horizontal Lookup (HLOOKUP)

FORMULAE AUDITING

Formula View

Tracing Precedents

Tracing Dependents

Using Watch Window

Go To Special…

CHARTS/GRAPHS ADVANCED TECHNIQUES

Creating Chart Using Shortcut Key

Saving Custom Chart as Templates

Setting Chart as Default

Applying Trendlines

Formatting and Editing Series, Plot Area, Data Points

Chart Area, legends, etc…

Using Sparklines (Line, Column, Win/Loss)

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.