Excel Projects

This repository contains my work in Microsoft Excel.

Below are the instructions for using dynamic heat map in excel.

1.Dynamic Heat Map

Analyzed accident frequency for the city of Cambridge by building a dynamic heat map of accidents. Generated heat map allows to quickly visualize when certain types of accidents are most likely to occur. The data visualization displays the safest and dangerous time to travel around the city.

Prerequisites

Basic Knowledge of Pivot Tables, custom and conditional formatting in Excel

Instructions

Go to the heat map sheet.
click on drop down list beside the blue boxes on top.

Output

You will see the heat map changing for different combination of accident type and season type
You will also see the Geo heat map (Power Map) at the bottom also changing accordingly.
On top left corner total number of accidents are displayed. .
Notice the values on X and Y axis, they're dynamic and will be changing dynamically based on the time the worksheet is opened. X-axis displays the day of the week and number of accidents hour wise subsequently. Similarly, Y-axis displays the number of accidents for following day of the week.

Built With

• Power Map - 3D visualization tool to plot geographic data

2.Sales Dashboard

I have utilized following items in building sales dashboard which analyzes products by category and region.

Pivot Tables
Pivot Chart
Data Refresh
Data Table
Dynamic Name Tagging
Slicers
Map Pivot
Sparklines