Time to Get Back to School
Summer is winding down, and the Back to School sales are in full force. It is time for students to sharpen their pencils and respond to the school-bell call to…
Removing Duplicates in Excel
Removing duplicate information can be both helpful and intimidating when working with many line items in Excel. Follow these steps to make the process easy : Ensure your data has…
Filter Data with Header Drop-Down Filters in Excel
All too often, when we are sent data from someone, it is not presented in the view we would like. Changing the way our data looks, and being able to…
How to Use a Quick Edit Menu in SharePoint
In older versions of SharePoint, uploading multiple documents was not an easy process, whereas the newer versions of SharePoint (2013, 2016 and 365) have the added ability to drag and…
SharePoint Metadata
Many organizations that adopt SharePoint as a document management system simply import the files in their shared drives in one fell swoop, without considering some powerful SharePoint tools, like Metadata.…
Different Ways to Upload Documents in SharePoint
SharePoint is a great way to organize documents - far better than a shared drive - but sometimes it can be a little confusing when trying to upload documents into…
Adding Subprojects in Microsoft Project
Project Managers might need to get lists of tasks for a project from more than one source in order to track everything throughout the project. The project manager could link…
Outlook Today Overview
Opening Outlook can be daunting at times, especially if you are someone who receives one hundred-plus emails every night. All you see is chaos first thing in the morning, and…
New Excel 2019 Function: MROUND
Every new version of Microsoft Excel comes with new or updated functions. The 2019 version of Excel is no exception. One of the new functions is MROUND. MROUND is a…
Using Eyedropper to Match Colors in PowerPoint
While building a PowerPoint presentation, it is common to want certain colors to match within the slide, so that elements of the slide do not look out of place. Anytime…