Learn Excel by Topic

15sectuts

Delete Blank Rows in Excel [Quick Tip]	Transpose Excel Rows and Columns [Quick Tip + Video]
Make a Bubble Chart in Excel [15 second tutorial]	Make a Pivot Table in Excel [15 Second Tutorial]
Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial]	Remove Duplicates [Quick Video Tip]

Analytics

Grouping Dates in Pivot Tables	Chart this Sales Data and get an iPod Touch [Visualization Challenge #2]
Product Recommendation � Excel Lookup Toolbox	Want to become a Data God? Learn Excel Data Tables
Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one	Create a number sequence for each change in a column in excel [Quick Tip]
Tweetboards – Alternative to traditional management dashboards	One more method to find unique values in excel and you can call me a dork
Visualizing Search Terms on Travel Sites – Excel Dashboard	Featured Visualizations – Jan 09
Automatically insert timestamps in excel sheet using formulas	Generating Random Phone Numbers
Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]	Management Dashboards – Compare 2 Decision Parameters [Part 5 of 6]
Handling spelling mistakes while searching your data using excel	Sorting a list of items in random order in excel – using formulas
Excel KPI Dashboards – Adding Micro Charts [Part 4 of 6]	Management Dashboards – Highlight Values Based on Percentile [Part 3 or 6]
Quickly process text using split() spreadsheet function in google docs	Doing the NY times Olympic medals by country year visualization in excel
Excel Bullet Graphs	Bingo / Housie Ticket Generator in Excel
How to count words in a cell using excel functions	Get Stock Quotes in Excel
on vlookup()

and()

Conditionally Formatting Dates in Excel [Part 1 of 2]	Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]
Search a Spreadsheet Full of Data using Conditional Formatting	What are the formulas you wish Excel had ?

array formulas

axis formatting

axis labels

Sales Funnel Charts in Excel – Tutorial

bad charts

bar charts

bubble charts

budget vs. actual

more articles on budget vs. actual »

calendar

2010 Calendar – Excel Template [Downloads]	Weekly Excel Links – Issues with Hosting of PHD
2009 Calendar Template in Excel – Now with week starting on Monday	Free Excel Calendar Template for year 2009 (and all years up to 9999)

cell

29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]	Creating Excel Art from Images [spreadsheet fun]
Free Excel Calendar Template for year 2009 (and all years up to 9999)	Custom Cell Formatting in Excel – Few Tips & Tricks

cell comments

Chart Busters

chart tamer

charting

Flu Trends Chart in Excel [Yes, we can edition]	Use “Script” font to make your incell charts realistic [quick-tips]
Flu Trends in a City chart from Google is Awesome!	Product Recommendation – Excel Dashboard Training Kit
A Brief History of Microsoft Excel – Timeline Visualization	Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations
Best of Pointy Haired Dilbert – 2009	Make a Quick Thermometer Chart to Compare Targets and Actuals
How to hide “0″ in chart axis [quick tip]	Use Shapes and Images to make Prettier Charts [Dashboard Tricks]
50% off on ExcelUser’s Dashaboard Kit [2 days only]	Group Smaller Slices in Pie Charts to Improve Readability
Excel Links – Learn Excel Online Edition	Format Charts Faster in Excel 2007 [quick tips]
Excel Links of the Week [Excel Dashboards Edition]	What is the most embarrassing charting mistake you made? [weekend poll]
Zoho sponsors our Visualization Challenge #2	Top X chart – Show Top X values of a chart Interactively
Chart this Sales Data and get an iPod Touch [Visualization Challenge #2]	Excel Links of the week [After a long time edition]
Lets Pimp a Gauge Chart [Chart Porn Friday]	Dashboard Best Practice – Google Analytics Intelligence Report
Switch Rows and Columns in Charts [Quick Charting Tip]	Making Interaction Plots using Excel
Project Dashboard + Tweetboard = pure awesomeness!!!	Making a chart with dynamic range of values
Visualization Lessons from Eiffel Tower [Chartbusters in Paris]	Make a Bubble Chart in Excel [15 second tutorial]
Recipe for a Donut Bar Chart	5 Things you probably dont know about this site
Twins, Clones and Duplicates – 6 Excel Shortcuts from an Excited Dad	Pareto Charts – How to do pareto analysis using Excel?
Nightmarish Pie Charts [because it is weekend]	Dynamically Grouping Related Events [Excel Combo Charts with Pizzazz]
Using Combo Charts to Group Related Time Events [Charting Goodness]	50 Best Cities for Finding a Job [Incell Dashboard using Excel]
Hide Grid Lines [Quick Tip]	Waterfall Charts using Excel
Are you excited about this twitter chart?	Charting Lessons from Optical Illusions
We cant Cure Cancer, But we can Cure this Medicare Chart [Chart Busters]	2 Great Pieces of Advice for Chart Makers, Dashboard Designers and Story Tellers Everywhere
14 Basic Skills for Chart Makers (Big question: How many do you have?)	Project Management: Show Milestones in a Timeline [Part 3 of 6]
Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial]	Fix this chart [excel homework #1]
Asset Allocation Chart Turns Zombie [ChartBusters #1]	Are you focusing on F word or S word? [Charting Principles]
Interview With Presentation Zen’s Garr Reynolds on Charting & Telling Stories	Welcome to Pointy Haired Dilbert
Bring out your bad charts, the ChartBusters are here…	Interviewing Garr Reynolds on this Friday, send me your questions
Incell Dot Plots in Microsoft Excel	Venn Diagrams in Excel
Intraday Candlestick Charting [Stock Charts]	Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)
Create a Dynamic Chart in Excel in 2 Minutes [spreadcheats]	Excel Tips Submitted by You [Part 2]
A Good Chart is a Story [Charting Principles]	Excel Tips Submitted by You [Part 1]
Announcing “Your Week” @ PHD	Tweetboards – Alternative to traditional management dashboards
Bonavista Chart Tamer Kicks ass.	Analyzing Search Keywords using Excel : Array Formulas in Real Life
Excel Links of the Week – What is really happening Edition	and the Winner is…
Budget vs. Actual Charts – 14 Charting Ideas You can Use	Interview with John Walkenbach on Excel and Banjo Charts…
Visualization Challenge – Budget vs. Actual Performance	Us vs. Them – Compare Sales Performance using Charts & Form Controls
RSS Icon using Donut Charts – Because it is Weekend	Japanese Candlestick Chart – Excel Tutorial
How Many Bubbles are Too Many Bubbles?	Market Segmentation Charts using Conditional Formatting
Make a Dynamic Chart using Data Filters	Review of PTS Clustered Stack Chart
Professional Resume or Data Visualization Fail? [poll]	[Weekend Poll] How do you Sex up your Charts?
Colors in Chart Labels [Quick Tip]	100 Excel Tips & Resources to Celebrate 2000 RSS Subscribers
Excel Links of the Week – Minor Changes to PHD edition	Do you know how to KISS, Wall Street Journal Does!
[Reader Poll] Stacked, Seperated or Mirrored ?	Visualizing Search Terms on Travel Sites – Excel Dashboard
Why No One Likes Your Pie Charts (And What to Do About It)	Sales Funnel Charts in Excel – Tutorial
Excel Basics – What are Combination Charts and How to Make One?	Excel 2007 Review – 10 things that WOWed me
Excel Links of the Week [Dec 15]	Brick Charts in Excel – an Alternative to Gridlines
What is camera tool and how to use it? [spreadcheats]	Are you making Blow charts? [charting tips]
How to present changes in Market Share using Charts?	Select & Show One Chart from Many
Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]	Making Pie-charts look Sexy – The CNN’s tax burden analysis chart
How to NOT spend $ 150,000 and still dress up your charts	5 Beautiful Visualizations [Oct 24]
Sports Statistics Dashboard in Excel – Few More Alternatives	Reader Poll: Should the axis for bar charts always start at zero?
Sports Dashboards in Excel – A Tutorial	The New Poor – Internet Penetration Rates by Country
Management Dashboards – Compare 2 Decision Parameters [Part 5 of 6]	Replace Radar Charts with Tables to Make Comparison Easy
Excel Links of the Week [Oct 06]	Excel Links of the Week [Sep 29]
Visualizing Sex & Love – 10 Infographics You Must See	Weekly Excel Links – Moved to Seattle Edition
You are NOT spider man, so why do you use radar charts?	Visualization Challenge – How to show market share changes?
Power Outage & 99 Excel Tips to keep you Busy	Infographics of the week [Sep 12]
Hack together a Gauge Chart in Excel without sweat	Cool Info-graphics of the Week [Sep 5]
Microcharting in Excel – 7 Alternatives Reviewed	6 charts you will see in hell
Display symbols in excel chart axis	It is show time baby! – better designer clocks to display time in your spreadsheets
Plot your data around the clock [Excel charting idea]	The Olympic Medals by Country Chart – Improved now
Excel Links of Week – Who is Obama edition? [Aug 12]	Use min-max charts to show the spread of data – Charting Best Practice
5 Infographics that can WOW you [Aug 7]	Vizooalization: 5 things I have learned about visualization at the zoo
Incell Bar charts – Revisited	Partition Charts in Excel – alternative to pie charts [visualization hack]
Gantt in 60 seconds – churn out an excel project plan in no time	Create Cool Tag Clouds in Excel using VBA

