Excel Tips


Progressive Tax Rate »

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.


Subtotal by Month »

November 7, 2017

You have daily dates, but you want subtotals by month in Excel. There is an amazingly easy way to do this.


Fill Weekend Dates »

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.


Sales by Region & Team »

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?


Bottom 5 Months »

November 3, 2017

Which are the bottom five months of rainfall? Learn how to solve this problem using a pivot table.


Sentiment Analysis »

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.


Map Charts »

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.