training ms excel advanced - 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 » training ms excel advanced - Formulas

training ms excel advanced - Formulas

resolvedResolved · Low Priority · Version Standard

Kasia has attended:
No courses

Formulas

How to build the formulas, transfer them over

RE: formulas

Hi Kasia

How you put a formula together depends on what you want it to do. For example, if I have typed 10 into cell B5 in a spreadsheet and 10 into cell B6, I can put together a formula that will add or subtract or multiply or divide these numbers.

The formula is always put into it's own cell in the spreadsheet, so let's say I put the formula into cell B7. Here are some examples of formulas I could put into cell B7 (note that a formula always starts with =):

=B5+B6 will add what's in cell B5 to what's in cell B6

=B5-B6 will minus what's in cell B6 from what's in cell B5

=B5*B6 will multiply the two numbers together

=B5/B6 will divide what's in cell B5 by what's in cell B6.


I hope this helps.
Amanda


 

Excel tip:

Creating charts in Excel 2010

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

View all Excel hints and tips


Server loaded in 0.09 secs.