If you have many rows of data and then have to summarize by, for example, department and date, Excel makes it very easy with PivotTables. PivotTables leaves the source data alone and creates the formulas for you. So experiment to your heart’s content, no information will be lost.
Want to know more? View the video, attend a one hour workshop or request a consulting visit.
- YouTube Video: TrainerLori Excel Basic PivotTables
- Workshop Schedule: Current ITS Workshop Schedule
- Consulting: Contact the Help Desk (x3333 or firstname.lastname@example.org)