>
0 items - $0.00

Your shopping cart is empty

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

Tips and Tricks

Tips and Tricks / 3 posts found

Tips and Tricks 5: Excel Shortcuts – Entering the current date and time

by Brilliance Computer Training Academy & Services
  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 [...]

Tips and Tricks 4: Excel Shortcuts – Cut/Copy/Paste/Undo/Redo and and fast sheet navigation

by Brilliance Computer Training Academy & Services
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 [...]

Tips and Tricks 1: Excel Shortcut to select a Row or Column

by Brilliance Computer Training Academy & Services
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.