Excel Pivot Tables Filter by Values
If you’ve ever used Pivot Tables in Excel, you no doubt have discovered the wonders of filtering.  The ability to filter row or column items can be extremely helpful when you don’t wish to analyze all of the items in the driving data set. But what...
Excel Lookup with Dynamic Input
VLOOKUP is great for returning information from a database, but one of the limitations is that the return information is static. What if the user wishes to look for certain data one day but different data another day?  This would require either two different sets of...
Automatically Refresh Excel Pivot Tables
Excel PivotTables are one of the greatest tools in the spreadsheet user’s toolkit. However, there is one tiny bit of functionality that appears to be missing: the ability of pivot tables to automatically update when information in the source data changes. Most user’s see this as...
Hide Drives in Windows Explorer via Registry Setting
With so many hardware devices (like printers, external hard drive enclosures, and home network devices) equipped with USB ports, it's likely that you've collected an array of advertised drives in Windows Explorer that are not actually accessible unless something is connected to them.  Perhaps you have...
Preview Fonts in Photoshop
Selecting a font in most applications has come a long way over the years.  In the old days you had to select each font separately from a drop down and decide if it was the right font for the job.  Then along came the ability to sample...
Office 2013 – Recover Unsaved Documents
Admit it; you’ve done this more than once.  You open an Office application like Word or Excel and type out your next great novel or number-crunching masterpiece.  Then, in a state of haste, you start closing windows and accidentally close the one window you intended to...
Power Pivot KPI Icons Not Changing
A common complaint about Power Pivot KPI icons is that it seems no matter which set of icons you select, it only shows the standard Red-Yellow-Green circle icons. The reason for this is that the icons are intended to be used with Power View.  The only...
QlikView “Allocated Memory Exceeded” Error – An Easy Check
If you have worked with QlikView and encountered the error message “Allocated Memory Exceeded”, there could be numerous reasons for this message.  You may have a quite a quest in store for yourself to figure out what the issue is.  But there’s quick and easy thing...
Rename Files Fast with the Tab Key
If you scan documents from a network scanner (like the giant printer down the hall) and have the scan sent to your email, you are probably less than thrilled with the name that the scanner gives the file.  The name is usually something generic and uninformative...
Convert a PowerPoint Presentation to Video
This tutorial applies to PowerPoint 2013, but several earlier versions of PowerPoint possess the same abilities.  The exact steps and options will vary slightly from version to version. Showing your PowerPoint masterpiece can be thrilling, but what if you want to reach a wider audience?  How...
QlikView 11 Script Editor Color Codes
Have you ever been looking at your scripts in QlikView and thought to yourself, “What do all these different colors represent?”  Well, puzzle yourself no further.  I am here to explain what all of these colors are trying to say and then show you how to...
Microsoft Excel – Understanding Excel Functions with Help
Admit it, you’ve used Excel functions without any idea how they work.  Someone said, “Click here for this.  Click here for that.” You’ve dutifully followed orders, blindly clicking on cells with no real clue as to why. It’s time to lift the veil of mystery and...
Microsoft Word – Replace Multiple Spaces with a Tab Character
Let’s set the stage: You receive a file from your co-worker where data has been arranged into multiple columns to create a table-like format. Upon careful examination, you notice that the column alignment is just a little bit off.  To discover the cause you press your...
Microsoft Excel – Convert Answers to Values FAST!
If you are new to Excel, you no doubt have already discovered the need to take a series of numbers created by formulas and convert them to fixed values.  In other words, replace the questions with the answers.  With no idea how to accomplish this, beginners...
Selecting Objects in Word with the Selection Pane
If you have ever inserted an object (like a picture, shape, or clipart) into a Word document and then made the unfortunate move where you pushed it behind your text... ...and now it seems forever trapped behind a sea of impenetrable words.  No matter how hard...
Excel Comma Style Keyboard Shortcut
If you are an Excel user who LOVES working from the keyboard as much as possible (i.e. data entry, navigation, feature activation, etc...) then you simply MUST know of this little gem of a keyboard shortcut. Although we have no scientific data to back up this...
Missing Resources when Using 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...
PowerPivot Tutorial
http://youtu.be/AHJIcqSFhzQ In this Microsoft Excel PowerPivot tutorial, you'll see how to use Microsoft Excel PowerPivot to import data from multiple data sources, link the data based on common fields and finally create a PivotTable and PivotChart to quickly analyze the data. This content is from our...
Free Tutorial: How to Format Cells in Microsoft Excel using the Format Painter Tool
http://youtu.be/kl7oBI2qn_Y?list=PLwLw21RsChcuPF4HitxlMXOaJtXCtMwIx In this Microsoft Excel tutorial, you'll see how to format cells in Microsoft Excel using the Format Painter tool. Learn more about Microsoft Excel in our Microsoft Excel Training courses.
Microsoft Excel Keyboard Shortcuts
Keyboard shortcuts may seem like a throwback to the olden days, but they can seriously ramp up your productivity once you start using them. Especially for tasks you do on a repeated basis. Here are some of the most common Microsoft Excel keyboard shortcuts. F7 -...