Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Office / Productivity

Office and productivity software is virtually any application people use to "produce" information. That includes almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.

Share tech news, updates, or what's on your mind.

Sign up to Post

An Introductory Tour to Marketo Marketing Automation
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design Studio, Lead Database, Analytics, and the Community. This will help you acclimate yourself to the system and know where each member of your team will mainly need access to perform their core duties.
1
What does it mean to be "Always On"?
LVL 4
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

How to tell Microsoft Office that a word is NOT spelled correctly
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When an Office module, such as MS Word, gives us the red squiggly underline signifying a misspelled word, yet it really is spelled correctly (such as a proper noun), we're all familiar with how to add it to the custom dictionary, that is, simply right-click the word and select Add to Dictionary. But suppose we type in a word that does not get the red squiggly underline, that is, Word thinks it is spelled correctly, yet we do not like that spelling, and we want Word (and other Office apps) to flag it as a misspelling. This video explains a Microsoft supported technique for achieving that.

1. Locate the ExcludeDictionary file


Exit all Office apps.

Using Windows/File Explorer (or whatever file manager you prefer), navigate to this file:

c:\Users\<username>\AppData\Roaming\Microsoft\UProof\ExcludeDictionaryEN0409.lex

Of course, <username> is your user name (in my video, it is Joe). The exact name of the file will vary depending on your language and Office version, but it will begin with ExcludeDictionary and have a LEX file extension.

Step1

2. Open the ExcludeDictionary file


Using Notepad (or whatever plain text editor you prefer), open the ExcludeDictionary file, which will be empty the first time you open it. If you do a File>Open, make sure that All Files is selected, since it is a LEX
14
 

Expert Comment

by:baffledbill
Thank you for the detail and writing it in an understandable way.

Based on your information, I played around with the various English files and my locale and language settings and saw it work as you suggested. I also found that it is safe to simply delete the files, and let Office recreate the appropriate one when it performs a spell check.
0
 
LVL 55

Author Comment

by:Joe Winograd, EE MVE 2015&2016
You're welcome, Bill. I'm glad to hear that it works for you. And thanks to you for determining that it is safe to delete the LEX file(s) — that Office will re-create the appropriate one when it performs a spell check. I hadn't tried that — very good to know! Regards, Joe
0
How a small business owner can reduce the cost of Google Apps
In this Experts Exchange video Micro Tutorial, I'm going to show how small business owners who use Google Apps can save money by setting up what is called a catch-all email address in their Gmail accounts. By using the catch-all feature, small business owners can support popular inbound email addresses, such as info@MySmallCompany.com, sales@MySmallCompany.com, support@MySmallCompany.com, etc., without having to pay the Google Apps fee for those "users". If the volume of such emails in your small business is reasonable, then all of them can be directed to another Gmail account on your domain. In the best case scenario, a one-person company can do fine with just a single Google Account user, saving the small business owner hundreds of dollars per year.

1. Sign into your Google Admin Console


Visit this link:

https://admin.google.com/AdminHome

Choose your Google Account and sign in with your password.

Step1

2. Bring up the Apps Settings


Click Apps.

Step2

3. Bring up the Google Apps Settings


Click Google Apps.

Step3

4. Bring up the Gmail Settings


Click Gmail.

Step4

5. Bring up the Gmail User Settings


Click User settings.

Step5

6. Enter the catch-all address


Scroll down until you find a section in the Gmail User Settings called Routing.

Enter the address of a real Gmail user in your account. This is where messages sent to unknown user accounts will be delivered.

Step6

7. Save the change to the catch-all setting


Click SAVE.

Step7
That's it! I hope you just saved yourself some money in Google Apps fees. Better in your pocket than Google's!

If you find this video to be helpful, please click the thumbs-up icon below. Thank you for watching!
3
 
LVL 14

Expert Comment

by:Allen Falcon
The downside of this approach is that any email sent to the domain, legitimate or not will be routed to the one user, which greatly increases the chances of spam and phishing attacks getting through.  It also provides a "legitimate" return address for spammers that use spoofing.

Other options are:
Setup specific nicknames for the user, such as info@, sales@, service@, help@ etc. This can be done from the User admin section, as noted in the video, by adding alias addresses.
Use the Groups feature to setup a "distribution list" for info@, sales@, etc to forward to the user

The advantage of these options is that you can also configure to user so that he/she can reply using the nickname/group name.  So, the user can reply as info@, sales@ etc OR their personal address.
0
 
LVL 55

Author Comment

