www.myonlinetraininghub.com Open in urlscan Pro
192.124.249.160 Public Scan

Back to summary

URL:
https://www.myonlinetraininghub.com/power-pivot-course?awt_a=f2Zj&awt_l=ptWL&awt_m=gR26enG7HfVR.Zj
Submission: On February 14 via api (February 14th 2024, 7:43:11 pm UTC) from OM — Scanned from DE

Form analysis
3 forms found in the DOM

GET https://www.myonlinetraininghub.com/

<form class="search-form" method="get" action="https://www.myonlinetraininghub.com/" role="search"><label class="search-form-label screen-reader-text" for="searchform-1">Search site</label><input class="search-form-input" type="search" name="s"
    id="searchform-1" placeholder="Search..." required=""><button class="search-form-submit button-secondary" type="submit" value="Search"><span class="screen-reader-text">Submit search</span><svg xmlns="http://www.w3.org/2000/svg"
      viewBox="0 0 512 512" class="search-form-submit-icon" width="24" height="24"><!-- Font Awesome Pro 5.15.3 by @fontawesome - https://fontawesome.com License - https://fontawesome.com/license (Commercial License) -->
      <path
        d="M508.5 468.9L387.1 347.5c-2.3-2.3-5.3-3.5-8.5-3.5h-13.2c31.5-36.5 50.6-84 50.6-136C416 93.1 322.9 0 208 0S0 93.1 0 208s93.1 208 208 208c52 0 99.5-19.1 136-50.6v13.2c0 3.2 1.3 6.2 3.5 8.5l121.4 121.4c4.7 4.7 12.3 4.7 17 0l22.6-22.6c4.7-4.7 4.7-12.3 0-17zM208 368c-88.4 0-160-71.6-160-160S119.6 48 208 48s160 71.6 160 160-71.6 160-160 160z">
      </path>
    </svg></button>
  <meta content="https://www.myonlinetraininghub.com/?s={s}">
</form>

POST

<form method="post" class="currency_switch_form">
  <select class="aelia_cs_currencies" name="aelia_cs_currency" aria-label="Choose Currency">
    <option value="USD" selected="selected">United States (US) dollar</option>
    <option value="AUD">Australian dollar</option>
    <option value="GBP">Pound sterling</option>
  </select>
  <noscript><button type="submit" class="button change_currency">Change Currency</button></noscript>
</form>

POST #

<form action="#" method="post" novalidate="novalidate" autocomplete="new-password">
  <div class="tve_lead_generated_inputs_container tve_clearfix tve_empty_dropzone">
    <div class="tve_lg_input_container tve_lg_input" data-css="tve-u-11644b189fa4afe">
      <input type="email" data-field="email" data-required="1" data-validation="email" name="email" placeholder="Type Your Email Here" data-placeholder="Type Your Email Here" class="">
    </div>
    <div class="tve_lg_input_container tve_submit_container tve_lg_submit" data-css="tve-u-12644b189fa4aff">
      <button type="submit" class="" style=""><span class=""><strong>Download My eBook</strong></span></button>
    </div>
  </div>
  <input id="_submit_option" type="hidden" name="_submit_option" value="redirect"><input id="_back_url" type="hidden" name="_back_url" value="https://www.myonlinetraininghub.com/exit-thank-you"><input id="_autofill" type="hidden" name="_autofill"
    value=""><input id="_sendParams" type="hidden" name="_sendParams" value=""><input id="_api_custom_fields" type="hidden" name="_api_custom_fields"
    value="YToxMDp7aTowO2E6Mjp7czoyOiJpZCI7czo0OiJuYW1lIjtzOjExOiJwbGFjZWhvbGRlciI7czo0OiJOYW1lIjt9aToxO2E6Mjp7czoyOiJpZCI7czo1OiJwaG9uZSI7czoxMToicGxhY2Vob2xkZXIiO3M6NToiUGhvbmUiO31pOjI7YToyOntzOjI6ImlkIjtzOjEyOiJtYXBwaW5nX3RleHQiO3M6MTE6InBsYWNlaG9sZGVyIjtzOjQ6IlRleHQiO31pOjM7YToyOntzOjI6ImlkIjtzOjExOiJtYXBwaW5nX3VybCI7czoxMToicGxhY2Vob2xkZXIiO3M6MzoiVVJMIjt9aTo0O2E6Mjp7czoyOiJpZCI7czoxMzoibWFwcGluZ19yYWRpbyI7czoxMToicGxhY2Vob2xkZXIiO3M6NToiUmFkaW8iO31pOjU7YToyOntzOjI6ImlkIjtzOjE0OiJtYXBwaW5nX3NlbGVjdCI7czoxMToicGxhY2Vob2xkZXIiO3M6ODoiRHJvcGRvd24iO31pOjY7YToyOntzOjI6ImlkIjtzOjE2OiJtYXBwaW5nX2NoZWNrYm94IjtzOjExOiJwbGFjZWhvbGRlciI7czo4OiJDaGVja2JveCI7fWk6NzthOjI6e3M6MjoiaWQiO3M6MTY6Im1hcHBpbmdfdGV4dGFyZWEiO3M6MTE6InBsYWNlaG9sZGVyIjtzOjg6IlRleHRhcmVhIjt9aTo4O2E6Mjp7czoyOiJpZCI7czoxMjoibWFwcGluZ19maWxlIjtzOjExOiJwbGFjZWhvbGRlciI7czoxMToiRmlsZSB1cGxvYWQiO31pOjk7YToyOntzOjI6ImlkIjtzOjE0OiJtYXBwaW5nX2hpZGRlbiI7czoxMToicGxhY2Vob2xkZXIiO3M6NjoiSGlkZGVuIjt9fQ=="><input
    type="hidden" id="tve_mapping" name="tve_mapping" value="YTowOnt9"><input type="hidden" id="tve_labels" name="tve_labels" value="YToxOntzOjU6ImVtYWlsIjtzOjIwOiJUeXBlIFlvdXIgRW1haWwgSGVyZSI7fQ==">
