How to use Pivot Tables in Microsoft Excel
In our recent free webinar, SkillForge instructor Bryon Smedley shows all of the cool things you can do with Pivot Tables in Microsoft Excel. If you're not using them already, you can learn all about them in our Microsoft Excel Pivot Table Training Class! https://youtu.be/KcYSI1cccoc
Making a Font Selection in Photoshop CC 2014 or Later
This isn’t about choosing the perfect font to enhance a brochure or flyer. It is much simpler than that. In most applications today when we want to change the font being used, we make a choice from a long list of fonts installed on our computer....
Photoshop: Flow vs Opacity
When working with some of the drawing tools in Photoshop, you will notice two different adjustment settings in the options bar. The adjustments I am referring to are opacity and flow. Just what are the differences between these two settings? Let’s go back to the days...
What is QlikView? Creating Dashboards from Excel and Other Data Sources using QlikView
https://youtu.be/A_YfJm1yttU In this webinar, you'll see how to create dashboards and data visualizations with data from Excel and other data sources using QlikView. For more on our QlikView Training Courses visit our QlikView Training page.
How to Round Task Durations in Microsoft Project
https://youtu.be/u3QSZYOhMVk In this tutorial, you'll see how to round the duration of a task in Microsoft Project by using a custom field. You'll also see how to use this custom field in all of your projects by adding it to your Global.mpt file.
Understanding Task Dependency Types in Microsoft Project
Dependency Types in Microsoft Project When creating schedules in Microsoft Project the first thing that a Project Manager would typically do is to input the tasks involved in a project. These tasks then need to be linked to show the relationship between them. These links create...
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...