Video Demos
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.
 |
 |
 |
Resources
Click on the document icons below to download the files to your computer – you’ll find them in your browser’s downloads folder. We have included the starter documents so you can follow along with the exercises in the books. There is also an example of the final completed version for you to use. Save the files into your OneDrive documents folder, or the documents folder on your PC.
Word 2016
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 |
Excel 2016
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 |
PowerPoint 2016
Click on the icons below to download the files.
 |
|
|
| Planet Earth Starter.xlsx | Planet Earth Final.xlsx | Sample Images.zip |
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, locate and click on your ‘OneDrive’ or ‘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.