charting principles

more articles on charting principles »

charting tips

Twins, Clones and Duplicates – 6 Excel Shortcuts from an Excited Dad	50 Best Cities for Finding a Job [Incell Dashboard using Excel]
Hide Grid Lines [Quick Tip]	Intraday Candlestick Charting [Stock Charts]
Excel Tips Submitted by You [Part 1]	Announcing “Your Week” @ PHD
Market Segmentation Charts using Conditional Formatting	Make a Dynamic Chart using Data Filters
100 Excel Tips & Resources to Celebrate 2000 RSS Subscribers	Why No One Likes Your Pie Charts (And What to Do About It)
How to NOT spend $ 150,000 and still dress up your charts	Sports Dashboards in Excel – A Tutorial
Management Dashboards – Compare 2 Decision Parameters [Part 5 of 6]	Excel Links of the Week [Sep 29]
Weekly Excel Links – Moved to Seattle Edition	Use min-max charts to show the spread of data – Charting Best Practice
Incell Bar charts – Revisited	Gantt in 60 seconds – churn out an excel project plan in no time
Create Cool Tag Clouds in Excel using VBA

charts

Use “Script” font to make your incell charts realistic [quick-tips]	Product Recommendation – Excel Dashboard Training Kit
Best Charts to Compare Actual Values with Targets – What is your take?	2 Great Pieces of Advice for Chart Makers, Dashboard Designers and Story Tellers Everywhere
Gantt Charts – Project Management Using Excel [Part 1 of 6]	Tweetboard Implementations – Download and make your twitter style dashboard today
Web Analytics Dashboard by Percent Mobile is Fun [Dashboard Reviews]	Ads that are also Infographics – 10 Dazzling Examples
Excel Links of the week	Excel Bullet Graphs
Worst bar chart ever? – World�s Most Expensive Places to Have Sxx	Hot Thermometer Charts in Excel – here is a cool way to do them
Gantt in 60 seconds – churn out an excel project plan in no time	Create in-cell pie charts in Excel
How to get more colors in excel chart – simple trick	73 Free Designer Quality Excel Chart Templates – Grab now and become a charting superman

Charts and Graphs

more articles on Charts and Graphs »

circular formulas

more articles on circular formulas »

cleanup data

clock

It is show time baby! – better designer clocks to display time in your spreadsheets	Polar clock using donut chart [Excel Visualization fun]
Plot your data around the clock [Excel charting idea]

colors

Excel Colors Somehow Getting Changed ?	Photographic Fridays #5 – Dawn
Photographic Fridays #2 – Marbles

column charts

combination charts

more articles on combination charts »

combo charts

countif()

Product Recommendation � Excel Lookup Toolbox	Prevent Duplicate Data Entry using Cell Validations
Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6]	29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]
Count the number of unique values in a range [Quick Tip]	Generating invoice numbers using excel [reader questions]
Using Array Formulas in Excel – Find if a list has duplicate items	Advanced Data Validation Techniques in Excel [spreadcheats]
Eight ways to exploit COUNTIF() … and sumif() too [spreadcheats]	Learn Excel IF Formula – 5 Tricks you Didnt know

custom cell formatting

more articles on custom cell formatting »

dashboards

