Excel Magic Trick 610: Pivot Table Year Over Year Sales Calculation From Daily Transactional Data
Loading...
Loading...
6,352
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (14)
-
I am glad that the videos help!
-
i love it
-
I am glad that you liked the videos!
-
Love your videos. Linked to them from my Symbaloo mix on Excel 2010. Let me know if you want to make a dedicated mix for your video set.
Loading...
6:25
Excel Magic Trick 611: Array Formula Year Over Year Sales Calculation From Daily Transactional Databy ExcelIsFun2,917 views- 5:56
Excel Magic Trick 612: Pivot Table Year Over Year Sales Calculation From Dates Listed As Textby ExcelIsFun4,198 views
- 13:54
Excel Magic Trick 609: Array Formula To Return Multiple Items - List Periods That Students Have Freeby ExcelIsFun3,470 views
- 11:06
Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periodsby ExcelIsFun6,619 views
- 7:58
Use Excel Pivot Tables to analyse your SALESby MrDatamart5,475 views
- 4:21
Excel - Formulas for Percentageby hwilmer11,437 views
- 6:19
Dashboards in Excelby contactatbiznet137,193 views
- 0:44
CALCULATE PERCENTAGEby 60secondstraining10,596 views
- 8:58
Excel Magic Trick 779: SUMIFS Faster Than SUMPRODUCT & TEXT When Using "Jan" Month Criteriaby ExcelIsFun3,677 views
- 9:14
Excel Magic Trick 637: Lookup A Chart -- Defined Names, INDIRECT function and Formulas In Picturesby ExcelIsFun5,391 views
- 8:12
Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)by ExcelIsFun6,104 views
- 6:46
Working with Pivot Tables in Excel 2010 - Part 3by titantechtraining23,109 views
- 8:01
Excel Magic Trick 650: Formula To Extract All Rows In Data Set Into 1 Column INDEX functionby ExcelIsFun3,532 views
- 7:44
Excel Magic Trick 613: Array Formula Year Over Year Sales Calculation From Dates Listed As Textby ExcelIsFun1,695 views
- 7:34
Excel Magic Trick 614: Extract Full Date from Monthly Dates Listed As Text -- Pivot Tableby ExcelIsFun2,538 views
- 6:56
How to Use Multiple Pivot Table Summaries in Excel 2007by DannyRocksExcels6,409 views
- 6:10
Excel Magic Trick 401: Quarterly Comparative Report - Pivot Table (PivotTable)by ExcelIsFun4,889 views
- 6:02
Excel 2010 Magic Trick 795: Pivot Table: Transactional Payroll Data Into Employee Reports PivotTableby ExcelIsFun2,967 views
- 7:58
Excel Lookup Series #1: VLOOKUP Function 1st Exampleby ExcelIsFun315,616 views
- 5:10
Excel Magic Trick 639: Approximate Match Lookup with Unsorted Column Across Multiple Columnsby ExcelIsFun2,407 views
Once again sir. Thank you.
jonathan92591 5 months ago
@jonathan92591 , I am glad that it helps!!
ExcelIsFun 5 months ago
Thank you for the quick reply!
I want a percentage comparison of two columns. I have a table from an external source, which has data about all employess working hours over a certain period of time. Using a pivot table I need to calculate utilization for each employee.
Utilization = days recorded / days to be recorded
Therefore I want to use a pivot table to show the following columns:
a. days recorded
b. days to be recorded
c. a in % of b
Is there a way of doing so? Please help
maxathlet 7 months ago
Send me the link to the post you made at the Mr Excel Message Board:
excelifun at gmail
ExcelIsFun 7 months ago
Thank you for the video! It is always very well explained and very helpfull.
Could you please explain how i can show column #1 of a pivot table as a percentage of ANOTHER column (e.g. column #2) of the same pivot table.
I need to calculate utilazation of consultans for my manager and therefore I need to "compare" one column of my pivot table with another. How can I do that?
Thank you very much!
maxathlet 8 months ago
Post questions to THE best Excel forum:
mrexcel[dot]com/forum
Be sure to say what sort of comparison you want, subtraction, division, or whatever.
ExcelIsFun 8 months ago