Thursday, May 16, 2013

Excel Formulas

Basic Formula:  Multiplication with Robert Griffith
<iframe width="420" height="315" src="http://www.youtube.com/embed/zGb6lWT2KZU" frameborder="0" allowfullscreen></iframe>

Thanks to Excelisfun.

Here are some quick notes:

15 Formulas, including Assumption Tables (Bus. 216 Class) with Cell References ($) such as for commission rate; projecting costs...
How to lock on formulas -- Using F4 Key  (Relative and Absolute formulas)
Also including:  payroll and tax payments; budgeting (estimates); gross rate;  net income; expenses; mark-up prices and profit margin calculations; Profits; Running Totals (expandable ranges: Shift  Colon); Sum Ifs ...Summing with 2 references (F4 key) etc.

The 2 questions one must ask for locking each cell references in formulas.

(Incorrect copying? √ Smart Tag -- immediate, or it's gone;  tax payments;  Fill without Formatting)
(Cost and mark-up for Sale Prices)

<iframe width="420" height="315" src="http://www.youtube.com/embed/_PBPU_5jTUA" frameborder="0" allowfullscreen></iframe>

No comments:

Post a Comment