The icons show the relative size of the population of the top 10 countries on the world map. It looks cool and informative on a dashboard. Click the above picture or here to see how to do it.

Combining map with bar charts is an excellent way of showing product performance in different geographical locations. Click the above picture or here to see how to do it.

This example uses Smiley Faces as the statistical indicators to show the relative performance of the US States. Click the above picture or here to see how to do it.

The color of the state indicate the relative performance of such state. The darker the color, the higher the performance. Click the above picture or here to see how to do it.

Meter is an ideal visual tool to indicate the progress of a project, the usage of a resource, or the level of achievement. Click the above picture or here to see how to do it.

This article shows the best ways of using them and their limitations. Click the above picture or here to see how to do it.

Demonstration of the uses of LOOKUP, VLOOKUP, HLOOKUP, MATCH, and INDEX functions for Data Referencing. Click the above picture or here to see how to do it.

Demonstration of the uses of OFFSET function for Dynamic Data Referencing without the need of using Visual Basic codes or Macros. It can be applied to reports and charts. Click the above picture or here to see how to do it.

Using Transpose Function to change the Data Layout. Click the above picture or here to see how to do it.

There are 4 ways of doing it. Click the above picture or here to see how to do it.

Use the RAND or RANDBETWEEN functions to generate test data Click the above picture or here to see how to do it.

Find the largest or smallest numbers in a range of data using LARGE and SMALL functions. Click the above picture or here to see how to do it.

The article includes fixed and adjustable schedules. Click the above picture or here to see how to do it.

It covers several date related functions, such as EDATE, EOMONTHS, DATE, WEEKDAY, DATEDIF, DAYS360, NOW, and TODAY. Click the above picture or here to see how to do it.

Click the above picture or here to see how to do it.

Click the above picture or here to see how to do it.

Click the above picture or here to see how to do it.

Click the above picture or here to see how to do it.

The FIFO and LIFO calculations affect the timing realization of profit and loss. They can be automated by using VB Modules. Click the above picture or here to see how to do it.

A Visual Basic module is created to generating a list of US Holidays which is critical to many date calculations. Click the above picture or here to see how to do it.

The two functions can be combined with the holiday list for more practical applications.Click the above picture or here to see how to do it.

Dates are core of all accrued interest calculations. Click the above picture or here to see how to do it.

A visual basic module with 2 loopings is created to do the prime factoring. Click the above picture or here to see how to do it.

A visual basic module is created to generate random numbers for lotteries. Click the above picture or here to see how to do it.

This article investigates the occurrence frequency of the PowerBall numbers. Click the above picture or here to see how to do it.

Click the above picture or here to see how to do it.

Click the above picture or here to see how to do it.

Click the above picture or here to see how to do it.

The translator can help save 80% to 90% of time compared with the one that we did in the old fashioned way. Click the above picture or here to see how to do it.

Click the above picture or here to see how to do it.

Click the above picture or here to see how to do it.

Click the above picture or here to see how to do it.

Looping is a key to increase efficiency by reducing the need to perform repetitious tasks. Click the above picture or here to see how to do it.

A VB Module is created to calculate IRR. Click the above picture or here to see how to do it.

Group the data in a Pivot Table with certain intervals for better viewing. Click the above picture or here to see how to do it.

This article uses stock prices for illustration. Click the above picture or here to see how to do it.

Click the above picture or here to see how to do it.

Create Excel Animation is a lot of fun and a good way to impress your friends and co-workers. Click the above picture or here to see how to do it.

This Excel VB program will automate the planning of trucking logistics which is a critical part of many manufacturing industries. Click the above picture or here to see how to do it.

A VB module will help you easily locate the X and Y Coodinates of a Shape Object in Exce. Click the above picture or here to see how to do it.

Data conversion is needed to import data into a database or as data source of Power BI. Click the above picture or here to see how to do it.

This article illustrates how to use an Excel Array Function to count duplicates as one item. Click the above picture or here to see how to do it.

Click the above picture or here to see how to do it.

Use "Find & Select" functions to select only displayed cells and to avoid copying cells in hidden columns or rows. Click the above picture or here to see how to do it.

This article illustrates how to create an action trigger like open or close a file to initiate a VB module.. Click the above picture or here to see how to do it.