Excel Tips
November 7, 2017
Excel formula for a progressive tax rate. This article shows you how to build a formula to calculate a progressive tax rate in Excel.
November 7, 2017
You have daily dates, but you want subtotals by month in Excel. There is an amazingly easy way to do this.
November 6, 2017
Excel Fill Weekend Dates. While Excel has a secret option to fill weekdays, there is no good way to fill weekend dates. This article will show you how.
Shift Subtotals Right 1 Column »
November 6, 2017
You've added subtotals in Excel. But you want those subtotals to move one column to the right, so they will be easy to see. Here is a method.
November 3, 2017
You have a report showing sales for 16 sales reps. Each sales rep belongs to a team. How can you create a report showing total sales for each team?
November 3, 2017
Which are the bottom five months of rainfall? Learn how to solve this problem using a pivot table.
November 2, 2017
Sentiment Analysis in Excel! There is a free add-in from Microsoft Labs that will let you do sentiment analysis in Excel. What if you have to wade through hundreds of survey comments to see what people think of your company? Excel can assign a probability showing how positive or negative each comment is.
Ctrl+Click to Insert Columns »
November 2, 2017
Excel fast way to insert many columns using the F4 key to Redo.
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.