Excel Secrets Level 1
September 5th 2017, 9:15AM - 4:30PM
Our Excel Secrets course covers Tips & Tricks for selection, navigation and using shortcuts for all the things that normally would take twice the time (which you do a lot!) You’ll learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulas everyone should know! Secrets of formatting super-fast and how to format your charts so they are stunning representation of your figures. At the end of this training course you’ll feel like an Excel Wizard!
Excel Ninjas Level 2
September 11th 2017, 9:15AM - 4:30PM
To help you become an Excel Ninja we cover manipulating multiple files and worksheets, 3D formulas, linking cells and special number formats to speed up data entry; ways to collapse large workbooks to see the totals you need and advanced charting; Making amazing tables in one click with secret built in formula; You'll learn how to speed up navigation around your spreadsheet and use range names in formula; use the auditing features to check your work and protect your spreadsheet. Finally make Pivot Tables!
Excel Gurus Level 3
September 13th 2017, 9:15AM - 4:30PM
Learn how to become an Excel Guru using Logical functions to work out ‘What IF’ questions. Covering Maths, Statistical, Financial, Date and Time functions and Array formulas, together with VLOOKUP, will ensure you’ve got all the tools to manipulate Advanced Formula. You will cut down on data entry errors with Advanced Data Management; Cover importing and exporting data into Excel, how to use Goal Seek and Solver and create your own macros!
Excel Dashboards Level 5
September 22nd 2017, 9:15AM - 4:30PM
Knowing your numbers - your core metrics - is absolutely critical to your success.Sometimes the numbers you need to track are spread out across different systems. It's so useful to have everything on one screen and all you need is to give it a glance. Yes, it's time to make a dashboard. It's like the instrument panel for your business. Your car has one. Planes have one.Let's make one for your business too.
Excel Secrets Level 1
October 3rd 2017, 9:15AM - 4:30PM
Our Excel Secrets course covers Tips & Tricks for selection, navigation and using shortcuts for all the things that normally would take twice the time (which you do a lot!) You’ll learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulas everyone should know! Secrets of formatting super-fast and how to format your charts so they are stunning representation of your figures. At the end of this training course you’ll feel like an Excel Wizard!
Excel Ninjas Level 2
October 9th 2017, 9:15AM - 4:30PM
To help you become an Excel Ninja we cover manipulating multiple files and worksheets, 3D formulas, linking cells and special number formats to speed up data entry; ways to collapse large workbooks to see the totals you need and advanced charting; Making amazing tables in one click with secret built in formula; You'll learn how to speed up navigation around your spreadsheet and use range names in formula; use the auditing features to check your work and protect your spreadsheet. Finally make Pivot Tables!
Excel Gurus Level 3
October 12th 2017, 9:15AM - 4:30PM
Learn how to become an Excel Guru using Logical functions to work out ‘What IF’ questions. Covering Maths, Statistical, Financial, Date and Time functions and Array formulas, together with VLOOKUP, will ensure you’ve got all the tools to manipulate Advanced Formula. You will cut down on data entry errors with Advanced Data Management; Cover importing and exporting data into Excel, how to use Goal Seek and Solver and create your own macros!
Excel Business Intelligence Level 4
October 23rd 2017, 9:15AM - 4:30PM
This course is designed for an Advanced Excel user to Understand the capability of the new Business Intelligence tools in Excel and use them to create great data visualisations and dashboards.Our Excel Business Intelligence course has been developed to fill the gap with this innovative new collection of add-on features in Microsoft Excel 2013 or above. Intended for Advanced Excel users this course runs through getting the BI modules installed, then how to use the 4 new tools – Power Query, Power Pivot, Power View and Power Maps.
Excel Dashboards Level 5
November 6th 2017, 9:15AM - 4:30PM
Knowing your numbers - your core metrics - is absolutely critical to your success.Sometimes the numbers you need to track are spread out across different systems. It's so useful to have everything on one screen and all you need is to give it a glance. Yes, it's time to make a dashboard. It's like the instrument panel for your business. Your car has one. Planes have one.Let's make one for your business too.
Excel Secrets Level 1
November 8th 2017, 9:15AM - 4:30PM
Our Excel Secrets course covers Tips & Tricks for selection, navigation and using shortcuts for all the things that normally would take twice the time (which you do a lot!) You’ll learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulas everyone should know! Secrets of formatting super-fast and how to format your charts so they are stunning representation of your figures. At the end of this training course you’ll feel like an Excel Wizard!