</form>

Text Content

 * Skip to main content
 * Skip to header right navigation
 * Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Menu
 * Courses
 * Pricing
   * SALE 20% Off All Courses
   * Free Courses
   * Power BI Course
   * Excel Power Query Course
   * Power Pivot and DAX Course
   * Excel Dashboard Course
   * Excel PivotTable Course – Quick Start
   * Advanced Excel Formulas Course
   * Excel Expert Advanced Excel Training
   * Excel Tables Course
   * Excel, Word, Outlook
   * Financial Modelling Course
   * Excel PivotTable Course
   * Excel for Customer Service Professionals
   * Excel for Operations Management Course
   * Excel for Decision Making Under Uncertainty Course
   * Excel for Finance Course
   * Excel Analysis ToolPak Course
   * Multi-User Pricing
 * Resources
   * Free Downloads
   * Excel Functions Explained
   * Excel Formulas
   * Excel Add-ins
   * IF Function
     * Excel IF Statement Explained
     * Excel IF AND OR Functions
     * IF Formula Builder
   * Time & Dates in Excel
     * Excel Date & Time
     * Calculating Time in Excel
     * Excel Time Calculation Tricks
     * Excel Date and Time Formatting
   * Excel Keyboard Shortcuts
   * Excel Custom Number Format Guide
   * Pivot Tables Guide
   * VLOOKUP Guide
   * ALT Codes
   * Excel VBA & Macros
   * Excel User Forms
   * VBA String Functions
 * Members
   * Login
   * Password Reset
 * Blog
 * Excel Webinars
 * Excel Forum
   * Register as Forum Member
 * 
 * Search
   Search siteSubmit search
 * Login

SALE 20% Off All Courses - Ends Feb 15th (8pm PDT)     See Courses

 * Courses
 * Pricing Sub Menu
   * SALE 20% Off All Courses
   * Free Courses
   * Power BI Course
   * Excel Power Query Course
   * Power Pivot and DAX Course
   * Excel Dashboard Course
   * Excel PivotTable Course – Quick Start
   * Advanced Excel Formulas Course
   * Excel Expert Advanced Excel Training
   * Excel Tables Course
   * Excel, Word, Outlook
   * Financial Modelling Course
   * Excel PivotTable Course
   * Excel for Customer Service Professionals
   * Excel for Operations Management Course
   * Excel for Decision Making Under Uncertainty Course
   * Excel for Finance Course
   * Excel Analysis ToolPak Course
   * Multi-User Pricing
 * Resources Sub Menu
   * Free Downloads
   * Excel Functions Explained
   * Excel Formulas
   * Excel Add-ins
   * IF Function Sub Menu
     * Excel IF Statement Explained
     * Excel IF AND OR Functions
     * IF Formula Builder
   * Time & Dates in Excel Sub Menu
     * Excel Date & Time
     * Calculating Time in Excel
     * Excel Time Calculation Tricks
     * Excel Date and Time Formatting
   * Excel Keyboard Shortcuts
   * Excel Custom Number Format Guide
   * Pivot Tables Guide
   * VLOOKUP Guide
   * ALT Codes
   * Excel VBA & Macros
   * Excel User Forms
   * VBA String Functions
 * Members Sub Menu
   * Login
   * Password Reset
 * Blog
 * Excel Webinars
 * Excel Forum Sub Menu
   * Register as Forum Member
 * 
 * Login


