Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel

ResolvedVersion 2010

Cathy has attended:
Excel Intermediate course
Excel Advanced course

Excel

Do you have Excel courses for Macs?

RE: Excel

Hi Cathy,

Thank you for your question. We don't use Macs in our normal training sessions. However, one of our trainers, Andrew, uses a Mac. To find out if he could help you, it would be best to call Enquiries at 0207 987 3777.

Kind regards
Marius Barnard
Excel Trainer

Thu 21 Jul 2016: Automatically marked as resolved.

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.