Microsoft Individual Chapters

Individual chapters are available for teachers who just want to teach a specific topic or specific tool for a software application.
Purchased chapters can be used throughout the school.

Learning Microsoft Excel Individual Chapters

Chapters 2&3: Formatting Spreadsheets

(46 pages)

Demonstrates how to format text, format values to currency and per cent, adjust column widths and row heights, apply and format borders, shade cells, centre text across multiple cells, wrap text within cells, print formulas and use the Format Painter Tool.

Chapter 4: Copying Cell Data

(27 pages)

Demonstrates how to use the Fill Right, Fill Down, Fill Series and AutoFill functions, the difference between Absolute and Relative references and how to use the AutoSum command and Flash Fill.

Chapter 6: Using Worksheets

(18 pages)

Shows students how to copy data between worksheets, duplicate a worksheet, move worksheets, delete worksheets, set tab colours

and create worksheets to display equation dumps.

Chapters 7, 8 & 9: Charts

(62 pages)

Demonstrates how to create charts from cell data. This includes selecting the chart type, layout and location, use the chart tools to format the chart, change the chart type and print and delete charts. Students are then shown how to create column, bar, line and combo charts, plot multiple column data, change axis scales, format columns, axes and walls, plotting charts in their own worksheet and create comparison and custom charts. Sparkline charts are also created and formatted along with Map Charts and applying the Quick Analysis tool.

Chapter 10: Drawing Tools

(30 pages)

Demonstrates how to shade cells, import graphics from clip art, stock or online, use the shape tools, add text to shapes, set graphic properties, use WordArt, the fill effects and the Draw tab.

Chapter 12: Making Decisions

(19 pages)

Introduces simple IF statements, the use of greater than, less than, greater than or equal to, less that or equal to and not equal to, appying AND and OR in IF statements and applying conditional formatting.

Chapter 13: Lookup Commands

(13 pages)

Demonstrates the structure of the VLookup command, setting the reference cell, the range reference and the display column. Looking up an interest rate table, creating an income tax calculation and calculating real estate agent commissions are covered.

Chapter 14: Creating Sales Invoices

(30 pages)

Demonstrates how to create sales invoices for companies. This includes how to format the invoice, name cells, look up stock values from a table, the difference between VLookup and XLookup, use IF statements to ensure calculations are only carried out when values are entered, turn off zero values, create a master invoice and set print areas.

Chapter 16: Macros and Buttons

(29 pages)

Demonstrates how to use macros and buttons. This incudes recording macros, assigning shapes to run macros, editing and deleting macros, applying button properties and looking at the macro steps.

Chapter 17: Payroll Systems

(20 pages)

Demonstrates how to create payroll systems for companies. This incudes completing a payroll worksheet, linking a payslip worksheet to the payroll using link formulas and setting macros and buttons to automate the payslip creation.

Chapter 20: Pivot Tables

(23 pages)

Demonstrates how to use Pivot Tables. This includes selecting the table data, creating a Pivot Table in a separate worksheet, formatting and editing the Pivot Table, adding extra fields, adjusting fields in the table, changing the pivot calculations, creating Pivot Charts and using Filters and Timelines.