Excel Forum
Similar Content
Remove Deleted Items from Slicers & Pivot Tables
Tutorial: How to remove items from a Slicer that are not actually in the data set that the Slicer f...
Easy Pivot Table in Excel (Auto-Subtotals Feature)
Tutorial: How to make a paired-down version of a Pivot Table for Excel. This allows you to quickly ...
Reuse Pivot Table Filters in Row, Column, & Value Fields
Tutorial: 2 ways to add Pivot Table Filter Fields (page fields) to row, column, and value fields wh...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.