Excel tips and tutorials
Dates can be tricky in Excel, especially in December and January! In those months, you often have to type the year too, because Excel defaults to the current year.
There are other Excel date problems too, like dates where you can’t change the formatting, and dates for the GetPivotData function. Here’s a quick look at dealing with those date issues.
In an Excel pivot table, you can use the % Running Total calculation, to show the current running total amount, divided by the grand total. For example, see what percentage of total sales come from the top 3 products.
Continue reading “Analyze Top Product Sales with Pivot Table % Running Total”
If you notice that Excel tables don’t automatically expand on your computer, to include new data, there might be a problem with the Excel Option settings. See how to change those settings manually, or use a macro to make the change.
Continue reading “Excel Table Does Not Expand Automatically to Include New Data”
If you’ve got a long list of sales orders on an Excel worksheet, how can you send one sales rep’s orders to a different sheet? There are lots of creative ways to do that, but my favourite solution is to use an Excel Advanced Filter. Would you use that solution too, or something different? Continue reading “Send Data to Different Sheets in Excel Based on Criteria”
Do you ever need to choose random names from a list in Excel? Maybe your charity is picking winners for a raffle, or your blog is doing a giveaway, or you need “volunteers” for a special project at work. As long as you have a list of the names, or ticket numbers, or anything else, Excel can do a random draw for you.
Continue reading “Choose Random Names From Excel List – Formulas No Macros”
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”
In Excel, you can create a Stacked Column chart, or a Clustered Column chart, using the built-in chart options. There isn’t a Clustered Stacked Column chart type, but here are 3 ways to create one. There’s a video below, that shows the steps for one method.
Continue reading “3 Ways to Create Excel Clustered Stacked Column Charts”
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?
Whether you’re scheduling players for a golf tournament, or assigning employees for daily shifts, Excel can make the job easier. There’s a Golf Tee Off Times example on my site, and you could adapt it for building other types of schedules. This week, I uploaded a second version of the file – it gives you more flexibility in assigning people to specific times.
Continue reading “Excel Workbook for Golf Tee Off Times Update”
In some data entry lists, you only want each item selected once. For example, pick players for a baseball lineup, or assign employees for their weekly on-call assignment. To prevent entries from being selected twice, use this data validation trick, to hide the used items in an Excel drop down list.
Continue reading “Hide Used Items in Drop Down List With Excel 365 Formula”
