SubscribeArchives
Expand All
- May 2012 (7)
- 16: Please Enroll in our Excel & Dashboards Masterclass – Melbourne (0)
- 14: VBA Move data from one sheet to multiple sheets (19)
- 09: Interactive Sales Chart using MS Excel [video] (32)
- 08: Catchup with Chandoo in Perth (0)
- 07: Displaying Text Values in Pivot Tables without VBA (3)
- 03: Formula Forensic 020. Bhavik’s Monthly Workingdays Formula (4)
- 01: Excel Links – Live from Sydney Edition (3)
- April 2012 (16)
- 27: Thank you, I am flying to Australia today! (23)
- 25: An IF Formula Challenge for you (133)
- 24: Lets meet when I am in Australia (9)
- 23: Send mails using Excel VBA and Outlook (17)
- 19: Formula Forensic No 019. Converting uneven Text Strings to Time (19)
- 18: Creating Customer Service Dashboard in Excel [Part 3 of 4] (0)
- 17: Creating Cash Flow Statement by Indirect Method – II (3)
- 16: Compare 2 Excel Files using View side by side Mode [Quick Tip] (9)
- 13: Last chance to sign-up for my Australian Excel Masterclass [Reminder] (6)
- 12: Formula Forensics 018. Retrieving the Nth number from a Range which has Gaps. (2)
- 11: Creating Cash Flow Statement by Indirect Method – I (27)
- 09: Consolidate data from different excel files (VBA) (6)
- 06: There are Easter eggs in this file!!! (49)
- 05: Formula Forensics No. 017 – A Solution to Maljzm’s problem. (9)
- 04: Sign-up for my Excel Dashboard Masterclass in Australia (6)
- 02: Using Excel As Your Database (35)
- March 2012 (16)
- 30: Comprehensive Guide to VLOOKUP & Other Lookup Formulas (11)
- 29: Formula Forensics 016. Suzannes DJIA Average (6)
- 27: 75 Excel Speeding up Tips Shared by YOU! [Speedy Spreadsheet Week] (9)
- 26: Excel Speedup & Optimization Tips by Experts [Speedy Spreadsheet Week] (12)
- 23: Happy Ugadi (32)
- 22: Optimization Tips & Techniques for Excel VBA & Macros [Speedy Spreasheet Week] (17)
- 21: Speeding up & Optimizing Excel – Tips for Charting & Formatting [Speedy Spreadsheet Week] (8)
- 20: Speed up your Excel Formulas [Speedy Spreadsheet Week] (14)
- 19: This week, Speed up your Spreadsheets – Your Action Required (4)
- 14: Data and Calculations for our Customer Service Dashboard [Part 2 of 4] (14)
- 12: What is so special about Go To Special? [15 tips] (8)
- 08: Formula Forensic No. 015 – Cornelia’s Price Rises (16)
- 06: In Cell Text Formats – 2 Quick Tips (10)
- 05: Yet Another Sales Funnel Chart in Excel (36)
- 02: Do you use Pivot Tables? What do you use them for & where do you struggle [Survey] (4)
- 01: Formula Forensic 014 – Faseeh’s Formula (7)
- February 2012 (14)
- 29: 14 ways to check if an year is leap year, using Excel [just for fun] (21)
- 27: How to add your own Macros to Excel Ribbon [quick tip] (4)
- 23: Join my Excel Dashboard Masterclass in Australia [May-June 2012] (7)
- 22: Designing a Customer Service Dashboard in Excel [Part 1 of 4] (20)
- 21: Formula Forensics 013. – On Vacation (2)
- 16: Formula Forensics 012. – A Neat Formula (20)
- 15: Use Text Format to Preserve Leading Zeros in Excel [Quick Tip] (14)
- 14: Reporting Scenarios using Offset (9)
- 13: Learn Statistics & Probability using MS Excel (4)
- 10: How would you customize Excel after installing? [poll] (12)
- 09: Formula Forensics 011. Lykes Formula (10)
- 08: Using external software packages to manage your spreadsheet risk [Part 4 of 4] (7)
- 06: Comparing 2 Lists with a Twist (10)
- 01: Formula Forensics No. 010 Count How Many Times a List of Values Occurs in a Range (16)
- January 2012 (14)
- 31: Custom Number Formats (Multiply & Divide by any Power of 10) (20)
- 30: Excel Links – Live from Bangkok Edition (14)
- 25: Cleaning Up Imported Data – A Recent Case Study (31)
- 24: Formula Forensics No. 008 – Elkhan’s MaxIf (26)
- 18: Excel’s Auditing Functions [Spreadsheet Risk Management - Part 3 of 4] (8)
- 17: Formula Forensics. 009 – Pradhishnair’s Chainage Problem (3)
- 16: Six Quick Updates (4)
- 13: Finding Friday the 13th using Excel (and learning cool formulas along way) (15)
- 11: Announcing Online VBA Classes from Chandoo.org, Please Join Today (9)
- 09: Use CTRL+Enter to Enter Same Data in to Multiple Cells [Quick Tip] (31)
- 06: 12 Steps to become awesome in Excel (and your work) in 2012 (8)
- 05: Quick Update about VBA Classes & Discount Expiry! (1)
- 03: How Companies Can Manage Spreadsheet Risk [Part 2 of 4] (5)
- 02: Free Picture Calendar Template – Download and make a personalized calendar today! (19)
- December 2011 (15)
- 30: Best of Chandoo.org – 2011 (9)
- 28: People & Websites that Helped me in 2011 [Thank you message] (30)
- 27: 2012 Calendar – Excel Template [Downloads] (22)
- 22: Merry Christmas & Happy New Year 2012 (28)
- 21: Formula Forensics. No 007 – Sumproduct (22)
- 19: Join Excel School & Become Awesome in Excel Today! (0)
- 15: Formula Forensics 006. Palindromes (13)
- 14: Shortcut for Long Models (13)
- 12: Learn Any Area of Excel using these 80 Links (19)
- 08: Formula Forensics No. 005 – Zebras and Checker-Boards (15)
- 07: Introduction to Spreadsheet Risk Management (21)
- 05: 8 Tips to Make you a Formatting Pro (15)
- 02: What is one area of Excel you want to learn more? [Survey] (190)
- 01: Make VBA String Comparisons Case In-sensitive [Quick Tip] (5)
- 01: Congratulations Chandoo.org 1,000,000 Page Hits (19)
- November 2011 (12)
- 30: Formula Forensics No.004 – Fred’s Problem (14)
- 29: Maintenance Work Complete (0)
- 23: Christmas Gift Shopping List Template – Set budget, track your gifts using Excel (7)
- 21: Add Data to Charts with Copy Paste [Quick Tip] (3)
- 18: Formula Forensics No. 003 – Lukes Reward (29)
- 16: Making Small Multiples in Excel [Charting Technique] (23)
- 14: Excel for Project Managers program is open, Please join today (1)
- 11: Calculate Payment Schedule [Homework] (38)
- 09: Excel for Project Managers is coming up next Monday (14th), Details Inside… (9)
- 07: Formula Forensics No. 002 – Joyces Question (17)
- 04: Fancy Posts – using HTML Display Codes in Chandoo.org Posts (13)
- 02: A Technique to Quickly Develop Custom Number Formats (23)
- October 2011 (11)
- 31: Using an Array Formula to Find and Count the Maximum Text Occurrences in a Range (39)
- 27: Compare 2 Lists Visually and Highlight Matches (13)
- 25: Tell us what you would like to learn in our Excel for PMs course [Survey] (23)
- 24: Excel Links – After a long time edition (2)
- 20: Thank you, We have a home [personal story] (142)
- 19: Split an Excel File in to Many using VBA [Videos] (13)
- 17: Quickly Fill Blank Cells in a Table [Reader Tip] (46)
- 14: Commercial Aspects of Project Management (8)
- 10: Filter values where Fruit=Banana OR Sales>70. In Other Words, How to use Advanced Filters? (19)
- 04: Offset() function to Calculate IRR for Dynamic Range (24)
- 03: A Challenge from Hui (11)
- September 2011 (12)
- 29: Incell Sales Funnel Charts (8)
- 27: Sum of Values Between 2 Dates [Excel Formulas] (11)
- 21: Analyzing Performance of Stocks using Excel [Example] (12)
- 19: Refresh All Pivot Tables at once [Quick Tip] (22)
- 16: Our VBA Class Registrations Close in Few Hours, Join Now & Learn Excel VBA (0)
- 15: Participate in Microsoft BI DataMashUp Contest & You could win $3000 Prize (17)
- 14: Hui’s Excel Report Printer (14)
- 12: Excel Training Recommender – Interactive Excel Tool for you (2)
- 09: Suicides & Murders by US States – An Interactive Excel Chart (11)
- 06: My Top 10 Tips for Mastering VBA & Excel Macros [Part 5 of 5 - VBA Crash Course] (8)
- 05: Announcing Online VBA Classes from Chandoo.org, Please Join Today (1)
- 02: Putting It All Together – Our First VBA Application [Part 4 of 5 - Excel VBA Crash Course] (12)
- August 2011 (16)
- 31: How to use Cells, Ranges & Other Objects in Excel VBA (5)
- 30: Understanding Variables, Conditions & Loops in VBA [Part 2 of 5] (13)
- 29: What is VBA & Writing your First VBA Macro in Excel [VBA Crash Course Part 1 of 5] (29)
- 26: Excel School Prices Going up from 29th August, Join Now to save! (5)
- 25: Simple KPI Dashboard using Excel (11)
- 23: Split Text on New Line using Excel & VBA [Macros] (25)
- 22: Custom Chart Axis Formating – Part 2. (46)
- 19: Selective Chart Axis Formating (40)
- 17: Join Excel Formula Crash Course & Master Excel Formulas (0)
- 16: 5 Announcements for You [Quick Read] (5)
- 12: Check if a Word or Phrase is Palindrome using Excel Formulas [Weekend Fun] (18)
- 10: MLB Pitching Stats Dashboard in Excel+VBA by our VBA Class Student (7)
- 09: Simplicity is a Virtue – BASE Rule (10)
- 08: 10 Excel Keyboard Shortcuts I can’t live without! (55)
- 03: Create PowerPoint Presentations Automatically using VBA (55)
- 01: Shift Calendar Template – FREE Download (11)
- July 2011 (14)
- 29: Get busy this weekend, with OR XOR AND [Excel Homework] (19)
- 27: Financial Modeling School is Open, Please Join Today! (2)
- 26: Scenario Analysis for the Project Valuation [Financial Modeling] (7)
- 25: Video Tutorial on Interactive Dashboard using Hyperlinks (12)
- 22: We Want Your Ideas – Results (7)
- 20: Interactive Dashboard in Excel using Hyperlinks (121)
- 19: Accumulated Depreciation using Mixed References (7)
- 18: Details about our Financial Modeling Class (5)
- 14: Create Dynamic Hyperlinks in Excel [Video] (27)
- 12: Sumproduct function to Consolidate Revenues? (7)
- 06: 3D Dancing Pendulums (14)
- 05: NPV() function to calculate Present Value (4)
- 04: Last Chance to Join our Singapore Excel Bootcamp [also, our training calendar for rest of the year] (1)
- 01: Winners of the Sales Analysis Chart Contest + One more Giveaway (38)
- June 2011 (13)
- 30: Sales Analysis Charts in Excel – 78 Alternatives (30)
- 27: Excel Links – Updates on Singapore Workshop Edition (1)
- 23: Automating Repetitive Tasks (13)
- 22: We Want Your Ideas (75)
- 20: Analyse Data like a Super Hero (4)
- 16: Register for our Excel & Financial Modeling Bootcamp in Singapore [Details inside] (4)
- 15: Win Loss Chart from a Series of Win, Loss Data (5)
- 14: Comparing Lists of Values in Excel using Array Formulas (17)
- 10: Amount Donated vs. Pledged [Excel Formula Homework] (22)
- 09: How to create a Win-Loss Chart in Excel? [Tutorial & Template] (12)
- 07: 10 Excel Formula Myths – Busted! (32)
- 03: Do you want to attend an Excel Workshop in Singapore? [Survey] (3)
- 01: Switch Scenarios Dynamically using Slicers (25)
- May 2011 (15)
- 30: How Would You Visualize Product Sales Data? [Excel Challenges #2] (28)
- 26: Advanced Sumproduct Queries (55)
- 24: Mod() function in excel to Implement Escalation Frequency [Financial Modeling Tutorials] (15)
- 23: Use Copy & Paste to Preserve References to Tables [Quick Tip] (9)
- 20: VBA Classes Registration Closing in a Few Hours – Join Now! (4)
- 19: Data Tables and Monte Carlo Simulations (Update) (8)
- 18: Count-down Timer App in VBA to Remind you about the VBAClasses Closing Time!!! (13)
- 16: Lost Excel Functions (31)
- 13: Introduction to Programming – Demo Lesson from our VBA Class (15)
- 11: Using Solver to Assign Items to Buckets (24)
- 09: VBA Classes are Open now. Please join today! (0)
- 06: 5 things you should know about VBA Classes + a Demo Lesson (6)
- 04: Dummy Data – How to use the Random Functions (33)
- 03: 80% Discount on PUP & PowerPivot Contest – Hurry up! (5)
- 02: Online VBA Classes by Chandoo.org – Details & Dates (9)
- April 2011 (13)
- 29: Place Key Information in Golden Triangle on your Reports, Dashboards etc. [Quick Tips] (19)
- 27: Update Report Filters using simple macro – a Dynamic Pivot Chart Example (31)
- 25: Comparing Sales of One Product with Another [Excel Techniques] (11)
- 22: There is an Easter Egg in Excel! (27)
- 20: What are Pivot Table Report Filters and How to use them? (15)
- 18: Are You Ready for Online VBA Classes? I need your help! (5)
- 15: Celebrating India’s Worldcup Cricket Victory – In Excel Dashboard Style! (24)
- 13: How to make a 5 Star Chart (Similar to Amazon) (29)
- 11: Auditing Spreadsheets? – Disable Direct Editing Mode to save time [quick tip] (11)
- 07: Show Details On-demand in Excel [Tutorial + Training Program] (43)
- 06: Give more details by showing average and distribution [Charting Tips] (7)
- 04: Excel Links – Congratulations Team India Edition (11)
- 01: March 2011 is best month ever and other news (23)
- March 2011 (16)
- 31: Beam Me Up Scotty – Excel Hyperlinks (19)
- 30: Form Controls – Adding Interactivity to Your Worksheets (50)
- 25: Learning Dashboards? – Go thru these 33 Recommended Resources (12)
- 24: KPI Dashboard – Revisited (16)
- 23: Executive Review Dashboard in Excel [Dashboard Week] (6)
- 22: Customer Service Dashboard using Excel [Dashword Week] (21)
- 22: Health-care Dashboard in Excel [Dashboard Week] (2)
- 21: Announcing Dashboard Week – Submit your entries now! (10)
- 18: Calculating Sum of Digits in a Number using Array Formulas [for fun] (32)
- 16: Use Analytical Charts to Make your Boss Love You (50)
- 14: Convert ISERROR formulas to IFERROR formulas [macro] (17)
- 11: IFERROR Excel Formula – What is it, syntax, examples and howto (34)
- 09: Excel Challenge #1 – Make Nuts without Going Nuts (55)
- 08: Financial Modeling School is closing in a Few Hours – Join Now! (0)
- 04: Quickly Remove Data Validation Rules using Paste Special (9)
- 02: 3+1 Ways to Learn Advanced Excel (1)
- February 2011 (16)
- 28: Get Rid of Page Break Lines with a snap [macros] (10)
- 25: Excel Teens are out to get you & Other findings from our Survey (11)
- 23: Financial Modeling School is Open, Please Join Today (2)
- 22: The Grammy Bump Chart in Excel (24)
- 18: Details about upcoming Financial Modeling School (6)
- 17: Printing Excel Reports via a Word Document (39)
- 16: Modeling Interest During Construction (IDC) – Excel Project Finance (9)
- 14: Quickly Compare Data using Row Differences (22)
- 11: How long have you been using Excel? [poll] (451)
- 10: Simple Excel Formula to Calculate All-time High, Trailing 12 Month High Values [Quick Tip] (9)
- 08: Introduction to Project Finance Modeling in Excel (3)
- 07: Make Awesome Data Entry Forms by using Conditional Formatting + Data Validation (10)
- 04: My trip to Maldives…, [travelogue + bonus Excel tip] (19)
- 03: A Huge Collection of Spreadsheets for Teachers [What Excel Can Do] (13)
- 02: How do Business Analysts use Excel [Guest Post from a Rock-star BA] (16)
- 01: Holiday Request Form in Excel [Awesome Ways our Readers are using Excel] (14)
- January 2011 (14)
- 27: Are You Trendy ? (Part 3) (34)
- 26: Are You Trendy? (Part 2) (20)
- 25: Worksheet Properties via a Menu (6)
- 24: Are You Trendy ? (24)
- 20: 220 Excel Tips, Tutorials, Templates & Resources for You [Celebrating 20k RSS Members] (12)
- 19: Find the Average of Closest 2 Numbers out of 3 [formula challenge] (54)
- 17: Excel Links – My First International Excel Workshop Edition (11)
- 14: Happy Birthday Hui, An Excel Dashboard to prove you are awesome! (27)
- 12: Join Excel School & Become Awesome in Excel (0)
- 11: How to Embed Youtube videos in to Excel Workbooks? (15)
- 07: Using Array Formulas to check if a list is sorted. (19)
- 06: Do you want to Learn Excel? Consider Joining Excel School (6)
- 05: How to Filter Odd or Even Rows only? [Quick Tips] (14)
- 03: Excel Links – What are your plans for 2011? (8)
- December 2010 (16)
- 30: Best of Chandoo.org – 2010 (3)
- 29: People & Websites that helped me in 2010 – A Big, Heartfelt Thank You (23)
- 28: 11 Excel Trackers & Templates to help you Rock 2011 (5)
- 23: Merry Christmas & Happy New Year 2011 (31)
- 22: Use Filter By Selected Cell’s Value to save time [Quick Tips] (8)
- 20: How would you Visualize World Education Ranking Data [Homework + Video] (20)
- 17: 2011 Calendar – Excel Template [Downloads] (28)
- 16: Do you use (or make) Excel Dashboards? Tell us about yourself to win a free training kit (51)
- 15: 6 Christmas Cards in Excel – Download and Spread Joy (12)
- 13: Excel Links – Next Dashboard Contest Edition (24)
- 10: Mutant Cell Modeling Problem [Homework] (21)
- 08: Make Dynamic Dashboards using Pivot Tables & Slicers [Video & Download] (14)
- 07: Merge Cells without Losing Data [Quick Tip] (51)
- 03: Make a Christmas Card, and you can Win a $50 Gift Card (6)
- 02: The Selection Pane (6)
- 01: Show Top 10 Values in Dashboards using Pivot Tables (9)
- November 2010 (26)
- 30: Excel Animation without Macros! (28)
- 26: Homework – When does Thanksgiving Day occur on same date again? (29)
- 25: Using WordArt in Excel (9)
- 24: An Excel Dashboard to Visualize 10,007 Comments [Dashboard Tutorial] (23)
- 22: Splitting a number into integer and decimal portions (16)
- 19: VLOOKUP Formula Cheat-sheet – FREE Download (10)
- 18: Scheduling Variable Feed Sources (1)
- 17: Show Months & Years in Charts without Cluttering (20)
- 16: Welcome to Chandoo.org. A short introduction to this website (107)
- 15: Formatting Multiple Worksheets? Use Group Sheets option to Speed up [Quick Tip] (20)
- 12: 90% of you can see up to cell M26 & other findings [visualization] (14)
- 11: Highlighting Data Points in Scatter and Line Charts (10)
- 10: Getting the 2nd matching value from a list using VLOOKUP formula (24)
- 09: How to write 2 Way Lookup Formulas in Excel? (27)
- 09: Using Lookup Formulas with Excel Tables [Video] (3)
- 08: Extract Values from Several Columns [VLOOKUP Quick Tip] (17)
- 05: 3 Lookup Formula Challenges + 2 Jokes + 1 Link [VLOOKUP Week] (18)
- 04: A Technique for Analysing Large Tables of Data (21)
- 03: Excel Hero Academy – Recommended Online Excel Training Program (8)
- 02: 6 Tips for Writing Better VLOOKUPs (25)
- 02: How to Look up Based on Multiple Conditions (26)
- 02: How to Lookup Values to Left? (31)
- 01: Mix VLOOKUP with Data Validation for some magic! [VLOOKUP Week] (12)
- 01: Making VLOOKUP formulas go wild [VLOOKUP Week] (10)
- 01: What is VLOOKUP Formula & How to use it? [VLOOKUP WEEK] (19)
- 01: Celebrating the Lookup Formulas – VLOOKUP Week @ Chandoo.org (2)
- October 2010 (15)
- 29: What is the last visible cell in your excel window? [Poll] (327)
- 28: Hiding Error Messages – Quick Tip (15)
- 27: Financial Modeling School Closing in a Few Hours – Join Now! (0)
- 26: How to make a Birthday Reminder in Excel ? [Video] (28)
- 25: Analyze Competition with Scatter Plots – A business chart example (3)
- 22: FREE Excel Financial Model for Analyzing an IPO – Download Today (7)
- 20: Excel Links – Happy Birthday Edition (31)
- 19: Learn an Excel Feature: Picture Links (or Camera Snapshots) (22)
- 18: Financial Modeling School is now Open – Register today! (0)
- 15: Are you a Solver Virgin? Watch this tutorial video …, (15)
- 14: Financial Modeling School Coming on Monday [Details Inside] (0)
- 11: Insert Currency Symbols & Other Special Characters in Excel [Quick Tip] (12)
- 08: Finding 2nd Largest Item in a List that meets a Criteria [Excel Array Formulas] (13)
- 05: Bad News & VLOOKUP Contest (61)
- 01: Thanks half a million… (and 2 excel tips) (10)
- September 2010 (17)
- 29: Excel School Closing in a Few Hours – Join Now! (5)
- 28: Show Zebra Lines when Value Changes [Excel Conditional Formatting Homework] (66)
- 27: Remove duplicates & sort a list using Pivot Tables (27)
- 24: Displaying & Selecting a Scenario using VBA [Modeling in Excel] (20)
- 22: How I Analyze Excel School Sales using Pivot Tables [video] (0)
- 21: Putting it all together – Final Project Evaluation Model [Part 6 of 6] (16)
- 20: Show all the names & their References [Spreadsheet Audit] (7)
- 20: You are invited [personal] (29)
- 16: A round-up on Circular References (27)
- 15: Excel School is Open – Join Today (0)
- 13: Make your data validations dynamic! [quick tip] (6)
- 10: How to Calculate Working Hours Between 2 Dates [Solution] (26)
- 09: 10 things you should know about Excel School (2)
- 08: How to Paste Numbers Only [quick tip] (25)
- 06: Share an excel link and win $14.85 gift card from Amazon (58)
- 03: August 2010 – Best Month Ever (and 2 charting tips inside) (14)
- 02: Modeling & Building Cash-flow Projections for Project Valuation [Part 4,5 of 6] (4)
- August 2010 (17)
- 31: How to cook a delicious dynamic chart that will have your boss drool (91)
- 30: We have updates!!! (7)
- 27: How many hours did Johnny work? [Excel Homework] (36)
- 25: Excel Everest – Recommended Excel Training Program (14)
- 23: Building Inputs & Assumptions Sheets – Excel Financial Modeling [Part 3 of 6] (15)
- 20: How do you make charts when you have lots of small values but few extremely large values? [Debate] (49)
- 18: Excel Wedding Planner is here, Get your copy today! (9)
- 16: Jump to Any Cell / Worksheet using Name Box [Quick Tip] (22)
- 13: What is the most unusual thing you have used Excel for? [Quick Poll] (130)
- 11: Take your Excel Baby Steps with 89 Minutes of FREE Online Training (13)
- 10: Winner of Excel Expense Tracker Contest – RomeoG (11)
- 09: 9 Excel Tips & Downloads Submitted by Our Readers [Reader Awesomeness Week] (8)
- 06: Download Excel Wedding Planner Today (8)
- 05: 12 Rules for Making Better Spreadsheets (11)
- 04: How Francis Landed on Chandoo.org, Become Awesome and Made a Superb Dashboard, all in ONE Weekend (35)
- 03: Immigrants in Denmark – An Excel Infographic (7)
- 02: Announcing Reader Awesomeness Week – Submit your Tips, Stories, Workbooks and Ideas (4)
- July 2010 (16)
- 30: 5 Rules for Making Better Charts (and one fun chart) (11)
- 29: Introducing Excel Wedding Planner (9)
- 28: Building a Layout for Project Evaluation Model & Best Practices [Part 2 of 6] (11)
- 26: How to show Indian Currency Format in Excel? (30)
- 23: 7 Links and One Question for You (5)
- 21: Introduction to Financial Modeling using Excel [Part 1 of 6] (36)
- 19: Select Expressions to Find their Values [Macro Debugging Tip] (11)
- 16: 7 Personal Expense Trackers using Excel – Download Today (112)
- 14: 4 Alternatives to Export Excel Dashboards as Web Pages (17)
- 12: Gantt Box Chart Tutorial & Template – Download and Try today (13)
- 11: Thank you (and thank you Excel), We have a Car! (27)
- 09: A Gantt Chart Alternative – Gantt Box Chart (14)
- 07: Find-out Days Overlaped [Excel Formula Homework] (64)
- 06: Do You Want to Learn Excel Financial Modeling? (7)
- 02: Football anyone? [off-topic] (21)
- 01: Even Faster Way to Compare 2 Lists in Excel [Quick Tip] (31)
- June 2010 (23)
- 30: Range Lookup in Excel [Formulas] (57)
- 28: Excel Links – Change in Posting Schedule Edition (9)
- 25: Office 2010 Contest Winners are here!!! (4)
- 24: Between Formula in Excel [Quick Tips] (106)
- 23: Use Excel For Rapid UI Prototypes [Awesome uses of Excel] (13)
- 22: A Hairy Update [personal] (13)
- 21: Excel Heros who Reviewed and Recommending Excel School (10)
- 21: Excel School Closing in a Few Hours – Join Now! (0)
- 18: What new chart types you want to see in Excel? [poll] (33)
- 17: Become a Comparison Ninja – Compare 2 Lists in Excel and Highlight Matches (57)
- 17: Super-mini Quick Update on Excel School (0)
- 16: Excel Quotation Template [Spreadsheets for Small Business] (14)
- 15: Weighted Average in Excel [Formulas] (50)
- 14: Join Excel School Today (1)
- 11: FIFA Worldcup Excel Spreadsheets [Roundup] (17)
- 10: 6 things you should know about Excel School (5)
- 09: Football Betting Sheet Template (7)
- 08: How to Add your Macros to QAT or Excel toolbars? (11)
- 07: Convert Text to Sentence Case using Excel Formulas [Quick Tips] (23)
- 04: Average of Top 5 Values [and some homework] (46)
- 03: Win a Netbook – 10000 RSS Contest (20)
- 02: Get Stock Quotes using Excel Macros [and a Crash Course in VBA] (102)
- 01: Check if two ranges of dates overlap [Excel Formulas] (29)
- May 2010 (21)
- 31: Updates on Website, Office 2010 Contest (6)
- 28: Official FIFA World-cup Soccer Balls since 1930 in an Excel Chart [Excel Fun] (9)
- 27: Use CTRL+Back Space to jump to active cell [Shortcut] (9)
- 26: Dynamic Dashboard in Excel – Pulling it all together [Part 4 of 4] (10)
- 25: Display Alerts in Dashboards to Grab User Attention [Quick Tip] (20)
- 24: An Excel Hero indeed [blog recommendation] (7)
- 21: Understanding Backstage view in Excel 2010 (14)
- 20: Attend Free Excel Training Session by Me on May 25th (4)
- 20: How to make new ribbons in Excel 2010? (29)
- 19: New Features in Excel 2010 Conditional Formatting (38)
- 18: What are Excel Sparklines & How to use them? [Excel 2010] (34)
- 17: What is new in Microsoft Excel 2010? [Office 2010 Week] (98)
- 13: Evolution of Privacy Policies on Facebook – a Panel Chart in Excel (7)
- 12: Introduction to Panel Charts using Excel – Tutorial & Template (23)
- 11: Exclude Hidden Rows from Totals [How to?] (12)
- 10: How to become really awesome in Excel? [Reader Questions] (32)
- 07: Important Update: Dilbert is gone! (56)
- 06: Data Tables & Monte Carlo Simulations in Excel – A Comprehensive Guide (102)
- 05: Change Data Labels in Charts to Whatever you want [Quick Tip] (38)
- 04: How to Get “Either-Or” Condition in Data Validation? (8)
- 03: Excel Links – Project Management Edition (4)
- April 2010 (20)
- 30: Wow!!!, Thank You :) (15)
- 30: Quarterly totals when you have multi-year data [SUMPRODUCT again] (3)
- 29: Find Quarterly Totals from Monthly Data [SUMPRODUCT Formula] (20)
- 27: SUMIF works in 2D too [quick tip] (11)
- 26: Childhood Dream comes true [personal story] (95)
- 23: What are your favorite colors for charts? (18)
- 22: Making a Dynamic Dashboard in Excel [Part 3 of 4] (4)
- 21: Budget vs. Actual Profit Loss Report using Pivot Tables (10)
- 20: Introduction to Excel SUMIFS Formula (69)
- 19: How to Select Right Chart for your Data (16)
- 15: Quickly Turn off Gridlines in Excel 2003 using Forms Toolbar [Excel Tips] (4)
- 14: Updates on Excel School [and 3 free lessons] (6)
- 13: Speaking at TechEd 2010 on “How to Select the Right Chart for your Data” (8)
- 12: Excel Formulas are not working?!? What to do when all you see is the formula, not result (146)
- 09: Survey Results in Dot Plot Panel Chart [followup on Incell Panel Chart] (17)
- 08: Make your Chart Legends Legendary (21)
- 07: Use CTRL+Click to speed up your formula entry [Quick Tips] (13)
- 06: Automatic Rolling Months in Excel [Formulas] (44)
- 02: There are Easter Eggs in this Post!!! (11)
- 01: How to Visualize Survey Results using Incell Panel Charts [case study] (45)
- March 2010 (17)
- 31: 101 Excel Secrets – Recommended E-Book (10)
- 30: Making a Dynamic Dashboard in Excel [Part 2 of 4] (2)
- 29: How to Check whether a Table is Filtered or not using Formulas (3)
- 26: What do you use Excel for? [Weekend Poll] (53)
- 25: My First Podcast!!! – Listen to know some cool charting and dashboard stuff (0)
- 24: Quarterly & Half-Yearly Profit Loss Reports [Part 5 of 6] (4)
- 23: How to Convert Text to Dates [Data Cleanup] (16)
- 22: Introducing PHD Sparkline Maker – Dead Simple way to Create Excel Sparklines (8)
- 18: Super Timesaver Tip – Add “Select Objects” to Quick Access Toolbar (11)
- 16: Making a Dynamic Dashboard in Excel [Part 1 of 4] (25)
- 15: Excel Links – Back to India Edition (2)
- 11: 31 Excel Tutorials – Learn and Be Awesome in Excel (17)
- 08: Introducing Flag Project – A fun way to Learn Excel Charting (37)
- 04: Get a Copy of Excel Project Management Templates Today! (2)
- 03: Exploring Profit & Loss Reports [Part 4 of 6] (6)
- 02: Writing “Either Or” formula in Excel [Formula Howtos] (7)
- 01: Annual Goals Tracker Sheet [awesome ways to use excel] (17)
- February 2010 (22)
- 26: Sachin Tendulkar ODI Stats – an Excel Info-graphic Poster (7)
- 25: Adding Calculated Fields to Pivot Table P&L [part 3 of 6] (8)
- 24: Use Paste Special to Speed up Chart Formatting [Quick Tip] (20)
- 23: Find and Remove Blank Items from a Range of Cells [personal experience] (15)
- 22: Comprehensive List of Excel Keyboard Shortcuts (65)
- 19: How do you consolidate data from multiple sheets in to one? [open thread] (40)
- 17: Excel School Last Call, Closing in Few Hours – Join Now! (6)
- 16: Save a ton of time by using Mouse scroll-wheel to Navigate Excel Ribbon (8)
- 16: Excel Links – Winner Takes it all Edition (1)
- 15: Welcome to Pointy Haired Dilbert – Know a Little About YOU (7)
- 12: Only 5 days left, Sign-up for Excel School Today! (4)
- 12: What is the most useless feature in Excel? [poll] (35)
- 11: Group Project Activities to Make Readable Gantt Charts (9)
- 10: Preparing Profit / Loss Pivot Reports [Part 2 of 6] (4)
- 09: What is Excel SUBTOTAL formula and 5 reasons why you should use it (39)
- 08: Excel School is Open for Admissions (6)
- 05: Excel School Registration Opens on Monday (8th Feb, 2010) (6)
- 05: Best Month Ever (and a charting tip inside) (21)
- 04: P&L Reporting using Excel [Part 1 of 6 on Excel & Accounting] (12)
- 03: Excel Keyboard Shortcuts – Open Thread (79)
- 02: Data Validation using an Unsorted column with Duplicate Entries as a Source List (11)
- 01: Excel Links of the Week – now even more downloads edition (1)
- January 2010 (20)
- 29: Fix Incorrect Percentages with this Paste-Special Trick (6)
- 27: Pivot Table Tricks to Make You a Star (83)
- 26: Delete Blank Rows in Excel [Quick Tip] (65)
- 25: Excel School Online Training – More Details (26)
- 22: Flu Trends Chart in Excel [Yes, we can edition] (17)
- 21: Use “Script” font to make your incell charts realistic [quick-tips] (23)
- 20: Dr. Scroll-bar Mortgage Calculator or: Why you should not be borning and use form controls (20)
- 19: Extract usernames from E-mail IDs [using LEFT and FIND formulas in Excel] (32)
- 18: Best Sales Dashboards, as Voted by You [Visualization Challenge #2 - Winners] (24)
- 15: Would you be interested in an online excel training program? (14)
- 15: Flu Trends in a City chart from Google is Awesome! (10)
- 14: Product Recommendation – Excel Dashboard Training Kit (11)
- 13: A Brief History of Microsoft Excel – Timeline Visualization (10)
- 12: Collapse, Expand Excel Charts using this hidden trick (10)
- 11: Excel Links – What are your plans for 2010 Edition (9)
- 08: What is PowerPivot? (and does it really wear underwear on top of pants !?!) (17)
- 07: A New Year Resolutions Template that Kicks Ass (26)
- 06: Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2] (9)
- 05: Conditionally Formatting Dates in Excel [Part 1 of 2] (121)
- 04: Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations (72)
- December 2009 (19)
- 30: Best of Pointy Haired Dilbert – 2009 (11)
- 28: Track Your Mutual Fund Portfolio using Excel [India Only] (36)
- 24: How to Find Dates of Public Holidays using Excel (5)
- 23: Merry Christmas & Happy New Year 2010 (27)
- 22: Print Worksheets in One Page Across [Quick Tips] (3)
- 21: The 1000th Post (19)
- 18: Best Charts to Compare Actual Values with Targets – What is your take? (14)
- 17: Make a Quick Thermometer Chart to Compare Targets and Actuals (18)
- 16: How to Print Excel Comments (6)
- 14: How to hide “0″ in chart axis [quick tip] (12)
- 11: 2010 Calendar – Excel Template [Downloads] (23)
- 09: Use CTRL+F1 to collapse ribbon [super-mini-quick-tip] (6)
- 08: How to pick a random date? [Formulas] (5)
- 07: Christmas Gift List – Set your budget and track gifts using Excel (13)
- 04: Dilbert on Excel, Spreadsheets and Cell C23 (5)
- 03: Use Shapes and Images to make Prettier Charts [Dashboard Tricks] (13)
- 02: 50% off on ExcelUser’s Dashaboard Kit [2 days only] (0)
- 02: Group Smaller Slices in Pie Charts to Improve Readability (11)
- 01: Excel Links – Learn Excel Online Edition (0)
- November 2009 (25)
- 30: Format Charts Faster in Excel 2007 [quick tips] (3)
- 27: The Zoho Visualization Challenge – Deadline Extended to 5th Dec (1)
- 25: Announcing PHD Thanksgiving Sale (0)
- 25: Findout Thanksgiving Day’s Date for Any Year [Excel Formulas] (22)
- 24: Why do you visit PHD? (4)
- 23: Personal Budget Spreadsheet [Downloads] (16)
- 20: 10 Supercool UI Improvements in Excel 2010 (23)
- 20: One Hundred Project Managers have chosen to be better, what about you? (0)
- 19: Reverse a List using Formulas [Using Excel INDEX() Formula] (14)
- 18: Download Excel 2010 Beta today [Office 2010 Updates] (7)
- 18: Transpose Excel Rows and Columns [Quick Tip + Video] (6)
- 17: Grouping Dates in Pivot Tables (41)
- 16: Excel Links of the Week [Excel Dashboards Edition] (3)
- 13: What is the most embarrassing charting mistake you made? [weekend poll] (5)
- 12: Zoho sponsors our Visualization Challenge #2 (0)
- 12: Top X chart – Show Top X values of a chart Interactively (8)
- 11: Chart this Sales Data and get an iPod Touch [Visualization Challenge #2] (61)
- 10: What is Excel SUMPRODUCT formula and how to use it? (99)
- 09: PHD Gets a Facelift (again) (6)
- 09: Excel Links of the week [After a long time edition] (1)
- 06: Lets Pimp a Gauge Chart [Chart Porn Friday] (24)
- 05: Product Recommendation – Excel Lookup Toolbox (4)
- 04: Dashboard Best Practice – Google Analytics Intelligence Report (7)
- 03: 10 Tips to Make Better and Boss-proof Excel Spreadsheets (33)
- 02: Switch Rows and Columns in Charts [Quick Charting Tip] (16)
- October 2009 (18)
- 30: Sweet Sweet Testimonial from a Sweet Sweet Lady (5)
- 29: Making Interaction Plots using Excel (6)
- 28: Copy Data Validations from one cell to another [quick tip] (6)
- 27: Project Dashboard + Tweetboard = pure awesomeness!!! (5)
- 26: Prevent Duplicate Data Entry using Cell Validations (17)
- 23: Solve Sudoku Puzzles using Excel [because it is weekend] (12)
- 22: Get a free copy of Project Management Bundle (1)
- 20: Meet Nakshatra & Nishanth (and say Happy Birthday to PHD) (26)
- 19: How to get Excel 2003 Toolbars in Excel 2007 [productivity hack] (19)
- 15: Making a chart with dynamic range of values (34)
- 14: The Project Management Bundle for Excel is Here, Download your copy today (5)
- 12: Baby Feeding Chart using Excel (15)
- 09: Visualization Lessons from Eiffel Tower [Chartbusters in Paris] (7)
- 08: Another Reason why Tables are so awesome [quick tip] (7)
- 06: Project Management Dashboard / Project Status Report using Excel [Part 6 of 6] (29)
- 05: Make a Bubble Chart in Excel [15 second tutorial] (11)
- 02: What buttons you have in the excel quick access bar ? [weekend poll] (31)
- 01: Use Cell Styles to Make your Spreadsheet Models User-friendly [Quick Tip] (8)
- September 2009 (16)
- 30: Recipe for a Donut Bar Chart (23)
- 28: 5 Things you probably dont know about this site (6)
- 25: Twins, Clones and Duplicates – 6 Excel Shortcuts from an Excited Dad (6)
- 24: Pointy Haired Dad (72)
- 22: Calculate Elapsed Time in Excel [Quick Tips] (16)
- 21: 7 ideas Excel can pick-up from iWork Numbers (12)
- 17: Master Excel 2007 Ribbon with this Free Learning Guide (18)
- 15: Excel Check Boxes, Even Simpler Way (20)
- 15: How to get tick marks in Excel? [custom cell formatting] (10)
- 14: Member of Month and Other Updates (0)
- 11: Pimp your comment boxes [because it is Friday] (8)
- 10: Want to become a Data God? Learn Excel Data Tables (52)
- 08: Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6] (25)
- 04: Pin Frequently Used Documents to File Menu to Save Time (2)
- 03: Get cell comments using Excel Formula (27)
- 02: Pareto Charts – How to do pareto analysis using Excel? (44)
- August 2009 (19)
- 31: 5k Giveaway – Excel is a Superhero – Winners (0)
- 28: Nightmarish Pie Charts [because it is weekend] (12)
- 27: Dynamically Grouping Related Events [Excel Combo Charts with Pizzazz] (24)
- 26: Using Combo Charts to Group Related Time Events [Charting Goodness] (10)
- 25: Make a Pivot Table in Excel [15 Second Tutorial] (13)
- 24: 29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock] (10)
- 20: 50 Best Cities for Finding a Job [Incell Dashboard using Excel] (7)
- 19: Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one (82)
- 17: Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip] (8)
- 14: Only 2 more days to get prizes worth $425, Hurry (1)
- 13: Hide Grid Lines [Quick Tip] (20)
- 11: Member of month, Excel links and Cooked HDD (4)
- 10: Waterfall Charts using Excel (71)
- 07: What would you do if a co-worker makes ugly chart? [weekend poll] (31)
- 06: Count the number of unique values in a range [Quick Tip] (29)
- 05: Excel Time Sheets and Resource Management [Project Management using Excel - Part 4 of 6] (22)
- 04: If Excel is a Superhero … [5k Contest and Giveaway] (75)
- 03: The funnest way to learn excel formulas (4)
- 03: Twitter Formula Contest – We are 5000 strong now (15)
- July 2009 (17)
- 31: Are you excited about this twitter chart? (4)
- 30: Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu (37)
- 29: Build a Retirement Calculator using Excel (learn how to use Goal Seek as a bonus) (23)
- 28: Charting Lessons from Optical Illusions (7)
- 27: Introducing PHD Forums (and some other updates) (6)
- 24: We cant Cure Cancer, But we can Cure this Medicare Chart [Chart Busters] (10)
- 22: Sumif with multiple conditions [quick tip] (62)
- 21: Use burn down Charts in your project management reports [bonus post] (25)
- 20: Generating invoice numbers using excel [reader questions] (16)
- 17: 2 Great Pieces of Advice for Chart Makers, Dashboard Designers and Story Tellers Everywhere (2)
- 15: Formula 1 Style Sorting of Times (Durations) in Excel (13)
- 14: 14 Basic Skills for Chart Makers (Big question: How many do you have?) (10)
- 13: Make an Impressive Product Catalog [spreadsheets for small business] (14)
- 09: Project Management: Show Milestones in a Timeline [Part 3 of 6] (57)
- 06: How to Round and Sort Data using Excel Formulas? (28)
- 02: Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial] (6)
- 01: Best month ever [blogging updates] (15)
- June 2009 (22)
- 30: Fix this chart [excel homework #1] (22)
- 29: Create a number sequence for each change in a column in excel [Quick Tip] (7)
- 25: Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6] (20)
- 23: Excel Links – Bacon bits are good edition (7)
- 22: Remove Duplicates [Quick Video Tip] (6)
- 19: Asset Allocation Chart Turns Zombie [ChartBusters #1] (15)
- 18: Creating New Cell, for real (28)
- 17: Are you focusing on F word or S word? [Charting Principles] (0)
- 16: Gantt Charts – Project Management Using Excel [Part 1 of 6] (107)
- 15: Interview With Presentation Zen’s Garr Reynolds on Charting & Telling Stories (2)
- 15: Welcome to Pointy Haired Dilbert (1)
- 12: Bring out your bad charts, the ChartBusters are here… (23)
- 12: Do you know these Double-click Tricks in Excel? (103)
- 10: Interviewing Garr Reynolds on this Friday, send me your questions (7)
- 10: Incell Dot Plots in Microsoft Excel (21)
- 09: Networkingdays() an improved version of networkdays formula (19)
- 08: Excel Formula 1 – Really Fast way to learn Excel Formulas (0)
- 05: How to Hide a Cell’s Contents in Excel? [Quick Tip] (25)
- 04: Converting Excel to PDF – Everything you need to know (58)
- 03: Venn Diagrams in Excel (24)
- 02: Tweetboard Implementations – Download and make your twitter style dashboard today (5)
- 01: Statistical Distributions in Excel [spreadcheats] (51)
- May 2009 (21)
- 29: Array formula to check if a number is prime [just for fun] (25)
- 28: Intraday Candlestick Charting [Stock Charts] (3)
- 27: Hide Formula Errors While Printing [Quick tip] (1)
- 26: Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them) (36)
- 25: Excel Links – Dilbert is Recession-proof Edition (5)
- 21: Now Edit Google Spreadsheets using MS Excel (5)
- 20: Signup for Microsoft Excel 2010 Technical Preview [Office 2010] (0)
- 19: Create a Dynamic Chart in Excel in 2 Minutes [spreadcheats] (42)
- 18: and then Dilbert is fired too (10)
- 15: Share Your Excel Tips for Your Week – Open Thread (3)
- 14: Excel Tips Submitted by You [Part 4] (1)
- 13: Excel Tips Submitted by You [Part 3] (6)
- 12: Excel Tips Submitted by You [Part 2] (4)
- 11: A Good Chart is a Story [Charting Principles] (25)
- 11: Excel Tips Submitted by You [Part 1] (8)
- 08: Announcing “Your Week” @ PHD (5)
- 07: Tweetboards – Alternative to traditional management dashboards (18)
- 06: Most Popular Posts in PHD – The March and April edition (0)
- 05: Use Mouse to Edit Formula Ranges [quick tip] (9)
- 04: Bonavista Chart Tamer Kicks ass. (7)
- 01: Web Analytics Dashboard by Percent Mobile is Fun [Dashboard Reviews] (1)
- April 2009 (9)
- 29: Analyzing Search Keywords using Excel : Array Formulas in Real Life (7)
- 28: Calculate Moving Average (127)
- 27: Excel Links of the Week – What is really happening Edition (2)
- 22: Hide a Workbook from Nosy Colleagues [quick tip] (7)
- 21: and the Winner is… (8)
- 20: Excel Formula Errors – Understand and Debug Them (17)
- 08: There is an Easter Egg in this Post (21)
- 07: Using Credit Card Numbers in Excel (2)
- 05: Budget vs. Actual Charts – 14 Charting Ideas You can Use (52)
- March 2009 (19)
- 31: Search a Spreadsheet Full of Data using Conditional Formatting (21)
- 27: Interview with John Walkenbach on Excel and Banjo Charts… (11)
- 25: Using Array Formulas in Excel – Find if a list has duplicate items (31)
- 23: Excel Links of The Week – Malmo Edition (5)
- 19: Skip Blank doesnt skip blank cells ?!? (20)
- 18: Visualization Challenge – Budget vs. Actual Performance (38)
- 17: Highlight Top 10 Values using Excel Conditional Formatting (39)
- 16: New Improved Version of Excel Formula Help (1)
- 13: Hot or Not – McKinsey’s Innovation Heatmap (8)
- 13: Excel Conditional Formatting Basics (55)
- 12: Us vs. Them – Compare Sales Performance using Charts & Form Controls (21)
- 10: How to use Excel Chart Templates and Save Time (6)
- 09: Excel Links of the Week – Free E-Book Edition (5)
- 06: RSS Icon using Donut Charts – Because it is Weekend (0)
- 05: Open Thread For First Time Commenters – What do you like in Excel? (20)
- 04: Japanese Candlestick Chart – Excel Tutorial (14)
- 03: February 2009′s Most Popular Posts (0)
- 02: 5 Areas where Mouse Kicks Keyboard’s Butt (27)
- 02: Weekly Excel Links – After a Long Time Edition (3)
- February 2009 (21)
- 26: How Many Bubbles are Too Many Bubbles? (8)
- 25: How to Change Shapes in Microsoft Office 2007 (0)
- 23: What would you like to ask John Walkenbach – Famous Excel Author and Guru? (26)
- 20: What is Your Opinion on Pie Charts? (14)
- 19: Welcome Robert & ClearlyAndSimply.com to Blogging (0)
- 18: Market Segmentation Charts using Conditional Formatting (8)
- 18: Google Spreadsheets Introduces Data Validation, Sweet! (4)
- 17: Quickly Change Formulas Using Find / Replace (8)
- 16: “Too Many Worksheets” Driving You Nuts? Read This! (25)
- 13: A Good Bubble Chart About the Bust (0)
- 13: Excel Colors Somehow Getting Changed ? (10)
- 12: Make a Dynamic Chart using Data Filters (17)
- 11: PHD reader gears up for a promotion despite recession and makes my day (3)
- 10: Weekly Links – Even More Downloads Edition (1)
- 09: Review of PTS Clustered Stack Chart (2)
- 07: Professional Resume or Data Visualization Fail? [poll] (15)
- 05: Write Your Own Twitter Client using Microsoft Excel (88)
- 04: Employee Satisfaction Surveys using MS Excel (23)
- 03: One more method to find unique values in excel and you can call me a dork (24)
- 03: Best of PHD – Jan 2009 (0)
- 02: PHD Excel Formula Helper – Now an E-Book (4)
- January 2009 (19)
- 30: [Weekend Poll] How do you Sex up your Charts? (4)
- 29: Colors in Chart Labels [Quick Tip] (22)
- 28: 100 Excel Tips & Resources to Celebrate 2000 RSS Subscribers (88)
- 26: Excel Links of the Week – Minor Changes to PHD edition (2)
- 23: Do you know how to KISS, Wall Street Journal Does! (10)
- 22: How to Hide Worksheet Tabs in Excel Workbook (52)
- 21: [Reader Poll] Stacked, Seperated or Mirrored ? (28)
- 19: Visualizing Search Terms on Travel Sites – Excel Dashboard (12)
- 19: Sorry, I screwed it up… (8)
- 16: Why No One Likes Your Pie Charts (And What to Do About It) (19)
- 13: What are the formulas you wish Excel had ? (37)
- 12: Excel Links of the Week [Jan 12] (2)
- 10: Featured Visualizations – Jan 09 (3)
- 09: Sales Funnel Charts in Excel – Tutorial (22)
- 08: Automatically insert timestamps in excel sheet using formulas (84)
- 06: Weekly Excel Links – Issues with Hosting of PHD (9)
- 05: Excel Basics – What are Combination Charts and How to Make One? (28)
- 02: Featured Visualizations – Jan 02 (3)
- 02: Great News: PHD becomes MVP (25)
- December 2008 (19)
- 31: Happy New Year to all PHD Readers (4)
- 30: Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats] (0)
- 29: Excel 2007 Review – 10 things that WOWed me (62)
- 23: Excel Links of the week – the Christmas edition (4)
- 19: 5 Awesome Info-graphics for your Inspiration [Dec 19] (4)
- 19: Use Alt+Enter to get multiple lines in a cell [spreadcheats] (7)
- 17: Creating Excel Art from Images [spreadsheet fun] (4)
- 17: Custom Views in Excel – Save filter and header settings for quick reference (17)
- 16: 2009 Calendar Template in Excel – Now with week starting on Monday (12)
- 15: Formula Debugging in Excel – Tip [spreadcheats] (21)
- 15: Excel Links of the Week [Dec 15] (0)
- 11: Interview with Charley Kyd on Everyday Excel (12)
- 10: Brick Charts in Excel – an Alternative to Gridlines (5)
- 04: Free Excel Calendar Template for year 2009 (and all years up to 9999) (18)
- 03: Parking Tickets in New York – Cool Interactive Visualization from NYTimes (0)
- 02: What is camera tool and how to use it? [spreadcheats] (20)
- 02: Are you making Blow charts? [charting tips] (2)
- 02: Best of Pointy Haired Dilbert – Nov 2008 (4)
- 01: Excel Links of the Week [Dec 1] (0)
- November 2008 (33)
- 30: 5 things that helped me run 10k (6)
- 26: Say thanks with an excel tip (33)
- 25: Prevent users from scrolling away on your dashboards [dirty little trick] (7)
- 25: Advanced Data Validation Techniques in Excel [spreadcheats] (46)
- 25: Fun way to clean up modern art with visualization (4)
- 24: Excel Links of the Week – PHD’s new tag line [Nov 24] (3)
- 24: Introducing Excel Formula Helper (7)
- 22: Google Spreadsheets Holiday Art Template (7)
- 21: 5 visualizations to inspire you [Nov 21] (1)
- 20: Generating Random Phone Numbers (8)
- 19: vlookup(), match() and offset() – explained in plain english [spreadcheats] (150)
- 19: The new Mac vs. PC web ad by Apple is really cool (3)
- 18: What would you like to ask Charley Kyd of Exceluser.com in an interview? (14)
- 18: Make your VBA macros work anywhere: Enable Relative References (2)
- 17: Excel Links of the Week – Do you want to run 10k with me edition (0)
- 17: Ads that are also Infographics – 10 Dazzling Examples (2)
- 15: 5 Visualizations for Your Inspiration [Nov 14] (0)
- 14: Seperating digits from a number [excel formulas] (14)
- 14: Is your (chart’s) underwear showing? (9)
- 14: How to present changes in Market Share using Charts? (16)
- 12: PHD Welcomes Readers from Lifehacker (5)
- 12: Eight ways to exploit COUNTIF() … and sumif() too [spreadcheats] (45)
- 11: Excel Formula for Finding Repeated Words in a Cell (9)
- 10: Excel Links of the Week – All Downloads at One Place Edition (3)
- 08: 5 Visualizations for your Inspiration [Nov 07] (1)
- 06: Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats] (11)
- 05: Select & Show One Chart from Many (134)
- 05: US Poll Trackers – Live Dashboards Ooze Visualization Goodness (0)
- 04: Relative vs. Absolute References in Formulas [spreadcheats] (18)
- 04: Minor Changes to PHD’s Look and Feel (3)
- 03: Excel Links of the Week [Nov 3] (1)
- 03: Best of Pointy Haired Dilbert – Oct 2008 (0)
- 01: Infographics of the week – Food, Maps, Privacy & Politics [Oct 31] (0)
- October 2008 (33)
- 31: Introducing Spreadcheats – Become Supergood with Excel in 30 days (11)
- 30: Soon you can use Excel on the Web (3)
- 29: Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6] (26)
- 29: Making Pie-charts look Sexy – The CNN’s tax burden analysis chart (8)
- 28: How to NOT spend $ 150,000 and still dress up your charts (20)
- 27: Excel Links of the Week – What the heck happened to photographic fridays edition (2)
- 25: 5 Beautiful Visualizations [Oct 24] (5)
- 24: Sports Statistics Dashboard in Excel – Few More Alternatives (1)
- 22: Sorting Text in Excel using Formulas (50)
- 21: Reader Poll: Should the axis for bar charts always start at zero? (24)
- 20: Sports Dashboards in Excel – A Tutorial (18)
- 20: Excel Links of the Week – Birthday Edition (7)
- 17: Use Enter to Paste Copied Values in Excel [Quick Tip] (10)
- 17: 5 Superb Visualizations of the Week [Oct 17] (2)
- 16: The New Poor – Internet Penetration Rates by Country (17)
- 16: 15 MS Excel Tips to Make you a Productivity Guru (24)
- 15: The shower curtain & rings sense of designing products (2)
- 14: More than 3 Conditional Formats in Excel (27)
- 13: Excel Links of the Week – The Mt. Rainier edition (2)
- 11: Windows 98 – Photographic Fridays #17 (0)
- 10: Visualizations of the Week [Oct 10] (1)
- 09: KPI Dashboards – Compare 2 Decision Parameters [Part 5 of 6] (26)
- 07: Replace Radar Charts with Tables to Make Comparison Easy (24)
- 07: Red vs. Blue – 35 Cool Visualizations on 2008 US Presidential Election (20)
- 06: Excel Links of the Week [Oct 06] (1)
- 06: Major Updates to Google Docs Spreadsheets App – Menus, Named Ranges, Toolbar (4)
- 04: Come, Lets Celebrate – Photographic Fridays # 16 (2)
- 03: Deal or No Deal – Download and Play the Popular TV Game Show in Excel (6)
- 03: Info-graphics of the week [Oct 3] (4)
- 02: Display decimals only when the number is less than 1 [Excel number formatting tip] (8)
- 02: Visualizations at Seattle Public Library – What Community is Reading? (0)
- 02: The Best of Pointy Haired Dilbert : September 2008 (5)
- 01: Simple Todo List application using Excel – Download and become productive (8)
- September 2008 (34)
- 30: Clean up Incorrectly Formatted Phone Numbers using Excel (27)
- 29: How to WOW your customers with tracking – Dominos pizza example (3)
- 29: Excel Links of the Week [Sep 29] (4)
- 27: Sun Flower – Photographic Fridays # 15 (0)
- 26: Google Maps Walking Directions Bug ?!? (2)
- 26: Visualizing Sex & Love – 10 Infographics You Must See (3)
- 25: Save a quarter buck everytime you buy coffee at starbucks (9)
- 25: Handling spelling mistakes while searching your data using excel (8)
- 23: Sorting a list of items in random order in excel – using formulas (7)
- 23: Gmail Labs 2 new useful features – Mark as Read, Label Auto Suggest (1)
- 22: SQL Queries from Excel (15)
- 22: Weekly Excel Links – Moved to Seattle Edition (0)
- 19: Steel Patterns – Photographic Fridays # 14 (2)
- 19: Microsoft says ‘I am PC’ and it is brilliant (17)
- 19: Charts of the Week [Sep 19] (1)
- 18: You are NOT spider man, so why do you use radar charts? (17)
- 18: Visualization Challenge – How to show market share changes? (16)
- 17: Calculating Paydays in a calendar year using Excel (4)
- 16: Web Page Monitor using Google Docs (4)
- 16: Power Outage & 99 Excel Tips to keep you Busy (2)
- 13: American Bald Eagle – Photographic Fridays # 13 (0)
- 12: Infographics of the week [Sep 12] (4)
- 12: Tracking your stock portfolio using Google Docs (17)
- 10: Excel KPI Dashboards – Adding Micro Charts [Part 4 of 6] (68)
- 09: Hack together a Gauge Chart in Excel without sweat (68)
- 08: Excel links of the week [Sep 8] (0)
- 08: Splitting text in excel using formulas (17)
- 06: Either the glasses are floating or you are drunk – Photographic Fridays # 12 (0)
- 05: Cool Info-graphics of the Week [Sep 5] (0)
- 05: Microcharting in Excel – 7 Alternatives Reviewed (26)
- 03: KPI Dashboards – Highlight KPIs Based on Percentile [Part 3 or 6] (37)
- 03: 6 charts you will see in hell (13)
- 02: Initials from Names using Excel Formulas (47)
- 02: Introducing new design of Pointy Haired Dilbert (11)
- August 2008 (42)
- 29: Photographic Fridays #11 – It stretches all the way you can see (1)
- 29: Cool Visualizations of the Week [Aug 29] (0)
- 28: Aligning charts, objects on spreadsheet [excel layout tip] (11)
- 28: What they dont teach you in any school – Appreciation (2)
- 27: Creating KPI Dashboards in Microsoft Excel [Part 2 or 6] – Adding One Click Sort (71)
- 26: Excel links of the week – weekend without wire [Aug 26] (8)
- 26: Date with my sheet – 10 tips on using date / time in excel (22)
- 25: Quickly process text using split() spreadsheet function in google docs (6)
- 22: Photographic Fridays #10 – At the Niagara Falls (0)
- 22: 5 wonderful visualizations you must see [Aug 22] (1)
- 21: Tiger Woods walks on water to please a fan – Awesome advertising (0)
- 21: Display symbols in excel chart axis (8)
- 20: Creating KPI Dashboards in Microsoft Excel [Part 1 of 6] (172)
- 20: Dell tells me to buy a finger print reader in order to have another color on the system (5)
- 19: It is show time baby! – better designer clocks to display time in your spreadsheets (1)
- 19: Switch between firefox tabs using mouse scroll wheel (4)
- 19: Excel Links of the week – What do you dream about? [Aug 19] (0)
- 18: Polar clock using donut chart [Excel Visualization fun] (11)
- 16: Photographic Fridays #9 – Here now, gone later (0)
- 15: Is this Google adsense ad misleading? (6)
- 15: Charts of the Week [Aug 15] (2)
- 14: Plot your data around the clock [Excel charting idea] (11)
- 13: Simulating Dice throws – the correct way to do it in excel (13)
- 13: Beyond If and Sum, 15 really useful excel formulas for everyone (63)
- 12: The Olympic Medals by Country Chart – Improved now (4)
- 12: Excel Links of Week – Who is Obama edition? [Aug 12] (2)
- 11: Use min-max charts to show the spread of data – Charting Best Practice (18)
- 11: Search restaurants by cuisine – Google maps (2)
- 08: Photographic Fridays #8 – Somewhere in the paradise (1)
- 07: 5 Infographics that can WOW you [Aug 7] (0)
- 07: Excel Basics: How to add drop down list to validate data (25)
- 07: Dashboarding Fun – Display Smileys in your excel dashboards (10)
- 06: Doing the NY times Olympic medals by country year visualization in excel (34)
- 05: Vizooalization: 5 things I have learned about visualization at the zoo (4)
- 05: Analyze your blog post’s readability with Google docs (0)
- 04: Add more superstars to your gmail (0)
- 04: Excel links of the week : ‘what can excite you most’ [Aug 4] (2)
- 04: Conditionally play sounds when a cell value changes (17)
- 04: Amul is Seriously Good – How agile is your brand? (1)
- 02: Welcome readers from Lifehacker and Delicious (0)
- 02: Photographic Fridays #7 – What makes you run? (0)
- 01: Excel can be Exciting – 15 fun things you can do with your spreadsheet in less than 5 seconds (75)
- July 2008 (34)
- 31: 500+ subscribers, great content, wow this site must be good ! (12)
- 31: Cool infographics around the web – [july 31] (0)
- 30: Want to Feed RSS to your Excel Sheet? Read this! (29)
- 30: Windows Mojave Experiment Kicks Ass (1)
- 29: Excel Links of the week (1)
- 29: 11 very useful excel keyboard shortcuts you may not know (32)
- 28: Which teacher inspired you most? (1)
- 28: Shuffle a list of numbers / items in excel spreadsheet (22)
- 25: Dear Microsoft, Blog is a real word (2)
- 25: Photographic Fridays #6 – Where do you want to go today? (2)
- 24: Mute conversations in Gmail to not follow a specific thread of mails (0)
- 24: Cool infographics around the web (0)
- 23: Watch out if you are buying insurance online at GEICO – your password is not encrypted (2)
- 23: Extract URLs from an excel spreadsheet cell using UDFs (0)
- 22: Changing Sort Orientation in Excel – Sorting across columns instead of rows (6)
- 22: Google Maps adds directions by Public Transport – Wow (4)
- 22: Excel Links – to iPhone or not to iPhone edition (3)
- 21: Excel Bullet Graphs (24)
- 18: Photographic Fridays #5 – Dawn (0)
- 18: Awesome folks at flickr introduce instant zoom for photos (0)
- 17: Improve your in-cell charts with colors and negative values (18)
- 17: Worst bar chart ever? – World’s Most Expensive Places to Have Sxx (2)
- 16: Bingo / Housie Ticket Generator in Excel (41)
- 15: Incell Bar charts – Revisited (28)
- 14: Use Google docs to track your bucks – [spreadsheet forms idea] (11)
- 11: myRoom.makeSuperCool() (8)
- 11: Photographic Fridays #4 – Fireworks (0)
- 10: Yahoo hopes to create more apps than no. of atoms in observable universe (0)
- 10: Partition Charts – Continuation – [More visualization fun] (3)
- 09: Partition Charts in Excel – alternative to pie charts [visualization hack] (17)
- 08: How to count words in a cell using excel functions (7)
- 05: Photographic Fridays #3 – Daisies (3)
- 03: Vodafone – creativity gone awry (10)
- 02: Copy like a cat – paste like a pro : 17 excel pasting tricks you must know (149)
- June 2008 (21)
- 30: Skip weekends while autofilling dates in excel (17)
- 30: Google maps 3d building outlines – wow (1)
- 27: Are you ready to solve problems differently? (0)
- 27: Photographic Fridays #2 – Marbles (6)
- 26: Hot Thermometer Charts in Excel – here is a cool way to do them (23)
- 24: Get Stock Quotes in Excel (23)
- 23: Most bizarre print ads – Indian version (2)
- 20: Photographic Fridays # 1 – Ground Zero (6)
- 19: Quickly display unique items in an excel list using advanced filters (11)
- 18: Stop feeling lucky, its just a google sari (1)
- 17: Here is a simple way to get Rs. 70 Lakhs when you are 55 – DONT touch your PF (0)
- 16: Formatting numbers in excel – few tips (14)
- 13: Incredible hulk strikes IMDB – awesome online ad (4)
- 12: Sunset (1)
- 11: App. idea for iPhone developers (for other location aware phones as well) (5)
- 09: Learn Excel IF Formula – 5 Tricks you Didnt know (104)
- 09: Cool outdoor advertising by Google Russia (5)
- 06: Am I a Japanese Translator? (2)
- 05: “I am feeling lucky” Firefox Search plug-in (0)
- 04: Email marketing is NOT distributing pamphlets (3)
- 02: How simple is your product? (0)
- May 2008 (20)
- 30: Improve productivity by opening same excel sheet in 2 windows – quick tip (1)
- 30: Inspiring (0)
- 29: Brooklyn Bridge in the night (1)
- 28: How to add a range of cells in excel – concat() (87)
- 23: Road Rage on Memorial weekend (0)
- 22: Get crazy CNN headlines on your t-shirt (2)
- 21: Welcome to Pointy Haired Dilbert – Chandoo.org (3)
- 20: Gantt in 60 seconds – churn out an excel project plan in no time (9)
- 19: Citibank’s brilliant “no panga sab changa” ad (6)
- 14: Rediff unLOCKS mystery of successful CEOs (2)
- 14: Here is a free idea for Starbucks (5)
- 14: MPD (3)
- 13: Creating in-cell bar charts / histograms in excel (41)
- 12: Shootout @ Hocking hills state park (0)
- 08: Dhoni sizzles in Tamilified ads (0)
- 07: Create in-cell pie charts in Excel (21)
- 05: on vlookup() (2)
- 02: Open your favorite sites directly from Windows XP run dialog box (7)
- 02: 7 Most innovative software job titles (1)
- 02: Calorie card : a sound business idea for gyms / health clubs (5)
- April 2008 (19)
- 30: Lenevo x300 ad mocks Macbook Air (5)
- 30: Vodafone pug is happy to help you .. or really? (4)
- 29: Another web advertising failure – shoppers stop (1)
- 28: Purnography on the lake – trip to Ashtabula county, put-in-bay (4)
- 24: Telling a kid how software development teams work (0)
- 23: Hot Fuzz – must watch for comedy lovers (1)
- 22: Create Cool Tag Clouds in Excel using VBA (26)
- 18: Mutual Fund Portfolio Tracker using MS Excel (114)
- 16: Do not disturb : I am scheduling a meeting (5)
- 15: Generate organization charts in excel – howto? (9)
- 11: frAGILE software development (3)
- 10: Focus on customers, not on your brand (2)
- 09: How to get more colors in excel chart – simple trick (10)
- 08: Google menu – does it lack common sense? (3)
- 07: Powerpoint Cartoons #3 – Auto fill (0)
- 07: Best of Indian Outdoor Advertising (5)
- 04: Change cell formats with find-replace in excel (5)
- 03: Few good Indian print ads – horlicks, maggi, zandu balm and head & shoulders (1)
- 01: Gmail custom time – fools day present for time travelers (4)
- March 2008 (18)
- 31: Null Pointer Exception (0)
- 28: 73 Free Designer Quality Excel Chart Templates – Grab now and become a charting superman (84)
- 26: PHD’s Regular Blah #12 (2)
- 24: Did you see the moon-walking bear? – nice ad (2)
- 21: Wow! – Traveling salesman in the age of ebay (1)
- 20: Track / share your goals using Google Spreadsheet Gadgets (4)
- 19: Car gets PHD, nobody is hurt (10)
- 18: CNN-IBN messes up global warming with local warming (2)
- 17: Powerpoint Cartoons #1 (3)
- 15: Nike’s new “my better is better than your better” ad kicks a$$ (0)
- 15: 3 excel keyboard shortcuts that can save a lot of time for you (9)
- 14: PHD gets lifehacked deliciously !!! (9)
- 13: Conditional Formatting in Excel – 5 Tips to make you a Rockstar (256)
- 11: IIM Indore 2008 Placements (1)
- 11: Hackers sneak into Serena Williams on Ramp (0)
- 10: Pulsar Mania – Bajaj’s new kickass advertisement (4)
- 05: Red is new black … or what? (2)
- 04: IT Mafia – hilarious spoof on Indian IT Industry (1)
- February 2008 (8)
- 25: Custom Cell Formatting in Excel – Few Tips & Tricks (113)
- 23: Why do notebook page layouts suck? (7)
- 20: Busy! (0)
- 16: 5 !!! I Did it (5)
- 12: Nationwide Paintbucket Guerrilla ad – nicely done (1)
- 06: Super(b) Tuesday! (5)
- 03: Proud owners of Macbook (3)
- 01: How not to hang your clothes? (1)
- January 2008 (16)
- 29: Huh! (5)
- 28: PHD’s Regular Blah #11 (4)
- 25: How to: sharing trip expenses using excel (12)
- 23: Subliminal Soup Ad from Potbelly (4)
- 22: Weekend @ Washington (0)
- 18: Mobile Banking Innovation from ICICI Bank (9)
- 17: Business Idea : Train / Flight Ticket Printing Machine (19)
- 14: Pointy growth inside nose and other such meaningless junk (5)
- 12: Amazon’s recommendation system – is it crazy? (6)
- 11: How I redirect traffic from blogger pages to wordpress posts (5)
- 10: Mera Jahan (8)
- 09: Lessons from music industry (0)
- 08: CAT 2007 results out! (0)
- 08: Tales of riding an auto in Chennai (3)
- 07: Auto tagging your old blog posts (15)
- 03: Normal is Boring : Having fun in whatever you do (0)
- December 2007 (10)
- 31: Happy New Year (4)
- 31: Economics of commission (0)
- 30: Lakdi Ki Kathi (0)
- 28: Comedy Movies – Must Watch (3)
- 26: How NOT to do Online Advertising – Lessons from Rediff (1)
- 23: Moved to WordPress from Blogger (6)
- 14: Proud Owner of iPod Nano (1)
- 10: My life in a mini-feed (0)
- 07: Please enter todays date to continue … (0)
- 04: Software or Strictware ?!? (1)
- November 2007 (2)
- 26: Welcome to Ummrica! (1)
- 20: PHD Regular Blah – the Nth installment (0)
- October 2007 (3)
- 31: Pay money but seek no control ! (0)
- 26: Wear… Will you? (2.0) (0)
- 10: Australian Team Spirit (0)
- August 2007 (3)
- 27: Back in Hong Kong (0)
- 05: RIP (0)
- 02: My screen just widened! (0)
- July 2007 (5)
- 27: Hong Kong – Made for tourists (2)
- 23: Off to Hong Kong (0)
- 14: 3 years and counting (0)
- 11: Question for MBAs (0)
- 02: Refreshing online ad (1)
- June 2007 (3)
- 27: The Art of Excel Charting (10)
- 18: 2 hours in Mediterranean (0)
- 04: PHD’s Regular Blah #9 (0)
- May 2007 (6)
- 25: Shift (0)
- 18: An Irish Evening (1)
- 15: in Dublin Now! (0)
- 14: Busy! (0)
- 05: Amul – an agile brand (2)
- 02: In Mumbai Now (0)
- April 2007 (10)
- 29: First and Last Golden Rule of Any Business – Know Your Customer (0)
- 29: Toothpic! (0)
- 28: Looking for a house in Chennai… (0)
- 19: Big Bazaar’s Innovative Parking Scheme (0)
- 16: Source of Happiness (0)
- 11: Business Idea: Community Water Purifiers (0)
- 11: Mobile Tailor (0)
- 04: PHD’s Regular Blah #8 (1)
- 04: Start Early (4)
- 01: Pelli Photos (0)
- March 2007 (6)
- 30: Making sense out of NEWsense (0)
- 30: Fresh MBAs and IT Companies (1)
- 26: The problem with B-schools (0)
- 22: The Calvin Fund! (0)
- 20: Say NO to Default Charts Forever! (1)
- 13: Busy! (0)
- February 2007 (10)
- 28: PHD’s Regular Blah # 7 (1)
- 25: Is Monopoly Fair? (13)
- 22: Do you know that Excel cant … (3)
- 20: Are fund managers poor marketers? (0)
- 15: Excel Charting Hacks #1 (1)
- 14: newsXXX (0)
- 12: Find out whether you need a house or not in 60 seconds (1)
- 09: Welcome to Madhu2.0 (0)
- 05: Musings of a Married Manager (0)
- 02: I am back… (0)
- January 2007 (3)
- 17: Blog Holiday! (0)
- 08: PHD’s Regular Blah #6 (0)
- 05: 10 good things about Seoul (0)
- December 2006 (14)
- 31: Birds of different feather flock together (2)
- 27: PHD’s Regular Blah #5 (0)
- 27: The Art of Imitation (0)
- 24: Merry Christmas (0)
- 22: Good news for Indian Movie lovers (0)
- 20: Desk-top Purnography (0)
- 19: PHD’s Regular Blah #4 (0)
- 10: Dongdaemun (0)
- 09: I love missing the last bus to office (0)
- 07: Creating New MFs – the SBI way (0)
- 04: PHD’s regular blah #3 (0)
- 04: Competition (0)
- 02: Purnography in Seoul (0)
- 01: Weekend Plans (0)
- November 2006 (10)
- 27: Seoul First Impressions (0)
- 25: In Seoul now… (0)
- 23: Supply Creates Demand (0)
- 20: Innocent Websites, pissed off clocks and such like … (1)
- 17: PHD’s regular blah # 2 (0)
- 14: Sweet Nothings (1)
- 13: Howto: Excel Based Mutual Fund Portfolio Tracker (3)
- 07: Lessons in Pricing from Murugan Idli Shop (0)
- 04: 3 Cheers to IIM Indore (0)
- 01: Redif(f)ining art of converting news to scoops (0)
- October 2006 (8)
- 29: Why arent IT jobs glorified in B-school Placements? (0)
- 25: Purnography – some latest work (0)
- 25: PHD’s Regular Blah! (2)
- 20: Offer for PHD Readers (0)
- 12: Carl Sagan, Frying Pan and Local Election (0)
- 11: New-Clear Advertising (0)
- 07: In the age of Adsense and TRPs (0)
- 05: Blue Dart Rocks! (0)
- September 2006 (14)
- 29: Coimbatore Bus Mafia and Adventure Trip to Ooty (1)
- 28: You Know … (0)
- 27: Relationships & Banks (0)
- 26: Cameras: Most Popular vs. Most Clicked (0)
- 19: Dhud! Dhud! Dhud! Dhud! (0)
- 13: Google Life! (0)
- 12: Porok, Call back Ads and Simple Joys of Life (0)
- 08: US Legal Firms, Infosys Employees and Online Advertising (0)
- 05: Welcome to PHD! (0)
- 05: 3 Steps to Create cool dashboards in excel (6)
- 04: R1C1 – Excel Here Launched (0)
- 04: How to Get Unique Items using Excel (9)
- 03: Importing blogger posts to wordpress (0)
- 01: Shoot the guy in eyes, you could get some discout… (0)
- August 2006 (7)
- 30: The biggest error message ever! (0)
- 29: Google Grrs at Google (0)
- 29: 2 seconds to go! (0)
- 25: Duct tape found! Three men arrested!!! (0)
- 18: How too many dishes spoiled the cook… (0)
- 11: A dream that is three and half years old… (0)
- 03: Orbit Musings and other things (0)
- July 2006 (10)
- 31: A date with my plate! (0)
- 27: A bachelors guide to renting a house in Chennai (0)
- 24: CATvertising (0)
- 21: Learnings of the week that was (0)
- 19: Now Adsense in Hindi (0)
- 15: Bombay – Pune Expressway : A travelers Delight (1)
- 14: How to serve the customer (0)
- 11: Wear, will you? (0)
- 06: HOT HOT Advertising (0)
- 05: Chennai – First Impressions (0)
- June 2006 (6)
- 30: Happy Weekend :) (0)
- 27: Chennai it is (0)
- 19: Updates… (0)
- 15: Overheard (0)
- 07: Super Copy (0)
- 03: Purnography @ Khandala (0)
- May 2006 (6)
- 29: In search of khandala… (0)
- 26: Aati kya khandala? (0)
- 12: A Day without Internet :) (0)
- 08: Whats cooking PHD? – Part 2 (0)
- 05: Focus on Details = Satisfied Customers (0)
- 04: Sunstroke and other things (0)
- April 2006 (11)
- 27: A trip I waited too long to make (0)
- 24: Understanding Customer – Insights from street (0)
- 22: Whats cooking PHD? (0)
- 21: Broad Band baj gaya!!! (0)
- 20: Now… (0)
- 14: Bas Dimag Lagao! (0)
- 12: The Art of Doing Nothing (0)
- 10: Welcome to Cashless world (0)
- 06: New number (0)
- 03: IIM Indore Convocation – 2006 (0)
- 01: in Campus (0)
- March 2006 (6)
- 28: Trip to North East India – frist cut (0)
- 25: Done with the trip (0)
- 11: Crash Reported, No dead bodies found! (0)
- 09: unSafexpress and other stories … (0)
- 04: in Cyderabad (0)
- 01: More on placements, graduation etc. (0)
- February 2006 (16)
- 28: TCS it is (4)
- 25: Farewell Party and the deadly hangover (0)
- 23: Loading MBA … ;) (0)
- 22: What is keeping me busy? (0)
- 20: The "notag pact" tag (0)
- 19: 12 days… :( (0)
- 18: Magazine advertising gets better (0)
- 17: MMT rocks again (0)
- 16: Unmaking of Business Sense (part 1) (0)
- 14: Low Dick Space (0)
- 12: 20 years: longest time to make another brick? (0)
- 10: How not to do advertising online? (0)
- 09: Moving to WordPress… (6)
- 07: 9 sureshot ways to kill your audience using powerpoint (0)
- 03: A new press to publish PHD Blog!!! (0)
- 03: My blog is infected…. (0)
- January 2006 (15)
- 31: SBI Life: Message that hits (1)
- 31: Misguided Enthusiasm? (0)
- 26: a lot of nothing (0)
- 21: HIV/AIDS – Interactive Campaign (0)
- 18: Absolut Shift (0)
- 17: Photographer and a lazy afternoon (0)
- 16: Welcome to the miraculous world (0)
- 16: <50 left … (1)
- 13: Happy Sankranthi (0)
- 10: My date with a mall (0)
- 09: Innovative New year calendar from Kotak (0)
- 06: Brands, Stop assuming customers are dumb! (0)
- 05: How Much Pointy Haired are you? (1)
- 03: 10 things that I cherish about 2005 (0)
- 02: CAT 2005 Results (0)
- December 2005 (12)
- 31: New Year (0)
- 30: PHD Blogmela (1)
- 29: PHD Blogmela, coming tomorrow :) (0)
- 28: Rediff Shopping – another failure (0)
- 26: Merry Christmas… (0)
- 24: Where will the multiplex go now? (0)
- 23: PHD Blogmela (0)
- 17: Some things and Some links… (0)
- 14: Surprisingly Banks (0)
- 12: Bah’k (0)
- 05: Hols… (0)
- 01: Winter makes this place sexier (0)
- November 2005 (12)
- 29: JIT – Writer’s notes from implementation (0)
- 27: The lastmile of online shopping (1)
- 24: Shareholders, value creation and all that bushllit (0)
- 23: How we think! (0)
- 19: CAT (0)
- 18: Major Audio System Change Reported in Indore!!! (0)
- 16: 500 days of PHD (0)
- 14: IRIS 2005 (0)
- 11: IRIS all the way (0)
- 06: Tell me where I can fit this (0)
- 04: PHD in new Avatar (0)
- 02: Salmagundi of sense and nonsense (0)
- October 2005 (6)
- 20: Many Many Happy Returns of the Day! (0)
- 19: Online Advertising (0)
- 15: Emote your customers (1)
- 11: My friend calls me "anti-bloggers, pro-iipm, pro-information secrecy dude", but … (0)
- 09: MarkeThink! (0)
- 05: The Good Old Days of Coding! (0)
- September 2005 (7)
- 29: mAdness? (1)
- 26: Life with out ‘i’ (0)
- 23: Purnography – September Sky (0)
- 17: IRISING (0)
- 12: getLatestUpdates() (0)
- 09: Finally I am 10+ (0)
- 04: Doing Nothing (0)
- August 2005 (15)
- 29: Recipe of my L!fe (0)
- 26: Leh Trip – Part 3 (0)
- 25: Sins of earlier lives (0)
- 23: Business (non)sense? (1)
- 20: Blogger for Word (0)
- 19: Leh Trip – Part 2 (0)
- 18: Feel Like God! (0)
- 17: Leh Trip – Part 1 (0)
- 16: Bah’k! (0)
- 06: bLAW bLAW bLAW! (0)
- 06: All set to go (0)
- 05: Ladakh Itinerary (0)
- 03: What the hell is this? (0)
- 02: Meeting with Mr. Barber (0)
- 02: And one day… (0)
- July 2005 (19)
- 31: Who can teach you to be passionate? (2)
- 31: Wanted to blog… (0)
- 28: Photo Quiz (0)
- 26: Perdition and Paradise – 2 (0)
- 25: Perdition & Paradise (0)
- 25: G O V A R gets visibility (0)
- 23: Busy and how? (0)
- 21: Busy! (0)
- 18: Water Fight Ver. 2.1 (0)
- 17: Sportstar ads (0)
- 15: Brand Extension (0)
- 13: You have got mmmmmmmmmmmmmail! (0)
- 13: They are back (0)
- 11: Dude! where is my fullstop? (0)
- 09: World through my window.. (0)
- 08: Fundu Error Message (0)
- 06: Why is selling soaps over-hyped? (0)
- 03: Come again? (0)
- 02: Purnography – offroad style! (0)
- June 2005 (24)
- 30: Usage Masks (0)
- 29: iShuffle! (2)
- 28: Purnography – Still worshipping the beauty (0)
- 27: Freedom (0)
- 24: Welcome ‘Link Yard’ (0)
- 22: Beautiful days are here again (0)
- 21: Know your internship insideout (0)
- 21: Bhooth Bangla or Plain Residential Complex? (0)
- 20: atTAG of the clones! (0)
- 19: Skype’d (0)
- 18: MBA is all about… (0)
- 18: Purnography – in the night (0)
- 18: Which one’s better? (0)
- 17: Is Mallika Sherawat the next bigthing happening to India? (0)
- 17: 2nd year begins ahoy! (0)
- 17: Its raining baby… (0)
- 16: News – where have you gone? (0)
- 15: A-305 2 C-320 (0)
- 14: Bah’k (0)
- 08: Purnography – The VT ishtyle (0)
- 08: Adness or Madness? (0)
- 03: Eat Out! (0)
- 02: Smart Tagging or Dumb Tagging? (0)
- 01: Busy! (0)
- May 2005 (14)
- 27: Purnography – Delayed but Delightful (0)
- 25: A beer that costed too much (0)
- 24: What is brain? (0)
- 23: Blurb (0)
- 22: B2B (0)
- 17: Heat waves and gujju looks (0)
- 15: Picture ? Puncture! (0)
- 11: PG on TV (0)
- 11: Nagpur dossiers (0)
- 09: Orange City (0)
- 06: The ultimate management book series (0)
- 04: Theobroma Delicacies! (0)
- 03: travailogue (0)
- 03: Pune! (0)
- April 2005 (19)
- 30: What a life… (0)
- 27: A nights tale (0)
- 26: Local Advertising (0)
- 25: A weekend that was… (0)
- 21: Purnography – 3 (0)
- 19: Vimukthi from world of cubes… (0)
- 18: Otherwise a lazy weekend (0)
- 17: Lazy Weekend (0)
- 15: Purnography 2 (0)
- 14: Chowpatti beach (0)
- 13: A date with just another mumbai bar & restaurant (0)
- 11: Updates (0)
- 10: From Bombay (0)
- 09: Purnography 1 (0)
- 09: 1/2 and how? (0)
- 07: Updates… (0)
- 05: First time and How! (0)
- 02: 3 Things (0)
- 01: LWD, 360, 4Ps, 5Ms, 3Cs and other not-so boring stuff… (0)
- March 2005 (25)
- 29: Who has the bigger one? You or me? (0)
- 29: Error (0)
- 26: Rang Barse… (0)
- 26: Holi Haiyeeeeee! (2)
- 25: Of career and electives… (0)
- 22: Freebees… No please! (0)
- 21: Convocation 2005 (0)
- 21: Convocation Today (0)
- 19: Thoughts in mind (0)
- 17: In retrospect: 3rd Block Rocks (0)
- 16: Almost forgot this… (0)
- 16: :) (0)
- 15: :( (0)
- 13: Presented Propaganda and Other Stories (0)
- 12: Urgently Needed (0)
- 11: Unlever or Unilever? (0)
- 09: PoWAH (0)
- 08: Leader or Manager? What is my calling? (0)
- 06: T4 – Treak To Table Top (0)
- 05: The PHD Blogmela (0)
- 04: The PHD Blogmela (update) (0)
- 04: How to feel wonderful? (0)
- 03: Noteven a wink (0)
- 01: 5000 words (0)
- 01: Back to BUSIness (0)
- February 2005 (22)
- 27: My Hindi Sucks (0)
- 26: The Blog Mela – PHD Way (0)
- 25: Madhu (1)
- 24: Midterms over. Now what? (0)
- 23: Midterms and nothingelse (0)
- 22: Thinking (0)
- 22: About Classroom Humor & IT Textbooks (0)
- 21: 10000 visitors (0)
- 20: FINdigestible! (0)
- 20: midterms (0)
- 19: You are simply the BEST (0)
- 18: busy! (0)
- 16: (0)
- 15: Power Salad and Other Valentine Stories (0)
- 13: of bulging, purging, choking and loving (BPCL) (0)
- 10: its a beautiful day! (0)
- 09: Exposed! (0)
- 07: It is a strict reGYM, your HIGHness! (1)
- 05: The holiday in a B Schoolers life (0)
- 03: My First Night (out) @ I (0)
- 02: Yahooligans (0)
- 02: Last 24 hours (0)
- January 2005 (17)
- 31: My appointment with Dr. Lecter (0)
- 30: Sunsets @ I (0)
- 29: Think (2)
- 27: Are we far from reality? (0)
- 26: All I Wanted to Say about GD/PI (2)
- 25: My current playlist (0)
- 24: What did you say your name is??? (0)
- 22: Accounting of Exams ! (0)
- 21: Latest @ PHD (0)
- 20: UtsAHA Pics… (0)
- 20: Ideas … Infinite! (0)
- 19: Host problem (0)
- 16: The AHA Effect! (0)
- 13: Happy Sankranti (0)
- 11: Busy (0)
- 08: Time of my life (0)
- 07: bah’k (0)
- December 2004 (32)
- 30: on Vacation (0)
- 28: help (0)
- 27: Of exams and holidays (0)
- 27: 27 and counting down (0)
- 26: how true!!! (0)
- 25: Kaisa chal raha hi? (0)
- 25: festive time in I (0)
- 24: Merry Christmas (0)
- 24: busy (0)
- 22: no time to blog :( (0)
- 20: outLOGging, 100 percentiles and Spamming (0)
- 19: See the learning (0)
- 19: Things my girlfriend and I have argued about… (0)
- 19: Feeling mighty good (0)
- 17: derivated humor (0)
- 17: its quiztime baby! (0)
- 16: c’est la vie (0)
- 14: Syndicating a day of my life! (0)
- 14: Its official now (0)
- 13: Three Things (0)
- 13: Kingsize weekend (0)
- 12: The legend passes away (0)
- 11: Duh!, even I did it (0)
- 10: Welcome to Chandoo.org ! (0)
- 10: Moved ! (0)
- 08: alphabetical grades and assorted updates… (2)
- 06: Marcovian queues, arranged marriages and forefathers !!! (6)
- 05: When machines get better than humans (0)
- 04: Escape to Reality – Part III (2)
- 04: Escape to Reality – Part II (2)
- 04: Escape to Reality – Part I (2)
- 02: I stink, therefore I exist (1)
- November 2004 (20)
- 30: grades, links, threads and deadlines (0)
- 29: Yuhoo !!! (0)
- 27: 150 days of Blogging and B School Life (10)
- 24: are you doing BLOWJOB??? (2)
- 22: 210 minutes of tragedy and 120 minutes of comedy … (4)
- 22: FIN-OM-ania (0)
- 20: Billi ka Shubh Din (0)
- 18: moc(k) shocks and research rags (0)
- 17: 4Ls – Link, Laughter, Lazyness, Losses (2)
- 15: bullCheat, bto and gut feelings (2)
- 14: Amazing reality of marketing surveys (0)
- 13: Awesome Diwali Night (3)
- 11: Strategic Repositioning of Blog (0)
- 11: Macro Gibberish (0)
- 10: Happy Diwali (0)
- 09: Random Thoughts (1)
- 08: The making of huge cutouts (0)
- 05: Who blinks first? (0)
- 04: Smirnocked!!! (0)
- 01: Its beeness as usual at I (0)
- October 2004 (10)
- 31: Mission Statement of Group 7 (4)
- 29: Age old theory of age !!! (1)
- 28: of Fishes and Idiots and Outsourcing (2)
- 27: Pick the Pix (0)
- 25: Making Location & Capacity Decisions (2)
- 25: when 30 becomes 29 … (0)
- 21: Long time, no see (1)
- 04: Start (2)
- 01: The mother of all terms (1)
- 01: T1 – An Interim Status Report (0)
- September 2004 (7)
- 25: MMF (0)
- 15: And the proverbial Nail in the coffin… (1)
- 14: aAH 2 mORE dAYS (2)
- 13: Superb Tail Piece (1)
- 08: Janmastami and other good things are here !!! (3)
- 04: So, What is happening??? (0)
- 01: Subject-ed Humor (0)
- August 2004 (18)
- 28: Its all in Game Theory Stupid!!! (6)
- 27: Of Lines and the troubles associated with them… (2)
- 26: I want a day like this everyday !!! (0)
- 25: Do you masturbate in class??? (0)
- 24: ‘sleeper’ class-apart (0)
- 22: Wake up man, You have a meeting now!!! (6)
- 19: Jargon Stanle-i (4)
- 18: Snapshots from hell (3)
- 17: Fasting, ‘Present’ations and Future Tensions (1)
- 16: Mad Termination (2)
- 12: New Timings, Same Work (1)
- 11: Messenger Cometh (0)
- 10: The Rape that i was talking about…. (1)
- 10: New Template, New Life (1)
- 09: Cliched but Yes.. (0)
- 06: alive and getting kicked (2)
- 01: Cold calls and Other insights (0)
- 01: Bizzee Busted and other stories (1)
- July 2004 (20)
- 30: Newsh… (0)
- 30: My Dreams (???) (1)
- 26: Announced Surprize,Words of the day and Armageddon (2)
- 25: Bartended!!! (2)
- 21: Full Swing (0)
- 19: What a weekend it has been…. (1)
- 16: Sexy Atmo (2)
- 13: Bizzy Bees (1)
- 10: Informal Night & other stuff (0)
- 09: I is Wet… (4)
- 08: Learnings all the way (2)
- 06: updates from a weakling… (0)
- 04: Jet, set and go (1)
- 04: Pictures (2)
- 04: more cases and saturday night party (0)
- 02: sleep depravation and power point ragging (1)
- 01: Added Later… (0)
- 01: Life slowly begins (1)
- 01: First Day – First Show (2)
- 01: … and thus born Modus Indoramus (5)
Archives time line:
At Chandoo.org, I have one goal, "to make you awesome in excel and charting". This blog is started in 2007 and today has 350+ articles and tutorials on using excel, making better charts. 
