AAT Comment: The ultimate crash course in Excel – part 3
AAT_Team
Administrator Posts: 511 🤖 Admin 🤖
A pivot table is one of the quickest and most effective ways to drill down into large sets of data in Excel. Once you have mastered the basics of the PivotTable in Excel you’ll find a world of data analysis opened up to you.
(Worth noting: PivotTable™ is the trademarked term for Microsoft Excel’s pivot table function. We use both terms in this article!)
The best way to understand what PivotTables are all about is to create one and experiment with it. The following example creates a PivotTable showing the total sales values of the top 10 best-selling products in an Excel table containing just over 2,000 invoices.
(Worth noting: PivotTable™ is the trademarked term for Microsoft Excel’s pivot table function. We use both terms in this article!)
The best way to understand what PivotTables are all about is to create one and experiment with it. The following example creates a PivotTable showing the total sales values of the top 10 best-selling products in an Excel table containing just over 2,000 invoices.
Full article.
0
Categories
- All Categories
- 1.3K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 390 NEW! Qualifications 2022
- 174 General Qualifications 2022 discussion
- 16 AAT Level 2 Certificate in Accounting
- 78 AAT Level 3 Diploma in Accounting
- 114 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 276 VAT
- 96 Software
- 281 Tax
- 148 Bookkeeping
- 7.2K General accounting discussion
- 211 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 589 Job postings
- 16 Who can benefit from AAT?
- 37 Where can AAT take me?
- 43 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 24 Apprenticeships
- 67 AAT membership