Archive of All Excel Related Posts

Subscribe to our RSS Feed to receive new excel tips as they are posted.

Click on any link to read the articles. (other views – Excel Tips Category view shows summaries for latest 7 post)

How to Get Unique Items using Excel

3 Steps to Create cool dashboards in excel

Howto: Excel Based Mutual Fund Portfolio Tracker

Find out whether you need a house or not in 60 seconds

Excel Charting Hacks #1

Do you know that Excel cant …

Is Monopoly Fair?

Say NO to Default Charts Forever!

Start Early

The Art of Excel Charting

How to: sharing trip expenses using excel

Custom Cell Formatting in Excel – Few Tips & Tricks

Conditional Formatting in Excel – 5 Tips to make you a Rockstar

3 excel keyboard shortcuts that can save a lot of time for you

Track / share your goals using Google Spreadsheet Gadgets

73 Free Designer Quality Excel Chart Templates – Grab now and become a charting superman

Change cell formats with find-replace in excel

Powerpoint Cartoons #3 – Auto fill

How to get more colors in excel chart – simple trick

Generate organization charts in excel – howto?

Mutual Fund Portfolio Tracker using MS Excel

Create Cool Tag Clouds in Excel using VBA

on vlookup()

Create in-cell pie charts in Excel

Creating in-cell bar charts / histograms in excel

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

How to add a range of cells in excel – concat()

Improve productivity by opening same excel sheet in 2 windows – quick tip

Learn Excel IF Formula – 5 Tricks you Didnt know

Formatting numbers in excel – few tips

Quickly display unique items in an excel list using advanced filters

Get Stock Quotes in Excel

Hot Thermometer Charts in Excel – here is a cool way to do them

Skip weekends while autofilling dates in excel

Copy like a cat – paste like a pro : 17 excel pasting tricks you must know

How to count words in a cell using excel functions

Partition Charts in Excel – alternative to pie charts [visualization hack]

Partition Charts – Continuation – [More visualization fun]

Use Google docs to track your bucks – [spreadsheet forms idea]

Incell Bar charts – Revisited

Bingo / Housie Ticket Generator in Excel

Improve your in-cell charts with colors and negative values

Excel Bullet Graphs

Excel Links – to iPhone or not to iPhone edition

Changing Sort Orientation in Excel – Sorting across columns instead of rows

Extract URLs from an excel spreadsheet cell using UDFs

Shuffle a list of numbers / items in excel spreadsheet

11 very useful excel keyboard shortcuts you may not know

Excel Links of the week

Want to Feed RSS to your Excel Sheet? Read this!

Excel can be Exciting – 15 fun things you can do with your spreadsheet in less than 5 seconds

Conditionally play sounds when a cell value changes

Excel links of the week : ‘what can excite you most’ [Aug 4]

Doing the NY times Olympic medals by country year visualization in excel

Dashboarding Fun – Display Smileys in your excel dashboards

Excel Basics: How to add drop down list to validate data

Use min-max charts to show the spread of data – Charting Best Practice

Excel Links of Week – Who is Obama edition? [Aug 12]

The Olympic Medals by Country Chart – Improved now

Beyond If and Sum, 15 really useful excel formulas for everyone

Simulating Dice throws – the correct way to do it in excel

Plot your data around the clock [Excel charting idea]

Polar clock using donut chart [Excel Visualization fun]

Excel Links of the week – What do you dream about? [Aug 19]

It is show time baby! – better designer clocks to display time in your spreadsheets

Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]

Display symbols in excel chart axis

Quickly process text using split() spreadsheet function in google docs

Date with my sheet – 10 tips on using date / time in excel

Excel links of the week – weekend without wire [Aug 26]

Creating KPI Dashboards in Microsoft Excel [Part 2 or 6] – Adding One Click Sort

Aligning charts, objects on spreadsheet [excel layout tip]

Initials from Names using Excel Formulas

6 charts you will see in hell

Management Dashboards – Highlight Values Based on Percentile [Part 3 or 6]

Microcharting in Excel – 7 Alternatives Reviewed

