formulas

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

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

formulas

resolvedResolved · Low Priority · Version Standard

Anouska has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course

formulas

any advice on remembering formulas?

Edited on Thu 6 Mar 2008, 11:00

RE: formulas

Hi Anouska hope you are well

Firstly thankyou for attending the course on Tuesday, and i hope you enjoyed it

as you will be aware there are basic formulas that are used as you may remember from Tuesday at the start of the day, we went through a refresher on formulas

he is a list of the bacis ones you may need

=sum(b3:b20) means add from b3 to b20
=average(b4,b7,d10,f5) find the average of the cells
=max(b4:d10) return the highest number from a range
=count(a3:h20) will count how many cells there are

you could also use the autosum button from the standard toolbar

that looks like this an M on its side

Just make sure you practice these types of formulas and you will be good in no time

Hope this helps you

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn


 

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips


Server loaded in 0.08 secs.