Excel File Recovery

How to Create and Use the Scatter Chart in Your Excel Worksheet

Except for the lines or columns in a chart, you can also use the markers in a scatter chart to show data and information. In this article, we will show you how to create and work with the scatter chart. The scatter chart is a very special chart in Excel. Some special markers in the chart will represent the data in your worksheet. With those obvious markers, you can easily analyze the data and information. Below allow us to show you how to create such a chart. Create a Scatter Chart ...

Read more »

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 »