# Excel

## World Map with Indicators

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.

## World Map with Bar Chart

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.

## US Map with Smiley Faces

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.

## US Thermal Map

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 Display

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.

## VLOOKUP and HLOOKUP functions

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

## Data Referencing

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.

## Dynamic Referencing

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.

## Data Transposing

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

## Create a Dropdown List by using Data Validation Command

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

## Generating Random Numbers

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

## Large and Small

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.

## Mortgage Amortization Schedules

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

## Date Functions

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.

## Fill Data in Multiple Empty Cells

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

## Use Conditional Formatting to create Quick Graphical Presentations

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

## Use Goal Seek to reverse engineer desired results

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

## Use Data Table for Scenario Analysis

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

## FIFO and LIFO Calculations

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.

## US Holidays Calculations

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.

## WORKDAY and NETWORKDAYS Functions

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.

## Calculation of Bond Payment Dates

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

## Prime Factoring

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.

## Lottery Numbers Generator

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

## Use COUNTIF function and sorting to analyze the PowerBall Playout

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

## Create Organization Chart by using SmartArt

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

## Use graphical functions in Microsoft Office to create impressive graphics

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

## Create Flow Chart by using SmartArt

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

## Use Translator

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.

## Compare Multiple Numbers and Text in Microsoft Excel

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

## Manipulate Text by using Excel Commands and Functions

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

## Navigate around cells, worksheets, and files by using Visual Basic Codes

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

## Different Looping Mechanisms in Excel VBA

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.

## Internal Rate of Return (IRR) Calculations with different Accrual Basis

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

## Use Excel Pivot Table to create a Crosstab Table

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.

## Create a Mark-to-Market Report by using VB module to pull data from website

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

## Use VB Module to automate some printing processes

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

## Animation in Excel using VBA

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.

## Trucking Logistics

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.

## Find the X and Y Coordinates of a Shape Object

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.

## Convert a Crosstab Table to Database Table Format

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.

## Count Duplicates as One Item

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.

## Use Enter or Tab Key to trigger a Visual Basic module

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

## Select Displayed Cells for Copying

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.

## Create an action trigger (Open /Close a file) for a VB Module

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.