Learn Excel by Topic

array formulas

more articles on array formulas »

axis formatting

more articles on axis formatting »

bad charts

more articles on bad charts »

bar charts

more articles on bar charts »

bubble charts

more articles on bubble charts »

cell comments

more articles on cell comments »

Chart Busters

more articles on Chart Busters »

chart tamer

more articles on 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 VisualizationSales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations
Best of Pointy Haired Dilbert – 2009Make 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 EditionFormat 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 #2Top 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 Chart5 Things you probably dont know about this site
Twins, Clones and Duplicates – 6 Excel Shortcuts from an Excited DadPareto 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 StoriesWelcome 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 ExcelVenn 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” @ PHDTweetboards – 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 Editionand the Winner is…
Budget vs. Actual Charts – 14 Charting Ideas You can UseInterview with John Walkenbach on Excel and Banjo Charts…
Visualization Challenge – Budget vs. Actual PerformanceUs vs. Them – Compare Sales Performance using Charts & Form Controls
RSS Icon using Donut Charts – Because it is WeekendJapanese Candlestick Chart – Excel Tutorial
How Many Bubbles are Too Many Bubbles?Market Segmentation Charts using Conditional Formatting
Make a Dynamic Chart using Data FiltersReview 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 editionDo 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 charts5 Beautiful Visualizations [Oct 24]
Sports Statistics Dashboard in Excel – Few More AlternativesReader Poll: Should the axis for bar charts always start at zero?
Sports Dashboards in Excel – A TutorialThe 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 SeeWeekly 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 BusyInfographics of the week [Sep 12]
Hack together a Gauge Chart in Excel without sweatCool Info-graphics of the Week [Sep 5]
Microcharting in Excel – 7 Alternatives Reviewed6 charts you will see in hell
Display symbols in excel chart axisIt 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 – RevisitedPartition Charts in Excel – alternative to pie charts [visualization hack]
Gantt in 60 seconds – churn out an excel project plan in no timeCreate Cool Tag Clouds in Excel using VBA
more articles on charting »

cleanup data

more articles on cleanup data »

column charts

more articles on column charts »

combo charts

more articles on combo charts »

data filters

more articles on data filters »

data labels

more articles on data labels »

data processing

more articles on data processing »

data series

more articles on data series »

data validation

more articles on data validation »

date and time

more articles on date and time »

donut charts

more articles on 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 VisualizationCollapse, Expand Excel Charts using this hidden trick
A New Year Resolutions Template that Kicks AssHighlighting Repeat Customers using Conditional Formatting [Part 2 of 2]
Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & ImplementationsTrack Your Mutual Fund Portfolio using Excel [India Only]
How to Find Dates of Public Holidays using ExcelMake 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 ExcelProject 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 todayBaby 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 WayIssue 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 ExcelExcel 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 ExcelNetworkingdays() an improved version of networkdays formula
Tweetboard Implementations – Download and make your twitter style dashboard todayStatistical Distributions in Excel [spreadcheats]
Intraday Candlestick Charting [Stock Charts]Tweetboards – Alternative to traditional management dashboards
Highlight Top 10 Values using Excel Conditional FormattingExcel Conditional Formatting Basics
Us vs. Them – Compare Sales Performance using Charts & Form ControlsExcel Links of the Week – Free E-Book Edition
RSS Icon using Donut Charts – Because it is WeekendJapanese Candlestick Chart – Excel Tutorial
Market Segmentation Charts using Conditional FormattingWeekly Links – Even More Downloads Edition
Write Your Own Twitter Client using Microsoft ExcelVisualizing Search Terms on Travel Sites – Excel Dashboard
Sales Funnel Charts in Excel – TutorialExcel Basics – What are Combination Charts and How to Make One?
2009 Calendar Template in Excel – Now with week starting on MondayBrick 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 EditionExtracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]
Select & Show One Chart from ManyAdding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]
Sports Dashboards in Excel – A TutorialMore 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 ExcelSimple Todo List application using Excel – Download and become productive
Clean up Incorrectly Formatted Phone Numbers using ExcelYou 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 GraphsLearn Excel IF Formula – 5 Tricks you Didnt know
Mutual Fund Portfolio Tracker using MS Excel73 Free Designer Quality Excel Chart Templates – Grab now and become a charting superman
How to: sharing trip expenses using excel
more articles on downloads »

dynamic charts

more articles on dynamic charts »

excel 2007

more articles on excel 2007 »

Excel 2010

more articles on Excel 2010 »

excel add-ins

