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

excel training course - how do i create

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - HOW DO I CREATE A FORMULA

excel training course - HOW DO I CREATE A FORMULA

ResolvedVersion Standard

Tanis has attended:
PowerPoint Introduction course
Excel Introduction course

HOW DO I CREATE A FORMULA

Tell me more about sum functions

RE: HOW DO I CREATE A FORMULA

Hi Tanis,

Thanks for the question.

The sum function is the easiest way to total numbers up within a range. You can use the Autosum button on the toolbar or similarly you can type =sum( and then highlight the range of cells you want to add up.

If you use a comma instead of a colon you can add individual cells up. For example, =sum(A1:C1) will add up A1 plus B1 plus C1, wheras =sum(A1,B1) will only add up the two cells A1 and B1.

Is there any specific questions or problems you have? If so please do not hesitate to let me know

Tracy

Excel tip:

Recovering Unsaved Work in Excel 2010

Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back.

Choose File then Info, click Manage Versions and then Recover Unsaved Workbooks which will automatically find the spreadsheets that haven't been saved.

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.