advanced excel seminar training - subtraction

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel seminar training - Subtraction

advanced excel seminar training - Subtraction

resolvedResolved · Low Priority · Version Standard

Elizabeth has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course

Subtraction

How do a apply a formula to allow subtraction between columns in a chart

RE: Subtraction

Hi Elizabeth,

Thanks for using the forum.

What you can do is put in different cells

A1 = 100
B1 = 45
C1 = A1 - B1

and you can plot a graph using the series A1:C1 so you can see the values in the first two bars and the last bar will be the formula of the first two.

I hope that answers your question, if not let me know

Tracy


 

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet

It would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:-

1) Select the data that might contain duplication's
2) Click the ''Data'' tab
3) Go to ''Data Tools'' and click ''Remove Duplicates''
4) A box will appear. Tick the boxes of the columns that you want to use to check for duplicates. Finally, click ''OK.''

View all Excel hints and tips


Server loaded in 0.74 secs.