Excel tips and tutorials
If you create a chart from worksheet data, and then filter the data, some of the chart date might disappear. Sometimes, that’s what you want — filter by Region, and see only the East’s sales in the chart. But, if you always want to see all the data in the chart, try this easy fix.
Note: There’s a similar problem with Excel’s in-cell Sparkline charts, and you can fix that too! Continue reading “How to Fix Excel Chart to Show Hidden Data from Worksheet”
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”
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”
Easter will be here soon, and if you want to know exactly (“eggsactly”?) when it is, you can calculate Easter’s date with an Excel formula or User Defined Function. See the example below, and there’s a sample file you can download too, with several Easter formulas and functions. Oh, and there’s cake!
See how to create a simple Excel line chart for monthly sales data. Next, add a target range in the chart, to show which months’ sales fall within that target range.
Continue reading “Excel Line Chart Shows Target Range for Monthly Sales”
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”
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”
Are you watching any of the 2022 Winter Olympics coverage? I hear the medal count reports on the morning radio, but that’s about all I’ve seen!
Back in 2010, the Winter Olympics were in Vancouver, Canada, so we watched lots of events that year. I downloaded some athlete bios that year, and had fun turning that data into pivot tables.
Continue reading “Excel With Olympic Athlete Data for Winter Fun”
Is it Thanksgiving yet? Or Family Day? Or any other holiday? Use an easy formula to find out, with a couple of Excel date functions.
Continue reading “Find Date of Nth Weekday in Month with Excel Formula”
When people think about spreadsheets, they usually think of numbers, formulas and calculations. But spreadsheets are great at organizing words too! Here are a few of the functions you can use with text, and a fun word cloud tool to try.
