Category Archives: %s

3 Steps to empty your Inbox (and keep it that way)

For the past 10 years I’ve lived with a completely empty inbox, and it has been wonderful. I don’t sift through hundreds of unread emails looking for a request I forgot to respond to. I don’t juggle multiple to-do lists. And I don’t end up with too many meetings and Read More

5 Things to ALWAYS use in your spreadsheets

I’m a big believer that there’s a right tool for every job, and it’s a mistake to force the wrong solution when it doesn’t fit. However in the world of spreadsheet modeling, there are a few tricks that you should always employ. 1. PARSE FORMULAS In Excel, you can split Read More

A quick trick to highlight alternating rows in Excel

Highlighting alternating rows is a great way to make your tables easier to read. It allows you to easily follow each row with you eyes rather than having to trace each line with your finger or use a ruler. Here is a quick and easy way to do this without Read More

Excel Table Formatting: Data Organization

For large expanding sets of data, use Excel Tables to organize your data and streamline reporting.  

Excel Basics: Filtering and Sorting Data

When you’re working with a large data set it can be helpful to filter out the unnecessary items, so you can focus on the important ones. Today we will show you how to filter a list of data, format it, and sort it. In the example below, we have a Read More

Excel Keyboard Shortcuts: Auto Filtering Using the Keyboard

When your auto filter is turned on, you don’t have to reach for the mouse! Here’s how to navigate the filter menu using your keyboard.  

More Excel Keyboard Shortcuts!

Everyone loves Excel keyboard shortcuts! Here a few tips to help you become fast and furious with your spreadsheets.

Excel Keyboard Shortcuts: 60 Seconds a Days

  As the N.B.A. season reached its midpoint with the All-Star game, one of the league’s all-time greatest players is quietly making his farewell tour.  Kobe Bryant of the Los Angeles Lakers has decided to retire after 20 seasons in the league, 5 N.B.A. championships, 18-time All-Star appearances and 2 Read More

Online training is now available!

We are proud to announce the release of online video versions of our live training programs. Soon, we will offer our full selection of standard course offerings, but in the meantime, you can peruse the content that is currently available in the Online Training section of the website.

Sample Questions for Excel Expert Certification

These are examples of questions you may find on the Microsoft Office Specialist (MOS) exam 77-888 (Excel 2010 Expert certification). Currently, the exam is 30 questions to be answered in 50 minutes. If you are able to complete the questions at about the speed that I demonstrate in the videos, Read More