Before getting started with this course, it's important to make sure that you are using a version of Excel that is compatible with Power Pivot. Check the Microsoft Office Support website to check compatibility.
- [Instructor] Now before we dive in it's important to talk…about versions and compatibility.…Couple important things to note here.…Power Pivot is currently not available for Mac,…and it's only available in certain versions…of Excel for Windows.…So first things first, if you wanna see a full current list…of compatible versions, check out support.office.com.…I'm showing you a full link here with a short code version…or you can simply Google, Where is Power Pivot,…and you'll land at this page here.…
And this site lays out all of the versions of Office…and Excel that contain Power Pivot…and these other business intelligence tools.…So take a look.…Make sure that your version is compatible…before you go on with the course.…Now a few other quick considerations.…Number one.…Power Pivot does work best with a 64-bit version in Excel.…Now it's not critical.…You can run Power Pivot with a 32-bit version of Excel.…It's just that 64-bit has access…to more processing power and more memory.…
So it's a bit faster and a bit more stable.…
- Power Pivots versus normal pivots
- Creating calculated columns and measures
- Power Pivot and DAX best practices
- Math, stats, and COUNT functions
- CALCULATE, FILTER, and ALL functions
- Joining data with RELATED
- Using iterator functions (SUMX and RANKX)
- Time intelligence formulas
Skill Level Intermediate
1. Getting Started
Set expectations1m 46s
2. Power Pivot and DAX 101
3. Common DAX Functions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.