Module 2: Spreadsheet Analysis | Function Referencing

• Module 1: Spreadsheet Analysis | Starting up with MS Excel
• Module 2: Spreadsheet Analysis | Function Referencing
• Module 3: Spreadsheet Analysis | Graphs and Validation Techniques
• Module 4: Spreadsheet Analysis | Lookup Functions
• Module 5: Spreadsheet Analysis | Data Analysis using Pivot Table, Filters and What If Analysis

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

NEXT