Excel 2011 Mac

Overview

Microsoft Excel, the world's most popular spreadsheet software, is designed to help users perform a myriad of business tasks, from to-do lists to forecasts to macros and VBA. Excel is our flagship course, used by hundreds of thousands of customers and clients around the world including the Institute of Chartered Accountants in England and Wales and many blue-chip firms.

Most office staff can use Excel to a basic level for data entry, to format cells, even to use a basic PivotTable. But few make it to the next level, to be able to build models, conduct scenario analyses, apply checks to flag errors, create a dashboard or format to a client-ready standard.

Our best-selling, award-winning, accredited course will do all of this. And it will do so efficiently, by using our proprietary filtering algorithm to direct your attention to those areas of Excel most relevant to you.

Learning Outcomes

Conduct insightful analysis of small or large data sets.

Build a dashboard to monitor your or your company's performance.

Banish your Excel pet hates for good.

Present your work beautifully be it in a table, scatter, radar or pie chart.

Audience

From regular users up to power users looking to brush up on VBA - our adaptive teaching method tailors training to each individual.

Accountants, bookkeeppers, teachers, salespeople, managers, graduates. The list just doesn't end with Excel.

Syllabus

Section 1: Pre-Syllabus

Unit 1.1 - The Excel Dashboard

Unit 1.2 - Basic Navigation and Editing

Section 2: Spreadsheet Administration

Unit 2.1 - Customising Excel

Unit 2.2 - Housekeeping

Unit 2.3 - Connecting Workbooks

Unit 2.4 - Sharing and Protecting

Unit 2.5 - Excel Crashes

Section 3: Orientation and Efficiency

Unit 3.1 - Editing

Unit 3.2 - Viewing

Unit 3.3 - Outline

Unit 3.4 - Cell References

Section 4: Data Handling

Unit 4.1 - Data Validation

Unit 4.2 - Sorting and Filtering

Unit 4.3 - Date and Time Functions

Unit 4.4 - Text Functions

Unit 4.5 - Lookup and Reference Functions

Unit 4.6 - Logical and Informational Functions

Unit 4.7 - Named Ranges

Unit 4.8 - Macros

Section 5: Data Analysis

Unit 5.1 - Mathematical Functions

Unit 5.2 - Summarising Data

Unit 5.3 - Pivot Tables

Unit 5.4 - Formula Auditing

Unit 5.5 - What-If Analysis

Unit 5.6 - Modelling Principles

Unit 5.7 - Modelling Techniques

Section 6: Presentation

Unit 6.1 - Cell Formatting

Unit 6.2 - Number Formatting

Unit 6.3 - Conditional Formatting

Unit 6.4 - Graphs and Charts

Unit 6.5 - Review

Unit 6.6 - Page and Print Setup

Duration

16 Hours

Details

Hours of Training

16 Hours

Base Price

£36.00

Additional Information

Can this course be authored/customised by the end-client

No

Does this Course have Downloadable Resources (e.g. guide. templates etc)