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
formulars

ResolvedVersion 2003

Alisa has attended:
Excel Intermediate course

Formulars

Excellent course, informative however for my role I will be need a good knowledge of formulars any tips on getting farmilar.

RE: Formulars

Hi Alisa

Thank you for your question; and welcome to the forum.

A couple of things you may find useful:

- Formulas always start with an equals sign =

- You can get a total for a row or column of numbers by clicking in the next available blank cell in the row or column; and using Alt + = to enter the Sum function. You will need to check that Excel has selected all the cells you wish to add together; if not you can use your mouse to select the cells that contain the values to be added.

- There is a key located to the left of the 1 key and below the Esc key on your keyboard which is called the pipe key - it has three different symbols on it. If you hold down the Ctrl key and press the pipe key at the same time, you will be able to see where all the formulas are in a spreadsheet. Use the same two keys to change your spreadsheet view back to normal.

I hope you find these useful.
Amanda

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

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