Splitting text in excel using formulas

Excel links of the week [Sep 8]

Hack together a Gauge Chart in Excel without sweat

Excel KPI Dashboards – Adding Micro Charts [Part 4 of 6]

Tracking your stock portfolio using Google Docs

Power Outage & 99 Excel Tips to keep you Busy

Web Page Monitor using Google Docs

Calculating Paydays in a calendar year using Excel

Visualization Challenge – How to show market share changes?

You are NOT spider man, so why do you use radar charts?

Weekly Excel Links – Moved to Seattle Edition

SQL Queries from Excel

Sorting a list of items in random order in excel – using formulas

Handling spelling mistakes while searching your data using excel

Excel Links of the Week [Sep 29]

Clean up Incorrectly Formatted Phone Numbers using Excel

Simple Todo List application using Excel – Download and become productive

The Best of Pointy Haired Dilbert : September 2008

Display decimals only when the number is less than 1 [Excel number formatting tip]

Deal or No Deal – Download and Play the Popular TV Game Show in Excel

Major Updates to Google Docs Spreadsheets App – Menus, Named Ranges, Toolbar

Excel Links of the Week [Oct 06]

Replace Radar Charts with Tables to Make Comparison Easy

Management Dashboards – Compare 2 Decision Parameters [Part 5 of 6]

Excel Links of the Week – The Mt. Rainier edition

More than 3 Conditional Formats in Excel

15 MS Excel Tips to Make you a Productivity Guru

The New Poor – Internet Penetration Rates by Country

Use Enter to Paste Copied Values in Excel [Quick Tip]

Excel Links of the Week – Birthday Edition

Sports Dashboards in Excel – A Tutorial

Reader Poll: Should the axis for bar charts always start at zero?

Sorting Text in Excel using Formulas

Sports Statistics Dashboard in Excel – Few More Alternatives

Excel Links of the Week – What the heck happened to photographic fridays edition

How to NOT spend $ 150,000 and still dress up your charts

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

Introducing Spreadcheats – Become Supergood with Excel in 30 days

Best of Pointy Haired Dilbert – Oct 2008

Excel Links of the Week [Nov 3]

Relative vs. Absolute References in Formulas [spreadcheats]

Select & Show One Chart from Many

Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]

Excel Links of the Week – All Downloads at One Place Edition

Excel Formula for Finding Repeated Words in a Cell

Eight ways to exploit COUNTIF() … and sumif() too [spreadcheats]

How to present changes in Market Share using Charts?

Is your (chart’s) underwear showing?

Seperating digits from a number [excel formulas]

Excel Links of the Week – Do you want to run 10k with me edition

Make your VBA macros work anywhere: Enable Relative References

What would you like to ask Charley Kyd of Exceluser.com in an interview?

vlookup(), match() and offset() – explained in plain english [spreadcheats]

Generating Random Phone Numbers

Introducing Excel Formula Helper

Excel Links of the Week – PHD’s new tag line [Nov 24]

Advanced Data Validation Techniques in Excel [spreadcheats]

Prevent users from scrolling away on your dashboards [dirty little trick]

Say thanks with an excel tip

Excel Links of the Week [Dec 1]

Best of Pointy Haired Dilbert – Nov 2008

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

Free Excel Calendar Template for year 2009 (and all years up to 9999)

Brick Charts in Excel – an Alternative to Gridlines

Interview with Charley Kyd on Everyday Excel

Excel Links of the Week [Dec 15]

Formula Debugging in Excel – Tip [spreadcheats]

2009 Calendar Template in Excel – Now with week starting on Monday

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

Creating Excel Art from Images [spreadsheet fun]

Use Alt+Enter to get multiple lines in a cell [spreadcheats]

Excel Links of the week – the Christmas edition

Excel 2007 Review – 10 things that WOWed me

Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]

Happy New Year to all PHD Readers

Excel Basics – What are Combination Charts and How to Make One?

Weekly Excel Links – Issues with Hosting of PHD

Automatically insert timestamps in excel sheet using formulas

Sales Funnel Charts in Excel – Tutorial

