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

formulas

ResolvedVersion 2003

Nadja has attended:
Excel Intermediate course
Excel Advanced course

Formulas

more formula training should be provided

RE: formulas

Hi Nadja,
Thank you for your post, in answer to your question, what sort of formulas are you looking for; in our advanced course we cover the most common such as;AND, OR, IF, SUMIF, V/HLOOKUP, PMT, GOAL SEEKER, SOLVER and SCENARIOS, we also show how to use the fx (Insert Function) dialog box which gives you access to over 150 different Functions, in addition we give an introduction to creating Custom Functions. It would be difficult to include many more options as they tend to be for very specific individual requirements, as well as time constraints for completing all the other areas which are in the course syllabus.
I personally learnt to use formulas and functions by accessing the fx (Insert Function) dialog box and experimenting with the many options available, as well as using on line and Excel's own Help facilities.
I hope that has been of help to you, if so please click the Resolved link, Best regards Pete

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

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.