Video Resources
Below are the video procedure demonstrations for Microsoft Office Applications: Word, Excel & PowerPoint, as described in the book. Click the links below. Videos will be added as the course progresses.
 |
 |
 |
 |
 |
 |
 |
File Resources
Save the files into your OneDrive documents folder. To do this, right click on the icons below and select ‘save target as’ (or ‘save link as’, on some browsers). In the dialog box that appears, locate and click on your ‘OneDrive’ documents folder, then click ‘save’.
Microsoft Word
Click on the icons below to download the files.
 |
|
 |
| Planet Earth Starter.docx | Planet Earth Final.docx | Mail Merge Test Data.xlsx |
 |
||
| Sample Images.zip |
Microsoft Excel
Click on the icons below to download the files.
|
|
 |
| Score Sheet Starter.xlsx | Score Sheet Final.xlsx | Statement Test Data.csv |
|
|
|
| IF Function Demo.xlsx | VLOOKUP Function Demo.xlsx | Chart Starter.xlsx |
|
|
|
| Data Analysis Starter.xlsx | Data Validation Demo.xlsx | Mail Merge Test Data.xlsx |
Microsoft PowerPoint
Click on the icons below to download the files.
 |
|
|
| Planet Earth Starter.xlsx | Planet Earth Final.xlsx | Sample Images.zip |
Microsoft Access
Click on the icons below to download the files.
 |
||
| Students.accdb |
Downloading the Files
To save the files into your OneDrive documents folder, right click on the icons above and select ‘save target as’ (or ‘save link as’, on some browsers). In the dialog box that appears, select ‘OneDrive’, click the ‘Documents’ folder, then click ‘save’.
The sample images are stored in a compressed zip file. To download the zip file, right click on the zip icon on the page above, ‘Sample Images.zip. Select ‘save target as’ (or ‘save link as’, on some browsers) and save it into ‘pictures’ on your OneDrive folder.
Once you have downloaded the zip file, go to your ‘pictures’ folder in your OneDrive, right click on the zip file, and select ‘extract all’ from the menu. From the dialog box that appears click ‘extract’. This will create a new folder in your pictures called ‘sample images’. You’ll find the images used in the examples in the books.
