It’s almost the holidays, so relax and enjoy some time away from work. Instead of struggling with budgets and forecasts, you can play games in Excel! And do you remember the games that were hidden in old versions of Excel?
Category: Excel tips
Happy Spreadsheet Day 2022
It’s finally here – the best day of the fall holiday season – Spreadsheet Day! You don’t need to buy any gifts, or cook a big meal, or find a trendy costume. Just open up your favourite spreadsheet, sit back, and enjoy the day!
Excel Sample Data for Football Season
The NFL preseason games for 2022 started last week. That reminded me of football-related questions that I had, way back in January 2010. Do the biggest players have the highest jersey numbers? Does the heaviest team win? As usual, I turned to Excel for the answers! Continue reading “Excel Sample Data for Football Season”
Fun With Microsoft Excel: Streaming Radio
Pro Tip – Don’t sign up for TikTok! It’s a giant carnival, filled with hypnotic music, shiny objects, travelling medicine shows, and fortune tellers. You stop in for 5 minutes, and stagger out hours later, dazed and confused. Sure, there’s helpful info on TikTok too, but you’ll probably get sidetracked while you look for it!
Continue reading “Fun With Microsoft Excel: Streaming Radio”
Warning for Hidden Rows and Columns in Excel
You can hide rows and columns in Excel, and it’s usually easy to unhide those rows or columns later. But, if you run into problems, these quick tips might help you show those rows and columns again.
Continue reading “Warning for Hidden Rows and Columns in Excel”
How to Fill Blank Cells in Excel With Value from Above
Some worksheets have blank cells in a column, instead of repeating the headings in every row. That white space makes it easier to read the report, but will cause problems if you need to sort or filter the data.
Here’s how you can fill in those blank cells, to avoid messing up your data. Then, use an easy conditional formatting trick, to hide the duplicate headings. Continue reading “How to Fill Blank Cells in Excel With Value from Above”
Excel Data Entry Tips Jump to Next Cell or Previous Cell
It’s been a long week, so here’s a quick Excel data entry tip for you. You’ll see how to move through a set of data entry cells that are in different rows and columns, quickly and easily.
Continue reading “Excel Data Entry Tips Jump to Next Cell or Previous Cell”
Get Ready for Spreadsheet Day 2021 on Oct 17th
Are you ready? Spreadsheet Day 2021 is almost here – Sunday, October 17, 2021. What plans do you have for this year’s celebrations? Continue reading “Get Ready for Spreadsheet Day 2021 on Oct 17th”
Happy Excel Day 44444
Did you already notice that today (September 5, 2021), is Excel day 44444? To see that number, type today’s date in a worksheet cell. Then, change that cell’s number format to General. Are you ready FOUR an Excel Day celebration?
Excel Roundup 2021-06-24
Happy Summer! Or, if you’re south of the equator, Happy Winter! To help you get the new season off to a good start, here’s a roundup of Excel articles and links. I hope you find a few interesting things to read, and new Excel features to try.
NOTE: To get Excel links and articles every other week, sign up for my bi-weekly Excel newsletter.