|
Featured Tutorial
Featured Macro
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
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