Excel tips and tutorials
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”
Ken Puls and Miguel Escobar just released their new Power Query book – Master Your Data with Excel and Power BI. I bought a digital copy, downloaded the sample files, and eagerly dove into the book. Then I remembered the problem I’ve had for a few months – the Excel Queries & Connections pane is stuck at the top of my second monitor. Here’s how I finally fixed it.
Continue reading “Excel Queries & Connections Pane Stuck at Top of Screen”
To find the highest and lowest amounts in Excel, use the MAX and MIN function. If you need to use criteria in your calculations, add the IF function to your formula, in older versions of Excel. In Excel 2019 and Excel 365, use the newer MAXIFS and MINIFS functions. You can even get the answer without formulas – use a pivot table instead!
Continue reading “Find MAX and MIN With Criteria in Excel Formulas”
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.
Your Excel file worked perfectly yesterday, but when you entered new data today, the totals didn’t update. Why did the formulas suddenly stop calculating, and how can you fix them? Here’s the most common reason for that problem, and a quick way to fix it. Also, see how to avoid that problem in the future.
Continue reading “Excel Workbook Formulas Not Calculating: How to Fix Them”
Do you love the formatted, named tables in Excel, and use them as much as possible? Or, do you hate tables, and avoid them at any cost? Here are some of the great things about Excel tables, and a few reasons to think twice about using them in your Excel files.
Continue reading “Excel Formatted Named Tables: Love Them or Hate Them?”
In this data validation drop down list, the most recently ordered products are at the top. The rest of the product names are below those, in alphabetical order. There’s a worksheet cell where you can set the number of top items. This technique uses new functions, SORTBY and MAXIFS, which are available in Excel 365.
Continue reading “Excel Drop Down List with Latest Items at Top”
