We all want to be remembered for our contributions to humanity. That’s why, way back in 2004, I made an Excel Smiley Face sample (aka “Happy Face”). There was a new version in 2009, and here’s another update, to change the Smiley Face shape colour automatically. You can do the same thing with other shapes too, like partial circle “pie slice”. Is there a Nobel Prize in this category?
Author: Debra Dalgleish
Excel Printing Tips Videos
Someone asked me for help with an Excel printing question recently – how to make the columns all fit on one printed page. Most of us don’t print our Excel sheets too often, so it’s easy to forget those Excel printing tips! Videos and tips below show a few things you can do to make Excel printing easier.
Compare Annual Data in Excel Pivot Chart
If you have a couple of years of daily data in Excel, you can use a pivot chart to quickly compare that data, month by month, year over year. This short video shows how to compare annual data in Excel pivot chart.
Show Loan Payments in Excel with PMT and IPMT
With the PMT function, you can enter a few numbers, and calculate the monthly payments for a loan amount. But when is each payment due, and how much goes to interest and principal? This PMT and IPMT functions example shows how to calculate that too.
Continue reading “Show Loan Payments in Excel with PMT and IPMT”
Excel Conditional Formatting for Weather Data
At work, we use Excel for serious projects, like financial reports or marketing forecasts. Excel is useful at home too, for personal tasks. I keep daily notes, and I added conditional formatting for weather data, to make the columns easier to read.
Continue reading “Excel Conditional Formatting for Weather Data”
Happy Spreadsheet Day 2019
Happy Spreadsheet Day 2019! What will you be doing to celebrate today? There’s a special Microsoft event at 12 noon Eastern Time, so catch that if you can (details below).
Dependent Drop Down List in Excel
With Excel data validation, you can create drop down lists in worksheet cells. Show the same list all the time, or show a “dependent” drop down list, based on the value entered in another cell. This video shows how to set one up, and there are written steps too.
Quick Data Entry Trick for Excel
This quick data entry trick for Excel works best in a table where you already have quite a few entries. To see the trick, watch the short video below. There are written steps too, below the video.
Change Sheet Names in Excel Macro Code
If you download one of the sample Excel workbooks from my Contextures website, you might want to customize it, to meet your requirements. The two videos below show how to customize one of my files, and you can make similar changes in other workbooks. Continue reading “Change Sheet Names in Excel Macro Code”
How to Add Emojis in Excel Worksheets
In the old days, we typed emoticons in our messages, to show a grin, or wink, etc. Now we use emojis online, and I finally learned how to add emojis in Excel too. Thanks to Wyn Hopkins who showed me this trick – my worksheets will never be the same! Also, thanks to Duncan Williamson, who shared a Sparklines trick.