Excel Tips


Pivot Charts »

August 21, 2017

Building a pivot chart to summarize a data set


Excel Shortcut - Insert Worksheet »

August 21, 2017

Today, a few different Excel shortcuts to insert a new worksheet.


Up/Down Markers »

August 18, 2017

Icon Sets debuted in Excel 2007


Compare 3 Lists »

August 17, 2017

You have three lists to compare. Time for lots of VLOOKUP?!


Excel Shortcut - Go To Cell Link »

August 17, 2017

The next item in our list of Excel shortcuts: How to jump from a cell to the linked cell. If you have a formula that is pulling data from elsewhere, you can jump to that other cell.


Replicate Pivot Table For Each Rep »

August 16, 2017

There is an easy way to replicate a pivot table for each rep, product, whatever


Excel Shortcut - Controlling Word Wrap »

August 16, 2017

Excel Word Wrap is great - you can create multi-line headings. Today's article shows you how to take control of where those words break.


Running Totals »

August 15, 2017

This episode shows three ways to do running totals


Excel Shortcuts - Formatting with !@#$%^ »

August 15, 2017

Today's Excel shortcut is actually six shortcuts. Ctrl+Shift+ the numbers one through six each perform some numeric formatting. Today, I will show you how to remember the formatting associated with the six keys.