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.



Box Set: Power Query - Automating with Excel

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 £295 + VAT and free for students on our assisted learning pathway.

Comments (0)Number of views (212)

Author: Alison Conaghan

Categories: Box Sets

Tags:

Print
About us

As an independent association established since 2000, we offer a trusted space for professionals in contact centre, field service, back office or retail operation. Benchmark against the best in class and learn from innovators and pioneers.

Learning Academy

On-demand modules

We have a wide range of virtual modules that you can view at your own pace.

Covid-19 Webinar Series 2

You have a community of support at The Forum. See the series of free webinars to help you through this unusual situation.

Conferences

National Conferences 2021
w/c 1st November Virtually and 9th November face-to-face
Annual conferences dedicated to the needs of their communities.

Customer Strategy & Planning 2021
Catch up on the highlights
Learn first-hand from practitioners and business leaders who are delivering successful change.

Get in touch
The Forum,
PO Box 173
High Peak
SK17 1DL

Copyright © 2021 - All Rights Reserved - theforum.social

Professional Forums Ltd. Company Number: 3915800. Registered Address: Emperor’s Gate, 114a Cromwell Road, London, SW7 4AG