Archive for Managed IT

Financial formulas for Microsoft Excel can improve your analysis of your investments and loans, making them useful in personal and professional finance. Become a better financial analyst with these formulas.

Excel is a powerful tool, but users can make common Excel mistakes leading to formula errors, incorrect data, and other issues. Learning how to avoid errors in Excel makes spreadsheets more accurate and reliable.

The LOOKUP function is a type of reference function in Excel. It looks up a value in a range of one column or row (also called a vector) and returns the corresponding value from another one-column or -row range. Its syntax is:

Excel errors popping up and frustrating your operations? Resolve them faster by learning about common errors in Excel, their meanings, and how to fix them!

Manually counting workdays for benefit accruals or other purposes can be tedious and error-prone. Discover how Excel workday functions simplify it!

Let’s go over a vulnerability that recently occurred in Microsoft Azure along with some helpful security measures you can take when using the platform.

Office Scripts add automation to Excel worksheets in OneDrive, SharePoint, and the desktop version. Learn about adding a button to Excel sheets

Finding ways to cut spending in your technology department — or really any department, for that matter — is more than ideal, especially when you’re on a tight IT budget.

Outlook displays a preview of emails so you can read the first few lines before opening them. Learn how to change the email preview length in Outlook.

Power Automate to generate automated workflows between apps and services to facilitate data collection, file synchronization, and notifications.

Heat maps turn data into visualizations, making it easier to interpret. Learn how to make a heat map in Excel and the various uses for heat maps.