Megan Hagedorn No Comments

Office 365: Create a Geographical Chart in Excel

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

Megan Hagedorn No Comments

Office 365: Update the Offline Global Address List in Outlook

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

Megan Hagedorn No Comments

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

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

Megan Hagedorn No Comments

Office 365: Use INDEX MATCH instead of VLOOKUP

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

Megan Hagedorn No Comments

Office 365: Deduplicate a List of Values in Excel

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

Megan Hagedorn No Comments

Office 365: Install Software from the Office 365 Portal

You can manage your software installations from the Office 365 Portal. This can be really helpful if, for example, you just got a new computer and it’s missing some programs, or you just want to see if there are any other programs that you have access to but don’t have installed.  To access the available software for installation, keep reading below! Read more

Megan Hagedorn No Comments

Office 365: Change your Office 365 Password

Maybe your current password is too hard to type, maybe it’s expiring soon—but for whatever reason, if you need to change your Office 365 password, keep reading! If your organization allows it, you can change your Office 365 Password from the Office 365 Portal. Please note that this will affect OneDrive, Skype for Business, Outlook, etc.
Read more

Megan Hagedorn No Comments

Office 365: Determine how your Org Upgrades from Skype to Teams

Don’t forget! Skype for Business is being replaced with Microsoft Teams over time.  Please see the following Microsoft articles for more information:

Understand Coexistence and Upgrade Journey for Skype for Business and Teams

Journey from Skype for Business to Microsoft Teams

FAQ – Journey from Skype for Business to Microsoft Teams

You can specify the “Coexistence Mode” for Teams and S4B for your organization by accessing the Teams & Skype for Business Admin Center (more on that in the previous blog post)–or access it directly by going to admin.teams.microsoft.com.

Read more