564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls 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 Introduction to Excel manual, or review how to license our courseware.
Section | Title |
---|---|
1.1 | Interacting with Office |
1.2 | Using the Ribbon |
Section | Title |
---|---|
2.1 | What is Excel Used for? |
2.2 | Opening and closing Excel |
2.3 | Structure of a Workbook |
Section | Title |
---|---|
3.1 | Entering Data |
3.2 | Editing and Removing Data |
3.3 | Inserting and Deleting Cells, Rows and Columns |
3.4 | Checking Spelling |
3.5 | AutoCorrect |
Section | Title |
---|---|
4.1 | Moving Around in Excel |
4.2 | Selecting Cells |
Section | Title |
---|---|
5.1 | Basic Formulae |
5.2 | Creating Formulae |
5.3 | Editing Formulae |
5.4 | Copying Formulae |
5.5 | Functions |
5.6 | Status Bar Calculations |
Section | Title |
---|---|
6.1 | Methods of Copying and Moving |
6.2 | AutoFill |
Section | Title |
---|---|
7.1 | Creating Series |
7.2 | Custom Lists |
7.3 | Flash Fill |
Section | Title |
---|---|
8.1 | Introduction |
8.2 | Closing Workbooks |
8.3 | Creating New Workbooks |
8.4 | Opening an Existing Workbook |
8.5 | Excel File Types |
8.6 | Files with Macros |
Section | Title |
---|---|
9.1 | Moving between Worksheets |
9.2 | Common Tasks |
9.3 | Inserting and Deleting Worksheets |
9.4 | Moving and Copying Worksheets |
9.5 | Group Mode |
9.6 | Summing across Sheets |
Section | Title |
---|---|
10.1 | Methods of Formatting |
10.2 | Formatting Text |
10.3 | Cell Alignment |
10.4 | Making Text Fit into Cells |
10.5 | Formatting Numbers |
10.6 | Cell Backgrounds |
10.7 | Cell Borders |
10.8 | about Gridlines |
Section | Title |
---|---|
11.1 | What are Number Formats? |
11.2 | Formatting Dates |
11.3 | Standard Number Formats |
11.4 | Custom Number Formats |
11.5 | Tricks with Number Formats |
Section | Title |
---|---|
12.1 | Views of a Worksheet |
12.2 | Printing |
12.3 | Printing Areas of a Worksheet |
12.4 | Page Breaks |
12.5 | Fitting Worksheets to Pages |
12.6 | Headers and Footers |
12.7 | Printing Titles |
Section | Title |
---|---|
13.1 | Definition of a Table |
13.2 | Creating and Removing Tables |
13.3 | Sorting Tables |
13.4 | Simple Filtering |
13.5 | Removing Filters |
13.6 | Filtering Specific Types of Data |
13.7 | Removing Duplicate Rows |
13.8 | Using the Data Form |
13.9 | Advanced Filtering (Using OR and AND) |
Section | Title |
---|---|
14.1 | Overview |
14.2 | Selecting Data |
14.3 | Creating Charts |
14.4 | Chart Location |
14.5 | Chart Types, Templates and Defaults |
14.6 | Formatting Charts |
14.7 | Formatting Parts of a Chart |
14.8 | Showing/Hiding Parts of a Chart |
14.9 | Specific Chart Element Consideration |
14.10 | Editing Data |
Section | Title |
---|---|
15.1 | Overview of Comments |
15.2 | Working with Comments |
15.3 | Ways to Show Comments |
Section | Title |
---|---|
16.1 | Relative Referencing |
16.2 | Absolute References |
Section | Title |
---|---|
17.1 | What are Range Names? |
17.2 | Creating Range Names |
17.3 | Creating Formulae using Range Names |
17.4 | Spill Formulae |
17.5 | Changing Range Names |
17.6 | Creating Range Names from Selected Cells |
17.7 | Scope of Range Names |
17.8 | Managing Range Names |
17.9 | Quirks of Range Names |
Section | Title |
---|---|
18.1 | CTRL and SHIFT Key Combinations |
18.2 | Function Keys |
18.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 2023. All Rights Reserved.