How Live Online Classes Work
Watch A Short Video Overview of Instructor-Led Online Classes

Microsoft Silver Learning Partner
microsoft-silver-learning-partner
What Students are Saying...

This was a very thorough class and the instructor was extremely knowledgeable and easy to follow. He was able to answer all my questions and provide relevant examples. I would highly recommend.

Course: Microsoft Project 2010 Training Student: Ellen L., Advanced Testing Laboratory

Dan was a great instructor.He was very personable and knowledgeable. His examples of real world applications of Javascript tied everything together for me.

Course: Javascript Training Student: Jim J., R.W. Baird

This was an excellent learning experience. I started the class with some knowledge of the content, so the pace worked very well for me.

Course: T-SQL with SQL Server 2008 Training Student: Debbie M., Pharmacist Mutual Insurance

The instructor was very knowledgeable and pleasant to work with – Thank You.

Course: Adobe InDesign CS5 Training Student: Kathy G., Choctaw Nation Health Services

Enjoyed the class. Rodney was accommodating, yet stayed on task. Gave plenty of time to ask questions to any level of detail we wanted.

Course: Microsoft Project 2003 Training Student:: David C., Siemens Energy, Inc.

Jen was one of the best instructors I have ever worked with in my past 45 years.

Course: Microsoft Access 2010 Advanced Training Student: Robert C., TNS Global

Jennifer was absolutely fantastic! She was a consummate professional, and I would highly recommend her to anyone that is interested in this course or any of the others that she delivers. Thank you, Jennifer!

Course: Microsoft PowerPivot 2013 Training Student: Jim M., The Bill and Melinda Gates Foundation

Free Demonstration
News and Discounts
Subscribe to receive news about our new courses and valuable training discounts!
 
First Name
Last Name
Email
   

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 leave open.  One second later you realize, this was the one windows you shouldn’t have closed.  All is lost… or is it?

Read the rest of this entry »

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.

PP1

Read the rest of this entry »

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 to check that may just be the reason for your plight.

If you have been writing expressions, one of the primary culplits for generating this memory error is a simple syntax error with your expression.

Here’s just such a scenerio:  You have created a fantastic pie chart and wish to add some intelligence to the chart.

Read the rest of this entry »

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 like “Scan0001.pdf” or a combination of the date and the time like “07182015-100855.pdf”.

Tab1

Read the rest of this entry »

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 can we take our presentation from the confines of the boardroom (or is that bored room?) and set it free so the world can bask in its glory?

Very easily; we convert it into a video.

In this tutorial, we discover a feature introduced in PowerPoint 2010 which allows you to take your slides and encode them to a video that can be loaded to your corporate network for on-demand viewing through an intranet portal, or posted to a more globally accessible site such as YouTube.

Read the rest of this entry »

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?” 

QV1

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 change them if you have your own color preferences.

Read the rest of this entry »

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 understand why these functions are so demanding of such data.

Here is just one of many options for understanding function logic:

This first part has nothing to do with obtaining function information, but it’s a great time saving trick.  If you like to type your functions directly in the cell; press your EQUAL button [=] and start typing the first few letters of the function name.  As you type, Excel will begin to AutoComplete the function’s name. Read the rest of this entry »

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.

word-replace-spaces-1

Upon careful examination, you notice that the column alignment is just a little bit off.  To discover the cause you press your Show /Hide button in Word to reveal the formatting codes. Read the rest of this entry »

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 usually spend great stretches of time retyping the numbers into the answer cells to make them “permanent”.

Eventually, someone who feels your pain turns you on to the technique of highlighting all of your formula cells, clicking Copy, then in the same cells clicking Paste Special…, Paste Link.

You could now not be more ecstatic.  “This is going to save me sooooo much time”, you say to yourself.

Well, guess what.  There’s an even FASTER way to accomplish this task.  Try this out: Read the rest of this entry »

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!