Skip to main content
Category

Microsoft Office 365

Office 365: Use Conditional Formatting In Excel

By Microsoft Office 365 No Comments

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

Microsoft 365: Convert a Table to a Data Range

By Microsoft Office 365 No Comments

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

Office 365: Explore the Excel Function Library

By Microsoft Office 365 No Comments

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 365: Open Online Office Document in the Desktop App

By Microsoft Office 365 No Comments

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

Dynamics 365: Share Important Flows for Redundancy

By Microsoft Dynamics CRM, Microsoft Office 365 No Comments

If you happen to own a Flow important to your organization, I highly recommend sharing the Flow with an additional user in the event that you leave the company or lose access to your account.  While it will be possible to recover any Flows “lost” this way, it can save a few headaches and extra clicks by sharing the Flow with another user.  This is also helpful in the event that your Flow fails to run or encounters some other error — Power Automate will email the owners of the Flow with the issue details. The more people that receive this email, the more likely it is that the issue will be addressed quickly! Read More

Skip to content