Excel Links of the Week [Jan 12]

What are the formulas you wish Excel had ?

Why No One Likes Your Pie Charts (And What to Do About It)

Visualizing Search Terms on Travel Sites – Excel Dashboard

[Reader Poll] Stacked, Seperated or Mirrored ?

How to Hide Worksheet Tabs in Excel Workbook

Excel Links of the Week – Minor Changes to PHD edition

100 Excel Tips & Resources to Celebrate 2000 RSS Subscribers

Colors in Chart Labels [Quick Tip]

[Weekend Poll] How do you Sex up your Charts?

PHD Excel Formula Helper – Now an E-Book

Best of PHD – Jan 2009

One more method to find unique values in excel and you can call me a dork

Employee Satisfaction Surveys using MS Excel

Write Your Own Twitter Client using Microsoft Excel

Review of PTS Clustered Stack Chart

Weekly Links – Even More Downloads Edition

Make a Dynamic Chart using Data Filters

Excel Colors Somehow Getting Changed ?

“Too Many Worksheets” Driving You Nuts? Read This!

Quickly Change Formulas Using Find / Replace

Market Segmentation Charts using Conditional Formatting

Welcome Robert & ClearlyAndSimply.com to Blogging

Weekly Excel Links – After a Long Time Edition

5 Areas where Mouse Kicks Keyboard’s Butt

Japanese Candlestick Chart – Excel Tutorial

Open Thread For First Time Commenters – What do you like in Excel?

RSS Icon using Donut Charts – Because it is Weekend

Excel Links of the Week – Free E-Book Edition

How to use Excel Chart Templates and Save Time

Us vs. Them – Compare Sales Performance using Charts & Form Controls

Excel Conditional Formatting Basics

New Improved Version of Excel Formula Help

Highlight Top 10 Values using Excel Conditional Formatting

Visualization Challenge – Budget vs. Actual Performance

Skip Blank doesnt skip blank cells ?!?

Excel Links of The Week – Malmo Edition

Using Array Formulas in Excel – Find if a list has duplicate items

Interview with John Walkenbach on Excel and Banjo Charts…

Search a Spreadsheet Full of Data using Conditional Formatting

Using Credit Card Numbers in Excel

There is an Easter Egg in this Post

Excel Formula Errors – Understand and Debug Them

and the Winner is…

Hide a Workbook from Nosy Colleagues [quick tip]

Excel Links of the Week – What is really happening Edition

Calculate Moving Average

Analyzing Search Keywords using Excel : Array Formulas in Real Life

Use Mouse to Edit Formula Ranges [quick tip]

Announcing “Your Week” @ PHD

Excel Tips Submitted by You [Part 1]

Excel Tips Submitted by You [Part 2]

Excel Tips Submitted by You [Part 3]

Excel Tips Submitted by You [Part 4]

Share Your Excel Tips for Your Week – Open Thread

Create a Dynamic Chart in Excel in 2 Minutes [spreadcheats]

Signup for Microsoft Excel 2010 Technical Preview [Office 2010]

Excel Links – Dilbert is Recession-proof Edition

Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)

Hide Formula Errors While Printing [Quick tip]

Array formula to check if a number is prime [just for fun]

Statistical Distributions in Excel [spreadcheats]

Tweetboard Implementations – Download and make your twitter style dashboard today

How to Hide a Cell’s Contents in Excel? [Quick Tip]

Excel Formula 1 – Really Fast way to learn Excel Formulas

Networkingdays() an improved version of networkdays formula

Incell Dot Plots in Microsoft Excel

Do you know these Double-click Tricks in Excel?

Gantt Charts – Project Management Using Excel [Part 1 of 6]

Excel Links – Bacon bits are good edition

Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]

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

How to Round and Sort Data using Excel Formulas?

Project Management: Show Milestones in a Timeline [Part 3 of 6]

Make an Impressive Product Catalog [spreadsheets for small business]

Generating invoice numbers using excel [reader questions]

Build a Retirement Calculator using Excel (learn how to use Goal Seek as a bonus)

