Written by Debra Dalgleish from Contextures Blog We all want to be remembered for our contributions to humanity. That's why, way back in 2004, I made an Excel Smiley Face…

Written by Debra Dalgleish from Contextures Blog Someone asked me for help with an Excel printing question recently – how to make the columns all fit on one printed page.…

Power BI is a data analytics & visualization software. It is one of the most popular and powerful way to work with complex business data. In this page, you will find…

Written by Debra Dalgleish from Contextures Blog If you have a couple of years of daily data in Excel, you can use a pivot chart to quickly compare that data,…

It’s Halloween time. As adults, we can’t go trick or treating. We can of course dress up in costumes and entertain others. But what about the poor spreadsheets. Don’t they…

Written by Debra Dalgleish from Contextures Blog With the PMT function, you can enter a few numbers, and calculate the monthly payments for a loan amount. But when is each…

Written by Debra Dalgleish from Contextures Blog At work, we use Excel for serious projects, like financial reports or marketing forecasts. Excel is useful at home too, for personal tasks.…

Written by Debra Dalgleish from Contextures Blog Happy Spreadsheet Day 2019! What will you be doing to celebrate today? There's a special Microsoft event at 12 noon Eastern Time, so…

Do you want to simulate multiple cash-flow scenarios and calculate the rate of return? Then this article is for you. You can get multiple scenarios of IRR with data tables.…

Written by Debra Dalgleish from Contextures Blog With Excel data validation, you can create drop down lists in worksheet cells. Show the same list all the time, or show a…