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

formulae list

ResolvedVersion 2007

Mohsin has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course
Excel Advanced course

Formulae list

Can I get a list of formulae used in Excel (eg. Percentage Change, YoY, Share, Sum, if only, vlookup etc.)

RE: Formulae list

Hi Mohsin

Thanks for getting in touch. You can easily find comprehensive lists of functions and formulas on the internet, but I don't know how useful you would find them. Far better to go to the Formulas tab, pick a group of functions you are interested in, and scroll through. When you select the function you want you will be given guidance on how to use it.

I hope this helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Formulae list

Thank you, Gary!

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

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.11 secs.