moazzamca1's channel
Loading...
-
1 week ago
Mr Excel & excelisfun Trick 97: Determine Quarter For column of Dates: CHOOSE or CEILING function?
Download workbook: http://people.highline.edu/...
See Mr Excel and excelisfun use two methods to create a formula that can take ...
moazzamca1
favorited
-
1 week ago
moazzamca1
liked
-
-
2 weeks ago
Learn Excel 2010 - "GL Codes Imported as Dates": Podcast #1506
Simons gets an accounting file from the company system. When he opens the accounting file, some G/L [General Ledger] codes are converted from the N...
moazzamca1
liked
-
2 weeks ago
Dueling Excel - "Total All Lookups": Podcast #1513
Mike and Bill look at two methods to lookup a column of sales amounts in order to create a single cell formula that will add all the bonuses. Learn...
moazzamca1
liked
-
-
3 months ago
-
6 months ago
Windmills No Hands
Windmills No Hands
moazzamca1
favorited
-
1 year ago
Excel Magic Trick #151: DATEDIF function (between two dates)
Calculate the days, months or years between two dates. See how to use the undocumented Excel DATEDIF function. See how to:
1) Calculate the number ...
moazzamca1
commented:
-
1 year ago
Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range
Download file: https://people.highline.edu...
See how to create a Sorted Unique List Of Words With Formula using INDEX, MATCH,...
moazzamca1
commented:
Great. I have a problem. I have to develop a file to assign reference no. to our letters. There are 5-6 departments who currently need to mention a running no. on their letters (unique for every letter). Currently a secretary keeps a register and tells the next available no. on phone. I want to c...
-
1 year ago
PowerPivot Calculated Columns: Podcast #1260
Today, in Episode #1260, Bill investigates Calculated Columns in the PowerPivot grid using DAX. Also, tips to Format your data for a more visually ...
moazzamca1
commented:
Hi Bill, I am looking to gorup dates in a pivot table but I want the date grouping format to appear as "dd-mmm-yy - dd-mmm-yy" instead of default dd/mm/yyyy. Is there a way I can do it?
Thanks.
-
-
1 year ago
Excel Charts 7 - Column & Line Chart
Show two different orders of magnitude in a chart by using a secondary axis along with columns and lines
moazzamca1
favorited
-
1 year ago
Excel Charts 12 - Screenshots
Paste a screenshot of another application into Excel 2010.
moazzamca1
favorited
-
1 year ago
Excel Charts 14 - Future Zeroes
If your chart shows future months as a line at zero, replace the line with blanks.
moazzamca1
favorited
-
1 year ago
Excel Charts 1 - Series Order
Change the series order in a chart
moazzamca1
favorited
-
1 year ago
Excel Charts 8 - Chart for Each
Create a chart for every customer.
moazzamca1
favorited
-
1 year ago
Excel in Depth 20 - Custom Sorting
Sort Excel items into a sequence that is neither AZ or ZA.
moazzamca1
favorited
-
1 year ago
-
1 year ago
-
1 year ago
Excel In Depth "Filter by Selection":Podcast #1239
Filter by Selection? In Excel 2010? Really? Where is it!? Podcast #1239 shows you! Access this 'secret command' hidden behind a wrong label in Exce...
moazzamca1
commented:
awesome, so simple that we never thought about it. thanks bill.
About moazzamca1's channel
Hi Mike. I am having a problem with DATEDIF function. In some cases it does not calculate correct number of days. For example, I want to work out number of days after completed years (the "YD" argument) between 3-Nov-03 to 25-Feb-17. The system is returning 82 days while this should have been 115...