Excel Tips
October 31, 2017
In 2017, Excel introduced a new chart type called a Map Chart. These maps will shade each country based on a value. Also, shade each state, province, county, zip code, and so on.
Track Changes in Formula Cells »
October 30, 2017
Track Changes in Excel Formula Cells. Can you show which items just changed as a result of changing certain input cells?
October 27, 2017
How to use a SUMIF to sum the *visible* cells that match a criteria. For example, sum all of the records where the Region="East", but ignore the rows that are already hidden. You will be surprised at the function that saves the day.
October 27, 2017
Using Advanced Filter in Excel to solve Mort's problem. Although regular filters have gotten more powerful, there are still times that the Advanced Filter can do some tricks that others can not.
October 26, 2017
Fill without Formatting. Sometimes you need to copy a formula but not screw up the existing formatting. Learn how with this article.
October 26, 2017
Can Excel print a running total in the footer for each page? It is not built-in, but a short macro will solve the problem.
October 25, 2017
How to use the Excel fill handle to fill the 1st and 15th of every month. It sounds simple, but it is not.
Scrape Webpages Using Power Query »
October 25, 2017
Power Query is pretty powerful. But I am about to do Power Query Squared... writing a query for one page and then having Excel perform the same query for a whole list of web pages.