>
0 items - $0.00

Your shopping cart is empty

Why not add some items in our Shop
Call Us at +27 21 786 1224

Excel Pivot Tables / 1 posts found

Introducing the Concepts of Pivot Tables

by Brilliance Computer Training Academy & Services
What is a Pivot Table? A Pivot Table gives a summary of information. But let me try and explain it as follows. Transaction Description Debit (in R100) Bakery 50 Bakery 10 Juice 7 Dairy 20 Dairy 10 Dairy 30 Meat 10 Meat 30 Tea & Coffee 40 Dry Store 20 Dry Store 50 Fruit & Veg 30 Fruit & Veg 30   If you look at these transactions and I ask you how much was spent on Diary. If you add together 20 + 10 + 30 = 60 (i.e. R6000) you indirectly already know what a pivot table does at […]