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

excel

ResolvedVersion Standard

Alison has attended:
Excel Advanced course

Excel

Where do I find the explanations for things like ISBLANK and other easy to use statements when writing functions?

Worksheet functions lists in Excel

Alison

In Excel go to the "Type A Question for help" box in the top right of the excel window and type in

Worksheet functions listed by category

and click the same sentence in the options that appear

In the Help window select the category and Function you want, and read the description and examples for its use.

Hope this helps

Carlos

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

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.