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

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

Getting Started with Office 2013

Setting your Preferences As a new user to Microsoft Office 2013, you may find yourself wanting to change some of the default settings. For example, … [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...]

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

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