more articles on excel add-ins »

excel apps

more articles on excel apps »

excel mvps

more articles on excel mvps »

excel tables

more articles on excel tables »

expense tracker

more articles on expense tracker »

form controls

more articles on form controls »

freeze panes

more articles on freeze panes »

john walkenbach

more articles on john walkenbach »

line charts

more articles on line charts »

list posts

more articles on list posts »

micro charts

more articles on micro charts »

mouse shortcuts

more articles on mouse shortcuts »

named ranges

more articles on named ranges »

Office 2010

more articles on Office 2010 »

pie charts

more articles on pie charts »

pivot tables

more articles on pivot tables »

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 GuidePin 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” @ PHDHow to use Excel Chart Templates and Save Time
5 Areas where Mouse Kicks Keyboard’s ButtUse Enter to Paste Copied Values in Excel [Quick Tip]
15 MS Excel Tips to Make you a Productivity GuruSimple Todo List application using Excel – Download and become productive
Clean up Incorrectly Formatted Phone Numbers using ExcelGmail Labs 2 new useful features – Mark as Read, Label Auto Suggest
Date with my sheet – 10 tips on using date / time in excelSwitch between firefox tabs using mouse scroll wheel
Beyond If and Sum, 15 really useful excel formulas for everyoneAnalyze your blog post’s readability with Google docs
11 very useful excel keyboard shortcuts you may not knowMute conversations in Gmail to not follow a specific thread of mails
Improve productivity by opening same excel sheet in 2 windows – quick tipGantt in 60 seconds – churn out an excel project plan in no time
Open your favorite sites directly from Windows XP run dialog boxChange cell formats with find-replace in excel
73 Free Designer Quality Excel Chart Templates – Grab now and become a charting superman3 excel keyboard shortcuts that can save a lot of time for you
more articles on productivity »

quick tip

more articles on quick tip »

scatter charts

more articles on scatter charts »

secondary axis

more articles on secondary axis »

spreadcheats

Collapse, Expand Excel Charts using this hidden trickPrint 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 oneUse 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 AverageExcel Formula Errors – Understand and Debug Them
Using Array Formulas in Excel – Find if a list has duplicate itemsExcel Conditional Formatting Basics
How to use Excel Chart Templates and Save Time5 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 FiltersEmployee 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
more articles on spreadcheats »

stacked bar

more articles on stacked bar »

stock charts

more articles on stock charts »

tag cloud

more articles on tag cloud »

text processing

more articles on text processing »

unique items

more articles on unique items »

using color

more articles on using color »

using excel

more articles on using excel »

VBA

Product Recommendation – Excel Dashboard Training KitExcel Links – What are your plans for 2010 Edition
Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & ImplementationsExcel 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 snafuExcel Links – Bacon bits are good edition
Networkingdays() an improved version of networkdays formulaVenn Diagrams in Excel
Now Edit Google Spreadsheets using MS ExcelExcel 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 EditionWrite Your Own Twitter Client using Microsoft Excel
How to Hide Worksheet Tabs in Excel WorkbookExcel 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 editionExcel Links of the Week – What the heck happened to photographic fridays edition
More than 3 Conditional Formats in ExcelSimple Todo List application using Excel – Download and become productive
Clean up Incorrectly Formatted Phone Numbers using ExcelHandling spelling mistakes while searching your data using excel
Power Outage & 99 Excel Tips to keep you BusyMicrocharting in Excel – 7 Alternatives Reviewed
Conditionally play sounds when a cell value changesExtract 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
more articles on VBA »

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 ReadabilityWaterfall 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 editionGantt 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 ExcelVenn Diagrams in Excel
Tweetboard Implementations – Download and make your twitter style dashboard todayWhat is Your Opinion on Pie Charts?
A Good Bubble Chart About the BustDo you know how to KISS, Wall Street Journal Does!
Featured Visualizations – Jan 095 Awesome Info-graphics for your Inspiration [Dec 19]
Parking Tickets in New York – Cool Interactive Visualization from NYTimesFun 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 ManySports Statistics Dashboard in Excel – Few More Alternatives
Sports Dashboards in Excel – A TutorialVisualizations of the Week [Oct 10]
Red vs. Blue – 35 Cool Visualizations on 2008 US Presidential ElectionVisualizing Sex & Love – 10 Infographics You Must See
more articles on visualizations »

web queries

more articles on web queries »

your week

more articles on your week »
Create Excel dashboards quickly with Plug-N-Play reports.


Project Management Templates for Excel