How to Find Dates of Public Holidays using Excel
Lets celebrate these holidays in PHD Style. By learning few excel formulas that you can use to find out dates for some of the popular public holidays like – labor day, memorial day etc. When is Labor Day (US) in 2010? Labor day (the US variant) is celebrated on first Monday of every September. It […]
Waterfall Charts using Excel
Learn how to create waterfall charts in Excel in this tutorial. Our guest author, Aaron, explains how to create cool looking waterfall charts with connectors. Waterfall charts are great, especially for visually showing the contribution of parts to a whole.
Generating invoice numbers using excel [reader questions]
Learn how to generate invoice numbers, tax codes etc. using Microsoft Excel. In this example we will take a real life example shared by Michelle and findout how we can generate invoice numbers using excel formulas. Read more to learn and download the example workbook.
Create a number sequence for each change in a column in excel [Quick Tip]
Here is a quick formula trick you can use to generate sequence numbers that only increment when there is a change. Assuming the sequence of values are in column C from C3, you can write the following formula in B4 onwards (B3 will be 1, wake up…) =IF(C4=C3,B3,B3+1) Now just copy paste the formula over […]
Employee Satisfaction Surveys using MS Excel
Today we will learn how to make an employee satisfaction survey and consolidate the data using excel.
Visualizing Search Terms on Travel Sites – Excel Dashboard
Microsoft excel bubble chart based Visualization to understand how various travel sites compete search terms
Sales Funnel Charts in Excel – Tutorial
Sales funnel is a very common business chart. Here is a simple bar chart based trick you can use to generate a good funnel chart to be included in that project report.