Workplace Learning Literacy Guide

This literacy guide is for adult learners who want to maximize their productivity with the Business Productivity tools they already have. This guide will reinforce ways in which a workplace learner could hone or improve the skills they have in many of the business productivity products available to them. The guide includes typical business operation scenarios in addition to general resources.

Using software, apps and the Internet can increase your productivity and save hours of time. In addition to general everyday use, there are features of each of the Office products will could result in a finished product in no time.  Some of those features are:

·         Creating a mail merge from Microsoft Outlook contacts (“Use mail merge to create and send bulk mail, labels and envelopes - Word,” 2016)

·         Inserting tables from Microsoft Excel (“Copy Excel data or charts to Word - Office Support,” 2016)

·         Using VLOOKUP to compare information from one Microsoft Excel worksheet to another (Baines, 2015)

·         Using Pivot Tables to quickly summarize information in Microsoft Excel (Duggirala, 2009)

For day to day or one off activities, the following resources are available to staff if examples or more clarification is needed.  Those resources are:

·         Lynda.com

·         Google.com

·         Support.Office.com

·         Chandoo.org

Unfortunately, workplace training is usually one of the smallest line items in a budget. This makes it’s even more important for employees to understand the tools on hand and use them to the best of their ability. I felt this literacy guide would be a quick helpful tool for those looking to improve their productivity and save time in the process.

References:

Baines, S. (2015, April 5). Excel – Using VLOOKUP to compare two lists | Pain in the Tech Blog. Retrieved July 2, 2016, from http://www.paininthetech.co.nz/?p=1246

Copy Excel data or charts to Word - Office Support. (2016). Retrieved July 2, 2016, from https://support.office.com/en-us/article/Copy-Excel-data-or-charts-to-Word-35f668e8-671a-4b78-b064-7a4ca61250d4

Duggirala, P. (2009, August 19). Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one | Chandoo.org - Learn Microsoft Excel Online. Retrieved July 2, 2016, from http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/

Use mail merge to create and send bulk mail, labels and envelopes - Word. (2016). Retrieved July 2, 2016, from https://support.office.com/en-us/article/Use-mail-merge-to-create-and-send-bulk-mail-labels-and-envelopes-F488ED5B-B849-4C11-9CFF-932C49474705?ui=en-US&rs=en-US&ad=US

Lynda.com. (2016). Retrieved

from http://www/lynda.com

Google.com. (2016). Retrieved

                from http://www.google.com