Excel Tips

November 21, 2017

Lev is commissioner of a competitive swim league. He writes: "I am the commissioner of a swim league. There are eight teams this year. Each team hosts one meet and is the home team. A meet will have 4 or 5 teams. How to arrange the schedule so every team swims against every other team twice? In the past, when we had 5, 6, or 7 teams, I could solve it by pressing F9 until close. But this year, with 8 teams, it is not coming out."

Default File Open Location »

November 21, 2017

If you always want Excel to default to a particular folder when you do File, Open... this article is for you.

Combine 4 Sheets »

November 20, 2017

Excel combine several worksheets into a single worksheet. Each worksheet might have a different number of records from day to day, so formulas are not the way to go. Instead, a little-known tool called Power Query will let you merge the data simply and quickly.

How many Kits Available »

November 17, 2017

Today, an interesting Excel problem about bills of material. You have a lot of raw materials. Each item might be assembled into several different top-level assemblies. Based on the raw material on hand, do you have enough to fulfill an order for a certain item?

Chart Hierarchy in X-Axis »

November 16, 2017

Charts created from pivot tables have an odd x-axis where you can show a hierarchy of fields... Perhaps Quarters and Months. This article shows you how to create a chart like this.

Filter to 27 Invoices »

November 15, 2017

Excel filters are great, but what if you need to find all records that match a long list of criteria? You need to find all of the line items on 27 invoices. Rather than click click click over and over in the filter, the Advanced Filter will quickly solve the problem