by:Joe Winograd, EE MVE 2015&2016
Hi Allen,
Yes, those are downsides of the approach, as stated in Google's caveat shown in Step #6 above and why I took the time to read the caveat in full during the video. Thanks very much for providing your thoughts on other options — those are interesting ideas! I've used aliases/nicknames and groups/distribution lists with other email providers/client software, but not with Gmail. I'll check it out — appreciate the tip! Regards, Joe
0
Fix Code to fill Missing data in Excel. Loop through spreadsheet in VBA.
This Experts Exchange lesson shows how to use VBA to loop through rows in Excel.  In order to sort, filter, and use database features, there needs to be a value in each column for every row. When data arrives with values missing, code to copy values where it is blank can be run.

This lesson shows the manual process to fill blanks, and the VBA code to implement it.

This is Part 2 in a 3-part series to discuss error handling in Excel.

Part 3 of this series will add errors to the code and then show how to fix them.  Part 1 of this Experts Exchange series suggested basic error handling code.

01. Set up the error handler


   At the top of the code for your procedure, the error handler is set up using     On Error GoTo Proc_Err

02. Dimension Variables


   Declare variable names and data types that will be used in this procedure.

03. Initialize Variables


   Initialize the values of variables that will be used in this procedure.

04. Calculate Variables


   Calculate the values of variables that be determined.

05. Give User a Chance to Back Out


   Issue a message box to the user and allow them to stop the process.

06. Determine the Last Row


   Determine the last row on the worksheet that needs to be written to.

07. Loop through each Row of Data and Save or Write Value


   Loop through each row and either save the value that is there, or write the last value saved if a value is needed.

08. Continue Looping until Done


   Continue looping until all values in the specified column are written.

09. Exit Code


   After the procedure code, a line label for the exit code (Proc_Exit: ) is used to signify what happens at the end of the procedure. This is code to gracefully exit.

10. Error Handling Code

0
 
LVL 22
This is Part 2 in a 3-part series to discuss error handling in Excel.  It can be watched independently of the other videos.  This presentation focuses on automating a manual process to copy values from one row to the next in a column of an Excel spreadsheet.

You will learn how to loop through rows using VBA.  This example copies values to blank cells, but you could do something else in your loop.

Part 3 of this series will add errors to the code and then show how to fix them.  
http://www.experts-exchange.com/videos/1518/Excel-Error-Handling-Part-3-Run-and-Fix-Bugs.html

Part 1 of this series reviewed basic error handling code.
http://www.experts-exchange.com/videos/1478/Excel-Error-Handling-Part-1-Basic-Concepts.html

Attached is the download file for this lesson, and the next: Books_ErrorHandling_02_Code2_CopyDownBlanks.xlsm
Books_ErrorHandling_02_Code2_CopyDo.xlsm
0
How to install the Office 2016 desktop applications that come with the free trial of Office 365 Home
In a previous video Micro Tutorial here at Experts Exchange, I explained how to get a free, one-month trial of Office 365, which provides the desktop versions of Office 2016. For Windows, this includes Access 2016, Excel 2016, OneNote 2016, Outlook 2016, PowerPoint 2016, Publisher 2016, and Word 2016, as well as Microsoft OneDrive. The previous tutorial ended at the point of downloading the installer for the Office 2016 desktop modules for Windows. This new tutorial goes through the installation process for those applications.

1. Run the downloaded installer


Using Windows/File Explorer (or whatever file manager you prefer), locate the downloaded installer for the Office 2016 apps that are included as part of the Office 365 Home subscription. The name may vary depending on your operating system, but it will look something like this:

Setup.<lots of other characters here>.exe

Run it (usually, via a double-click, but that depends on your file manager and settings) and then click the "Run" button on the "Security Warning" dialog.

step1

2. Accept the User Account Control dialog


Depending on your User Account Control (UAC) settings, you may or may not get the UAC dialog. If you do, click the "Yes" button.

step2

3. Wait until all Office 2016 apps are installed


Although it says, "We'll be done in just a moment", grab a cup of coffee.

step3

4. Check for the Office Tools shortcuts


Check to make sure that the installer created a "Microsoft Office 2016 Tools" program group, with two shortcuts in it.

step4

5. Check for the Office shortcuts


Check to make sure that the installer created shortcuts for all of the Office 2016 apps. It does not
0
How to get a free trial of Office 365 with the Office 2016 desktop applications
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Personal. However, only one of them offers a free trial — Office 365 Home. This Experts Exchange video Micro Tutorial explains how to go through the process of obtaining the free, one-month trial for Office 365 Home, which includes the desktop versions of Office 2016. For Windows, this includes Access 2016, Excel 2016, OneNote 2016, Outlook 2016, PowerPoint 2016, Publisher 2016, and Word 2016, as well as Microsoft OneDrive. In a subsequent EE video Micro Tutorial, I show how to install the downloaded desktop versions of those Office 2016 modules in a Windows 7 system.

