Target Vs Actual Sales Chart
Power Point Visualization

Animated Target Vs Actual Sales Chart in Power Point

We have started the Microsoft Power Point Charts and visualization tutorial. Here we have created a data driven Target Vs Actual Sales chart with animation. You can use this Chart with your data. [caption id="attachment_17492" align="aligncenter" width="685"] Target Vs Actual Sales Chart in PPT[/caption] Click here to download the file- Watch the step by step video tutorial:
Advanced Condtional Formatting
Excel Tips and Tricks

Search Text from Specific or all columns in Excel

In this article, you will learn how to use Advanced Conditional Formatting to search text in data. Here we have taken the example for employee Performance rating data. We two type of search –Search in specific column and Search in all columns. Note: This trick is useful only for small data set. Search in specific Column: To search in specific column, just select the column name form the drop down
VBA

Create Auto Table of Contents in Excel Workbook

In this article, you will learn how to create a Table of Contents for any active workbook using VBA. We have created VBA code which you can put in your personal macro. Below is the code to create the Table of Contents - Option Explicit Sub Create_TableOfContents() 'Check is workbook is protected If ActiveWorkbook.ProtectStructure = True Or ActiveWorkbook.ProtectWindows = True Then MsgBox "Workbook is protected. Please unprotect it first", vbCritical
Animated Speedometer
Charts and Visualization

Animated Speedometer Chart in Excel

In this article, we have created an Animated Speedometer Chart using Excel Charts and VBA. This beautiful chart can be used in your business dashboard. An animation will run when the value of service level will be changed, or worksheet will be activated. Below is the snapshot for Animated Speedometer Chart- [caption id="attachment_17070" align="aligncenter" width="1253"] Animated Speedometer Chart[/caption] Below is the code to run this animation- Option Explicit Private Sub
Dynamic Variance Arrow Chart with Slicer
Charts and Visualization

Dynamic Variance Arrows Chart with Slicers

In the previous article we create a Dynamic Chart with Variance Arrows using multiple check boxes. In this article, we have created the similar Dynamic Chart with Variance Arrows using Slicer. This is quite useful chart to display the Sales variance in compare of previous year. We have used green and red arrow to display the percentage change. You can select multiple market in slicers using Ctrl + Click. Below
Dynamic Variance Arrows Chart with Check Boxes
Charts and Visualization

Dynamic Variance Arrows Chart with Check Boxes

In this article, we have created a Dynamic Chart with Variance Arrows using multiple check boxes. This is quite useful chart to display the Sale variance in compare of previous year. We have used green and red arrow to display the percentage change. This is a dynamic chart. if you will check any market name check box, data will be changed automatically on the chart. Below is the data for
Word Count in Excel
VBA

UDF to get the frequency of specific word in a Paragraph

In this article, you will learn how to create a User Defined Function in VBA to get the frequency of specific word in a paragraph. Using this UDF you will be able to get the Total Words, Specific word count (Case Sensitive Check) and Specific word count (Non-Case Sensitive Check). For example, we have below given paragraph, and we have got the Total word count and Specific word count also-
Group of Circle Charts
Charts and Visualization

Group of Circle Charts in Excel

Using the multiple Doughnut charts, we have created a beautiful Group of circle charts. In this Group of Circle Charts, we have displayed Market level and Over all service level. You can use it in your business dashboard or presentation. Below are the data points for which we have created this Group of Circle charts – [caption id="attachment_16550" align="aligncenter" width="262"] Data Set[/caption] Below is the snapshot of Group of Circle
Auto Bullet Points in Excel
Excel Tips and Tricks

Auto Bullet Points in Excel

In this article, you will learn how to add Auto Bullet Points in Excel using Custom formatting. To add the auto bullet point in excel range below are the steps- Select the excel range. Press Alt+O+E to open the Format Cells window. Go to Number tab. Got to Custom. Put the below code in Type box- “   ■    General;    ■ General;   ■    General;   ■    General” You can take any other
Dynamic Chart with Scroller
Charts and Visualization

Dynamic Chart with Form Control Scrollbar

In this article, we have created a Dynamic Chart with Form Control Scrollbar. If we have multiple dates in your data, then we can use scrollbar on the chart to display rolling 10 days or 15 days data points at a time. We have used below given data to create this dynamic chart – [caption id="attachment_16355" align="aligncenter" width="439"] Data point to create dynamic Chart[/caption] Below is the dynamic chart with