Twitter Formula Contest – We are 5000 strong now

The funnest way to learn excel formulas

Excel Time Sheets and Resource Management [Project Management using Excel - Part 4 of 6]

Count the number of unique values in a range [Quick Tip]

Member of month, Excel links and Cooked HDD

Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]

Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one

50 Best Cities for Finding a Job [Incell Dashboard using Excel]

29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]

Get cell comments using Excel Formula

Pin Frequently Used Documents to File Menu to Save Time

Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6]

Want to become a Data God? Learn Excel Data Tables

How to get tick marks in Excel? [custom cell formatting]

Excel Check Boxes, Even Simpler Way

Master Excel 2007 Ribbon with this Free Learning Guide

7 ideas Excel can pick-up from iWork Numbers

Calculate Elapsed Time in Excel [Quick Tips]

Twins, Clones and Duplicates – 6 Excel Shortcuts from an Excited Dad

5 Things you probably dont know about this site

Recipe for a Donut Bar Chart

Use Cell Styles to Make your Spreadsheet Models User-friendly [Quick Tip]

What buttons you have in the excel quick access bar ? [weekend poll]

Project Management Dashboard / Project Status Report using Excel [Part 6 of 6]

Baby Feeding Chart using Excel

10 Tips to Make Better and Boss-proof Excel Spreadsheets

Product Recommendation – Excel Lookup Toolbox

Excel Links of the week [After a long time edition]

What is Excel SUMPRODUCT formula and how to use it?

Top X chart – Show Top X values of a chart Interactively

Excel Links of the Week [Excel Dashboards Edition]

Grouping Dates in Pivot Tables

Transpose Excel Rows and Columns [Quick Tip + Video]

Download Excel 2010 Beta today [Office 2010 Updates]

Reverse a List using Formulas [Using Excel INDEX() Formula]

10 Supercool UI Improvements in Excel 2010

Findout Thanksgiving Day’s Date for Any Year [Excel Formulas]

Excel Links – Learn Excel Online Edition

Dilbert on Excel, Spreadsheets and Cell C23

Christmas Gift List – Set your budget and track gifts using Excel

Use CTRL+F1 to collapse ribbon [super-mini-quick-tip]

2010 Calendar – Excel Template [Downloads]

How to Print Excel Comments

How to Find Dates of Public Holidays using Excel

Best of Pointy Haired Dilbert – 2009

Conditionally Formatting Dates in Excel [Part 1 of 2]

Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]

Excel Links – What are your plans for 2010 Edition

Extract usernames from E-mail IDs [using LEFT and FIND formulas in Excel]

Dr. Scroll-bar Mortgage Calculator or: Why you should not be borning and use form controls

Excel School Online Training – More Details

Delete Blank Rows in Excel [Quick Tip]

Pivot Table Tricks to Make You a Star

Excel Links of the Week – now even more downloads edition

Data Validation using an Unsorted column with Duplicate Entries as a Source List

Excel Keyboard Shortcuts – Open Thread

P&L Reporting using Excel [Part 1 of 6 on Excel & Accounting]

Excel School Registration Opens on Monday (8th Feb, 2010)

Excel School is Open for Admissions

What is Excel SUBTOTAL formula and 5 reasons why you should use it

Preparing Profit / Loss Pivot Reports [Part 2 of 6]

Group Project Activities to Make Readable Gantt Charts

Excel Links – Winner Takes it all Edition

Save a ton of time by using Mouse scroll-wheel to Navigate Excel Ribbon

Excel School Last Call, Closing in Few Hours – Join Now!

Comprehensive List of Excel Keyboard Shortcuts

Adding Calculated Fields to Pivot Table P&L [part 3 of 6]

Writing “Either Or” formula in Excel [Formula Howtos]

Exploring Profit & Loss Reports [Part 4 of 6]

31 Excel Tutorials – Learn and Be Awesome in Excel

Excel Links – Back to India Edition

Making a Dynamic Dashboard in Excel [Part 1 of 4]

Super Timesaver Tip – Add “Select Objects” to Quick Access Toolbar