Excel is one of the most powerful, yet most underused, software programs. It can do some extraordinary things. Learn how to maximise this tool to improve your productivity and performance.
This program introduces additional skills to develop your knowledge of Microsoft Excel by focusing on PivotTables, PivotCharts, SmartArt diagrams and conditional formatting.
This program focuses on expanding your knowledge of Excel’s functions and understanding how to write well-structured formulas.
This program shows you how to create calculations across multiple worksheets and across multiple workbooks.
This program focuses on creating simple to complex charts to visually present business data.
Microsoft Excel is the main tool for many people working with financial information and this program introduces the financial tools and formulas available in Excel.
This program will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.
This program provides instruction in the more advanced use of Excel Macros. It will take participants beyond our Excel - Macros with VBA Programming and introduces techniques for high-end Excel users to better utilise the power of Excel.
This program focuses on the main features of Microsoft Excel PowerPivot; a very fast, space-saving, columnar add-on database that can handle vast amounts of data far beyond the limits of an Excel worksheet. It introduces PowerPivot’s calculation language Data Analysis Expressions (DAX) and explains how to use PivotTables with the PowerPivot data. Participants will also explore visualisation in Excel of PowerPivot’s data.
With Power Query discover, connect to and import data into Microsoft Excel. Then, using PowerPivot, remodel and enhance the imported data by writing queries through Power Query ‘M’ language.