Learn for Free
See the articles and videos on this page and sign-up to our Top Tips email for useful information and to download our free spreadsheets
Videos
Hiding and unhiding
data
Free Spreadsheets
Do you struggle to keep track of your prospects? Do you worry about following up calls when you should?
Download our free spreadsheet.
Download Prospects / Customers Contact Management
Do you want to record when you started working on a job and when you finished? Do you want to easily total those times? Download our free spreadsheet
Download Time Logging
Excel Top Tips
Do you want to stop an email address in a cell from creating an email when you
click on it? Or a website opening when you click on its cell?
- Select the cell
with the hyperlink (email or website address) in.
- Right mouse
click
- Select Copy
- Right mouse
click again.
- Select ‘Paste
Special’
- Click the
operation ‘Multiply’.
- Click OK.
Do you need to change text from this format 'SMITH' to
this,
'Smith'?
Use the
'Proper' function.
For example, if the value in cell A1 is 'SMITH' enter the
formula
in another cell. This cell will now show 'Smith'.