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
   

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 task dependencies.

There are 4 different types of task dependency:

  • Finish-to-Start (FS): The finish date of one task drives the start date of another.
  • Start-to-Start (SS): The start date of one task drives the start date of another.
  • Finish-to-Finish (FF): The finish date of one task drives the finish date of another.
  • Start-to-Finish (SF): The start date of one task drives the finish date of another.

Read the rest of this entry »

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.

filter_pivottable_values_1

But what do you do if you wish to filter by the Value-based items?  In other words, the numbers in the “connect the dots” area where row and column choices intersect.  These, on first glance, don’t appear to have sorting and filtering controls available.

filter_pivottable_values_2

Rest assured, they do exist; you just have to dig a bit to find them.

Read the rest of this entry »

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 VLOOKUP functions or the functions would need to be reprogrammed.

In the database below, the user would wish to return address information in one scenario, but return financial information in another scenario.

Suppose there are times when the user requires a mixture of the two; that would require a third set of VLOOKUP functions. This could become an ever evolving set of work.

Read the rest of this entry »

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 a glaring lack of functionality. There is, however a very good reason why pivot tables do not automatically update.

Read the rest of this entry »

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 setup a mirrored drive for backup purposes that you want to be “out of sight; out of mind”.

HideDrives 1

Hiding these devices is quite simple… provided you can do a bit of counting in binary.

Read the rest of this entry »

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 fonts by hovering your mouse pointer over the list.  What a time saver.

But not in Photoshop! (Pssst!  You actually can, but don’t tell anyone.  It’ll be our little secret.)

Read the rest of this entry »

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 »