Author: Debra Dalgleish

Excel Roundup http://blog.contextures.com/ 4

Excel Roundup 20170504

There’s always something new and interesting to learn in Excel. In this month’s Excel roundup, you’ll find links to some of the best articles that I’ve read recently, and links to new and updated...

7 Ways to Round in Excel http://blog.contextures.com/ 6

7 Ways to Round in Excel

It’s not usually as obvious as the error in the screen shot below, but have you ever seen Excel adding things up incorrectly? No wonder some people take out a calculator, to check the...

SUMIFS with empty criteria 5

SUMIFS Formula With Empty Criteria Cells

I recently learned about The 100-Day Project (#The100DayProject), in which you work on making something every day, for 100 days. Would Excel formulas (#100DaysOfXL) be considered an artistic project? Maybe not, but I had...

Pivot Table Fill Colour Disappears 6

Pivot Table Fill Colour Disappears

Microsoft just announced the winner of their Excel World Champ data visualization contest. Congratulations to Ghazanfar Abidi, from Canada! I found his website today, and learned something new from his latest blog post –...

Excel Name Fix Challenge http://blog.contextures.com/ 8

Take the Excel Name Fix Challenge

Last week, in my Contextures Newsletter, I posted an Excel Name Fix challenge. There was a short list of names, which needed to be fixed. Then we needed to count how many were fixed....

Freeze All Worksheets Macro 2

Excel Freeze All Worksheets Macro

If you’re working with a large worksheet in Excel, it usually helps if you freeze the cells at the top and/or the left side of the sheet. That way, your headings are always visible,...

Excel Rank IF Formula http://blog.contextures.com/ 1

Excel RANK IF Formula Example

Excel has a RANK function, so you can calculate where each number stands in a list of numbers. There isn’t a RANKIF function though, if you need to rank based on criteria. Someone asked...