MS Excel Training Courses
| Name | Description |
|---|---|
| Microsoft Office Excel Intermediate | This Microsoft Excel course focuses on the need to produce real time reports using Charts and Pivot Tables and introduces new functions and data tools to help participants be more productive. Areas covered include If Statements, VLookup, data analysis functions, sorting and filtering data in tables, data validation and cleaning data . This is our most popular Microsoft Excel course and is a very comprehensive day for Excel users to really get to grips with the key functions they need. |
| Microsoft Office Excel Advanced | This Microsoft Excel advanced course will extend your knowledge into some of the more specialized and advanced capabilities of Excel by using the data analysis and business intelligence features. You will learn how to use the newer functions and features including PivotTables and Power Pivots for analysis of large data sets. Using Get and Transform functions are always popular sections on the course, as well as a first look at creating Macros using the powerful point and click features available in Microsoft Excel. |
| Microsoft Office Excel Foundation | This course aims to provide a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. |
| Data Visualisation with Excel and PowerPoint | This course is designed for people who present technical or financial information using a combination of MS Excel and MS PowerPoint. It will cover a wide range of tools and techniques such as quick features in Excel, charts, conditional formatting, pivot table/charts and dashboards. It will challenge the way we present information and seek to create new insights into how we can get our audience to understand and interpret information more effectively. |
| Introduction to Financial Modelling and Analysis with Excel | The aim of the course is to provide a general introduction to spreadsheet modelling and related analysis.
The central part of the course focuses on the creation of a model from scratch. This will entail the use of relevant Excel tools (Lookups, macros, range names etc.) and the use of this model for various outputs, production of summary reports, KPIs etc. It will also involve comparison with history requiring the extensive use of advanced functions in Pivot tables and other relevant techniques. |
| Business Plan Modelling using Excel | Effective business planning is fundamental to success in business. Building the plan model is the first step in transforming ideas into tangible reality. A well-organised plan should tell you if the concepts make sound business sense. It is easier to compete for support and resources with the aid of a convincing plan. |
| Data Analysis - Excel 365 – Dynamic Array Formulas (a game changer), Pivot Table Techniques, Macros and beyond | Excel 365 has heralded an explosion in the tools available for reporting and analysis in accounting. This course will provide a detailed introduction to these new tools showing what they do, how they operate and providing real world examples. Where appropriate, we will contrast how these real world issues would have been handled in ‘legacy’ (i.e. pre 365) Excel. Dynamic Array Formulas will be explored in detail, exploring their full functionality. The course will also present useful and practical techniques to enhance skills in more familiar areas; like Charting, and Formatting, Pivot Tables and Macros. |
| Data Analysis - Excel 365 – Power Query, Power Pivot, Dashboard Production and beyond | Excel 365 has heralded an explosion in the tools available for reporting and analysis in accounting. This course will introduce two of the most powerful Excel tools - Power Query and Power Pivot and then use those techniques (with standard Excel skills) to produce an Excel Dashboard. We will examine Excel tools for ‘What if’ and newer techniques in the very important data analysis areas of LOOKUP (especially XLOOKUP) and FILTERING. The course will complete using the Excel Dashboard we created to communicate the results via exchanges between Excel and PowerPoint. |
| Programming in VBA - Using Microsoft Excel | The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Excel. The learner will be able to work with VBA within the Excel environment to program and automate worksheet operations. Users of Excel up to Office 365 can be facilitated. |
| Excel Macros from A to Z using VBA | This course refreshes the skills of Advanced users of Excel on the basics of Macros, then builds on the knowledge of participants to enable them to create, vet and edit Macros effectively and accurately using VBA. |