Microsoft Office 365

We’ve covered conditional formatting a few times before, but I used conditional formatting in a new-to-me way this month and wanted to share.  I was assigning dates to tasks for a project and realized that it would help me if I could at-a-glance determine how soon tasks were due.  Behold, conditional formatting! Keep reading to see how I solved my problem.  By the way – to look at those older posts, check out the links below:

Office 365: Use Conditional Formatting to Automatically Assign Colors to Calendar Items in Outlook

Office 365: The Beauty of Conditional Formatting in Excel

Read More

Tables in Excel are typically helpful and easy to use, but occasionally you can run into formatting issues that just can’t seem to be fixed, like a cell that’s formatted as a percentage but displaying as a decimal.  I typically notice this issue with formatted cells — especially percentages & dates, even cells with data validation — and finally have a workaround: convert the table back to a data range. It even keeps the formatting of the cells, though it’s easy to remove if needed.

Read More

Excel features hundreds of functions, and it’s never too late to learn more about them!  Thankfully, the Function Library is the perfect place to check out more. The Function Library categorizes and lists all available functions.  When you hover over the function name, you’ll see a pop-up giving a brief description, syntax example, and a link to a related help article for the function.  Keep reading to learn more! Read More

Microsoft is rolling out a fresh look & feel to many of its applications, and you can preview it now! Keep reading to learn how to enable the new UI.

Read More

In my opinion, it is surprisingly nonintuitive to find details (chats, files, recordings, etc) from meetings past in Microsoft Teams– especially if they don’t appear on your calendar.  I’ve outlined my current preferred method to find this information below. Read More

While I can’t stand it when a bank website logs me out after 4 minutes of inactivity, I do understand why this is such an important security feature — especially for many organizations in this “work from anywhere” era.  I recently stumbled upon this feature by accident and thought I’d share its whereabouts for any interested admins! Read More

I recently had an Office document shared with me and accessed it via the link in the email notification, which opened the file in the online version of Excel.  I prefer to work in the desktop app, but even I had a heck of a time figuring out how to open the file there rather than the browser! Keep reading to learn how to open an Excel/PowerPoint/Word Online document in the desktop app. Read More

We’ve covered in-line or grid editing Dynamics 365 views previously, but did you know that Sharepoint offers the same feature?  Good news — it’s about as easy to use as it gets.  Read More

One of the newer features in Microsoft Teams is the ability to set an Out of Office message.  With Teams being utilized so heavily for day-to-day communication (and even replacing some emails), it makes so much sense to use this feature when you’re not around. It also syncs to your Outlook calendar and is very easy to set up — keep reading to learn more.

Read More