The Excel Core training course is perfect for those that quake at the thought of using the programme. It lays out the basics, its capabilities, and gives you the skills you need to master it over the course of one day. Starting with the creation of workbooks and worksheets, it then introduces an overview of other timesaving features such as Macros and Autofill, and how to create simple formulae and format worksheets. At the end of the course, students will be able to create and manage worksheets, create and format cell data, apply formulas and functions, present data visually, and also give them the ability to analyse and organise both inputted and outputted data.
The Excel Expert training course is the perfect follow up to Excel Core, or a great entry point for those that have a level of confidence within the programme already. If you know how to run calculations and filter and sort numeric data then this course will allow you to further develop and expand on your existing knowledge. Students will tackle how to automate common tasks, how to apply advanced analysis techniques to more complex data sets such as Pivot Tables, how to link your worksheets with others, and how to import and export data using Power Views.
Getting a bit more technical, VBA for Excel teaches students to make the most of the programming possibilities in Excel. VBA for Excel will teach participants about the Visual Basic Editor, declaring variables, constants and data types, and will give you the knowledge you need to write your first VBA function. It will also provide in-depth guidance on decision structures, loop structures, complex exercises, and user forms, which will allow users to realise Excels potential as a powerful tool for the manipulation and analysis of present data.
Did you know that it is now possible to process millions of rows of Data in Excel? What this means for you is that you can use the programme to gain deeper business insight and shorter decision making cycles. With the Power BI training course, you will learn how to consolidate and mine data from multiple sources, investigate trends, create dashboards, and most importantly- make sense of your business data. As daunting as this may sound, with the right knowledge, this can be done with a few clicks within Excel and the results will provide you with the business intelligence that you need to succeed.
This course is designed with supervisors, managers in mind, but it will also be of use to team members who need the ability to summarise, report, and analyse data. The Data Analysis & Business Modelling training course provides learners with the skills they need to use Excel for reporting and business modelling for decision making, using real-world business scenarios. You can utilise the programme to evaluate investments and financial decisions, ensure accurate data entry, summarise data using histograms and PivotTables, and even estimate business variables using trend curves present in the data. There are programmes out there that charge you thousands to offer this kind of function, but with the right skill set under your belt, you can utilise Excel to do it for you.