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 2016 Advanced
Course Overview
- Use Lookup & Informational Functions
- Create Pivot Tables
- Use What-If Tools
- Sharing and Tracking Workbooks
- Record Basic Macros
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:30. Alternate 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 2016 Advanced Course Outline
RECAP FUNCTIONSIF Statements Nested IF AND, OR, NOT Combining IF AND, OR, NOT SUMIF Vertical Lookup (VLOOKUP) Horizontal Lookup (HLOOKUP) Lookup and Information FunctionsMATCH function INDEX Function ISTEXT, ISVALUE, ISDATE, ISNULL, ISERR, ISNA IFERROR OFFSET ADVANCED LIST MANAGEMENTAdvanced Filter Database Functions: DSUM, DMIN, DMAX, DAVERAGE, DCOUNT, DCOUNTA TEXT FUNCTIONSUPPER, LOWER, PROPER CONCATENATE DATE FUNCTIONSTODAY() NOW() NETWORKDAYS WEEKDAY SUMMARISING DATA WITH PIVOT TABLESInserting 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 TOOLSScenarios Custom Views Goal Seek Solver Data Tables One Input Two Input PROTECTING AND COLLABORATIONSharing 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 MACROSDisplaying 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 |
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
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.