Excel Formulas and Functions
You can work on Excel but sometimes marvel at the formulas, that your colleagues have created. Excel is easy. We will cover formulae in depth in this interesting course.
Course Outline
Session 1:
Popular Functions:
- Sum, Average, Count, Counta, Countblank, Maximum and minimum.
Create from Scratch:
- Program general arithmetics into Excel,
- using addition, subtraction, multiply, divide, brackets
Copy Formulae
- using absoulte $ or relative, down accross and both
Excel function wizard for statistical functions:
- If,
- Nested if,
- Sumif(s), Averageif(s), Countif(s)
Names, Ranges and Tables,
- To simplify cell-referencing
- Using Ranges as Tables
- Conditional Formatting
Working with Excel sheets and files,
- calculating using multiple sheets
- or files
Session 2:
SubTotals:
- Excel Subtotals,
- Group, Outline
Cross referencing data:
- Xlookup,
- Vlookup,
- Hlookup,
- Match,
- Index,
- Indirect
Excel Pivot Tables
- Create
- Modify
- Format
- Sort
- Group
Charts and Pivot Charts
