Find Excel Duplicates with Conditional Formatting

In March, I wrote an article about the Remove Duplicates tool in Excel which makes it really easy to remove duplicates row (records) from a list of … [Read more...]

Microsoft Excel Help – Remove Duplicates Tool

Have you even been overwhelmed by an extensive Microsoft Excel spreadsheet? If yes, you’re not alone. Upon receiving thousands of lines of complex … [Read more...]

Microsoft Excel Training – Using Slicers

When it comes to Microsoft Excel training, no education is complete without fully understanding how to use Slicers. In this Directions Training … [Read more...]

Using Timeline Slicers in Excel 2013 Pivot Tables

More notes from “The Office Guy”… Excel has always had a lot of robust tools that allow users to analyze their data. Among the most popular tools … [Read more...]

Comments in Microsoft Excel

Many users of Excel have been able to see comments on cells for a while, but there hasn't been a way to add new comments to a cell. With Excel Online, … [Read more...]

Locking Certain Cells or Ranges in a Protected Worksheet

By default, the Locked setting is turned on for every cell in a Microsoft Excel worksheet. This can be confusing because the locked setting doesn't … [Read more...]

Repositioning of the Chart Formatting Tools in Excel 2013

Creating charts using Microsoft Excel is nothing new, this has been a core feature of Excel for a very long time. However, in Excel 2013 there are two … [Read more...]

Using the Recommended Charts Tool in Excel 2013

Creating charts using Microsoft Excel is nothing new, this has been a core feature of Excel for a very long time. However, in Excel 2013 there are two … [Read more...]

An Eye on Your Data

Let’s say you have a very large worksheet in Microsoft Excel and want to view how any changes in one area will affect the totals and other … [Read more...]

Text to Columns Function in Excel

Have you ever had an Excel worksheet where full names were combined into one cell and you needed to have the first name in one cell and the last name … [Read more...]

ISFORMULA Function in Excel 2013

One of Directions Training’s Microsoft Applications Instructors wanted you to know… Some of the things we look forward to in new versions of … [Read more...]

The Screenshot Capture Tool in Microsoft Office

Notes from the “Office Guy” at Directions Training: Here’s another cool feature found in Microsoft Office that you might not be aware of. Now, when … [Read more...]

Fantastic New Features in Excel 2013

Wondering if you should upgrade from your current version of Microsoft Excel to Excel 2013? If you do more than the basics, the answer is definitely … [Read more...]

Quick Analysis Tools in Excel 2013

Notes from the “Office Guy” at Directions Training: This month I’m going to continue exploring some of the new features found in Microsoft Excel … [Read more...]

PowerPivot for Excel

One sheet in Microsoft Excel has a limit of 1,048,576 rows, but you may have millions of rows of data. So what do you do now? You can download the … [Read more...]

Flash-Fill in Microsoft Excel 2013

Last month we introduced you to one of Directions Training’s Microsoft Applications Instructors who refers to himself as an “Office Guy.”  We also … [Read more...]

New Face of Microsoft Excel 2013

One of Directions Training’s Microsoft Applications Instructors wanted you to know that in reality, he’s an “Office Guy.” So, what is an “Office … [Read more...]