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

microsoft excel training - average

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Average

microsoft excel training - Average

ResolvedVersion Standard

Sema has attended:
Excel Introduction course

Average

How do I get an average?

RE: Average

Hi Sema,

Thank you for the question. To get an average from a set of data simply type in =AVERAGE( and select the data you wish to average then press return.

The shortcut is also on the toolbar on the dropdown arrow near the sum function.

Hope this helps

Tracy

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

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.