HDTutorial
EN
How To Automatically Pull In New Report Data Into Excel Using PowerQuery

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How To Automatically Pull In New Report Data Into Excel Using PowerQuery

114,104 views October 31, 2019 6:15

Watch on YouTube
ChannelMichael Olafusi

Description from the creator

One common situation most users of Excel face in making recurrent reports -- daily reports, weekly reports, monthly reports etc -- is that of updating the raw data part of the report with the new data for the period they are creating report for.

As simple as this looks, it is often a boring, repetitive and time consuming task. It could mean having to copy and paste data from the new source data files every day. For some people who get data from different sources (branches, sales people, departments etc), that coping and pasting can easily become a 20 mins task with potentials for human errors.

How do you set up your report to automatically pull in new data from source files? PowerQuery is the answer.

About this tutorial

Michael Olafusi published this 6:15 video tutorial on October 31, 2019. It has been watched 114,104 times on YouTube.

Category
Education
Duration
6:15
Published
October 31, 2019
Views
114,104
Likes
545

Tags

Share

This tutorial in other languages