Office 365 Resources

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.

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
307 Liverpool Road, Widnes
WA8 7HP, United Kingdom