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.
2 Responses to “Recommended Excel Links & Resources on Web”
[...] Browse more Excel Links or Share a link with me (email me at chandoo.d @ gmail.com) Spread some love,It makes you awesome! Tweet [...]
[...] Browse more Excel links. Spread some love,It makes you awesome! Tweet [...]