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 selecting a rangeNormally when selecting a range, one uses the mouse to drag over the area that you wish to select. However, when there is a contiguous range of values you would like to select, first make sure of the following before using the shortcuts. The range is surrounded by an empty rows and empty columns (or the row or column headers to the left and the right). Now click in the top left corner of the range you want to select to activate that cell. Next, press Shift + End + → which will select the row area […]
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.