When we are working with many rows of data, it would be time consuming to scroll through all the data to see if there are duplicate rows of information. Luckily for us, Excel has a built-in duplicate remover. To use
Removing Duplicate Rows of Information in Excel Read Post »
If your Excel workbook uses many formulas to display report data for managers or supervisors, and you need to give them only the report worksheet, you can copy just the values of that worksheet and leave all the formulas behind
Copy and Paste Only Values in Excel Read Post »
Customizing a bullet point can be fun and useful, bringing more attention to important information. As with anything new, using this method to bring attention to information takes a little time to get others in sync with you. However, once
Custom Bullet Points in Word Read Post »
By default, in Excel, when you press the Enter key, you will move down to the cell below. When you need to copy a formula down through a number of cells, this is a little bit of a pain; you
Enter Formula and Stay in the Same Cell in Excel Read Post »
So many people use Microsoft Excel daily that it would seem to be the one application everyone understands. It isn’t. While most people use Excel daily, not everyone knows how to do much beyond the basics, and no one knows
Take Excel to the Next Level Read Post »
Searching in SharePoint can be a powerful tool, if you know what you are doing. Fortunately for us, search in SharePoint is very similar to searching in most online search engines. Let’s take a look at a couple of the
Search Helpers in SharePoint Read Post »
Allowing everyone to have full access to a database you created can bring on many issues. In most cases, too many queries and reports get created, which makes it hard at some point for users to find what they are
Ribbon and Navigation Pane Restrictions in Access Read Post »
Microsoft Project is a very robust program that allows you to view different views simultaneously, but one of the most popular added views is the Timeline. Typically, the timeline is added above whatever view is already showing, which is typically
MS Project: Add Tasks to Timeline Read Post »
When writing queries in Access, it is important to know where to place the criteria for the queries, as placing the criteria in the wrong place can drastically change the outcome. Although there are many ways to write criteria in
Access: Queries – AND vs. OR Read Post »
Construction and software development are two areas that have employed Project Managers for decades. However, many other areas employ them as well. NASA and Space-X both employ many PMs, but so do organizations as diverse as the Secret Service, IBM,
Project Management: Not just for bridge-builders and software coding. Read Post »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
