Mr Excel & excelisfun Trick 83: PowerPivot or Helper Column & PivotTable & Custom Number Format
Loading...
Loading...
3,058
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (10)
-
@foralloccasions , you have to download and install the PowerPivot add-in. It doesn't come with Excel 2010.
-
What did you click @1:38 to open the PowerPivot?
-
@JessMenu , Yes, if the student id was given, that would be much better!
-
The potential problem that I see here is how the "name" column might not be unique in the future. Unique numbers that can't change or be reused by another like student IDs are better candidates for that column. But I sure you guys have already thought of that.
Thanks for another great video, Power pivot table looks like a new feature in 2010, I really need to install the latest office.
Loading...
6:37
Mr Excel & excelisfun Trick 82: Allow Below Limit: Data Validation or Conditional Formattingby ExcelIsFun1,322 views- 8:42
Mr Excel & excelisfun Trick 85: Algebra Solving For Unknown: Goal Seek Or Algebra Excel Formula?by ExcelIsFun2,176 views
- 9:06
Mr Excel & excelisfun Trick 84: Count Calls Every 15 Minutes Count Times Between Upper & Lower Limitby ExcelIsFun1,498 views
- 9:04
Mr Excel & excelisfun Trick 89: PivotTables Grand Totals To Left: LOOKUP or GETPIVOTDATA function?by ExcelIsFun2,330 views
- 4:06
PowerPivot Data Analyst 12 - Asymmetric Reportingby bjele1234,999 views
- 4:53
Excel Dashboardsby dashboardspy44,492 views
- 4:44
PowerPivot Data Analyst 1 - What is PowerPivot?by bjele12317,063 views
- 6:52
IT Skills: Excel - Display two different sets of data in the SAME chart with Secondary Axisby RikkisRefreshers10,060 views
- 12:58
PowerPivot in Microsoft Excel 2010by Office2010HK6,112 views
- 58:35
Excel 2007 / 2010 Tricks For Making Your Job Easier: HCC Professional Development Dayby ExcelIsFun3,143 views
- 9:41
Mr Excel & excelisfun Trick 75: Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX?by ExcelIsFun4,037 views
- 8:24
[Wall Street Excel] Lesson 1: Alt Shortcuts [Part 1]by WSExcel638 views
- 10:27
Mr Excel & excelisfun Trick 94: Lookup Data In Text String & Extract Data From Text Stringby ExcelIsFun2,923 views
- 5:50
Mr Excel & excelisfun Trick 90: Remove Earlier Duplicates, Keep Last Duplicateby ExcelIsFun2,184 views
- 1:09:39
Excel Magic Trick 778: INDEX & MATCH Functions Beginning To Advanced (18 Examples)by ExcelIsFun19,387 views
- 10:54
Mr Excel & excelisfun Trick 78: Extract Top Two Customers In Each Industry with Formula (2 Examples)by ExcelIsFun1,978 views
- 5:26
PowerPivot from Multiple Excel Filesby contextures6,914 views
- 10:29
Excel 2010 Magic Trick 798: Partial Text Lookup Formula To Return Multiple E-mail Recordsby ExcelIsFun2,992 views
- 6:27
Excel 2010 Magic Trick 800: Alter VLOOKUP Table To Simplify Formula To Return Multiple Itemsby ExcelIsFun3,853 views
- 2:31
PowerPivot Data Analyst 4 - Linking Tablesby bjele1234,707 views
Mr Excel...dam you guys are brilliant
Lightin77 5 months ago
@Lightin77 , not so much brilliant, just having fun with Excel!
ExcelIsFun 5 months ago
Very cool solution.
I used the Index and Match to determine the course in question, then tossed it into a traditional Pivot Table. It's an approach I learned from watching ExcelIsFun!
dmr450 5 months ago
@dmr450 , cool!
ExcelIsFun 5 months ago
Great Video! but,
Why hasn't you attached the workbook to this trick?
loyaus 5 months ago
@loyaus , I did not have the PowerPivot Solution from Mr Excel. But on Monday I can upload the raw data set and my solution.
ExcelIsFun 5 months ago