Use Shapes and Images to make Prettier Charts [Dashboard Tricks]	50% off on ExcelUser’s Dashaboard Kit [2 days only]
Excel Links of the Week [Excel Dashboards Edition]	Dashboard Best Practice – Google Analytics Intelligence Report
Project Dashboard + Tweetboard = pure awesomeness!!!	The Project Management Bundle for Excel is Here, Download your copy today
Project Management Dashboard / Project Status Report using Excel [Part 6 of 6]	Twitter Formula Contest – We are 5000 strong now
2 Great Pieces of Advice for Chart Makers, Dashboard Designers and Story Tellers Everywhere	Excel Links – Bacon bits are good edition
Tweetboards – Alternative to traditional management dashboards	Web Analytics Dashboard by Percent Mobile is Fun [Dashboard Reviews]
What is Your Opinion on Pie Charts?	Visualizing Search Terms on Travel Sites – Excel Dashboard
Prevent users from scrolling away on your dashboards [dirty little trick]	Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]
Sports Statistics Dashboard in Excel – Few More Alternatives	Reader Poll: Should the axis for bar charts always start at zero?
Dashboarding Fun – Display Smileys in your excel dashboards	Excel Bullet Graphs

data

Fix Incorrect Percentages with this Paste-Special Trick	Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations
Grouping Dates in Pivot Tables	Chart this Sales Data and get an iPod Touch [Visualization Challenge #2]
Product Recommendation � Excel Lookup Toolbox	Another Reason why Tables are so awesome [quick tip]
Want to become a Data God? Learn Excel Data Tables	Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one
One more method to find unique values in excel and you can call me a dork	The New Poor – Internet Penetration Rates by Country
Clean up Incorrectly Formatted Phone Numbers using Excel	Changing Sort Orientation in Excel – Sorting across columns instead of rows
Skip weekends while autofilling dates in excel	Quickly display unique items in an excel list using advanced filters

data filters

data labels

data processing

data series

data validation

data visualization

The New Poor – Internet Penetration Rates by Country

more articles on data visualization »

date and time

donut charts

downloads

Flu Trends Chart in Excel [Yes, we can edition]	Dr. Scroll-bar Mortgage Calculator or: Why you should not be borning and use form controls
A Brief History of Microsoft Excel – Timeline Visualization	Collapse, Expand Excel Charts using this hidden trick
A New Year Resolutions Template that Kicks Ass	Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]
Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations	Track Your Mutual Fund Portfolio using Excel [India Only]
How to Find Dates of Public Holidays using Excel	Make a Quick Thermometer Chart to Compare Targets and Actuals
2010 Calendar – Excel Template [Downloads]	Christmas Gift List – Set your budget and track gifts using Excel
Use Shapes and Images to make Prettier Charts [Dashboard Tricks]	Personal Budget Spreadsheet [Downloads]
Download Excel 2010 Beta today [Office 2010 Updates]	Top X chart – Show Top X values of a chart Interactively
Making Interaction Plots using Excel	Project Dashboard + Tweetboard = pure awesomeness!!!
Solve Sudoku Puzzles using Excel [because it is weekend]	Making a chart with dynamic range of values
The Project Management Bundle for Excel is Here, Download your copy today	Baby Feeding Chart using Excel
Project Management Dashboard / Project Status Report using Excel [Part 6 of 6]	Recipe for a Donut Bar Chart
Calculate Elapsed Time in Excel [Quick Tips]	Master Excel 2007 Ribbon with this Free Learning Guide
Excel Check Boxes, Even Simpler Way	Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6]
Dynamically Grouping Related Events [Excel Combo Charts with Pizzazz]	Using Combo Charts to Group Related Time Events [Charting Goodness]
50 Best Cities for Finding a Job [Incell Dashboard using Excel]	Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one
Waterfall Charts using Excel	Excel Time Sheets and Resource Management [Project Management using Excel - Part 4 of 6]
Use burn down Charts in your project management reports [bonus post]	Generating invoice numbers using excel [reader questions]
Make an Impressive Product Catalog [spreadsheets for small business]	Project Management: Show Milestones in a Timeline [Part 3 of 6]
Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]	Gantt Charts – Project Management Using Excel [Part 1 of 6]
Incell Dot Plots in Microsoft Excel	Networkingdays() an improved version of networkdays formula
Tweetboard Implementations – Download and make your twitter style dashboard today	Statistical Distributions in Excel [spreadcheats]
Intraday Candlestick Charting [Stock Charts]	Tweetboards – Alternative to traditional management dashboards
Highlight Top 10 Values using Excel Conditional Formatting	Excel Conditional Formatting Basics
Us vs. Them – Compare Sales Performance using Charts & Form Controls	Excel Links of the Week – Free E-Book Edition
RSS Icon using Donut Charts – Because it is Weekend	Japanese Candlestick Chart – Excel Tutorial
Market Segmentation Charts using Conditional Formatting	Weekly Links – Even More Downloads Edition
Write Your Own Twitter Client using Microsoft Excel	Visualizing Search Terms on Travel Sites – Excel Dashboard
Sales Funnel Charts in Excel – Tutorial	Excel Basics – What are Combination Charts and How to Make One?
2009 Calendar Template in Excel – Now with week starting on Monday	Brick Charts in Excel – an Alternative to Gridlines
Free Excel Calendar Template for year 2009 (and all years up to 9999)	Advanced Data Validation Techniques in Excel [spreadcheats]
Excel Links of the Week – All Downloads at One Place Edition	Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]
Select & Show One Chart from Many	Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]
Sports Dashboards in Excel – A Tutorial	More than 3 Conditional Formats in Excel
Management Dashboards – Compare 2 Decision Parameters [Part 5 of 6]	Replace Radar Charts with Tables to Make Comparison Easy
Deal or No Deal – Download and Play the Popular TV Game Show in Excel	Simple Todo List application using Excel – Download and become productive
Clean up Incorrectly Formatted Phone Numbers using Excel	You are NOT spider man, so why do you use radar charts?
Excel KPI Dashboards – Adding Micro Charts [Part 4 of 6]	Management Dashboards – Highlight Values Based on Percentile [Part 3 or 6]
Excel Bullet Graphs	Learn Excel IF Formula – 5 Tricks you Didnt know
Mutual Fund Portfolio Tracker using MS Excel	73 Free Designer Quality Excel Chart Templates – Grab now and become a charting superman
How to: sharing trip expenses using excel

