Excel Tips
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
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 26, 2017
Fill without Formatting. Sometimes you need to copy a formula but not screw up the existing formatting. Learn how with this article.
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.
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.
October 24, 2017
Excel offers 175 shapes. You can create circles, ovals, dodecahedrons. But what if you need to create a triangle joined to a circle? Let me introduce you to Merge Shapes. This feature is in Power Point, but you can copy the merged shape back to Excel and use all of the shape formatting tools.
Windfall to Pre-Pay Mortgage? »
October 24, 2017
Karen just inherited $12K. If she makes a single lump-sum payment on her mortgage, how will that affect the number of payments until the mortgage is paid off?
October 23, 2017
Using Find and Replace will screw up your in-cell formatting. What do I mean by that? Let's say that you have 25 letters in Excel and only the third word is bold or red. Find and replace any of the words in the cell and you will lose the formatting. This article describes a workaround.