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...]

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...]

Dashboards in SharePoint 2013 using the Excel Web Access Web Part

You can easily display Microsoft Excel charts and tables using the Excel Web Access Web Part in Microsoft SharePoint 2013. This enables decision … [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...]

Why Upgrade to Microsoft Office 2013?

Here are just a few reasons why you should upgrade to Microsoft Office 2013. Office 2013 ventures beyond the mouse and keyboard to embrace … [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...]

Office 2013 Tips and Tricks

A New Look The first change you'll notice when you launch an application within Microsoft Office 2013 is the new landing page.  In the first … [Read more...]

Thumbtacks in Microsoft Office

If you work in a busy office and have to create, edit and print many documents each day, one of the problems you may encounter is finding the file in … [Read more...]

The New Office 2013

One of Directions Training’s Microsoft Applications Instructors wanted you to know… Microsoft Office 2013 is coming! OK – It’s out there and … [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...]

The Importance of Microsoft Applications Training

One of Directions Training’s Microsoft Applications Instructors wanted you to know… As an Applications Instructor, I deal daily with people who … [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...]

Unsaved Saved Work

One of Directions Training’s Microsoft Applications Instructors wanted you to know… So you're using one of the Microsoft Office 2010 or 2013 … [Read more...]