Unlike training companies offering scheduled courses, we offer the alternative of your Mac Excel Training Course delivered in central London on a date of your choice, either onsite or at our offices in Moorgate, Bank ir Liverpool Street. We offer courses for Introduction or Beginners, Intermediate and Advanced right up to seminars looking at the VBA programming language or upgrade training for individuals or groups.
In addition we also run custom courses tailored to your exact requirement. You select required topics to build your own bespoke Excel training course. Our unique Course Builder tool lets you create a shopping basket of training topics for your Excel course.
Whether you need a consultative 1 to 1Excel training session using your examples or group training, our trainers can deliver a highly professional service.
If this sounds like the training service you require, then please contact us on 020 7920 9500 or click the Contact Me Now button below. A member of our team will get back to you asap.
Mac Excel Training Course Levels & Contents
Intro
Inter
Advanced
VBA
Custom Courses
Mac Excel Introduction Course Contents
Objectives - This course is designed to provide a sound platform and understanding of Excel
Spreadsheet Principles
What is a spreadsheet?
Screen Layout
Navigation with Excel, Menus, Toolbars or Ribbons(V2007), Spreadsheets etc
Entering Data
Entering Text, Numbers, Dates
Entering Auto Lists
Deleting
Editing
Selecting data
Moving and Copying
Viewing the Clipboard
Inserting new columns and new rows
Navigation
Using the Scrollbars and Mouse
Using the Keyboard
Go To
Creating Formulae
Concept
Creating Formulae
Editing
Bodmas : Mathematical Order
Copying Formulae
Functions
Concept
Using the AutoSum Icon
Common Functions Sum, Min, Max, Average, Count
Cell References
Concept
Relative references
Absolute references
Formatting
Formatting Cells
Number formats
Changing font type and size
Text alignment and orientation
Wrapping text
Applying borders and shading
Autoformat
Conditional formatting
Format Painter
Clearing Formats
Formatting Columns and Rows
Printing
Page Orientation
Adding Headers and Footers
Printing a selection
Setting a print area
Shrink to Fit
Adjusting page breaks within Page Break Preview
Repeating columns and rows
Printing Gridlines
Setting a print area
Mac Excel Intermediate Course Contents
Course Objectives - This course is designed to build on the introduction course. It focuses on functions and formulae and better Excel Worksheet management. Also included is charting your data in Excel.
Naming Cell Ranges
Concept and Purpose
Naming individual cells
Naming ranges of cells
Deleting and amending named ranges
Using named cells/ranges in formulae
Named ranges as a navigation aid
Conditional Functions
Benefits and purpose
If Statements
Nested If
And, Or, Not
Combining If, And, Or, Not
Sumif
Countif
Conditional Formatting
Working with Dates and Times
Entering Dates and Times
Different date/time formats
How dates are stored
Calculating working days
Using the DAY(),MONTH(),YEAR() functions
Time calculations
Worksheet Management and Linking
Inserting and deleting sheets
Changing the default number of workbook sheets
Linking sheets in the same file
Linking different Excel files
Using Edit, Links
Viewing different files at once
Saving a workspace
Viewing different sheets at once
Window Split
Data consolidation
Essential List Management
Sorting Data
Adding Subtotals
Autofilter
Freeze Panes
Group and Outline
Data Form
Charting your data
Using the Chart Wizard
Editing and Formatting charts
Saving custom chart types
Setting a default chart type
Protecting and Sharing Excel Files
Sharing a file
Tracking changes
Accepting or rejecting changes
Applying Data validation rules
Inserting comments
Protecting cells, sheets, files
Password protecting a file
Checking for Errors
Spell-check
Find and replace
Autocorrect
Formula Auditing Tools
Revealing Formulae
Tracing Precedents/Dependents
Goto Special
Mac Excel Advanced Course Contents
Course Objectives - To build on previous knowledge and explore Advanced functionality within Excel, finishing with an introduction to Macros
Lookup Functions
Vertical Lookup (Vlookup)
Horizontal Lookup (Hlookup)
Match and Index
Informational Functions
IsText
IsValue
IsDate
IsNull
IsErr, Is Error, IsNa
Summarising Data with Pivot Tables
Using the Pivot Table Wizard
Changing the pivot table layout
Formatting
Grouping items
Inserting calculated fields
Pivot Table Options
Display and hide data in fields
Lay out reports directly on worksheet
Pivot Chart
General Analysis Tools
Scenarios
Custom Views
Reports
Goal Seek
Solver
Protecting and Sharing Excel Files
Sharing a file
Tracking changes
Accepting or rejecting changes
Applying Data validation rules
Inserting comments
Customisation Options
Showing / Hiding Toolbars
Customizing Toolbars
Customizing Menus
Adaptive Menus
Default Options
Add-ins
Introduction to Macros
Purpose of Macros
Recording macros
Where to save macros
Absolute and relative recording
Running macros
Custom buttons, menu items, keyboard shortcuts
Mac Excel VBA Macros Course Contents
Course Objectives -
To develop automated procedures in Excel using the Visual Basic for Applications language
What is a Macro?
Concept and discussion
The Visual Basic Interface
The Project Window
Code Window
Properties Window
Navigating between Excel and the VB Editor
Recorded Macros
Record New Macro
Assigning a keyboard short cut
Saving with the file
Methods of Executing
Menu
Visual Basic Toolbar
Keyboard Shortcut
Custom Toolbar Button
Custom Menu Item
Button
Alt [F8]
Forms Toolbar
Editing the Code
Using the Visual Basic Editor
Structure of a sub routine
Describe the colour scheme of Key Words
Navigation in a Module
Editing in a module
Use of Function Keys
Reassign keyboard shortcut
Run subroutines together
Checking For Errors
Debugging
Step Mode
Immediate Window
Object Browser
Toggle Breakpoint
Help system
Types of Recording
Relative
Absolute
Portability
Personal Macro Workbook
This Work Book
New Workbook
Add-ins
Creating New Functions
Uses
Function Keyword
Use of Arguments
Variables
Constants
Control Structures
IF
Nested IF
AND OR NOT
SELECT CASE
Inbuilt Functions
Distribution
Watch Pane
Step through Functions using the immediate Window
VBA Language Rules
Theory of Object
Properties and Methods
Active Objects
Object Model Hierarchy
Inheritance
Spreadsheet Form Controls
Combo box
Spinner control
Scroll bar
Option button
Check Box control
Interactive Macros
Msgbox
Conditional Message Box
Inputbox
Creating Interactive Forms
Form Controls
User forms
Using the Properties Window
Combo box
Radio Buttons
Group box
Check box
Built in Dialog Boxes
Creating Custom Menus
Creating Custom Toolbars
Event Procedures
What are Event Procedures?
On Open
Before Close
On Activate
On Deactivate
On Key
On Time
Security
Protecting/locking code for view/edit
Digital Signatures
Customizing the VB Editor
Dockable Windows
Format Editor
We have developed our own Custom Course Builder, where you can choose the topics you want to include in your course. Each topic has an estimated teach time, so you can see how long it would take to learn what you want!
1-to-1 training courses are charged at £450 per day. (Our offices or your venue)
All IT training courses at our offices are charged at a daily rate of £695 per day, for 2 to 8 delegates.
We also offer training at your venue for £595 per day. If required, laptops are available at an additional £150 per day.
For courses outside the M25, trainer travel and accomodation expenses are not included in the above prices but are charged at cost.
Build your course
With our course builder form, you can choose your own topics and build a course that suits your needs and your time scale. Select a application below to go to the Course Builder page
Mac Excel Training Courses in London and the UK
