# Author: Debra Dalgleish

## Excel Data Validation Troubleshooting

How many data validation rules do you have in the giant Excel workbook that you use every morning? If you inherited that file from somebody else, you might not have any idea what’s on...

## Create a Tartan Pattern in Excel

Suddenly, it’s November, and it’s time to plan what you’ll wear on St. Andrew’s Day (November 30th). He is the patron saint of Scotland (and other countries), so of course you’ll need a kilt,...

## Excel Lookup Formula Challenge 20171026

Here’s an Excel Lookup Formula challenge to get your brain fired up. Can you solve it without doing a Google search? The problem details are shown below, and you can download the sample workbook....

## Quick Trick to Add or Move Pivot Table Fields

We’re still recovering from Tuesday’s Spreadsheet Day celebrations, so we’ll keep it simple today. Here’s a quick trick to add or move pivot table fields, just by typing. Watch the really short video, and...

## Happy Spreadsheet Day 2017

Happy Spreadsheet Day 2017! You’ve been waiting all year for this special day to arrive, I’m sure, so what will you do to celebrate today?

## How to Fix Excel Data Bars Appearance

To make a bar chart right in the worksheet cells, use Excel Data Bars, built with conditional formatting. See how to add a standard set of Data Bars (Excel 2007 and later), and adjust...

## Multiple Copies of Pivot Table Sheet

If you need to make a quick report, Excel has a built-in command that makes multiple copies of pivot table – one for each item in a Report Filter. See how that feature works,...

## Compare Pivot Table Values As Percentages

As you know, pivot tables are a quick and easy way to summarize a huge table of data in Excel. With just a few clicks, you can create totals for thousands of rows of...

## Excel Hyperlinks Run Command Files

You can use Excel hyperlinks to navigate through a workbook, go to web pages, open other Excel files, and even open PDF files. However, if you try to use an Excel hyperlink to run...

## Looking Back at Early Versions of Excel

While clearing some of the boxes in the basement, I found a stack of old MacUser and MacWorld magazines. A couple of issues had articles on early versions of Excel (it started on the...

## Excel CONVERT Function With Drop Down Lists

With the Excel CONVERT function, you can change quantities from one measurement type to another. For example, a hot day in Celsius looks even worse in Fahrenheit! Get my CONVERT workbook, with drop down...

## Save Space With Excel On Demand Slicers

In one of my sample files, you can use Slicers to select criteria for an advanced filter. There are 3 Slicers at the top of the sheet, and an output range below that.  And...