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 2011 Intermediate
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.
To get the most from this course, you must be able to perform basic Apple Excel actions and create basic formulae and functions.
This is a 1 day Apple MS Excel Intermediate Course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.
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
Absolute, Relative References
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
Using Name Ranges in Formulae
Named Ranges for Navigation
LINKING SHEETS AND FILES
Changing the default number of workbook sheets
Linking sheets in the same file
Linking different Excel files
Using Edit, Links
Viewing Different Files On One Screen
Saving a workspace
Viewing Different Parts Of The Sheet On One Screen
Benefits And Purpose
SUMIF And SUMIFS
AVERAGEIF And AVERAGEIFS
COUNTIF and COUNTIFS
ISERROR And IFERROR
Nesting IF WITH AND, OR
What is a table?
Why use a table?
Creating a table
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
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
Clearing Conditional Formatting
Copying Conditional Formatting to other cells and sheets
Vertical Lookup (VLOOKUP)
Horizontal Lookup (HLOOKUP)
Using Watch Window
Go To Special…
CHARTS/GRAPHS ADVANCED TECHNIQUES
Creating Chart Using Shortcut Key
Saving Custom Chart as Templates
Setting Chart as Default
Formatting and Editing Series, Plot Area, Data Points
Chart Area, legends, etc…
Using Sparklines (Line, Column, Win/Loss)
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
What Our Clients Say
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.