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 column headers and that there are no blank columns or
Removing Duplicates in Excel Read Post »
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 do it quickly, can save us some time, when we
Filter Data with Header Drop-Down Filters in Excel Read Post »
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 drop many documents into a library at the same time.
How to Use a Quick Edit Menu in SharePoint Read Post »
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. This mistake can lead directly to a failed implementation- the
SharePoint Metadata Read Post »
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 a SharePoint library. If your company recently updated from an
Different Ways to Upload Documents in SharePoint Read Post »
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 the files, but in most cases, linking too many files
Adding Subprojects in Microsoft Project Read Post »
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 you are instantly stresses out, before you get anything done.
Outlook Today Overview Read Post »
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 little different than other rounding functions, as you reference a
New Excel 2019 Function: MROUND Read Post »
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 we can make a slide more appealing to the senses,
Using Eyedropper to Match Colors in PowerPoint Read Post »
When working with large chunks of data, we sometimes need to sort the data to figure out where we need to focus our attention. This could mean that we need to quickly sort our data by more than one column,
Sorting by Multiple Columns in Excel Read Post »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
