Learning Academy Box Sets

Take the opportunity to gain accreditation in a specific subject. Our Box Sets are groups of related modules that help you focus your learning. The full box set cost includes your accreditation. To complete accreditation, you need to watch all five modules and send an email to accreditation@theforum.social to describe what you have taken from the modules and how you have applied these in your role.
Each Box Set costs £325 +VAT. (Free to anyone on an Assisted Learning Pathway). Click on the descriptions below to book your place now.

Student takeaways

One of our members from Lifeplus completed the Capacity Planning, Budgeting & Forecasting box set these are the headline takeaways:
- A small impact in your field can have a good effect higher up in the ranks at board level i.e. matching up with a higher strategic objective

- Planning teams need to collaborate with other areas/organisations, engage stakeholders

- Increase Operational effectiveness - As a team, we have vastly increased our communication channels

- Improve and manage the flow of your data cycle and version control

- Long Term: Financial and Budget Planning – Operational: Drives capacity, scenario planning, and risk

- In the middle of a transformation/plan, the challenges are still there, and targets not being met --> this must lead to evolving the approach to capacity and demand

- Improve the quality of the data, focussing on what/why/how, determine what happened to the customer base

- Demonstrating Value and ROI – benefits achieved, costs avoided, risks avoided

Published on 05 August 2021

Box Set: Power Query - Automating with Excel

Watch at your own Pace

As analysts we can spend a lot of our time on repetitive tasks. Copying and pasting data from one file to another, cleaning and combining our data to produce regular reports. This is not only tedious and time consuming but it also can lead to errors.

Automating this work can free up our time to do more rewarding work and deliver extra value.

There are many systems out there that allow us to automate, but what if we don't have these. We can still do a great deal of automation using the power query functionality in excel.

In this box set we will cover

Data Structure
Importing Data
Cleaning Data
Appending Data
Automating Formulae
Combining Data

The learning is in bite sized chunks that you can watch and we watch at your own speed. With practical exercises you can complete as you go.
Then become an accredited by sharing how you have applied this learning in your own role.

To find out more and see if you have a compatible version of excel, watch the introduction video below.

The cost of this mini series including accreditation is great value at £325 + VAT and free for students on our assisted learning pathway.