1. Visit the website for Office 365 Home


Visit the site with the only Office 365 edition that currently offers a free trial:
https://products.office.com/en-us/compare-microsoft-office-products

Step1

2. Request free trial


Click the "Try for free" button.

Step2aClick the "Try 1-month free" button.

Step2b

3. Sign into your Microsoft account


Enter your email or phone for your Microsoft account, your password, and click the "Sign in" button.

Step3

4. Go through the payment process


Even though it is a free trial, you must provide a payment method and go through the payment process. So be prepared with a credit/debit card or a bank account or PayPal. If you are unwilling to provide a payment method, you cannot get the free trial.

Step4

5. Go through the install process

0
 
LVL 7

Expert Comment

by:Yashwant Vishwakarma
Thank You for sharing Joe :)
0
 
LVL 55

Author Comment

by:Joe Winograd, EE MVE 2015&2016
You're welcome, Yashwant. I'm glad you like it! Regards, Joe
0
How to delete the Recently Browsed folder list in Microsoft Office Picture Manager
Microsoft Office Picture Manager has a Picture Shortcuts pane that shows a list with the Recently Browsed folders. While creating my video Micro Tutorial here at Experts Exchange showing How to Install Microsoft Office Picture Manager in Office 2013, I discovered that Picture Manager itself does not provide the capability to delete items from the Recently Browsed folder list or to delete the list in its entirety. Fortunately, there's an easy way to do it outside of Picture Manager. This video Micro Tutorial explains the method.

1. Locate the OIScatalog.cag file


Open Windows/File Explorer or whatever file manager you use and navigate to this file:

c:\Users\<username>\AppData\Local\Microsoft\OIS\OIScatalog.cag

<username> is the user name, such as Joe in the screenshot below.

Step1

2. Exit Picture Manager and open the OIScatalog.cag file


Close all instances of Picture Manager that are running and then open the OIScatalog.cag file in Notepad or whatever text editor you use.

Step2

3. Delete lines


Delete the lines containing the folders that you want to be removed from the Recently Browsed folder list and Save the OIScatalog.cag file.

Step3

4. Run Picture Manager


Run Picture Manager to verify that the folders have been removed from the Recently Browsed list.

Step4

5. Optional test — delete entire list



Close all instances of Picture Manager that are running and then delete the OIScatalog.cag file. Run Picture Manager to verify that the entire Recently Browsed folder list has been removed.

Step5
That's it! If you find this video to be helpful, please click the thumbs-up icon below. Thank you for watching!
2
How to Install Microsoft Office Picture Manager in Office 2013
Microsoft Office Picture Manager is not included in Office 2013. This comes as quite a surprise to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This video explains how to correct this serious omission by the folks in Redmond and install (for free!) Microsoft Office Picture Manager 2010, which plays very nicely with Office 2013. This video Micro Tutorial is fully documented in my Experts Exchange article, How to Install Microsoft Office Picture Manager in Office 2013.

1. Determine the bit-level of your Office 2013.


Open any Word document (a new, blank one is fine).

To see if you have the 32-bit or 64-bit version of Office 2013, click the File menu, then Account, then About Word.

Step1a
Step1b

2. Download the Microsoft SharePoint Designer.


Download the matching bit-level for your Office 2013 from one of these links:

32-bit
http://www.microsoft.com/en-us/download/details.aspx?id=16573

64-bit
http://www.microsoft.com/en-us/download/details.aspx?id=24309

Step2

3. Run the downloaded SharePoint installer.


Using Windows/File Explorer (or whatever file manager you prefer), execute the downloaded installer and on the opening screen click the Customize button.

Step3

4. Mark all three program sections as Not Available.


Click the drop-down on Microsoft SharePoint Designer and select Not Available.

Click the drop-down on Office Shared Features and select Not Available.

Click the drop-down on Office Tools and select Not Available.

Step4a
Step4b

5. Select Picture Manager to install.


Click the plus sign for Office Tools to expand it.

Click the drop-down on Microsoft Office Picture Manager and select
10
 

Expert Comment

by:pokercrazy
Thank you! The changes to Office 2013 are not the best. I appreciate you putting this together.
Have a good day
0
 
LVL 55

Author Comment

