This is an archive recording of the Stop Wasting Time with Excel webinar presented by Excel University.
Website: https://www.exceluniversity.com

Want to be notified of new Excel articles? Sign up for the Excel University blog here:
Blog: https://www.exceluniversity.com/blog

Instead of spending extra time doing tasks manually, you'll learn how to have Excel do them for you. We will use a common financial report as our example. We'll see how classic Excel features like tables and SUMIFS can improve efficiency to some extent, and how Power Query and the data model can improve it even more :)

This webinar focuses on improving the efficiency of a common Excel task ... building and updating a report. We'll cover the entire progression of the report process. We'll start by considering how the report is typically updated (manually). Then, we'll improve it with classic Excel features and functions such as tables and SUMIFS. Then, we'll improve efficiency even more with Power Query and the data model. This webinar illustrates how knowledge of these Excel features can help you get your work done faster. At the end of the day, why would we spend more time than necessary doing our work? Time is a precious resource, and learning how to use Excel can help you save a ton of time!

Here are the 5 Excel topics we'll cover:

1. Tables
2. SUMIFS
3. Power Query
4. Data model
5. Cube functions

Here is our outline:

1. We'll get started by using classic Excel features to improve our report (tables, SUMIFS)
2. Next, we'll use Power Query to improve the report process
3. Finally, we'll use the data model and cube functions to improve it even more

Hope you enjoy the webinar, and I hope it helps you get your work done faster.