Skip to main content
Category

Microsoft Office 365

Office 365: Take Private Notes in Microsoft Teams

By Microsoft Office 365 2 Comments

Over the summer, Microsoft added a feature that makes it so easy to take private notes in the OneNote or Wiki applications within Teams.  I think this is really great feature, because there are tons of collaboration options within Teams and ways to share information, but there are just as many times in the “real world” where I want to take notes for my own purposes. Keep reading to find out how to take private notes in Teams! Read More

Office 365: Create a Geographical Chart in Excel

By Microsoft Office 365 No Comments

Excel’s charting capabilities are well-known at a basic level—everyone knows that they can create pie, bar, or line charts/graphs with their Excel data.  However, Excel also allows you to create geographical charts that automatically plot data on a map.  The maps use a “fill” function to show data, so this best shows numerical data by County/State/Country etc. You can plot data by:

Country/Region
State/Province
County
Postal Code
      
Read More

Office 365: Update the Offline Global Address List in Outlook

By Microsoft Office 365 One Comment

One of the Address Books that Outlook keeps is the Global Address List, which is a comprehensive list of every “mailbox-enabled or mail-enabled object in an Active Directory forest that has Exchange installed” (Source: Microsoft).

Microsoft also keeps an offline version of this address list, and this can be accessed when you are not connected to Exchange.  You’ll want to keep this address list, or address book, updated in the event that you need it.  Read More

Office 365: Use the Help Box to Find What you Need

By Microsoft Office 365 No Comments

Microsoft implemented an interactive and contextual search box in many of its applications some time ago. This feature is often overlooked, but can be a huge help in Office 365 applications like Word and Excel, among others.  It actually gives you real menu options as answers! This is far superior to the old “help” button/window where it just searched Bing. Read More

Office 365: Use INDEX MATCH instead of VLOOKUP

By Microsoft Office 365 No Comments

I recently completed a massive project involving data normalization, and this is the second of two tips that really helped me throughout the process.  You may be familiar with VLOOKUP, a function in Excel that allows you to, well, look up values from a separate table. There are some constraints with it, though, for example, you must name a single number to indicate the column that will be returning values.  INDEX MATCH combines two functions in Excel and allows you to actually select the column you want to return values from manually with your mouse. To use INDEX MATCH, keep reading! Read More

Office 365: Deduplicate a List of Values in Excel

By Microsoft Office 365 No Comments

I recently completed a massive project involving data normalization, and this is one of two tips that really helped me throughout the process.  For this particular task, removing duplicates was helpful for a sub-import of new accounts (and finding the unique accounts in a list of 140,000 records!) as well as determining the “status reason” values that were being used in this massive file.  If you need to normalize or massage data, or just need to evaluate a list of values without duplicates, keep on reading! Read More

Skip to content