About This Training Course

Excel Formula Workshop Version 2010/2007/2003 Training Course

Session 1: Common Formulae
1.1 PEMDAS (BOMDAS) or (BEMDAS)
1.2 Named Ranges
• Naming Ranges Individually
• Creating Names in Bulk
• Using Names in Formulas
1.3 Simple Formulae
• SUM
• AVERAGE
• MIN
• MAX
• IF
• MODE
• LARGE

Session 2: Count Formulae
2.1 COUNT
2.2 COUNTA
2.3 COUNTBLANK
2.4 COUNTIF

Session 3: Date and Time Formulae
3.1 TODAY
3.2 NOW
3.3 DAY
3.4 MONTH
3.5 YEAR
3.6 NETWORKDAYS
3.7 DATEDIF

Session 4: Lookup and Reference Formulae as well as an Intro to Nesting
4.1 VLOOKUP
4.2 HLOOKUP
4.3 LOOKUP
4.4 INDEX and nested MATCH

Session 5: Database Functions
5.1 DAVERAGE
5.2 DCOUNT
5.3 DCOUNTA
5.4 DMAX
5.5 DMIN
5.6 DSUM
5.7 DGET
5.8 DVAR
5.9 DVARP
5.10 DSTDEVP
5.11 DSTDEV

Session 6: Rounding Functions
5.1 ROUND
5.2 ROUNDUP
5.3 ROUNDDOWN
5.4 CEILING
5.5 FLOOR
5.6 INT

Session 7: Financial Functions
7.1 RATE
7.2 NPER
7.3 PV
7.4 PMT

Session 8: Other Useful Functions
8.1 VAR
8.2 VARP
8.3 STDEV
8.4 STDEVP
8.5 SMALL
8.6 RANK
8.7 TEXT
8.8 UPPER
8.9 LOWER
8.10 PROPER
8.11 OFFSET
8.12 MEDIAN
8.13 ISBLANK
8.14 ISTEXT
8.15 ISERROR
8.16 ISNUMBER
8.17 ISTEXT
8.18 SUMIF
8.19 SUBTOTAL

Session 9: Arrays, Concatenation & More
9.1 Joining results with Concatenation
9.2 Nailing more nested formulae
9.3 Array formulae
9.4 Custom {AVERAGE(IF)}
9.5 Custom {SUM(IF)}
9.6 Custom {MIN(IF)}

Session 10: Formula Auditing
10.1 Auditing Formulas
• Auditing formulas
10.2 Locating and Resolving Errors
• Using the formula checker to resolve errors
10.3 Finding Precedents

Subjects Covered

This Excel Formula Workshop Version 2010/2007/2003 Training Course will cover the following subject:


• Excel Formula

Training Course Outcomes

Creation of intermediate and advanced formulas.

Prerequisites

What is assumed of the students?
• Students have reasonable keyboard skills.
• Students have reasonable mouse skills.
• Students have a knowledge of Windows.
• Students have a strong exisiting knowledge of Excel.

Other Information

If you need further information contact Startnextweek.com.au on 1300 728 102