>
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 /

Excel Basics

Excel Basics / 5 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 [...]

What if Excel see Dates in your Bank Statements as text? Convert text to dates in under a minute.

by Brilliance Computer Training Academy & Services
I have a bank statement which I download every month as a csv file. The date is given in format 01/12/2015 (or dd/mm/yyy - day/month/year) format. Excel reads this as text.Here is how you convert Text to Date. Select the Column where the dates are listed. Click on the Data tab. In the Data Tools Group, click on Text to Columns button. In the Convert Text to Columns Wizard:Select Data Type as Delimited text. Click Next Selecting the Delimiters: None is necessary since you are working with a single column of data anyway. Click Next Selecting the Column data format [...]

Easily moving cell contents to a different location. No Cut and Paste needed.

by Brilliance Computer Training Academy & Services
Easily moving cell contents to a different location. No Cut and Paste needed.   Sometimes we built a list in Excel and we want to move some cell entries up or down according to our preference. As an example, say we have the months of a year: January February March April May June July August September October November December Now we might want to have the months starting at March, as it is considered the start of a financial year in some countries. Often we would do as follows: We will select the range that we want to move, right [...]