by:Joe Winograd, EE MVE 2015&2016
Hi pokercrazy,
You're welcome! I'm glad you found it helpful. If you wouldn't mind clicking the thumbs-up button under the video window, I'd really appreciate it. You have a nice day, too. Regards, Joe
0
Adding an Experts Exchange site search to the Firefox browser
How to create a custom search shortcut to site-search Experts Exchange using Google in the Firefox browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site.

1. Launch your Bookmark Menu

Press 'Ctrl + Shft + B' (Windows) or 'Apple Key + B' (Mac) in Firefox to launch the Bookmark Menu

2. Create a new bookmark

In the Bookmark Library, right click on "Bookmarks Menu", and select "New Bookmark"

3. Fill out your bookmark fields

We'll use the following info.

Name - Search Experts Exchange (This name can be anything you want)
Location: https://www.google.com/#q=%s+site:experts-exchange.com (the %s acting as a dynamic replaceable keyword)
Keyword -  ee (This keyword will be what triggers the custom search and can be anything you'd like)

4. Add the bookmark

5. Try your new custom search

Type "ee" in your address bar, followed by your search terms. All of your results should now be from Experts Exchange.
6
Adding an Experts Exchange site search to the Chrome browser
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site.

1. Launch the Search Engine Menu

In chrome, via your address bar go to:
chrome://settings/searchEngines

2. Add a New Search Engine

Scroll to the bottom and "Add a new search engine" using the following values:
Name - Search Experts Exchange (This name can be anything you want)
Keyword - ee (This keyword will be what triggers the custom search)
URL - https://www.google.com/#q=%s+site:experts-exchange.com  (Site search operator URL with %s acting as a dynamic replaceable keyword)

3. Save the New Search Engine

Press Enter and exit out of your settings area.

4. Try your new custom search

Type "ee" in your address bar, followed by your search terms. All of your results should now be from Experts Exchange.
13
 

Expert Comment

by:ermooney
This doesn't work for me because since I live in Japan, I am always taken to google.co.jp rather than google.com. Typing ee pulls up sites with ee in their names or content.  That's OK.  If I type in experts exchange, I am taken to a page where experts exchange is among the search results.  I click on the URL, log in and then do my search.
0
 
LVL 18

Author Comment

by:Lucas Bishop
@ermooney, some feedback regarding your comments:

This doesn't work for me because since I live in Japan, I am always taken to google.co.jp rather than google.com

One way to work around this is to force English language and US based results with the following additional operators:
&lr=lang_en&cr=countryUS

Open in new window


So when you are setting up the custom search engine, you would use the following URL:
https://www.google.com/#q=%s+site:experts-exchange.com&lr=lang_en&cr=countryUS

Open in new window


Typing ee pulls up sites with ee in their names or content.
If you've completed the "Add a Search Engine" (Step 2 in instructions above),  to trigger this dynamic search with "ee" you will type "ee" into the browser address bar and then press the space bar (not the enter key). This will trigger the custom search engine to become active.

Is it only applicable to the Chrome browser on PCs?
It's only applicable to Chrome desktop browsers. Currently the mobile OS doesn't allow the creation of custom search engines.
0
Building an interactive eFuture classroom
Building an interactive eFuture classroom

Watch and learn how ATEN provided a total control system solution including seamless switching matrix switch, HDBaseT extenders, PDU, lighting control to build an interactive eFuture classroom.

Making a Flowchart with XMind Plus
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when you download it from the site, but to export the file to anything other than HTML, you would have to purchase an upgrade.
2
 
LVL 17

Expert Comment

by:Kyle Santos
Great job, Arianna!!!
0
Enrolling an Employee in Time Q Plus
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
1
Building Probability Models in Excel Part 7: Modeling a Correlated Two-Fund Investment
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a Monte Carlo simulation using the simulated returns.

1. Modeling a Simple Investment: Type in the means and standard deviations of the return of both of the funds, along with the correlation coefficient

2. Select B7:C7 and type =CORAND($B$5), then press Command+Shift+Enter

3. Copy down to row 16

4. Label the returns of fund 1 and fund 2

5. Enter =EXP(NORMINV(B7,$B$2,$B$3)) into cell E7 and copy down to E16

6. Enter =EXP(NORMINV(C7,$C$2,$C$3)) into cell F7 and copy down to F16

7. Label the $1 investment into fund 1 and fund 2

8. Enter =H6*E7 into cell H7 and =I6*F7 into cell I7 then copy both down to row 16

9. Enter =H16 into cell B25 and =I16 into cell C25

10. Select A25:C524 then click ToolsSimToolsSimulation Table


0
 

Expert Comment

by:Richard Shaw
In the SIM table (A25: A524) -- what is the meaning and use of the column A data?
0
Building Probability Models in Excel Part 6: Investment Modeling Using a Log-Normal Distritribution
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calculate the 5% Value at Risk of the investment from the results.

1. Modeling a Simple Investment: Type in the mean and standard deviation of possible returns

2. Label column A “Return” in cell A5

3. Enter =EXP(NORMINV(RAND(),$B$2,$B$3) into cell A6 and copy down to cell A15

4. Enter 1 into cell B5 to represent $1 invested

5. Enter =B5*A6 into cell B6 and copy down to cell B15

6. Enter =B15 into cell B20

7. Select A20:B519

8. Click Tools > SimTools > Simulation Table

9. Enter 1000 into cell B17 and label “Initial”

10. Enter =$B$17*B21 into cell C21 and copy down to cell C519

11. Enter =PERCENTILE(B20:B519,0.05) into cell B18 and label 5% VaR

0
Building Probability Models in Excel Part 5: Modeling an Investment Using Discrete Random Variables
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over 500 iterations.

1. Modeling a Simple Investment: Type in the amount invested, the possible returns, and the corresponding probabilities

2. Label column A and B “Return” and “Wealth,” respectively in A11 and B10

3. Enter =DISCRINV(RAND(),$B$2:$B$7,$A$2:$A$7) into cell A12 and copy down to cell A21

4. Enter =D2 into cell B11

5. Enter =B11*A12 into cell B12 and copy down to cell B21

6. Create a Monte Carlo Simulation: Enter =B21 into cell B23

7. Enter =B21 into cell B23

8. Click Tools > SimTools > Simulation Table

0
Building Probability Models in Excel Part 4: Discrete Random Variables
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabilities and outcomes with the =STDEVPR command.

1. Discrete Random Variables: Type in the set of outcomes and corresponding probabilities in cells A2:B6

2. Enter =SUM(B2:B6) into cell B7

3. Enter =DISCRINV(RAND(),A2:A6,B2:B6) into cell B9 and label “Profit”

4. Enter =B9 into cell B14

5. Select cells A14:B213

6. Click Tools > SimTools > Simulation Table

7. Enter =AVERAGE(B14:B213) into cell B11 and label “Mean”

8. Enter =STDEV(B14:B213) into cell B12 and label “StDev”

9. Enter =STDEVPR(A2:A6,B2:B6) into cell C12

0
Building Probability Models in Excel Part 3: Monte Carlo Simulations and Conditional Probability
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the
Monte Carlo simulation.

1. Download and Install SIMTOOLS: Search Roger Myerson on Google, and click on the first link

2. Follow the links to find the SIMTOOLS download and download it

3. Go to Excel add-ins, click Select and find the file

4. Check the square to the left of SIMTOOLS.XLAM

5. Click Select to install

6. Use SIMTOOLS to generate a Monte Carlo Simulation: Open the spreadsheet from the last tutorial that simulates 30 sales calls

7. Enter =IF(C2=E2,1,0) into cell B33 and enter =C4 into cell C33

8. Enter target number of sales =12 into cell C26

9. Select A33:C232

10. Click Tools > SimTools > Simulation Table

11. Calculate the Conditional Probability: Enter =IF(C34=$C$26,B34,”..”) into D34 and copy down to D232

12. Enter =SUM(D34:D232) into Cell F28 and label “# High Skill”

13. Enter =COUNT(D34:D232) into Cell F29 and label “Total Target”

14. Enter =F28/F29 into Cell F31


1
Building Probability Models in Excel Part 2: Simulating Sales Calls
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels.

1. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill level”

2. Enter =IF(RAND()<$C$2,1,0) into cell A2 and copy to A31

3. Enter =SUM(A2:A31) into cell C4

4. Simulating Calls With Two Different Skill Levels: Enter =2/3 into cell E2 for high skill and =1/3 into cell F2 for low skill

5. Enter =IF(RAND()<0.5, E2, F2) into cell C2

0
 

Expert Comment

by:ankitha reddy
nice one.. thanks for the video
0
Working with Templates
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
0
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Using Word Count
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
1
Using Mail Merge to Create Envelopes and Labels
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses.

1. Navigate to the “Start Mail Merge” button in the Mailings tab

2. Follow the step-by-step process until asked to find the address document

3. Locate the file and begin creating envelopes/labels

0
Creating Footnotes
This video shows the viewer how to set up and create Footnotes in their document.

1. Click on the References tab

2. Select "Insert Footnote"

3. Type in desired text

0

Office / Productivity

Office and productivity software is virtually any application people use to "produce" information. That includes almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.