Excel Forum
Similar Content
Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...
Quickly See All Cells linked to a Formula or Function in Excel
Tutorial: Ill show you how to see the cells used in a formula/function in Excel and also how to tel...
Display the Current Day of the Week in Excel
Tutorial: Use a formula or formatting to display the current day of the week in Excel. Sections: For...



Mr Excel & excelisfun Trick 38: Weekly Report Formula or Pivot Table?


See Mr Excel and excelisfun take daily transactional data and create Weekly Summary Reports using a Pivot Table (PivotTable) and a series of formulas.
Learn about:
1.Formula for first Monday in Week using DAY and WEEKDAY functions and DATE, MONTH and YEAR functions
2.Formula to create Text label for Chart using TEXT function, Custom Number Format and the join symbol, Ampersand.
3.Create a Weekly Chart without Chart Junk.
4.Keyboard shortcut for default chart on sheet: Alt + F1
5.Pivot Table Grouped by Week
6.Line Chart and Column Chart for Weekly data





Got a Question? Ask it Here in the Forum.