Excel Formulas And Functions

1.Introduction On Excel Formulas And Functions
Introduction
Mathematical operators
Modifying values with cell references

2.Complex Formula
Order of operations
Creating complex formulas

3.Relative and Absolute Cell References
Relative references
Absolute references

4.Functions
Parts of a function
Using functions

5.Double-Check Your Formulas
Double-check your formulas
Check the references
Look for mix-ups

6.Understanding Number Formats
What are number formats?
Using number formats correctly

7.Invoice
Writing the function
Using VLOOKUP

8.Data Validation
Data validation

1.Introduction On Excel Formulas And Functions
Introduction
Mathematical operators
Modifying values with cell references

2.Complex Formula
Order of operations
Creating complex formulas

3.Relative and Absolute Cell References
Relative references
Absolute references

4.Functions
Parts of a function
Using functions

5.Double-Check Your Formulas
Double-check your formulas
Check the references
Look for mix-ups

6.Understanding Number Formats
What are number formats?
Using number formats correctly

7.Invoice
Writing the function
Using VLOOKUP

8.Data Validation
Data validation