202R2/4 Cell Referencing in Excel
When editing or redesigning a worksheet, all the data and and formulae can be moved all over! So that our formulae will continue to work, we have to consider if that cell reference will be […]
Read More →When editing or redesigning a worksheet, all the data and and formulae can be moved all over! So that our formulae will continue to work, we have to consider if that cell reference will be […]
Read More →The order of operations Excel calculates formulas based on the following order of operations: Operations enclosed in parentheses Exponential calculations (3^2, for example) Multiplication and division, whichever comes first Addition and subtraction, whichever comes first […]
Read More →Formatting is very similar to Word, the toolbar is virtually identical. Obviously there is extra focus on table like tools. VIDEOABOUT https://www.youtube.com/watch?v=etAMC0KRuBE link https://www.youtube.com/watch?v=etAMC0KRuBE 4 minutes (Fitness) Changing the font size and color Using bold, […]
Read More →The greatest power of spreadsheets is that they can be programmed (the formula with functions) to do the maths as you update the data We have already seen how to create basic formulae in this […]
Read More →The greatest power of spreadsheets is that they can be programmed (the formula with built-in functions) to do the maths as you update the data We have already seen how to create basic formulae in […]
Read More →