formulaes

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulaes

Formulaes

resolvedResolved · Low Priority · Version 2003

Norah has attended:
Excel Introduction course

Formulaes

What are teh shortcuts to using formulaes?

RE: formulaes

Hi Norah

Thank you for your question, and I'm glad you found today's course useful.

Two shortcuts we discussed today were:

Alt and + to enter the Sum function into a spreadsheet
Ctrl + the 'pipe' key (key below Esc) to display all the formulas in a spreadsheet.

I hope you find the forum useful in future.
Amanda


 

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips


Server loaded in 0.09 secs.