duplicates

Twins, Clones and Duplicates – 6 Excel Shortcuts from an Excited Dad	Count the number of unique values in a range [Quick Tip]
Using Array Formulas in Excel – Find if a list has duplicate items	One more method to find unique values in excel and you can call me a dork
Excel 2007 Review – 10 things that WOWed me	Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]
Excel Links of the Week [Nov 3]

dynamic charts

e-books

Announcing PHD Thanksgiving Sale	Product Recommendation � Excel Lookup Toolbox
Master Excel 2007 Ribbon with this Free Learning Guide	The funnest way to learn excel formulas
Excel Formula 1 – Really Fast way to learn Excel Formulas	PHD Excel Formula Helper – Now an E-Book

excel 2007

Excel 2010

excel add-ins

excel apps

excel chart templates

more articles on excel chart templates »

Excel Dashboard Tutorials

more articles on Excel Dashboard Tutorials »

Excel Dashboard Tutorials

more articles on Excel Dashboard Tutorials »

excel dashboards

Excel Links of the Week [Excel Dashboards Edition]	Twitter Formula Contest – We are 5000 strong now
Prevent users from scrolling away on your dashboards [dirty little trick]	Reader Poll: Should the axis for bar charts always start at zero?

more articles on excel dashboards »

Excel Howtos

Grouping Dates in Pivot Tables	Making Interaction Plots using Excel
Excel Check Boxes, Even Simpler Way	Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu
Make an Impressive Product Catalog [spreadsheets for small business]	Create a number sequence for each change in a column in excel [Quick Tip]
Intraday Candlestick Charting [Stock Charts]	Excel Tips Submitted by You [Part 3]
Excel Colors Somehow Getting Changed ?

excel links

Weekly Excel Links – Moved to Seattle Edition	Excel Links of Week – Who is Obama edition? [Aug 12]
Excel links of the week : ‘what can excite you most’ [Aug 4]	Excel Links of the week
Excel Links � to iPhone or not to iPhone edition

excel mvps

excel tables

expense tracker

find

Extract usernames from E-mail IDs [using LEFT and FIND formulas in Excel]	Track Your Mutual Fund Portfolio using Excel [India Only]
29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]	Excel Tips Submitted by You [Part 2]
Search a Spreadsheet Full of Data using Conditional Formatting	What are the formulas you wish Excel had ?
Weekly Excel Links – Issues with Hosting of PHD	Change cell formats with find-replace in excel

find replace

Change cell formats with find-replace in excel

form controls

formatting

10 Supercool UI Improvements in Excel 2010	Recipe for a Donut Bar Chart
Pimp your comment boxes [because it is Friday]	Want to become a Data God? Learn Excel Data Tables
50 Best Cities for Finding a Job [Incell Dashboard using Excel]	Are you focusing on F word or S word? [Charting Principles]
Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)	Announcing “Your Week” @ PHD
5 Areas where Mouse Kicks Keyboard’s Butt	How to Change Shapes in Microsoft Office 2007
[Weekend Poll] How do you Sex up your Charts?	Colors in Chart Labels [Quick Tip]
Use Alt+Enter to get multiple lines in a cell [spreadcheats]	Creating Excel Art from Images [spreadsheet fun]
Custom Views in Excel – Save filter and header settings for quick reference	Brick Charts in Excel – an Alternative to Gridlines
Is your (chart’s) underwear showing?	How to NOT spend $ 150,000 and still dress up your charts
Excel can be Exciting – 15 fun things you can do with your spreadsheet in less than 5 seconds	Improve your in-cell charts with colors and negative values
Formatting numbers in excel – few tips	Change cell formats with find-replace in excel
Custom Cell Formatting in Excel – Few Tips & Tricks

freeze panes

gridlines

Hide Grid Lines [Quick Tip]	Interview With Presentation Zen’s Garr Reynolds on Charting & Telling Stories
Do you know how to KISS, Wall Street Journal Does!	Brick Charts in Excel – an Alternative to Gridlines

heatmaps

Flu Trends Chart in Excel [Yes, we can edition]	Flu Trends in a City chart from Google is Awesome!
Baby Feeding Chart using Excel	Excel Time Sheets and Resource Management [Project Management using Excel - Part 4 of 6]
We cant Cure Cancer, But we can Cure this Medicare Chart [Chart Busters]	Hot or Not – McKinsey’s Innovation Heatmap
Featured Visualizations – Jan 02	The Olympic Medals by Country Chart – Improved now

hide

10 Tips to Make Better and Boss-proof Excel Spreadsheets	Hide a Workbook from Nosy Colleagues [quick tip]
How to Hide Worksheet Tabs in Excel Workbook

howtos

Grouping Dates in Pivot Tables	10 Tips to Make Better and Boss-proof Excel Spreadsheets
Making Interaction Plots using Excel	Making a chart with dynamic range of values
Excel Check Boxes, Even Simpler Way	Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu
Make an Impressive Product Catalog [spreadsheets for small business]	Create a number sequence for each change in a column in excel [Quick Tip]
Remove Duplicates [Quick Video Tip]	Converting Excel to PDF – Everything you need to know
Intraday Candlestick Charting [Stock Charts]	Excel Tips Submitted by You [Part 3]
Excel Colors Somehow Getting Changed ?	Review of PTS Clustered Stack Chart
Write Your Own Twitter Client using Microsoft Excel	One more method to find unique values in excel and you can call me a dork
Conditional Formatting in Excel – 5 Tips to make you a Rockstar

if()

Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]	Top X chart – Show Top X values of a chart Interactively
Baby Feeding Chart using Excel	29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]
Create a number sequence for each change in a column in excel [Quick Tip]	Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]
Array formula to check if a number is prime [just for fun]	Formula Debugging in Excel – Tip [spreadcheats]
Advanced Data Validation Techniques in Excel [spreadcheats]	Learn Excel IF Formula – 5 Tricks you Didnt know

if() excel formula

more articles on if() excel formula »

in-cell charting

more articles on in-cell charting »

INDEX()

