Excel Footer Font Fix and Custom Footer Macro

When you’re printing financial reports in Excel, do you set them up to print one page wide? That feature saves paper, but it can make the header and footer text too small to read, especially if it’s in a small font size already. Here’s how you can avoid that problem. And there’s a macro to create a custom worksheet footer too!

Continue reading “Excel Footer Font Fix and Custom Footer Macro”

How to Compare Two Lists in Excel-New Items

Do you ever need to compare two lists in Excel, and see if there are some items in one list, that aren’t in the other list? The video below shows how to check for new items, and only add those to your existing list. You don’t want to have a list that’s full of duplicates entries!

Continue reading “How to Compare Two Lists in Excel-New Items”

Excel Find and Replace with Wildcard

With the Find and Replace feature in Excel, you can look for specific characters, and replace them with different characters, or replace them with nothing. You can also use wildcard characters in the Find What box, to make the find feature more flexible. The short video below shows you the steps. 

Continue reading “Excel Find and Replace with Wildcard”

Create Excel Monthly Calendar From 6 Formula Cells

Create a monthly Excel calendar, based on a few short formulas. Next, add formatting and a heading, and if you’re feeling fancy, show a list of the month’s holidays too! This example uses functions that are available in Excel 365, and in Excel for the Web.

Continue reading “Create Excel Monthly Calendar From 6 Formula Cells”

Unpivot Excel Data with Power Query Step by Step Video

This step-by-step video shows how to unpivot data in Excel, using Power Query. This creates better source data that you can use to build flexible pivot tables. And it doesn’t change your original data – you can leave that as is!

Continue reading “Unpivot Excel Data with Power Query Step by Step Video”