Microsoft Office courseware and training manuals

We do have old courseware for Word, PowerPoint, Outlook, Visio and Publisher (feel free to ask about licensing this), but we only have courseware for the current version of Microsoft Office in Excel and Access:

Adding Tables to a Query
; Deleting Tables from a Query
; Adding Single Fields to a Query
; Adding Multiple Fields to a Query
; Deleting Fields from a Query
; The Asterisk (*) – Including All Fields
; Changing the Order of Fields
; Sorting by Fields
; Omitting Fields
; The Best Way to Write Queries
; Saving Queries

Cut, Copy, and Paste
; Drag and Drop
; Replacing and Inserting Cells with Drag and Drop
; Special Options for Pasting
; The Paste Tool
; Paste Special
; Paste Special using the Right-Click Menu
; The Format Painter

AutoFill

Copying Using AutoFill
; AutoFill Paste Options
; The Clipboard
; Using the Clipboard
; Copying and Pasting Using the Clipboard
; Clearing the Clipboard

Filling Cells
(4 pages)

Creating Series

Creating a Series from its First Two Values
; Filling a Series with the Right Mouse Button

Custom Lists

Flash Fill

Flash Fill when Copying Down
; Flash Fill Tool using the Ribbon
; Other Examples of Flash Fill

Moving and Selecting in Excel
(6 pages)

Moving Around in Excel

Using the Mouse to Move Around
; Keyboard Shortcuts for Moving Around
; Zooming the View

Standard Number Formats using the Ribbon
; Standard Number Formats using Format Cells

Custom Number Formats

Creating Custom Number Formats
; General Rules for Custom Number Formats
; Example of a Typical Custom Number Format
; Re-using Custom Number Formats

Tricks with Number Formats

Tricks with Text
; Hiding Parts of a Number Format
; Colouring Parts of a Number Format
; Getting Positive and Negative Numbers to Line Up
; Getting Decimal Points to Line Up
; Fractions
; Scaling Large Numbers
; Filling Spaces

Reasons to Prefer MATCH/INDEX to VLOOKUP
; The Range Names for our Example
; The Syntax of MATCH
; Using MATCH to Find Row/Column Numbers for our Example
; Syntax of the INDEX Function
; Creating the INDEX Function for our Example
; Combining MATCH and INDEX in a Single Function

The Parts of a Chart (Chart Elements)
; Selecting Part of a Chart
; Selecting a Data Point or Legend Entry
; Formatting Part of a Chart
; Using the Formatting Task Bar
; Worked Example: Setting the Gradient Fill for a Chart Title

Referring to a Workbook by Name
; Referring to a Workbook by Index Number
; Referencing the Most Recently Opened Workbook
; The Difference between ActiveWorkbook and ThisWorkbook
; Opening a Closed Workbook
; Creating New Workbooks
; Saving Workbooks

Referring to Worksheets

Referring to Worksheets by Name
; Why IntelliSense Doesn’t Work with Worksheets
; Referring to Worksheets by Index Number
; Using Sheet Codenames
; Referring to the Active Sheet
; The Difference between Worksheets and Sheets

Referring to a Single Cell
; Referring to a Block of Cells
; Using Range Names to Refer to Cells
; Referring to Non-Contiguous Ranges
; An Old-Fashioned Way to Refer to Ranges

The Cells Property

Referring to a Cell with Row and Column Numbers
; Referring to a Block of Cells
; Referring to Every Cell on a Worksheet

Rows and Columns

The Range, Rows and Columns Properties
; The EntireRow and EntireColumn Properties

Referring to the Active or Selected Cell

ActiveCell and Selection
; Activate vs. Select

The Offset Property

Offsetting from the ActiveCell
; Offsetting a Block of Cells

The End Property

The Four Directions of the End Property
; Finding the Start of a List
; Finding the Bottom Right Corner of a Table
; Finding the Next Blank Cell in a Column
; Selecting from the Top to the Bottom of a List
; Dealing with Blank Cells

Referring to Regions of Cells

The CurrentRegion Property
; The CurrentArray Property

Resizing Ranges

The Resize Method
; Resizing with the Range Property

Referring to Special Cells

Specifying the Type of Values

Referring to Used Cells

Referring to the Used Range
; The Last Used Cell
; The Last Populated Cell

The Possible Results of a Message Box
; Storing the Result of a Message Box
; Testing Which Button was Clicked

The VBA InputBox Function

Syntax and Parameters of the InputBox Function
; Using an Input Box to Ask a Question
; Setting a Default Value
; What Happens if You Click Cancel?
; Inputting Different Types of Data
; Dealing with Data Type Mismatches

The Form Grid
; The UserForm Toolbar
; The Dominant Control
; Aligning Controls to Each Other
; Distributing Controls
; Aligning Controls to the Form
; Making Controls the Same Size
; Changing the Z-Order of Controls
; Arranging Buttons

The Data Events of a Text Box
; Deciding on Your Validation Rules
; Creating Basic Validation Code
; Selecting the Text in a Text Box
; Ideas for Less-Intrusive Validation
; Resetting the Formatting Properties
; Using Hidden Labels
; Validation at the Form Level
; Setting the Focus to a Control
; Looping over Controls
; Validating Every Text Box in One Pass

Selecting Parts of a MultiPage Control
; Working with Pages
; The Index and Value Properties
; Looping Through Pages and Controls

TabStrip Controls

Working with Tabs
; Drawing Tab Strips and Controls
; Using Tabs in Code
; Looping Over the Tabs Collection

Additional Form Controls
(3 pages)

Additional Form Controls

Adding Items to the Toolbox
; Organising the Toolbox

Examples of Extra Controls

The Date and Time Picker
; The RefEdit Control
; Progress Bars

Controlling Other Applications
(12 pages)

Referencing Object Libraries

Setting a Reference to an Object Library
; The Default References
; References and the Object Browser
; Microsoft Office Version Numbers

An Example for Word

Setting a Reference to the Word Object Library
; Declaring a Variable for Word
; Creating a New Instance of Word
; Showing and Activating Word
; Creating a New Document
; Writing and Formatting Text in Word
; Copying from Excel to Word
; Saving the Document and Closing Word
; The Complete Example

An Example for PowerPoint

Setting a Reference to the PowerPoint Object Library
; Opening PowerPoint and Creating a Presentation
; Creating a Title Slide
; Copying from Excel to PowerPoint
; Moving and Resizing PowerPoint Objects
; Saving the Presentation and Closing PowerPoint
; The Complete Example

An Example for Outlook

Setting a Reference to the Outlook Object Library
; The Complete Example