Flu Trends Chart in Excel [Yes, we can edition]	Reverse a List using Formulas [Using Excel INDEX() Formula]
Product Recommendation � Excel Lookup Toolbox	Recipe for a Donut Bar Chart
29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]	Generating invoice numbers using excel [reader questions]
How to Round and Sort Data using Excel Formulas?	Incell Dot Plots in Microsoft Excel
Excel Tips Submitted by You [Part 4]	Excel Tips Submitted by You [Part 2]
Us vs. Them – Compare Sales Performance using Charts & Form Controls

INDIRECT()

29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]	Excel Tips Submitted by You [Part 3]
Select & Show One Chart from Many

interactive

Parking Tickets in New York – Cool Interactive Visualization from NYTimes	5 visualizations to inspire you [Nov 21]
Shoot the guy in eyes, you could get some discout…	MMT rocks again
How not to do advertising online?	HIV/AIDS – Interactive Campaign
Tell me where I can fit this

interviews

Interview With Presentation Zen’s Garr Reynolds on Charting & Telling Stories	Interviewing Garr Reynolds on this Friday, send me your questions
Interview with John Walkenbach on Excel and Banjo Charts…	What would you like to ask John Walkenbach – Famous Excel Author and Guru?
Interview with Charley Kyd on Everyday Excel	What would you like to ask Charley Kyd of Exceluser.com in an interview?

john walkenbach

keyboard

Excel Links of the Week – The Mt. Rainier edition	11 very useful excel keyboard shortcuts you may not know
3 excel keyboard shortcuts that can save a lot of time for you

keyboard shortcuts

Excel Links of the Week – The Mt. Rainier edition	11 very useful excel keyboard shortcuts you may not know
3 excel keyboard shortcuts that can save a lot of time for you

more articles on keyboard shortcuts »

large

Top X chart – Show Top X values of a chart Interactively	29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]
Highlight Top 10 Values using Excel Conditional Formatting

Learn Excel

Excel Formula for Finding Repeated Words in a Cell	15 MS Excel Tips to Make you a Productivity Guru
Excel Basics: How to add drop down list to validate data	Want to Feed RSS to your Excel Sheet? Read this!
Shuffle a list of numbers / items in excel spreadsheet	Changing Sort Orientation in Excel – Sorting across columns instead of rows
Use Google docs to track your bucks – [spreadsheet forms idea]	How to count words in a cell using excel functions
Skip weekends while autofilling dates in excel	Hot Thermometer Charts in Excel – here is a cool way to do them
Formatting numbers in excel – few tips	How to get more colors in excel chart – simple trick

left()

Extract usernames from E-mail IDs [using LEFT and FIND formulas in Excel]	Track Your Mutual Fund Portfolio using Excel [India Only]
29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]	Using Credit Card Numbers in Excel
Generating Random Phone Numbers

line charts

list posts

macros

Product Recommendation – Excel Dashboard Training Kit	Excel Links – Learn Excel Online Edition
Excel Links of the Week [Excel Dashboards Edition]	Solve Sudoku Puzzles using Excel [because it is weekend]
Pimp your comment boxes [because it is Friday]	Get cell comments using Excel Formula
Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu	Excel Links – Bacon bits are good edition
Networkingdays() an improved version of networkdays formula	Venn Diagrams in Excel
Excel Tips Submitted by You [Part 4]	Analyzing Search Keywords using Excel : Array Formulas in Real Life
Weekly Links – Even More Downloads Edition	Write Your Own Twitter Client using Microsoft Excel
Make your VBA macros work anywhere: Enable Relative References	More than 3 Conditional Formats in Excel

maps

We cant Cure Cancer, But we can Cure this Medicare Chart [Chart Busters]	Excel Links – Bacon bits are good edition
Featured Visualizations – Jan 09	Featured Visualizations – Jan 02
Parking Tickets in New York – Cool Interactive Visualization from NYTimes	5 visualizations to inspire you [Nov 21]
5 Visualizations for Your Inspiration [Nov 14]	5 Visualizations for your Inspiration [Nov 07]
Infographics of the week – Food, Maps, Privacy & Politics [Oct 31]	5 Beautiful Visualizations [Oct 24]
Google Maps Walking Directions Bug ?!?	Cool Info-graphics of the Week [Sep 5]
Google Maps adds directions by Public Transport – Wow

MATCH()

Flu Trends Chart in Excel [Yes, we can edition]	Product Recommendation � Excel Lookup Toolbox
29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]	Incell Dot Plots in Microsoft Excel
Excel Tips Submitted by You [Part 4]	Excel Tips Submitted by You [Part 3]
Excel Tips Submitted by You [Part 2]	Weekly Excel Links – After a Long Time Edition
Advanced Data Validation Techniques in Excel [spreadcheats]	vlookup(), match() and offset() – explained in plain english [spreadcheats]

max()

29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]	Incell Dot Plots in Microsoft Excel
Excel Tips Submitted by You [Part 1]	Using Array Formulas in Excel – Find if a list has duplicate items
Formula Debugging in Excel – Tip [spreadcheats]	Introducing Excel Formula Helper

micro charts

Microsoft Excel Conditional Formatting

more articles on Microsoft Excel Conditional Formatting »

Microsoft Excel Formulas

50 Best Cities for Finding a Job [Incell Dashboard using Excel]	Formula 1 Style Sorting of Times (Durations) in Excel
Create a number sequence for each change in a column in excel [Quick Tip]	Excel Formula 1 – Really Fast way to learn Excel Formulas
Hide Formula Errors While Printing [Quick tip]	Excel Tips Submitted by You [Part 3]
Announcing “Your Week” @ PHD	Using Credit Card Numbers in Excel
Highlight Top 10 Values using Excel Conditional Formatting	New Improved Version of Excel Formula Help
Quickly Change Formulas Using Find / Replace	Automatically insert timestamps in excel sheet using formulas
Seperating digits from a number [excel formulas]	Eight ways to exploit COUNTIF() … and sumif() too [spreadcheats]
Excel Formula for Finding Repeated Words in a Cell	Relative vs. Absolute References in Formulas [spreadcheats]
Calculating Paydays in a calendar year using Excel	Splitting text in excel using formulas
How to count words in a cell using excel functions

more articles on Microsoft Excel Formulas »

mouse shortcuts

named ranges

now()

Calculate Elapsed Time in Excel [Quick Tips]	Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]
Automatically insert timestamps in excel sheet using formulas

number formatting

more articles on number formatting »

numbers

Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]	Create a number sequence for each change in a column in excel [Quick Tip]
Seperating digits from a number [excel formulas]	Bingo / Housie Ticket Generator in Excel

