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

Algae Services. Powered by Blogger.