MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Checkmarks in Excel

July 19, 2018 - by Bill Jelen

Checkmarks in Excel

Creating checkmarks in Excel is usually a hassle. Yes, you could type a capital letter P and change the font to Wingdings 2, but who can remember that combination?

I was discussing Icon Sets in my Power Excel seminar in Atlanta and a fellow named Jack Whipple explained how he uses icon sets to create checkmarks in Excel.

Jack has a list of things that have to be completed during month-end close. He adds a symbol next to each item:

Three symbols to indicate if an item is done
Three symbols to indicate if an item is done

Here is the system in action. Jack explains that he uses the empty circle to indicate things that are not done. If he prints the list and carries it around on a clipboard, he can add a checkbox inside the circle to manually mark things as he walks around.

continue reading »

More Reading

Magnifier in Excel

Magnifier in Excel »

July 12, 2018 - by Bill Jelen

When I am doing a presentation at a Staff Meeting or my Live Power Excel Seminar, I have started to use the Windows Magnifier to show details in the Ribbon or dialog boxes.

Pivot Table With Text in Values Area

Pivot Table With Text in Values Area »

July 10, 2018 - by Bill Jelen

Can you build a pivot table with text in the values area? Susan from Melbourne Florida has a text field and wants to see the before and after of that text.

read more news »

Featured Products

Excel Video Medley

Excel Video Medley »

Excel Video Medley covers everything from Pivot Tables to VLOOKUP to VBA. Learn how to create scientific graphs. Use Excel for statistics.

Supercharge Excel When You Learn to Write DAX For Power Pivot

Supercharge Excel When You Learn to Write DAX For Power Pivot »

Hands-on book to learn and master the DAX language!

Excel JavaScript UDFs Straight to the Point

Excel JavaScript UDFs Straight to the Point »

JavaScript custom functions - UDFs can be used like any other native functions or UDFs in Excel. This book shows the process of creating JavaScript UDFs in Excel Developer Preview for Office Insider program subscribers.

MrExcel LIVe

MrExcel LIVe »

A book for people who use Excel 40+ hours per week. Illustrated in full color.

Learn to Write DAX

Learn to Write DAX »

Data analysis expressions (DAX) is the formula language of PowerPivot and Power BI. Simply reading a book is normally not enough to help Excel users learn DAX skills – you need to complete exercises and get plenty of practice to make the transition.

Power Pivot and Power BI

Power Pivot and Power BI »

Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.

see more products »