Excel Lesson 2: Part 1 (Adding Basic Formula)
Please Note: This session builds on, and assumes that you have completed, the previous Excel sessions. If that is not the case, please go back and complete them before returning to this session.
STEP 1: Getting Started
Launch Excel and create a new blank Workbook or open up an existing Workbook. I will use:
STEP 2: Entering Basic Formula (Multiplication)
In Excel, a cell can contain an actual data value like a name, price, date etc. or it can contain some kind of formula or calculation. All formulas begin with the equals sign (=).
In this example, we have decided to knock 10% of all current retail prices to try and clear some stock. To do that, we take the original value (£7,500) and multiply it by 0.9 and store the result here.
We can now repeat this for all the other prices.
Notice the following points:
If you forget to start with the ‘=’ sign, Excel will not realize it is a formula.
We use the asterisk (*) for multiplication.
The column ‘Discounted Price’ is using the ‘Currency’ data type (like ‘Retail Price’).
All these calculations have been done manually – without any copying or using cell references.
STEP 3: Entering Basic Formula (Subtraction)
We can now use a formula to manually compute the saving made on each car.
Again, we have made the ‘Saving’ column of type ‘Currency’.
STEP 4: Entering Basic Formula (Addition & Division)
You can obviously use addition (+) and division (/) in a similar way.
In later sessions we will see how to use formulas in a much more sophisticated and efficient way.
That completes this session.
AssignmentTutorOnline
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
