Upcoming Leadership Events

Are you a Director or Senior Leader? Join our regular forums to raise standards in customer operations together. The Forum holds events for leaders to network and hear from inspirational speakers throughout the year.

Each session will be recorded, with an edited transcription published and shared around the wider group and community. Future sessions will develop previous discussions and bring in new questions. Each month a new article will be published designed to be built upon exploring new different, but connected, topics. This will lead to a comprehensive article reflecting the comments of all sessions. Each discussion group will be kept small, to give each attendee the opportunity to contribute and answer the key questions, whilst allowing time for the topic area to grow.

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

Comments (0)Number of views (5339)

Author:

Categories: Box Sets

Tags:

Print

As a member, you are not on your own but part of a community with others facing many similar challenges. We are here to help you to make a tangible impact in your organisation and show how developing the capability of each specialist professional function is fundamental to your business.

Book for one of our events to experience our exceptional community or get in touch to talk about how we can help you and your teams to be fully effective in adding value to your business. Email advice@theforum.social, call 0333 123 5960 or contact any of The Forum team.