excel computer training - excel introduction

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training - Excel introduction

excel computer training - Excel introduction

resolvedResolved · Low Priority · Version Standard

Rachel has attended:
Excel Introduction course

Excel introduction

How do you add cells together?

RE: Excel introduction

Hi Rachel

If you want to add the total of, for instance, cells A1, B1 & C1

in a different cell, type =SUM(A1:C1)

Hope this helps

Paul

RE: Excel introduction

Alternatively, you can use the + operator.

eg. =A1+B1

will give you the sum of A1 and B1.

Regards, Rich


 

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips


Server loaded in 0.11 secs.