Office 2010

OFFSET()

Top X chart – Show Top X values of a chart Interactively	Excel Links of the week [After a long time edition]
Making a chart with dynamic range of values	29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]
Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]	Calculate Moving Average
Visualizing Search Terms on Travel Sites – Excel Dashboard	Advanced Data Validation Techniques in Excel [spreadcheats]
vlookup(), match() and offset() – explained in plain english [spreadcheats]	Make your VBA macros work anywhere: Enable Relative References

paste-special

Fix Incorrect Percentages with this Paste-Special Trick	Transpose Excel Rows and Columns [Quick Tip + Video]
Copy Data Validations from one cell to another [quick tip]	Twins, Clones and Duplicates – 6 Excel Shortcuts from an Excited Dad
Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)	Skip Blank doesnt skip blank cells ?!?
Weekly Links – Even More Downloads Edition	Copy like a cat – paste like a pro : 17 excel pasting tricks you must know

personal finance

more articles on personal finance »

pie charts

pivot tables

portfolio tracker

more articles on portfolio tracker »

printing

Print Worksheets in One Page Across [Quick Tips]	How to Print Excel Comments
10 Supercool UI Improvements in Excel 2010	Want to become a Data God? Learn Excel Data Tables
Converting Excel to PDF – Everything you need to know	Hide Formula Errors While Printing [Quick tip]
Excel Links of the Week – Minor Changes to PHD edition	Excel Links of the Week [Jan 12]

productivity

Format Charts Faster in Excel 2007 [quick tips]	10 Tips to Make Better and Boss-proof Excel Spreadsheets
How to get Excel 2003 Toolbars in Excel 2007 [productivity hack]	What buttons you have in the excel quick access bar ? [weekend poll]
Master Excel 2007 Ribbon with this Free Learning Guide	Pin Frequently Used Documents to File Menu to Save Time
Do you know these Double-click Tricks in Excel?	Excel Tips Submitted by You [Part 2]
Announcing “Your Week” @ PHD	How to use Excel Chart Templates and Save Time
5 Areas where Mouse Kicks Keyboard’s Butt	Use Enter to Paste Copied Values in Excel [Quick Tip]
15 MS Excel Tips to Make you a Productivity Guru	Simple Todo List application using Excel – Download and become productive
Clean up Incorrectly Formatted Phone Numbers using Excel	Gmail Labs 2 new useful features – Mark as Read, Label Auto Suggest
Date with my sheet – 10 tips on using date / time in excel	Switch between firefox tabs using mouse scroll wheel
Beyond If and Sum, 15 really useful excel formulas for everyone	Analyze your blog post’s readability with Google docs
11 very useful excel keyboard shortcuts you may not know	Mute conversations in Gmail to not follow a specific thread of mails
Improve productivity by opening same excel sheet in 2 windows – quick tip	Gantt in 60 seconds – churn out an excel project plan in no time
Open your favorite sites directly from Windows XP run dialog box	Change cell formats with find-replace in excel
73 Free Designer Quality Excel Chart Templates – Grab now and become a charting superman	3 excel keyboard shortcuts that can save a lot of time for you

products

Would you be interested in an online excel training program?	Product Recommendation – Excel Dashboard Training Kit
50% off on ExcelUser’s Dashaboard Kit [2 days only]	Announcing PHD Thanksgiving Sale
One Hundred Project Managers have chosen to be better, what about you?	The funnest way to learn excel formulas
How simple is your product?

project management

Know your internship insideout	The ultimate management book series
Accounting of Exams !	Ideas … Infinite!
grades, links, threads and deadlines	Mission Statement of Group 7

more articles on project management »

project management templates

more articles on project management templates »

quick acess toolbar

more articles on quick acess toolbar »

quick tip

random

Generating Random Phone Numbers	Sorting a list of items in random order in excel – using formulas
Simulating Dice throws – the correct way to do it in excel	Shuffle a list of numbers / items in excel spreadsheet
Worst bar chart ever? – World�s Most Expensive Places to Have Sxx

reader questions

more articles on reader questions »

references

Want to become a Data God? Learn Excel Data Tables	Make your VBA macros work anywhere: Enable Relative References
Relative vs. Absolute References in Formulas [spreadcheats]

rept

Use “Script” font to make your incell charts realistic [quick-tips]	50 Best Cities for Finding a Job [Incell Dashboard using Excel]
Incell Dot Plots in Microsoft Excel	Incell Bar charts – Revisited

reviews

Product Recommendation – Excel Dashboard Training Kit	What is PowerPivot? (and does it really wear underwear on top of pants !?!)
7 ideas Excel can pick-up from iWork Numbers	The funnest way to learn excel formulas
Converting Excel to PDF – Everything you need to know	Web Analytics Dashboard by Percent Mobile is Fun [Dashboard Reviews]
Excel 2007 Review – 10 things that WOWed me	Hot Fuzz – must watch for comedy lovers

ribbon

Excel Links – What are your plans for 2010 Edition	Use CTRL+F1 to collapse ribbon [super-mini-quick-tip]
Use Cell Styles to Make your Spreadsheet Models User-friendly [Quick Tip]	Master Excel 2007 Ribbon with this Free Learning Guide
Hide Grid Lines [Quick Tip]	Remove Duplicates [Quick Video Tip]
Do you know these Double-click Tricks in Excel?	Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)
Hide a Workbook from Nosy Colleagues [quick tip]

rows()

Reverse a List using Formulas [Using Excel INDEX() Formula]	Top X chart – Show Top X values of a chart Interactively
Recipe for a Donut Bar Chart	Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]
Formula 1 Style Sorting of Times (Durations) in Excel	How to Round and Sort Data using Excel Formulas?

scatter charts

screencasts