POWER PIVOT AND DAX COURSE

You are here: Home / Power Pivot and DAX Course
20% Off All Courses - Ends Aug 17th



 


ARE YOU SICK OF WAITING FOR THE IT DEPARTMENT TO EXTRACT DATA FROM YOUR SYSTEMS?


DO YOU SPEND TOO MUCH TIME FLATTENING YOUR DATA TABLES INTO ONE WITH VLOOKUP
JUST SO YOU CAN USE IT IN A PIVOT TABLE REPORT?


ARE YOU FRUSTRATED THAT EXCEL CAN’T HANDLE MORE DATA?

 


POWER PIVOT FOR EXCEL FIXES ALL THAT.

In my Power Pivot for Excel course I’ll teach you how you can use the free Power
Pivot Excel add-in to perform powerful data analysis right from within Excel
2010 onward, bringing self-service business intelligence to your desktop.



 


DON'T KNOW PIVOT TABLES?

Don't worry, I've teamed up with John Michaloudis to bring you the most
comprehensive Pivot Table course on the planet (as an optional extra), so you
can master Pivot Tables too. More about John's Xtreme PivotTable course in a
minute.


BIG DATA ON YOUR DESKTOP

Leveraging “big data” in your business might be crunching sales patterns to plan
inventory levels, cutting staff expenses by analysing employee overtime and
rearranging work schedules or using social media data to gauge what customers
think about your business and competitors.

Power Pivot for Excel enables you to transform enormous quantities of data with
incredible speed into meaningful information to get the answers you need in
seconds, all with the comfort of familiar Excel tools and features.

 * Import millions of rows of data from virtually any source including
   relational databases, data feeds, Reporting Services, text files,
   multidimensional sources, cloud services, data feeds, Excel files, and data
   from the Web into a single Excel workbook,
 * Create relationships between the different sources just like Access.
 * Build interactive reports with PivotTables, PivotCharts and Slicers, and then
   further analyze the data so that you can make timely business decisions.
 * Power Pivot calculations and analysis are extremely fast. You can process
   millions of rows in about the same time as thousands.
 * Data Analysis Expressions (DAX) is a new formula language that extends the
   data manipulation capabilities of Excel to enable more sophisticated and
   complex grouping, calculation, and analysis like never before.
 * The DAX formula language is very similar to that of Excel formulas.

All without requiring IT assistance.

Note: even if IT guard the data like their life depends on it, once they hand
over the 'data goods' you can load it into Power Pivot and it's yours forever.
Each month/week/day you just need to get the new data and import it to your
Power Pivot model where you can analyse it to your heart's desire. Shhh, don't
tell IT you're secretly harvesting their data for your own use... that's just
between you, me and Power Pivot 😉

 


SNEAK PEEK OF POWER PIVOT

For best viewing quality: press play then 1. click the cog and select 720p HD,
and 2. click the icon on the bottom right of the video to view in full screen.





 


WHAT YOU GET IN THE POWER PIVOT FOR EXCEL COURSE

 * Hands on Project Based Learning – We build a Power Pivot model together from
   start to finish. The course follows a progressive path with each video
   teaching a technique or step which you then perform using the data provided
   in the course. So, at every stage you are practicing what you learn which
   helps retain knowledge and build confidence.
 * Download the completed Excel Power Pivot files created during filming and use
   them as a reference tool that you can go back to later on to refresh your
   memory.
 * The training is delivered online and tutorials are available to watch 24/7 at
   your own pace. Pause, rewind, replay as many times as you like.
 * 5.5 hours of video tutorials covering everything from installing Power Pivot,
   importing data, DAX formulas, PivotTables and more.
 * Compatible with Excel 2010, 2013, 2016, 2019, 2021 and Office 365 - there are
   separate courses for Excel 2010/2013 and Excel 2016 onward and Office 365 so
   that you'll know where to find the various features in the menus in your
   version.
 * The pace is pretty fast because I hate courses that waffle on. I like to get
   straight to the point so you’re up to speed fast, and I’ve designed it so
   that if you need to re-watch anything you can rewind and replay the videos as
   many times as you like.
 * The average video length is 4 ½ minutes! Fit it in during a coffee break, on
   the train or bus to work, at the airport, or anywhere you have a spare 5
   minutes and an internet connection.
 * 12 months access to the video tutorials and file downloads. There’s even a
   download option where you can download all videos in the course and keep them
   on your own PC forever.
   
 * When you’ve finished I’ll send you a ‘Certificate of Completion’ saying
   you’ve completed the course which you can add to your resume/CV arsenal.
 * BONUS e-Book: Learn to Write DAX by Matt Allington. This book extends your
   hands-on practice. Inside you will find explanation of concepts, sample
   exercises and then practice questions and answers to maximize learning
   retention and experience. The e-book is delivered via email 31 days after
   joining the course.

 


