Excel: calculate day of the week average with Averageif / PivotTable by Chris Menard
6 هزار بار بازدید -
6 سال پیش
-
Need to know what day
Need to know what day of the week is your best day? If you are a retailer, don't assume Saturday is your best day. Maybe Thursday is your best day. Let's use Excel to find out.
To calculate the day of the week average, you can use either the Averageif function or a PivotTable. You need to add the Text function as a helper column. Use the letter "d" to figure out the day of the week.
August 9, 2018, is a Thursday. One letter d will be 9, two letter ds will be 09, three ds will be Thu, and four ds will be Thursday.
Example: The date 8/9/2018 with the text function. Assume the date is in cell A2.
In cell B2, type =Text(A2,"ddd") to return Thu.
Type =Text(A2,"dddd") to return Thursday spelled out.
=Text(A2,"dd") to return 09.
Averageif has three arguments.
************
Chris Menard's Websites
************
http://chrismenardtraining.com
Tables in Excel - Free course on ten reasons to use Tables in Excel.
https://chrismenardtraining.teachable...
************
ACCLAIM - Digital Credentials - Microsoft
************
Microsoft Office Master 2016 - Acclaim Digital Credential
https://www.youracclaim.com/badges/dc...
Microsoft Office Specialist Excel 2016 Expert - Acclaim Digital Credential
https://www.youracclaim.com/badges/8e...
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
To calculate the day of the week average, you can use either the Averageif function or a PivotTable. You need to add the Text function as a helper column. Use the letter "d" to figure out the day of the week.
August 9, 2018, is a Thursday. One letter d will be 9, two letter ds will be 09, three ds will be Thu, and four ds will be Thursday.
Example: The date 8/9/2018 with the text function. Assume the date is in cell A2.
In cell B2, type =Text(A2,"ddd") to return Thu.
Type =Text(A2,"dddd") to return Thursday spelled out.
=Text(A2,"dd") to return 09.
Averageif has three arguments.
************
Chris Menard's Websites
************
http://chrismenardtraining.com
Tables in Excel - Free course on ten reasons to use Tables in Excel.
https://chrismenardtraining.teachable...
************
ACCLAIM - Digital Credentials - Microsoft
************
Microsoft Office Master 2016 - Acclaim Digital Credential
https://www.youracclaim.com/badges/dc...
Microsoft Office Specialist Excel 2016 Expert - Acclaim Digital Credential
https://www.youracclaim.com/badges/8e...
And make sure you subscribe to my channel!
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
6 سال پیش
در تاریخ 1397/06/18 منتشر شده
است.
6,025
بـار بازدید شده