Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
551 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Here are the chapters included in this course manual (we use exactly the same manuals for our classroom and online Microsoft Excel courses).
Click here to download a sample of the first two chapters of this Excel Modelling manual, or review how to license our courseware.
Section | Title |
---|---|
1.1 | Guideline 1 – Use a Cover Sheet |
1.2 | Guideline 2 – Separate Inputs and Calculations |
1.3 | Guideline 3 – Use Styles |
1.4 | Guideline 4 – Use Range Names |
1.5 | Guideline 5 – Keep Formulae Simple |
1.6 | Guideline 6 – Copy Formulae Across |
1.7 | Guideline 7 – Use Consistent Period Headings |
Section | Title |
---|---|
2.1 | What are Range Names? |
2.2 | Creating Range Names |
2.3 | Range Names in Formulae |
2.4 | Working with Range Names |
2.5 | The Scope of Range Names |
2.6 | 3-Dimensional Ranges |
Section | Title |
---|---|
3.1 | Overview of Styles |
3.2 | Applying Styles |
3.3 | Creating Styles |
3.4 | Changing Styles |
3.5 | Merging Styles |
Section | Title |
---|---|
4.1 | What are Number Formats? |
4.2 | Formatting Dates |
4.3 | Standard Number Formats |
4.4 | Custom Number Formats |
4.5 | Tricks with Number Formats |
Section | Title |
---|---|
5.1 | Overview |
5.2 | Creating Conditional Formats |
5.3 | Editing and Deleting Conditional Formats |
5.4 | More Sophisticated Rules |
5.5 | Viewing Conditionally Formatted Cells/Rules |
Section | Title |
---|---|
6.1 | Overview of Notes |
6.2 | Working with Notes |
6.3 | Ways to Show Notes |
Section | Title |
---|---|
7.1 | What is Data Validation? |
7.2 | Creating Validation Rules |
7.3 | Referencing Formulae in Validation |
7.4 | Dropdown Lists |
7.5 | Input Messages |
7.6 | Copying and Clearing Validation Settings |
7.7 | Highlighting Validated Cells |
Section | Title |
---|---|
8.1 | Types of Protection |
8.2 | Protecting Worksheets |
8.3 | Protecting a Workbook’s Structure |
8.4 | Password-Protecting Workbooks |
8.5 | Preventing Accidental Changes to a Workbook |
8.6 | Hiding Worksheets |
8.7 | Hiding Cells and Formulae |
Section | Title |
---|---|
9.1 | Using Grouping |
9.2 | Creating Grouping/Outlining |
9.3 | Problems with Grouping/Outlining |
9.4 | Removing Outlining/Grouping |
Section | Title |
---|---|
10.1 | Overview of IF Functions |
10.2 | Creating IF Functions |
10.3 | Nesting IF Conditions |
10.4 | The SWITCH Function |
Section | Title |
---|---|
11.1 | The CELL and INFO Functions |
11.2 | Sheet Number / Numbers |
Section | Title |
---|---|
12.1 | List of Text Functions |
12.2 | Text Functions – a Case Study |
Section | Title |
---|---|
13.1 | Returning Date Information |
13.2 | Manipulating Dates |
Section | Title |
---|---|
14.1 | Types of Lookup Table |
14.2 | Inexact Matches (Continuous Value Lookups) |
14.3 | Exact Match Lookup Tables |
14.4 | Trapping Errors |
Section | Title |
---|---|
15.1 | Inspection Functions |
15.2 | Handling Errors |
Section | Title |
---|---|
16.1 | Introduction to XLOOKUP |
16.2 | Using XLOOKUP |
Section | Title |
---|---|
17.1 | Overview of Conditional Statistical Functions |
17.2 | SUMIFS, COUNTIFS, etc |
Section | Title |
---|---|
18.1 | Masking |
18.2 | Logical Functions |
Section | Title |
---|---|
19.1 | Combining MATCH and INDEX |
19.2 | The XMATCH Function |
19.3 | The CHOOSE Function |
19.4 | The OFFSET Function |
19.5 | The INDIRECT Function |
Section | Title |
---|---|
20.1 | Our Example |
20.2 | Solutions without SUMPRODUCT |
20.3 | The SUMPRODUCT Function |
Section | Title |
---|---|
21.1 | Examples of Dynamic Range Names |
21.2 | Making a Range Name Dynamic |
21.3 | Dynamic Range Names and Charts |
Section | Title |
---|---|
22.1 | Template for a Cashflow Calculation |
22.2 | Calculating Interest |
Section | Title |
---|---|
23.1 | Discount Rates |
23.2 | Discounted Cashflow |
23.3 | NPV and IRR Functions |
Section | Title |
---|---|
24.1 | Moving between Worksheets |
24.2 | Common Tasks |
24.3 | Inserting and Deleting Worksheets |
24.4 | Moving and Copying Worksheets |
24.5 | Group Mode |
24.6 | Summing across Sheets |
Section | Title |
---|---|
25.1 | Overview of Scenarios |
25.2 | Creating a Scenario |
25.3 | Showing Different Scenarios |
25.4 | Editing, Deleting and Merging Scenarios |
25.5 | Summarising Scenarios |
Section | Title |
---|---|
26.1 | Goal-Seeking Example |
26.2 | Using Goal-Seeking |
Section | Title |
---|---|
27.1 | Overview of Data Tables |
27.2 | One-Way Data Tables |
27.3 | Two-Way Data Tables |
Section | Title |
---|---|
28.1 | Creating a Row of Data |
28.2 | Other Keyboard Shortcuts |
If you book a place on one of our courses you will automatically get access to the relevant courseware manual online, and also have the option to receive a paper copy of it.
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.