In this example, I will show you how I used Excel to decide which car to buy.
Step 1: you need to identify a list of cars to choose from (based on price budget, features, etc...)
Step 2: you need to identify the criteria that matters when choosing a car. The criteria I put here are: Price, Options, Space, Safety, Service, Spares, Performance and Resale. Feel free to add/remove other criteria of your interest.
The easiest way to visualize a project plan to better track it is to use a "Gantt Chart"
Since there is no ready-made Gantt Chart in Excel 2016, I will show you how to do it step by step to get the same chart in the picture.
Step 1: Input all the project phases with a start date and end date for each phase.
Step 2: Add another column for the Duration where the values there are the difference between the end date and start date
The easiest way to view a sales funnel in Excel is to use the "Funnel Chart".
Step 1: Input all the sales phases in one column and their relative values in the column next to it.
Step 2: Select your table (consisting of steps and values) and go to Insert -> Charts -> Insert Waterfall or Stock Chart -> Funnel
The issue here is that you may start the year with 50 employees, and end it with 60, so without understanding the real story behind, you may assume that your headcount increased by 10 employees. While the truth is that you had some hires, some exists and some transfers in and out of this department.
The best way to visualize this story is through a "waterfall chart"