Excel Magic Trick 1112

Clean Transactional Data, Then Create PivotTable Monthly Cost Report

DESCRIPTION

(01:06) Group By Date In PivotTable Error (Cannot group that selection error)
(01:42) Text To Columns To Convert Text Dates To Dates
(02:53) Text To Columns Fatal Error (Microsoft Excel has stopped working error)
(03:51) Formula to add zero to Text Number To Convert Text Number Back To Number
(04:16) Paste Special Values Right-Click Mouse Trick
(04:46) PivotTable To Add Costs by Month From Transactional Data (Group By Date)
(05:28) Format PivotTable: Report Layout: Tabular Form & Number Formatting (not Cell Formatting)
(06:02) Paste Special Operation Add Zero To Convert Text Number Back To Number
(07:21) Paste Special Values & Operation Add Zero To Convert Text Number Back To Number and NOT replace Number Formatting and Borders in Data Set.
Convert Text Dates & Numbers To Dates & Numbers many Other Tricks
Cannot group that selection PivotTable Group by Date Error. Microsoft Excel has stopped working error

WORKBOOKS