Hi all,

These are some Excel Links I have collected over time. Refer to them for some useful tricks, advice or amusement.

• 14 misconceptions about charts and graphs
• 9 steps to better chart formatting
• The perils of hidden cells
• Handling CSV files when the content has genuine commas
• Don’t forget about the A in VBA
• Spell check and Excel formulas
• Handling Duplicates in Google Docs
• ACDC Rocks – ASCII Video in Excel
• Passion, not charts – Steve Jobs at Whiteboard
• 200+ Excel Tips & Articles: by David McRitchie
• Going to that Special Cell in Excel
• Drawing in Excel – Using co-ordniates to generate huge drawings
• Exporting a range of cells as a picture – vba macro
• Christmas Planner in Excel
• 2×2 Panel Charts
• Finding Prime Numbers using Excel
• Convert Excel Tables to HTML
• Back up excel files while you work using VBA
• Charts that make you go wtf
• Introduction to Error Bars in Charts
• Tell about your fav VBA code and win Excel goodies
• There are only 14 different calendars, really!
• Use RegEx in Excel Find
• Number Spirals in Excel
• Huge Data for Simulations and Experimentation
• Another Excel Clone, this time with Python goodness
• Check your Excel Version using VBA
• How to print an excel sheet in one page?
• Excel Tutorial : Naming a range
• Why you cannot open two excel files with same name
• Understand Stock Charts in Excel
• Choose the Right Chart Using this Flow Chart
• Quickly Create Named Ranges using F4 Key
• Print Multiple Areas from Several Sheets by Creating a Consolidation Sheet
• Get a List of Filenames in a Directory to Excel using Browser
• Excel to Twitter, now in Add-in Format
• Bars are good, only when focus + context are taken care
• Use mouse to paste as values
• Simple Expense Tracker using Excel 2007 Features
• Leaving the door open could cause excessive CPU load
• Match multiple items instead of one – using UDFs
• Data Validation Trick – Use the same source, but validate differently
• How can you add 2 legends in a chart
• How to put images in a cell comment
• Chart Tamer Beta Released – Future Looks Bright and Clear
• More Data Validation Goodness, Dynamic Ranges in Validation Lists
• Import Delicious Bookmarks to Excel
• Excel date format conversion causes irrevocable damage to gentic research teams
• A Robust String Concatenation Function
• 2 Simple things you should know to be a great presenter
• Making Your Random Numbers Unique
• Simple Charts Always Rule
• Bingo Cards – US Style
• Prepare Your Data for Charting
• Make Office Better
• 10 Tips on thinking like a designer
• How databars are improved in Excel 2010
• Transposing a dataset with Pivot tables
• Use Microsoft Chart Advicer to make Better Charts
• Make table of contents with just dragging
• Understand the PowerPivot for Excel 2010
• Learn Excel OFFSET Function Interactively
• Why gradient fills can be bad for your charts?
• Charting when you have lots of data – Unemployment Data Case Study
• VBA Macro to automatically back up excel files
• Mimicking Slicer feature in Excel 2007 and earlier
• Copying Vlookup Formulas – the easy way
• Highly Recommended: Watch Hans Rosling’s Chart Magic in TED India
• Getting Started with VBA? – Free online lessons
• Introduction to VBA – How to get started?
• Create a Zoombox in Excel
• How to chart when one data point is too large
• How to build Excel Addins
• Making your own “Hello World” button in Ribbon
• An Excel Tree Map Addin
• Rental Popularity of Movies – NY Times Visualization of Netflix Data
• Edit Multiple Sheets using Group Feature
• Understand color to make better charts
• A new version of Bible, in excel
• Solve word puzzles with Excel
• Use dot plots instead of pies to compare categories
• This ink-blot chart breaks some rules, but succeeds
• A brilliant use of Excel – Chess Game Viewer using Scatter Plots
• A good round up of Active-x Controls in Excel
• A cumulative spending chart goes crazy and Chartbuster rightly fixes it
• When should we celebrate the “Spreadsheet day”?
• Data in, Brilliance out @ Tableau Public
• Importing Text to Excel – All you need to know
• Data Pig’s New Book on Excel and Access – First Chapter Free
• How to use custom lists to change the sort order
• Why stacked bar charts are not such a good idea
• Transferring data within VBA Macros
• Project Management using Excel
• YuMMMMMy Custom Format Code for One Letter Months
• Automatic Table of Contents in Excel with a Macro
• Right brian or left brian – which one is your chart addressing?
• Create Pivot Tables from Data in Multiple Sheets
• What is new in Excel 2010?
• Importing Text Files into Excel – a Primer
• Chart Makeovers – Interesting Case Study
• Combine Data and Charts in your Dashboards
• Know Scatter Plot Matrix
• Generating Sample Data for Your Excel Adventures
• Beginners Guide to Web Analytics (and why you should read it)
• Start your next dashboard with a sentence
• Excel Tetris Game!
• Embed Wordle word clouds in to Excel
• Fill a combo box with unique values – Excel Recordset Tricks

Share an Excel Link with me

Simple, just email your link to me at chandoo.d @ gmail.com or tweet it to @r1c1. If I like the link, I will share it with our readers thru a post or tweet.

More Excel Links

Browse thru my Google Reader shared list or excel links category posts for more links to useful Excel Resources on the web.

Thanks.