Office 365 Resources

Video Demos

Below are the video procedure demonstrations for Microsoft Office Applications: Word, Excel & PowerPoint, as described in the book. Videos will be added as the course progresses.

Word Thumb Excel Thumb

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.

saving images from a web page

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.

extract a zip file in windows

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.

Phone: +44 (151) 424-2618
office@elluminetpress.com
Liverpool Road, Widnes
WA8 7HP, United Kingdom