Recently, I posted how one can use the Microsoft Excel WEEKDAY function to help clean-up and provide a tabular report on monthly Office 365 SharePoint Usage. This post is a follow-up where I’ll demonstrate how you actually create the visual… Read More ›
Microsoft Excel has numerous functions and features that are used to validate data and apply conditional formatting to cells. Below we’ll see how to combine these features along with the CODE, ISNUMBER, and LEN functions to make quick work of… Read More ›
Most users of Microsoft Excel know that the product supports templates. There are the many out-of-the-box templates you are presented with when you first launch Excel, and there is the “Save as Template” XLTX options through which you can save… Read More ›
Power BI Fitness and Meal Planning with Excel This post demonstrates a Power BI Fitness and Meal planning solution based on Excel data. Power BI is an excellent tool for visualizing important data about the food we consume and provides… Read More ›
Not too long ago, I accidentally hid the “Task Name” column in a Microsoft Project plan. It wasn’t as obvious as I thought it would be to restore or reinsert that critical column. Here are some options for you if… Read More ›
At the end of every quarter, I deliver a usage report which summarizes the historical number of users who visited a page in the Office 365 SharePoint Intranet. The metrics data and graphics are created by exporting the Office 365… Read More ›
Both professionals and hobbyists depend on Microsoft Excel for scheduling and resource planning, and if that’s the case for you too, then the WORKDAY and WORKDAY.INTL formulas are two essential tools to have in your belt of Excel tools. Both… Read More ›
If you read the following Microsoft Office support article, you’ll find documentation that outlines how users can take advantage of the “Create Site” functionality on their SharePoint home page: https://support.office.com/en-us/article/create-a-team-site-in-sharepoint-online-ef10c1e7-15f3-42a3-98aa-b5972711777d In case the link is no longer active when you… Read More ›
Many day-to-day activities for the Machine Technology program are now being manged using out-of-the-box features in SharePoint and Office 365 as we’ll see below with a quiz built using Microsoft Forms. Those features are complemented by custom page layouts and… Read More ›
This is a brief post regarding a new update to the SharePoint Project Task Tracker app. The update was deployed to fix a bug wherein all content on the Reports tab was collapsed when clicking the “Project Views” section header…. Read More ›