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 […]
You might want to insert the current date or time in Excel. Two easy shortcuts for this is: Ctrl + ; is a shortcut key to enter the current date in a cell. Ctrl + : or Ctrl + Shift + ; are shortcut keys to enter the current time in a cell. It should be noted though that once you have entered a date or time, these values are fixed. Should you wish to enter a date or time that will constantly update each time that the Excel file opens or when Excel refreshes calculations, you will then rather want to […]
Copy, Paste, Cut Ctrl + C is a shortcut key to copy; alternatively click on the Home tab, Clipboard, and Copy. Ctrl + V is a shortcut key to paste; alternatively click on the Home tab, Clipboard, and Paste. Ctrl + X is a shortcut key to cut; alternatively click on the Home tab, Clipboard, and Cut. Undo and Redo Ctrl + Z is a shortcut key to Undo the previous key stroke. Ctrl + Y is a shortcut key to Redo or restore the previous Undo. Moving to the next or previous window Ctrl + Tab is a shortcut […]
Excel Shortcut to select a Row or Column: To select a column of an active cell, press Ctrl + Spacebar or click on the column border. To select a row of an active cell, press Shift + Spacebar or click on the row border. Excel Shortcut to hide a Row or Column Ctrl + 0 hides the column of the active cell. Ctrl + 9 hides the column of the active cell However, I found that these keys only work when pressing the 0 above the Qwerty keyboard. Those in the numerical pad does not work.