Excel tips and tutorials
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”
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”
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”
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”
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”
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”
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”
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.
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”
When you create a pivot table in Excel, it doesn’t matter if there are filters applied in the source data table. The pivot table includes all the data, whether it’s hidden or not. But, if you’d like to create a pivot table from filtered list visible rows only, you can try this technique.
Continue reading “Pivot Table from Filtered List Visible Rows”
