Labels

Module 2: Spreadsheet Analysis | Function Referencing



This module covers:
Arithmetic Functions, Absolute/Relative Cell Referencing, Mixed References, Formula
Auditing Tools, Formula Error Checking, Tracing Precedents/Dependents, Goto, Naming
individual or range cells, Deleting and amending named ranges, Using named cells/ranges
in formula, Using SUMPRODUCT. Conditional Functions: SUMIF and SUMIFS, COUNTIF
and COUNTIFS, AVERAGEIF and AVERAGEIFS Functions, Using FLOOR/ CEILING/
MROUND/ MOD/ QUOTIENT Functions. Text functions: MID, SEARCH, LEFT, RIGHT
FUNCTIONS, TRIM, CLEAN, UPPER, LOWER, DOLLAR FUNCTIONS, SUBSITUTE. Logical
functions: IF, AND, OR and NESTED IF. Date Functions: DAYS360, TODAY, NOW,
NETWORKDAYS, WORKDAY,

 
                                    Function Referencing

No comments:
Write comments

Please do not enter spam links

Services

More Services