One very cool feature I recently discovered was the ability to send snippets of code in Microsoft Teams where the formatting is preserved and even enhanced with syntax highlighting, the option to wrap text, and more!
Office 365 subscribers get fairly frequent updates pushed to their systems, but it’s not always clear what functionality has been updated, removed, or added. In this tip, we’ll walk through how to check for updates, how to view what’s new, and how to view the Office 365 roadmap.
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:
Did you know that you can easily reply to all participants in an email with a meeting? This is a great shortcut in Outlook because it automatically grabs all of the participants from the email and copies all prior messages below the meeting information, just as a “normal” reply would. Read more
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
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
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
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
I don’t know about you, but I find the notification sound for Office 365 incredibly annoying. I don’t mind the notifications themselves, but the noise? No thanks! Luckily, you can easily change your notification settings from the Office 365 portal. Read more
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