Pivot Table Tricks to Make You a Star	Flu Trends Chart in Excel [Yes, we can edition]
Dr. Scroll-bar Mortgage Calculator or: Why you should not be borning and use form controls	Extract usernames from E-mail IDs [using LEFT and FIND formulas in Excel]
Collapse, Expand Excel Charts using this hidden trick	A New Year Resolutions Template that Kicks Ass
Grouping Dates in Pivot Tables	Top X chart – Show Top X values of a chart Interactively
Switch Rows and Columns in Charts [Quick Charting Tip]	Solve Sudoku Puzzles using Excel [because it is weekend]
How to get Excel 2003 Toolbars in Excel 2007 [productivity hack]	Making a chart with dynamic range of values
Another Reason why Tables are so awesome [quick tip]	Use Cell Styles to Make your Spreadsheet Models User-friendly [Quick Tip]
Recipe for a Donut Bar Chart	Want to become a Data God? Learn Excel Data Tables
Dynamically Grouping Related Events [Excel Combo Charts with Pizzazz]	Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]
Remove Duplicates [Quick Video Tip]	Gantt Charts – Project Management Using Excel [Part 1 of 6]
Statistical Distributions in Excel [spreadcheats]

search

Excel Tips Submitted by You [Part 2]	Search a Spreadsheet Full of Data using Conditional Formatting
“I am feeling lucky” Firefox Search plug-in	Pointy growth inside nose and other such meaningless junk

secondary axis

shortcuts

Twins, Clones and Duplicates – 6 Excel Shortcuts from an Excited Dad	Announcing “Your Week” @ PHD
Excel Links of the Week – The Mt. Rainier edition	11 very useful excel keyboard shortcuts you may not know
Improve productivity by opening same excel sheet in 2 windows – quick tip	3 excel keyboard shortcuts that can save a lot of time for you

simulation

Deal or No Deal – Download and Play the Popular TV Game Show in Excel	Simulating Dice throws – the correct way to do it in excel
Here is a simple way to get Rs. 70 Lakhs when you are 55 – DONT touch your PF

small

29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]	Formula 1 Style Sorting of Times (Durations) in Excel
How to Round and Sort Data using Excel Formulas?	Incell Dot Plots in Microsoft Excel
Highlight Top 10 Values using Excel Conditional Formatting

sorting

Want to become a Data God? Learn Excel Data Tables	Formula 1 Style Sorting of Times (Durations) in Excel
How to Round and Sort Data using Excel Formulas?	Sorting Text in Excel using Formulas
Sorting a list of items in random order in excel – using formulas	Shuffle a list of numbers / items in excel spreadsheet
Changing Sort Orientation in Excel – Sorting across columns instead of rows

spreadcheats

Collapse, Expand Excel Charts using this hidden trick	Print Worksheets in One Page Across [Quick Tips]
What is Excel SUMPRODUCT formula and how to use it?	Prevent Duplicate Data Entry using Cell Validations
Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one	Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]
Build a Retirement Calculator using Excel (learn how to use Goal Seek as a bonus)	Do you know these Double-click Tricks in Excel?
Statistical Distributions in Excel [spreadcheats]	Create a Dynamic Chart in Excel in 2 Minutes [spreadcheats]
Calculate Moving Average	Excel Formula Errors – Understand and Debug Them
Using Array Formulas in Excel – Find if a list has duplicate items	Excel Conditional Formatting Basics
How to use Excel Chart Templates and Save Time	5 Areas where Mouse Kicks Keyboard’s Butt
Quickly Change Formulas Using Find / Replace	“Too Many Worksheets” Driving You Nuts? Read This!
Make a Dynamic Chart using Data Filters	Employee Satisfaction Surveys using MS Excel
Colors in Chart Labels [Quick Tip]	Excel Basics – What are Combination Charts and How to Make One?
Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]	Use Alt+Enter to get multiple lines in a cell [spreadcheats]
Formula Debugging in Excel – Tip [spreadcheats]	What is camera tool and how to use it? [spreadcheats]
Advanced Data Validation Techniques in Excel [spreadcheats]	vlookup(), match() and offset() – explained in plain english [spreadcheats]
Eight ways to exploit COUNTIF() … and sumif() too [spreadcheats]	Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]
Relative vs. Absolute References in Formulas [spreadcheats]	Introducing Spreadcheats – Become Supergood with Excel in 30 days

stacked bar

statistics

Statistical Distributions in Excel [spreadcheats]	Sports Statistics Dashboard in Excel – Few More Alternatives
Analyze your blog post’s readability with Google docs

stock

Tracking your stock portfolio using Google Docs	Mutual Fund Portfolio Tracker using MS Excel
My screen just widened!	The Calvin Fund!
Google Life!	Now…
Shareholders, value creation and all that bushllit	Online Advertising
getLatestUpdates()	4Ls – Link, Laughter, Lazyness, Losses
bullCheat, bto and gut feelings

stock charts

substitute()

29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]	Analyzing Search Keywords using Excel : Array Formulas in Real Life
Generating Random Phone Numbers	Excel Formula for Finding Repeated Words in a Cell

sum()

29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]	Sumif with multiple conditions [quick tip]
Analyzing Search Keywords using Excel : Array Formulas in Real Life

sumif()

What is Excel SUMPRODUCT formula and how to use it?	Product Recommendation � Excel Lookup Toolbox
29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]	Sumif with multiple conditions [quick tip]
Eight ways to exploit COUNTIF() … and sumif() too [spreadcheats]	Learn Excel IF Formula – 5 Tricks you Didnt know

sumproduct

Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]	Christmas Gift List – Set your budget and track gifts using Excel
What is Excel SUMPRODUCT formula and how to use it?	Product Recommendation � Excel Lookup Toolbox
Project Management Dashboard / Project Status Report using Excel [Part 6 of 6]	29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]
Count the number of unique values in a range [Quick Tip]	Excel Time Sheets and Resource Management [Project Management using Excel - Part 4 of 6]

tables

Want to become a Data God? Learn Excel Data Tables	Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6]
5 Awesome Info-graphics for your Inspiration [Dec 19]	Excel Links of the Week [Dec 15]

Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations	Track Your Mutual Fund Portfolio using Excel [India Only]
Make a Quick Thermometer Chart to Compare Targets and Actuals	2010 Calendar – Excel Template [Downloads]
Personal Budget Spreadsheet [Downloads]	The Project Management Bundle for Excel is Here, Download your copy today
Recipe for a Donut Bar Chart	Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6]
Excel Time Sheets and Resource Management [Project Management using Excel - Part 4 of 6]	Use burn down Charts in your project management reports [bonus post]
2009 Calendar Template in Excel – Now with week starting on Monday	Google Spreadsheets Holiday Art Template
Excel Links of the Week – All Downloads at One Place Edition	Replace Radar Charts with Tables to Make Comparison Easy
73 Free Designer Quality Excel Chart Templates – Grab now and become a charting superman

