All articles with 'tutorial' Tag

How to Find Dates of Public Holidays using Excel

Published on Dec 24, 2009 { 4 Comments }
How to Find Dates of Public Holidays using Excel
Continue »

Waterfall Charts using Excel

Published on Aug 10, 2009 { 21 Comments }
Waterfall Charts using Excel
Continue »

Generating invoice numbers using excel [reader questions]

Published on Jul 20, 2009 { 12 Comments }
Generating invoice numbers using excel [reader questions]
Continue »

Create a number sequence for each change in a column in excel [Quick Tip]

Published on Jun 29, 2009 { 4 Comments }
Create a number sequence for each change in a column in excel [Quick Tip]
Continue »

Employee Satisfaction Surveys using MS Excel

Published on Feb 4, 2009 { 16 Comments }
Employee Satisfaction Surveys using MS Excel
Continue »

Visualizing Search Terms on Travel Sites – Excel Dashboard

Published on Jan 19, 2009 { 10 Comments }
Visualizing Search Terms on Travel Sites – Excel Dashboard
Continue »

Sales Funnel Charts in Excel – Tutorial

Published on Jan 9, 2009 { 17 Comments }
Sales Funnel Charts in Excel – Tutorial
Continue »

Custom Views in Excel – Save filter and header settings for quick reference

Published on Dec 17, 2008 { 4 Comments }
Custom Views in Excel – Save filter and header settings for quick reference
Continue »

Brick Charts in Excel – an Alternative to Gridlines

Published on Dec 10, 2008 { 5 Comments }
Brick Charts in Excel – an Alternative to Gridlines
Continue »

What is camera tool and how to use it? [spreadcheats]

Published on Dec 2, 2008 { 10 Comments }
What is camera tool and how to use it? [spreadcheats]
Continue »

Excel Links of the Week [Dec 1]

Published on Dec 1, 2008 { 0 Comments }
Excel Links of the Week [Dec 1]
Continue »

Advanced Data Validation Techniques in Excel [spreadcheats]

Published on Nov 25, 2008 { 21 Comments }
Advanced Data Validation Techniques in Excel [spreadcheats]
Continue »

Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]

Published on Oct 29, 2008 { 10 Comments }
Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]
Continue »

Sports Dashboards in Excel – A Tutorial

Published on Oct 20, 2008 { 12 Comments }
Sports Dashboards in Excel – A Tutorial
Continue »

Gantt in 60 seconds – churn out an excel project plan in no time

Published on May 20, 2008 { 7 Comments }
Gantt in 60 seconds – churn out an excel project plan in no time
Continue »