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
546 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 Intermediate Excel manual, or review how to license our courseware.
Section | Title |
---|---|
1.1 | Basic Formulae |
1.2 | Creating Formulae |
1.3 | Editing Formulae |
1.4 | Copying Formulae |
1.5 | Functions |
1.6 | Status Bar Calculations |
Section | Title |
---|---|
2.1 | Moving Around in Excel |
2.2 | Selecting Cells |
Section | Title |
---|---|
3.1 | Relative Referencing |
3.2 | Absolute References |
Section | Title |
---|---|
4.1 | What are Range Names? |
4.2 | Creating Range Names |
4.3 | Creating Formulae using Range Names |
4.4 | Spill Formulae |
4.5 | Changing Range Names |
4.6 | Creating Range Names from Selected Cells |
4.7 | Scope of Range Names |
4.8 | Managing Range Names |
4.9 | Quirks of Range Names |
Section | Title |
---|---|
5.1 | Overview of IF Functions |
5.2 | Creating IF Functions |
5.3 | Nesting IF Conditions |
5.4 | The SWITCH Function |
5.5 | Combining IF with Other Logical Functions |
Section | Title |
---|---|
6.1 | Overview of Conditional Statistical Functions |
6.2 | SUMIFS, COUNTIFS, etc |
Section | Title |
---|---|
7.1 | Creating Conditional Formats |
7.2 | Editing and Deleting Conditional Formats |
7.3 | More Sophisticated Rules |
7.4 | Viewing Conditionally Formatted Cells/Rules |
Section | Title |
---|---|
8.1 | Definition of a Table |
8.2 | Creating and Removing Tables |
8.3 | Sorting Tables |
8.4 | Simple Filtering |
8.5 | Removing Filters |
8.6 | Filtering Specific Types of Data |
Section | Title |
---|---|
9.1 | Views of a Worksheet |
9.2 | Printing |
9.3 | Printing Areas of a Worksheet |
9.4 | Page Breaks |
9.5 | Fitting Worksheets to Pages |
9.6 | Headers and Footers |
9.7 | Printing Titles |
Section | Title |
---|---|
10.1 | What are Number Formats? |
10.2 | Formatting Dates |
10.3 | Standard Number Formats |
10.4 | Custom Number Formats |
10.5 | Tricks with Number Formats |
Section | Title |
---|---|
11.1 | Returning Date Information |
11.2 | Manipulating Dates |
Section | Title |
---|---|
12.1 | Moving between Worksheets |
12.2 | Common Tasks |
12.3 | Inserting and Deleting Worksheets |
12.4 | Moving and Copying Worksheets |
12.5 | Group Mode |
12.6 | Summing across Sheets |
Section | Title |
---|---|
13.1 | What is Data Validation? |
13.2 | Creating Validation Rules |
13.3 | Referencing Formulae in Validation |
13.4 | Dropdown Lists |
13.5 | Input Messages |
13.6 | Copying and Clearing Validation Settings |
13.7 | Highlighting Validated Cells |
Section | Title |
---|---|
14.1 | Types of Protection |
14.2 | Protecting Worksheets |
14.3 | Protecting a Workbook’s Structure |
14.4 | Password-Protecting Workbooks |
14.5 | Preventing Accidental Changes to a Workbook |
14.6 | Hiding Worksheets |
14.7 | Hiding Cells and Formulae |
Section | Title |
---|---|
15.1 | Overview |
15.2 | Selecting Data |
15.3 | Creating Charts |
15.4 | Chart Location |
15.5 | Chart Types, Templates and Defaults |
15.6 | Formatting Charts |
15.7 | Formatting Parts of a Chart |
15.8 | Showing/Hiding Parts of a Chart |
15.9 | Specific Chart Element Consideration |
15.10 | Editing Data |
Section | Title |
---|---|
16.1 | CTRL and SHIFT Key Combinations |
16.2 | Function Keys |
16.3 | Other Special Keys |
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.