Excel Solutions

How to Batch Send Multiple Emails via Excel VBA

We examine the code required to send emails in bulk from Excel with data particular to each recipient, plus a general attachment. The workbook used in this exercise can be found here The article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window". It is further assumed that Outlook is the email program. Data Copy the following text into a...

Read more »

How to Apply Conditional Formatting to a Pivot Table in Your Excel Worksheet

Conditional formatting and pivot table are two highly effective features in Excel. In this post, we will show you how to correctly apply conditional formatting to a pivot table. When you need to highlight cells based upon certain criteria, you might use the conditional formatting. Besides, you can also use this feature in a pivot table. On the other hand, in a pivot table, the rule of conditional formatting will be a little different. Now, please read on this article and see how to properly...

Read more »

How to Show Data in a Thermometer Chart in Your Excel Worksheet

When you need to show the data and information in a more intuitive way, you will certainly use a chart. In this article, we will show you how to create a thermometer chart in your worksheet. The shape of a thermometer is very special. And you can use it to show some special information. For example, you can show the completion of sales volume in the chart. The image below shows the sales target and the completion of a product. Now we will create a thermometer chart for this...

Read more »