COMMON FORMULAE
PEMDAS (BOMDAS) or (BEMDAS)
Named Ranges
- Naming Ranges Individually
- Creating Names in Bulk
- Using Names in Formulas
Simple Formulae
- Sum function
- Average function
- Min function
- Max function
- If function
- Mode function
- Large function
COUNT FORMULAE
- Count function
- Counta function
- Countblank function
- Countif function
DATE AND TIME FORMULAE
- Today function
- Now function
- Day function
- Month function
- Year function
- Networkdays function
- Datedif function
LOOKUP AND REFERENCE FORMULAE AS WELL AS AN INTRO TO NESTING
- Vlookup function
- Hlookup function
- Lookup function
- Index And Nested
Match functions
DATABASE FUNCTIONS
- Daverage function
- Dcount function
- Dcounta function
- Dmax function
- Dmin function
- Dsum function
- Dget function
- Dvar function
- Dvarp function
- Dstdevp function
- Dstdev function
|
ROUNDING FUNCTIONS
- Round function
- Roundup function
- Rounddown function
- Ceiling function
- Floor function
- Int function
FINANCIAL FUNCTIONS
- Rate function
- Nper function
- Pv function
- Pmt function
OTHER USEFUL FUNCTIONS
- Var function
- Varp function
- Stdev function
- Stdevp function
- Small function
- Rank function
- Text function
- Upper function
- Lower function
- Proper function
- Offset function
- Median function
- Isblank function
- Istext function
- Iserror function
- Isnumber function
- Istext function
- Sumif function
- Subtotal function
ARRAYS, CONCATENATION & MORE
Joining Results With Concatenation
Nailing More Nested Formulae
Array Formulae
- Custom {Average(If)} function
- Custom {Sum(If)} function
- Custom {Min(If)} function
FORMULA AUDITING
Auditing Formulas
Locating And Resolving Errors
- Using the formula checker to resolve errors
Finding Precedents
|