text processing

timelines

A Brief History of Microsoft Excel – Timeline Visualization	Project Management: Show Milestones in a Timeline [Part 3 of 6]
Featured Visualizations – Jan 02	5 Visualizations for Your Inspiration [Nov 14]

transpose

Transpose Excel Rows and Columns [Quick Tip + Video]	Switch Rows and Columns in Charts [Quick Charting Tip]
Member of month, Excel links and Cooked HDD

twitter

Are you excited about this twitter chart?	Tweetboard Implementations – Download and make your twitter style dashboard today
Excel Links of the Week – What is really happening Edition	Weekly Links – Even More Downloads Edition
Write Your Own Twitter Client using Microsoft Excel

udf

Track Your Mutual Fund Portfolio using Excel [India Only]	Get cell comments using Excel Formula
29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]	Networkingdays() an improved version of networkdays formula
Clean up Incorrectly Formatted Phone Numbers using Excel	Handling spelling mistakes while searching your data using excel
Microcharting in Excel – 7 Alternatives Reviewed	Conditionally play sounds when a cell value changes
Extract URLs from an excel spreadsheet cell using UDFs	How to add a range of cells in excel – concat()

unique

Prevent Duplicate Data Entry using Cell Validations	Create a number sequence for each change in a column in excel [Quick Tip]
What are the formulas you wish Excel had ?

unique items

using color

using excel

VBA

Product Recommendation – Excel Dashboard Training Kit	Excel Links – What are your plans for 2010 Edition
Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations	Excel Links – Learn Excel Online Edition
Excel Links of the Week [Excel Dashboards Edition]	Solve Sudoku Puzzles using Excel [because it is weekend]
Pimp your comment boxes [because it is Friday]	Get cell comments using Excel Formula
Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu	Excel Links – Bacon bits are good edition
Networkingdays() an improved version of networkdays formula	Venn Diagrams in Excel
Now Edit Google Spreadsheets using MS Excel	Excel Tips Submitted by You [Part 4]
Excel Tips Submitted by You [Part 1]	Analyzing Search Keywords using Excel : Array Formulas in Real Life
Weekly Links – Even More Downloads Edition	Write Your Own Twitter Client using Microsoft Excel
How to Hide Worksheet Tabs in Excel Workbook	Excel Links of the Week [Jan 12]
Creating Excel Art from Images [spreadsheet fun]	Excel Links of the Week [Dec 15]
Excel Links of the Week [Dec 1]	Make your VBA macros work anywhere: Enable Relative References
Excel Links of the Week – Do you want to run 10k with me edition	Excel Links of the Week – What the heck happened to photographic fridays edition
More than 3 Conditional Formats in Excel	Simple Todo List application using Excel – Download and become productive
Clean up Incorrectly Formatted Phone Numbers using Excel	Handling spelling mistakes while searching your data using excel
Power Outage & 99 Excel Tips to keep you Busy	Microcharting in Excel – 7 Alternatives Reviewed
Conditionally play sounds when a cell value changes	Extract URLs from an excel spreadsheet cell using UDFs
How to add a range of cells in excel – concat()	Create Cool Tag Clouds in Excel using VBA

videos

Excel School Online Training – More Details	What is PowerPivot? (and does it really wear underwear on top of pants !?!)
Transpose Excel Rows and Columns [Quick Tip + Video]	Dashboard Best Practice – Google Analytics Intelligence Report
How to get Excel 2003 Toolbars in Excel 2007 [productivity hack]	Make a Bubble Chart in Excel [15 second tutorial]
Make a Pivot Table in Excel [15 Second Tutorial]	Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial]
Remove Duplicates [Quick Video Tip]	Tiger Woods walks on water to please a fan – Awesome advertising

visualization principles

more articles on visualization principles »

visualizations

Best Sales Dashboards, as Voted by You [Visualization Challenge #2 - Winners]	Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations
Best Charts to Compare Actual Values with Targets – What is your take?	Use Shapes and Images to make Prettier Charts [Dashboard Tricks]
Group Smaller Slices in Pie Charts to Improve Readability	Waterfall Charts using Excel
Are you excited about this twitter chart?	Charting Lessons from Optical Illusions
14 Basic Skills for Chart Makers (Big question: How many do you have?)	Project Management: Show Milestones in a Timeline [Part 3 of 6]
Excel Links – Bacon bits are good edition	Gantt Charts – Project Management Using Excel [Part 1 of 6]
Bring out your bad charts, the ChartBusters are here…	Interviewing Garr Reynolds on this Friday, send me your questions
Incell Dot Plots in Microsoft Excel	Venn Diagrams in Excel
Tweetboard Implementations – Download and make your twitter style dashboard today	What is Your Opinion on Pie Charts?
A Good Bubble Chart About the Bust	Do you know how to KISS, Wall Street Journal Does!
Featured Visualizations – Jan 09	5 Awesome Info-graphics for your Inspiration [Dec 19]
Parking Tickets in New York – Cool Interactive Visualization from NYTimes	Fun way to clean up modern art with visualization
5 visualizations to inspire you [Nov 21]	5 Visualizations for your Inspiration [Nov 07]
Select & Show One Chart from Many	Sports Statistics Dashboard in Excel – Few More Alternatives
Sports Dashboards in Excel – A Tutorial	Visualizations of the Week [Oct 10]
Red vs. Blue – 35 Cool Visualizations on 2008 US Presidential Election	Visualizing Sex & Love – 10 Infographics You Must See

vlookup

Flu Trends Chart in Excel [Yes, we can edition]	Track Your Mutual Fund Portfolio using Excel [India Only]
Christmas Gift List – Set your budget and track gifts using Excel	Excel Links of the Week [Excel Dashboards Edition]
Top X chart – Show Top X values of a chart Interactively	Product Recommendation � Excel Lookup Toolbox
29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]	Generating invoice numbers using excel [reader questions]
Excel Tips Submitted by You [Part 3]	Excel Links of the Week – What is really happening Edition
vlookup(), match() and offset() – explained in plain english [spreadcheats]	Excel Links of the Week – What the heck happened to photographic fridays edition
Learn Excel IF Formula – 5 Tricks you Didnt know	on vlookup()
Mutual Fund Portfolio Tracker using MS Excel