Excel Power Tools Reporting Made Easy

Academy Membership

This is for individual Membership: When you are registering for yourself. if you want to register for a group or team, check out the team membership. Worth more than $10K! 48-hours free trial

  • Access to all video courses.
  • 430+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month with a 2-day free trial
  • EUR: €45.11
  • GBP: £38.39
  • NZD: $79.77
  • CAD: $66.85
  • AUD: $73.65

Academy Membership - for Teams

This is for team Membership: When you have a group of team members registering. if you want to register for one person, check out the individual membership. Worth more than $10K! 48-hours free trial

  • Access to all video courses.
  • 430+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month with a 2-day free trial
  • EUR: €45.11
  • GBP: £38.39
  • NZD: $79.77
  • CAD: $66.85
  • AUD: $73.65
per member

Excel Power Tools – Reporting Made Easy

This course will introduce you to the Excel Power Tools – built-in functionality within Excel that’s designed to make your life easier when preparing reports in Excel. If you need to do any reporting, graphing or repetitive tasks in Excel then this is the course for you.

Length: 3 Hours and 29 Minutes

$259.00
  • EUR: €238.44
  • GBP: £202.92
  • NZD: $421.65
  • CAD: $353.37
  • AUD: $389.27
Or log in to access your purchased courses

This course will introduce you to the Excel Power Tools – built-in functionality within Excel that’s designed to make your life easier when preparing reports in Excel. If you need to do any reporting, graphing or repetitive tasks in Excel then this is the course for you.  

We will start with a basic overview of Excel tables and cover off some best practice tips for working with data in Excel. Then we will move into an introduction to Excel Power Query – the one-stop-shop for transforming your data within Excel. See how you can quickly cleanse your data with just the click of a button (split columns, replace values, calculated columns, and more).  

From the Power Query, we will load our data into the Excel Data Model. If you struggle with VLOOKUPs or have slow, cumbersome Excel reports due to lots of formulae and calculations, then you don’t want to miss this module.  

Along the way, we will be creating PivotTables and PivotCharts to gather insights from our data. At the end of this course, you will have the tools and knowledge to create robust, insightful, and easy to use Excel reports in a fraction of the time it takes you now. 

Modules