January 5, 2017
Toggle Excel Conditional Formatting On and Off
One of the nice features of Excel Tables is the banded row formatting, which makes it easier to read and
Read MoreJanuary 5, 2017
One of the nice features of Excel Tables is the banded row formatting, which makes it easier to read and
Read MoreDecember 29, 2016
An awesome new feature available in Office 365 are Icons. You’ll find Excel Icons in the Insert tab of the
Read MoreSeptember 28, 2016
Using Excel Styles in your workbooks can not only make formatting them quicker and easier, but also result in more
Read MoreJuly 12, 2016
The Excel Clipboard is an extremely useful tool that’s very well hidden. Most of us are familiar with being able
Read MoreNovember 24, 2015
Around this time last Year I created an Advent Calendar in Excel: To Count Up or To Count Down? Now,
Read MoreNovember 10, 2015
I bet there's been the odd time you've said to yourself "wouldn't it be nice if Excel had..." Or maybe
Read MoreAugust 25, 2015
Excel’s Flash Fill tool is so cool that you’ll be looking for reasons to use it! Introduced in Excel 2013
Read MoreAugust 11, 2015
The Excel Fill Series tool is like having a bundle of tricks at your fingertips. It can help with one
Read MoreAugust 4, 2015
Have you ever wanted to only copy or paste visible cells? For example, below I have a table containing outstanding
Read MoreJune 17, 2015
I want to be clear that when I say apps for Office in Excel, what I am talking about are
Read MoreJune 9, 2015
Did you know that when Excel opens a new workbook it uses a template called ‘Book’ to create the new
Read MoreJune 2, 2015
A few weeks ago one of our members, Kylie, sent me this question: “How can I fill column E
Read MoreApril 20, 2015
Excel worksheet protection is a great way to prevent people accidentally messing up the reports you’ve spent hours creating. However,
Read MoreMarch 10, 2015
Filters are one of my most used Excel tools. They’re not fancy, but they sure do earn their keep. I’ve
Read MoreJanuary 19, 2015
Excel’s Custom AutoFilter can perform a myriad of tasks that are often overlooked. Just last week we had a question
Read MoreDecember 2, 2014
You’ll be Amazed at what you can CTRL+F in Excel Excel’s Find tool is one of the first features you’re
Read MoreNovember 25, 2014
Today I’ve got a Christmas treat for you with an Excel Advent Calendar that Phil and I created. Before you
Read MoreNovember 12, 2014
I arrived back from the 2014 Microsoft MVP Summit in Seattle on Sunday a little tired but bounding with excitement
Read MoreSeptember 15, 2014
In this tutorial we're going to look at how Santa is using Excel Custom Data Validation to limit the number
Read MoreJuly 8, 2014
Did you know you can set different passwords to protect specific ranges of your Excel worksheets? It’s called Allow Users
Read MoreJune 9, 2014
Copying and Pasting are two of the most common tasks you’ll perform in Excel. This is especially true for me
Read MoreMarch 21, 2014
One of the most useful features in Excel are custom number formats yet they remain largely underused. In my Excel
Read MoreMarch 5, 2014
Each year our sons choose a cake they want me to make for their birthday. Now, I am no baker
Read MoreFebruary 12, 2014
They say the true Excel fan has uninstalled Word from their PC, and removed the F1 key from their keyboard
Read MoreJanuary 30, 2014
The Scenario You need to change the range referenced by your chart/conditional formatting/named range so you merrily open the Edit
Read MoreJanuary 10, 2014
If you’re frustrated using Excel on a Mac because you don’t know the shortcut keys you’re used to using on
Read MoreNovember 20, 2013
I like to use Excel hyperlink buttons in my Excel workbooks to help with navigation. I link them to a
Read MoreNovember 7, 2013
Sometimes it’s the little things that make a big difference so today I’m going to share with you a few
Read MoreOctober 30, 2013
Today I want to share with you an Excel secret. It’s so powerful that when you know this your Excel
Read MoreAugust 28, 2013
The Easy Way In this example I’m going to show you how you can extract the domain name from a
Read More