Any Excel user who considers themselves a “power user” cannot make such a statement with a straight face without knowing how to use VLOOKUP functions. Of all of the ways to retrieve information, the VLOOKUP function is without debate the most popular means of looking up and returning information from an Excel list. It’s not […]
Create a Video in PowerPoint 2016
If you have ever been tasked with creating a video to demonstrate come process in an application, like creating pivot tables in Excel or performing a mail merge in Word, you probably had to spend a bit of money on some screen capturing software. There are many great programs on the market designed specifically for […]
Office 2016–New Chart Types
As a seasoned producer of charts, you have probably wondered why Microsoft has not included certain type of charts that have previously only been available via third-party add-on programs. Microsoft has heard your calls and added some new and exciting charts to the Office 2016 charting engine. These charts type are not just available in […]
Apply Two Different Number Formats to a Single Field (Excel Pivot Tables)
There comes a time in every Excel Power User’s life when they must deal with mixed content in a single field. Examine the following table: The Value field (column E) contains a mixture of sale amounts (values as decimals) and discount rates (percentages.) If a pivot table is constructed using this data, it can take […]
Missing Resources in Microsoft Project Resource Pools
If you work with Microsoft Project and have ever leveraged the power of Resource Pools across multiple projects, you may have encountered a strange behavior when assigning those resources. When you share resources between a Resource Pool file (a dummy project file that typically has no tasks but is merely a container for holding resources) […]