A few years’ ago I created a video showing you how to create an animated Christmas tree. See the video here https://www.bluepecantraining.com/portfolio/created-a-christmas-tree-with-sparkling-lights-in-excel/ It’s Christmas time again and I thought it was time to create version 2.0 to include an automated countdown to Christmas and animated tree and stars, all on a Christmassy background. Watch the… Read More »Countdown to Christmas in Excel with Christmas Tree & Lights
Have you ever wondered what Excel’s #NUM! error actually means? The #NUM! error can appear for several reasons: here are three of the most likely. Reason 1: You are Performing an Impossible Calculation in Excel If you perform an impossible calculation in Excel you will get the #NUM! error. An example of an impossible calculation… Read More »Excel’s #NUM! Error – What Does it Mean?
This tutorial will show you how to format cells using custom number formats that include icons and emojis. Conditional formatting as you may know provides a limited selection of icon sets, but if you are after more variety or indeed a bit of fun with your Excel spreadsheet then this is for you. Download the… Read More »Including Icons and Emojis in Excel’s Custom Number Formats