Excel 2011 Mac
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.
- 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.
- 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.
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