PREREQUISITES:

 * Have access to Excel 2010 or Excel 2013/2016 Office Professional Plus, Office
   2016 Professional, any version of Excel 2019, 2021 or Office 365, or the
   standalone edition of Excel 2013/2016. Click here for the full list.
   
   Tip: to check if your Excel version has Power Pivot go to the File tab >
   Options > Add-ins > In the 'Manage' drop down list choose 'COM Add-ins' >
   click Go. If 'Microsoft Office PowerPivot for Excel' is in the list you're
   good to go 🙂 If it’s not there and you have the Standalone Excel 2013
   version below 1511, you can simply update your version and Power Pivot will
   be available. In Excel 2016, 2019, 2021 and Office 365 Power Pivot ships in
   the box!
   
   
 * Pivot Table and Pivot Chart knowledge is helpful, but expertise is not
   necessary to take this course.
   
   
   
   If you think you need to brush up on your PivotTable skills first you can add
   John's PivotTable course to your bundle. Click here to find out more about
   John's Xtreme PivotTable course.

 * Mac users: Power Pivot won’t run on a Mac, sorry 🙁 You can install Windows
   on Mac using Parallels, Boot Camp or VMWare Fusion and then install Power
   Pivot on a PC version of Excel (see first point above) running under a VM.
   
   
 * Compatibility with other versions:
   
   
   

   Note: Excel 2016/2019/2021 comes with new DAX functions which are not
   backwards compatible with Excel 2013.

 * Sharing Power Pivot Excel files: Office 365 users can share Excel files under
   10MB via Excel Online with others. Excel Online supports Slicers and
   modifying Power Pivot PivotTables, but not the creation of Power Pivot
   PivotTables. Excel Online is a great option for users who wish to view Power
   Pivot reports but don't have a version of the Excel Desktop App that contains
   Power Pivot.



WHO IS TEACHING THE COURSE?

That would be me, I’m Mynda Treacy, Co-founder of My Online Training Hub, and a
Microsoft Excel MVP.

I have been working with Excel since 1995 and teaching since 2010 (not including
teaching many colleagues over the years), and I’m excited to be presenting this
Power Pivot course.

Power Pivot transforms Excel from a day to day spreadsheet to a commanding BI
tool able to consume an All You Can Eat Data Buffet right from the comfort of
your desk. No donut bribery for the IT department required to rush through your
report or data request 🙂

It’s exciting, it’s ground breaking and you’ll never look back.

 


CHOOSE YOUR COURSE

Tip: The courses below (Power Pivot for Excel and Xtreme PivotTables) complement
each other. If you want to learn PivotTables then take John's course. If you
want to take PivotTables to the next level and use massive data and multiple
tables of data in the one PivotTable then take the Power Pivot course. If you
think you need to brush up on your PivotTable skills before tackling Power Pivot
then take both courses.

Buy More Than 1 Course and Get 20% Off Each One


Choose Currency
United States (US) dollar Australian dollar Pound sterling Change Currency

 * Online Only : 12 months online access to the course(s)
 * Online + Download : 12 months online access to the course(s) + download the
   course videos to keep
 * GST : Prices are shown exclusive of GST for Australian customers.


These Prices Already Have The 20% Discount Applied



MYNDA'S POWER PIVOT AND DAX : ONLINE



$169 $135Add to cart

$169 $135Add to cart

12 Months Online

$169 $135Add to cart

--------------------------------------------------------------------------------

Online Only Access To Course

--------------------------------------------------------------------------------

Power Pivot and DAX Videos
5hrs 23min

--------------------------------------------------------------------------------

One Payment for 12 Months Access

--------------------------------------------------------------------------------

Unlimited 24/7 access

--------------------------------------------------------------------------------

Pause, rewind, replay

--------------------------------------------------------------------------------

Download Workbooks and Practice Data

