The golf courses aren’t too crowded here this summer, because of the social distancing rules. So, if you’re trying to spread out the players at your course, use this Excel workbook for golf tee off times.
Author: Debra Dalgleish
Add Filter Commands at Top of Right-Click Menus
Do you spend lots of time in Excel tables, filtering the data, then clearing those filters later? If so, this free add-in from AlexJ will help you save time. The add-in will add filter commands at the top of right-click menus, where they’re easy to use.
Continue reading “Add Filter Commands at Top of Right-Click Menus”
How to Copy Excel Formulas with Table References
If you create Excel formulas that include table references, and then try to copy those formulas to adjacent columns, you might get incorrect results. See why that happens, and how to avoid those problems, when you copy Excel formulas with table references.
Continue reading “How to Copy Excel Formulas with Table References”
Colour Bands in Excel Table Based on Dates
When you create a named table in Excel, you can colour the alternating rows with one of the built-in Table Styles. But how could you colour alternating groups of information, such as dates? This example shows show to create colour bands, based on dates, so it’s easy to see where each day’s data begins and ends.
Continue reading “Colour Bands in Excel Table Based on Dates”
Excel Formula to Sum for Odd or Even Weeks
Here’s an Excel formula challenge for you, based on an email question that someone sent to me. They wanted help with an Excel formula to sum for odd and even weeks. See my solution, and let me know how you’d solve the problem.
Continue reading “Excel Formula to Sum for Odd or Even Weeks”
Fix Slow Excel Files with FastExcel Tools
If we’re sitting at home, with little to do but eat, watch TV and sleep, we might get a bit slow and bloated, which isn’t a great feeling. Nobody wants slow, bloated Excel files either, so Charles Williams just released a new, improved version of his FastExcel tools, to help you fix them! Unfortunately, it only works on Excel files, not people.
Continue reading “Fix Slow Excel Files with FastExcel Tools”
Excel Weekly Meal Planner Update 20200402
There’s an Excel weekly meal planner on my website, to help you organize your meals, and create a shopping list. Now that we’re staying home for a while, with very little shopping, I updated the file, to include an inventory of the food we have on hand.
Continue reading “Excel Weekly Meal Planner Update 20200402”
Excel Pivot Table Refresh Error with Data Model
A simple data change can cause a strange pivot table refresh error, if you added the data to the Data Model. The problem is easy to fix, once you see what’s causing it, but the error message, shown below, isn’t much help! I’d never heard of function PCMinorObjectCollection, had you?
Continue reading “Excel Pivot Table Refresh Error with Data Model”
Excel Roundup 20200319
It’s been a long time since the last Excel roundup, so here’s a new one! Check out these Excel links and articles, and I’m sure you’ll find a few interesting things to read.
Find the Nth Weekday in a Month in Excel
Some events occur on the Nth weekday of a specific month each year. Maybe your book club meets on the 4th Tuesday every month, and you don’t want to miss any meetings. In Excel, you can use a formula to find the Nth weekday in a month, and there’s an example shown below. Continue reading “Find the Nth Weekday in a Month in Excel”