--------------------------------------------------------------------------------

30 Day Money Back Guarantee

 


MYNDA'S POWER PIVOT AND DAX : DOWNLOAD



$339 $271Add to cart

$339 $271Add to cart

12 Months Online + Download

$339 $271Add to cart

--------------------------------------------------------------------------------

Online Access + Download & Keep Course Videos

--------------------------------------------------------------------------------

Power Pivot and DAX Videos
5hrs 23min

--------------------------------------------------------------------------------

One Payment for 12 Months Access

--------------------------------------------------------------------------------

Unlimited 24/7 access

--------------------------------------------------------------------------------

Pause, rewind, replay

--------------------------------------------------------------------------------

Download Workbooks and Practice Data

--------------------------------------------------------------------------------

30 Day Money Back Guarantee

 


JOHN'S XTREME PIVOT TABLES : ONLINE



$149 $119Add to cart

$149 $119Add to cart

12 Months Online

$149 $119Add to cart

--------------------------------------------------------------------------------

Online Only Access To Course

--------------------------------------------------------------------------------

Xtreme PivotTable Videos
9hrs 28min

--------------------------------------------------------------------------------

One Payment for 12 Months Access

--------------------------------------------------------------------------------

Unlimited 24/7 access

--------------------------------------------------------------------------------

Pause, rewind, replay

--------------------------------------------------------------------------------

Download Workbooks and Practice Data

--------------------------------------------------------------------------------

30 Day Money Back Guarantee

 


JOHN'S XTREME PIVOT TABLES : DOWNLOAD



$299 $239Add to cart

$299 $239Add to cart

12 Months Online + Download

$299 $239Add to cart

--------------------------------------------------------------------------------

Online Access + Download & Keep Course Videos

--------------------------------------------------------------------------------

Xtreme PivotTable Videos
9hrs 28min

--------------------------------------------------------------------------------

One Payment for 12 Months Access

--------------------------------------------------------------------------------

Unlimited 24/7 access

--------------------------------------------------------------------------------

Pause, rewind, replay

--------------------------------------------------------------------------------

Download Workbooks and Practice Data

--------------------------------------------------------------------------------

30 Day Money Back Guarantee

 



NOTES

 * Videos will be available for download after the 30 day Money Back Guarantee
   period ends. You can watch the videos online in the meantime.
 * Membership and access to the training materials is for one person only.
   Logons are not to be used by multiple people.
 * Downloaded videos are to be used only by the registered member, they are not
   to be transferred/shared amongst other people.
 * You can request a refund provided that no more than 30% of the course videos
   have been watched.

Added to Cart

BLOG CATEGORIES

 * AI in Excel
 * Excel
 * Excel Charts
 * Excel Dashboard
 * Excel Formulas
 * Excel Office Scripts
 * Excel PivotTables
 * Excel Shortcuts
 * Excel VBA
 * General Tips
 * Online Training
 * Outlook
 * Power Apps
 * Power Automate
 * Power BI
 * Power Pivot
 * Power Query

Sign up to our newsletter and join over 400,000
others who learn Excel and Power BI with us.

 

COMPANY

 * About My Online Training Hub
 * Disclosure Statement
 * Frequently Asked Questions
 * Guarantee
 * Privacy Policy
 * Terms & Conditions
 * Testimonials
 * Become an Affiliate
 * Sponsor Our Newsletter


SUPPORT

 * Contact
 * Forum
 * Helpdesk – For Technical Issues

Copyright © 2024 · My Online Training Hub · All Rights Reserved. Microsoft and
the Microsoft Office logo are trademarks or registered trademarks of Microsoft
Corporation in the United States and/or other countries. Product names, logos,
brands, and other trademarks featured or referred to within this website are the
property of their respective trademark holders.




Download A Free Copy of 100 Excel Tips & Tricks

Download My eBook

We respect your privacy. We won’t spam you.

x
8.5k Shares
Share
Tweet
Pin
Share
Share
Print
Share
Email
Share

My Online Training Hub
Data and Cookie Consent
In order to provide a more personal user experience, we and our 219 partners use
technology such as cookies to store and/or access device information.
By clicking “Accept” you consent to these technologies which will allow us and
our partners
to process non-sensitive data such as IP address, unique ID, and browsing data
for the purposes of serving personalized ads and content, ad and content
measurement, audience insights, and to develop and improve products.
Your choices on this site will be applied only for this site. You can change
your settings at any time, including withdrawing your consent, by going to the
Privacy Policy
page of this site.
Manage Settings
Accept

Update Privacy Settings