All articles:
Showing latest post on top
- How to calculate WEEKNUMBER in Month / Quarter / Year with Excel?
- Automatically Format Numbers in Thousands, Millions, Billions in Excel [2 Techniques]
- How to compare two Excel sheets using VLOOKUP? [FREE Template]
- Sales Analysis Dashboards with Power BI – 30+ Alternatives
- Announcing Power BI Dashboard Contest (win $500 prizes!)
- Compound Interest Formula in Excel
- How to convert test scores to letter grades in Excel?
- How to calculate the Gender Pay Gap using Excel Formulas? (Free Calculator Template)
- Weighted Average in Excel [Formulas]
- How to get non-adjacent columns with FILTER function in Excel
- What is XLOOKUP and how to use it in Excel?
- Get all BOLD text out Excel Cells Automatically
- How to fix SPILL Error in Excel Tables (3 easy solutions)
- Loan Amortization Schedule in Excel – FREE Template
- How-to create Dependent Drop Downs in Excel [Dynamic & Multiple]
- VLOOKUP(), MATCH() and INDEX() – explained in plain English
- Beautiful Staff Roster Excel Template [FREE Download]
- How to calculate time between two dates in Years, Months & Days [Excel Formula]
- 35 shortcuts & tricks to make you an #AWESOME Data Analyst
- FREE Calendar & Planner Excel Template for 2024
- CP05: Interview with MrExcel – Bill Jelen (on his incredible work ethic)
- Who went to both USA & UK? [Excel Challenge]
- Top 10 Power BI Interview Questions & Answers
- SQL vs. Power Query – The Ultimate Comparison
- Calculating Critical Path using Excel Formulas [Project Management]
- How to make a pivot table when you have data in multiple sheets [Tutorial]
- Python is in Excel! – Here is a complete getting started guide for you
- CP03: The Ugly Truth About Power BI (actually, 4 of them)
- How to “auto” generate calendar tables with Power Query – The best method
- Top 10 Accounting KPIs and How to Calculate them in Excel?
- CP02: Six Tips to get a Six Figure ($100,000+) Data Job
- Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast)
- When & how to use the 30+ chart types in Power BI?
- Make an Impressive Interactive Map Chart in Excel
- How to Create a Dynamic Excel Dashboard in Just 5 Steps
- Speed up your Excel Formulas [10 Practical Tips]
- A clever technique to simplify your long, nested IF formulas
- Create a beautiful, elegant & interactive to-do list with Excel (FREE Template + Tutorial)
- Send Email from Excel with Office Scripts & Power Automate
- Top AI features in Excel – a round up
- Learn Advanced Excel – 3 Month Roadmap with Resources
- The Excel Mandelbrot
- FREE Calendar & Planner Excel Template for 2023
- Merry Christmas & Happy New Year 2023
- Range Lookup in Excel – How to lookup the pricing tier? [Formulas]
- #### in Excel cell
- How to connect to a SINGLE file on SharePoint from Power Query (Fix Unable to Connect Error)
- FIFA 2022 World Cup Schedule & Results – Excel [FREE Download]
- Filter one table if the value is in another table (Formula Trick)
- Which Excel Formulas should you learn first?
- Mortgage Calculator with Extra Payments – Excel Download
- Learn SQL for Data Analysis in one hour
- How to create interactive tooltips in Power BI (step by step)
- How to learn Python as an “Excel person”?
- Can you split “The Hangover” expenses? [Excel Homework]
- What is LAMBDA? 4 Practical examples to REALLY understand it
- FREE 2022 Calendar & Monthly Planner Printable Template
- Merry Christmas & Happy New Year 2022
- How to write complex Excel formulas (hint: it’s a lot like LEGO)
- Sorting values in Olympic Medal Table style [Quick Tip]
- How to use Date & Time values in Excel – 10 + 3 tips
- Getting Started with Power BI – Sales Dashboard in one hour
- 6 Essential TEXT functions in Excel with 6 Everyday Examples
- How to create a fully interactive Project Dashboard with Excel – Tutorial
- Getting Started with Power Pivot & DAX – FREE Live Masterclass
- Extract data from PDF to Excel – Step by Step Tutorial
- 10 Advanced IF formula tricks you must know
- Write a formula to get Department Budget for a Month [Homework]
- How to embed Excel files, calculators on your website? – Step by step instructions
- Dynamic Arrays Live Masterclass – Replay
- 5 Simple & Useful Conditional Formatting Tricks
- Merry Christmas & Happy New Year 2021
- Image Lookup – How-to show dynamic picture in a cell [Excel Trick]
- 9 Box grid for talent mapping – HR for Excel – Template & Explanation
- 6 Must Know Line Chart variations for Data Analysis
- Two-level Data Validation [Excel Trick]
- Excel formula to convert calendar format to table
- Power Query Tutorial – What is it, How to use, Full examples, Tips & Tricks
- Project Plan – Gantt Chart with drill-down capability [Templates]
- Introducing Power BI Play Date – Online class to master Power BI (oh yeah, Power Query & Power Pivot too)
- How to make stream graphs in Excel?
- These Pivot Table tricks massively save your time
- 50% done – mid year updates for 2020
- Top 10 Excel formulas for IT people
- Lookup last non blank value – Excel Challenge
- Excel TEXTJOIN Function – What is it, how to use it & 3 advanced examples
- How to make a variance chart in Power BI? [Easy & Clean]
- How to make an Interactive Chart Slider Thingy
- How to export YouTube video comments to Excel file? – Free template + Power Query case study
- Celebrating 50k Subscribers on YouTube + Give away
- Highlight due dates in Excel – Show items due, overdue and completed in different colors
- Multiple Find Replace with Power Query List.Accumulate()
- How to show positive / negative colors in area charts? [Quick tip]
- 6 Best charts to show % progress against goal
- Easy Website Metrics Dashboard with Excel
- What are Excel Sparklines & How to use them? 5 Secret Tips
- Add slope line to XY charts
- Excel Dynamic Array Functions – What are they, how to use them, Examples and FAQs
- There are 20 Easter Eggs in this Workbook
- Is there a secret code in this data? [Excel Homework]
- Number to Words – Excel Formula
- A quick personal update
- 18 Tips to Make you an Excel Formatting Pro
- How-to create an elegant, fun & useful Excel Tracker – Step by Step Tutorial
- Advanced Pivot Table Tricks for you
- Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one
- Make a random sentence with Excel formulas
- Free 2020 Calendar Template & Daily Planner
- Merry Christmas & Happy New Year 2020
- Come and learn from me in London – April 2020
- Filter as you type [Quick VBA tutorial]
- Introduction to Power BI – What is it, how to get it, how to create reports with Power BI and how to publish them?
- Celebrate with spider web chart [Halloween Fun]
- Using IRR with Data Tables – Modeling Cash-flow Scenarios in Excel
- Impress with Tornado Charts in Excel
- Excel Basics: How to add drop down list to validate data
- Zelda Stamina Wheel Chart
- How can you analyze 1mn+ rows data – Excel Interview Question – 02
- #awesome trick – Extract word by position using FILTERXML()
- Show difference between cells in status bar – VBA Example
- Yummy WAFFLE chart in Power BI
- Job Title Matching Problem [Excel Homework]
- Free Excel Risk Map Template
- How to extract common values in two tables? – Power Query Tip
- VLOOKUP or INDEX+MATCH? – Excel Interview Question – 01
- How-to highlight maximum value in Excel charts? [Quick tip]
- Pivot Tables from large data-sets – 5 examples
- How to conditionally format visuals in Power BI?
- Tour de France – Distance & Pace over time – Radial Charts
- Make info-graphics with shape fill technique [Charting Tip]
- How to predict cricket scores [Excel + Machine Learning]
- Should finance people learn Power BI?
- Combine multiple Excel files using Power Query [Full example + download]
- How to trace precedents in Excel formulas? [tip+music from Prague]
- Circular Arc – Doughnut Charts
- 5 simple rules for making awesome column charts
- How many calls we got outside office hours? [Excel / Power Query homework]
- How to fake “Key influencers chart” in Excel?
- How to sort left to right in Excel (quick tip)
- There is an Easter Egg in this Power BI report
- VLOOKUP multiple matches – trick
- Source vs. Use of Funds – 14 charting alternatives
- Top 10 Excel Formulas for any situation
- Create impressive dashboard tiles in Excel
- Power BI Webinar, Amsterdam & Australia tours [update time]
- Employee Turnover Dashboard – Power BI for HR
- Quickly Change Formulas Using Find / Replace
- Quickly change charts from one to another with this trick
- Elevator problem – Excel homework
- Quick tip: Make a list of numbers (or dates) in Power Query easily
- Hui’s World ! – An Excel Project of Global Scale.
- Leave entitlement vs. usage analysis with Power Query
- How many people used their entire sick leave entitlement? [Power Query / Excel homework]
- Lenient lookup [Advanced Formula Trick]
- My top 5 tips for designing beautiful Power BI reports
- 5 tips: Power Query for Accountants (and finance people) – Free Masterclass
- When is the next Monday? [Homework]
- Performing Maths in Microsoft Word (In an Excel Blog)
- What is Power BI, Power Query and Power Pivot?
- How to get a random sample of data with Power Query
- Make funky and creative hand-drawn chart in Excel – Quick tutorial
- Top 5 with above average – Power Pivot Trick
- Announcing Excel School v2.0 – Quick intro and details inside
- 12 Steps to learn Excel and become awesome @ work in 2018
- Nest Egg Calculator using Power BI
- Excel School v2.0, blogging schedule, personal life – a quick update
- How to get percentage of something calculations in Excel Pivot Tables
- Top 5 HR Analytics Examples – Free Video Masterclass
- Calculate travel time and distance between two addresses using Excel + Maps API
- Mutual Fund Portfolio Tracker using MS Excel
- Play spreadsheet soccer with Excel Penalty Game [VBA]
- 100+ Excel Formula Examples + List
- How to undo in Power Query [Quick Tip]
- Which two teams qualify to next stage? [Excel Homework]
- Excel Tables Tutorial & 13 Tips for making you a Data Guru
- Best Excel Books & Power BI Books – 2018
- FIFA Worldcup 2018 Excel Tracker – FREE Download
- Introduction to Excel SUMIFS Formula
- Excel formula showing as text instead of actual result – How to fix the problem
- Distinct count in Excel pivot tables
- Beautiful Budget vs. Actual chart to make your boss love you
- 60 sports in six charts
- May the POWER BI with you [Star Wars Day Viz]
- A trick to Pivot text values
- Time series analysis and interactive forecasting in Excel – Sample video from 50 ways course
- Top 5 keyboard shortcuts for Excel Charts
- Create your first interactive chart in Excel with this tutorial
- How your country did in Commonwealth Games – Power BI Viz and Tutorial
- Visualizing Commonwealth games performance – Interactive chart
- Rescue oddly shaped data – Battle between Formulas, VBA and Power Query
- Maths worksheets for your kids – teach addition, subtraction & multiplication with these
- How many Excel themed cryptic crossword clues can you solve? [Easter Eggs 2018]
- Quick tip: Rename headers in pivot table so they are presentable
- One Control Three Cells
- Stay on top of money with this awesome household budget spreadsheet [downloads]
- How windy is Wellington? – Using Power Query to gather wind data from web
- This year, become a Very Table Genius
- 2018 Calendar, daily planner Excel templates [free downloads]
- Merry Christmas and Happy New Year 2018 [Holiday Card]
- How much long service bonus to pay? [Homework]
- 5 conditional formatting top tips – Excel basics
- Filter all records for November or 11AM or 2017 [quick tip]
- Thank you, we have a home in New Zealand
- Which power plan is best for me? Excel for everyday problems
- Conditional Rank, the easy way [quick tip]
- Formula Forensics 043: Rankifs or Conditional Rank
- How to Distribute Players Between Teams – Evenly
- Conditional Formatting – Chart Data Labels
- Histograms & Pareto charts in Excel – tutorial, tips and downloadable template
- Find out if a number has repetitive digits [formula homework]
- D’oh – Visualizing Homer’s favorite sayings in Power BI
- Keep Calm and Power BI [Breathing Exercise Vizzes]
- VLOOKUP that fat table with ease [3 quick tips]
- Epic Introduction to Power BI [video]
- Introducing Power BI Play Date online class [Details inside]
- Convert unevenly spaced list to table [Data from Hell]
- Copy Paste Visible Cells only (Two more ways to do it)
- Copy & paste visible cells only [Excel Trick]
- Awesome chart to visualize Salary Increases for 3,500+ people [Tutorial]
- Employee Performance Panel Charts in Power BI with R
- Employee Performance Panel Charts – Excel vs. R [video]
- Use File > Info to quickly unprotect multiple worksheets [Quick tips]
- Extract currency amounts from text – Power Query Tutorial
- Joyplot in Excel
- How to add a lot of Goal Seeking to a model
- Rounding time to nearest minute or quarter hour etc. [formulas]
- SUMPRODUCT Vs. Power Query on Mt. KauKau
- Jo’s first keyboard shortcut
- Start your bar charts from zero – Excel geeks screaming at you from mountain top
- Selective Sub-totals in Pivot Tables [Quick Tip]
- Avoid Hiring Boo-boos with Excel – COUNTIFS for the win [video]
- Relative References in Excel Tables
- Modelling Inventory Run Rate & Cash Flows using Excel
- There are 5 hidden cells in this workbook – Find them all [Excel Easter Eggs]
- How many employees are on leave during Easter holidays [Homework]
- Hide columns one one tab same way as they were in another place [quick tip]
- Sand Pendulums – Lissajous Patterns in Excel
- Reshaping your data easily – Case study [Pivot tables FTW]
- Figuring out Employee Churn with Power Query [HR Analytics]
- Kill NULLs – a Simple macro to save time when importing data from SQL Server
- Lookup most frequent item [Homework]
- Use CTRL to make copies of worksheets quickly
- Find them and Extract them – VBA Macro
- Designing awesome financial metrics dashboard [tutorial]
- Road Trip Planner Template [Excel Downloads]
- Get rid of that ugly formatting with two simple tricks
- Check for two out of three conditions (Homework)
- Untrimmable Spaces – Excel Formula
- Formula Forensics 042: Reverse Text – A Formulaic Solution
- Merry Christmas & Happy New Year 2017 [Holiday Greeting]
- An odd lookup problem [Formulas]
- Sorting to your Pivot table row labels in custom order [quick tip]
- We Want Your Ideas
- Finding the closest school [formula vs. pivot table approach]
- Can you solve this blood pressure problem? [IF Formula Homework]
- How to add a line to column chart? [Charting trick]
- CP056: So which formulas you should care to learn?
- Find first & last date of a sale using Pivot tables [quick tip]
- How many formulas should you learn? [Weekend Poll]
- Finding if a cell has 7 in it… [Pattern matching in Excel]
- CP055: “Yes, I am back” edition (and a bonus Excel tip)
- Interactive Decision Tree Visualization in Excel [Trump vs. Hillary in Swing States]
- Currency format Pivot fields with one click [Friday VBA]
- How to generate all combinations from two separate lists [Pivot Table Trick]
- A quick tip about data analysis while on bike [Video + Personal]
- Check if a range has all numbers from 1 to n [Homework]
- Mapping Spread of Obesity [Chart Critique and Alternatives]
- Visualizing Financial Metrics – Contest Winners
- Visualizing target vs. actual progress – Biker on a hill chart
- Stacked Bar/Column Chart with Indicator Arrows – Advanced
- Formula Forensics No. 041 – Convert a Roman Numeral to a Number
- Sara’s Copy Shop – Break even analysis and what-if modeling in Excel [Videos]
- Stacked Bar and Indicator Arrow Chart – Tutorial
- Tell me about an analysis problem that you couldn’t solve with Excel?
- 18 ways to turn analysis projects into a nightmare
- Hourly Goals Chart with Conditional Formatting
- Visualizing Financial Metrics – 30 Alternatives
- PSA: Don’t let auto correct spoil your party
- Analyzing 300,000 calls for help [case study]
- Weekend open mic – Share your one hand Excel shortcuts
- Excel Links – Getting used to life in Windy Wellington Edition
- Find the seals [Excel puzzle]
- Correlation vs. Causation [Charting Chatter]
- Add any number of days, months or years to a date with this simple trick
- 5 Shortcuts for you, one for every weekday [Awesome August]
- Introduction to Forecasting in Excel 2016 [Charts & Visual Analysis]
- How to get Maps in to Excel charts & dashboards [Master Class]
- Find out how many times a value is present in a cell [formulas]
- On / Off conditional formatting with this simple trick
- We are moving to New Zealand [personal]
- How to visualize multiple variables over several years? [Contest]
- Teach coding to your kids with this maze game [VBA]
- What is the sum of values excluding items on stop list? [home work]
- Sum up neither “A” nor “B” values – How to use DSUM function in Excel [video]
- Generating sequence numbers from cluster values [VLOOKUP to the rescue]
- Show more of your workbook on screens [quick tip]
- Fish Eye Effect for highlighting selection – Is it effective? [Advanced Charting]
- Excel Tips, Tricks, Cheats & Hacks – Readers Edition
- SUMPRODUCT – Beginner to Advanced [Master Class]
- How many ‘Friday the 13th’s are in this year? [Formula fun + challenge]
- Excel Tips, Tricks, Cheats & Hacks – Readers Edition Prequel
- Apply Conditional Formatting using Slicers
- Extract the 10 digit number [formula homework]
- Excel Tips, Tricks, Cheats & Hacks – Notable Excel Websites (Non-MVP) Edition
- Excel Tips, Tricks, Cheats & Hacks – Excel Ninja Edition
- Earth Venus cosmic dance – Animated chart in Excel
- Sumerian Voter Problem [IF formula homework]
- Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition
- Figure out slot from given time [quick tip]
- Advanced Interactive Charts using Excel [Master Class]
- Introducing Chandoo.org Monthly Master Class
- Tell all versions of truth [Dashboard Best Practice]
- CP054: Top 10 Pivot Table Tricks for YOU
- A slicer that doesn’t slice [Pivot Table Tricks]
- There are seven pandas hidden in this workbook [Easter Eggs]
- These icons are so pretty, can I get them in green? [conditional formatting trick]
- How to create animated charts in Power Point [VBA]
- CP053: Excel Data Validation for Dummies
- Unpivot and then pivot for clarity (case study)
- “How Trump happened” in Excel [visualizations]
- Autosum many ranges quickly with Multi-select & ALT= [quick tip]
- Analyzing half a million complaints – Customer Satisfaction Scorecard [Part 3 of 3]
- Analyzing half a million customer complaints – Regional Trends [Part 2 of 3]
- Analyzing half a million consumer complaints [Part 1 of 3]
- Formula Forensics 040 – Apportioning Sales by Criteria
- Not so wild lookups [video]
- CP052: Book Review – M is for Data Monkey by Ken & Miguel
- Use slicers to create a cool selection mechanism [quick tip]
- Make 1,200 dinosaurs in no time with Excel [formulas]
- Format charts quickly with chart styles & color themes [quick tip]
- Transpose this address data [VBA homework]
- Don’t make your charts heavier than they should be – The weight of the world chart [case study]
- CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered
- How can I help you in 2016? [Survey]
- 2016 Calendar, daily planner Excel templates [free downloads]
- Best of Chandoo.org – 2015
- People & websites that helped me in 2015 [thank you message]
- Merry Christmas & Happy New Year 2016 [Holiday Greeting]
- Generate a snow flake pattern Excel [holiday fun]
- How many Mondays between two dates? [homework]
- Color changing line chart [tutorial]
- KPI Contest Winners
- CP050: Fifty Excel Tips to make you awesome
- Pricing Tier Lookup formula
- KPI performance charts & dashboards – 43 alternatives (contest entries)
- CP049: Don’t do data dumps!!!
- Edit cells & formulas faster [shortcut]
- CP048: How to create animated charts in Excel?
- Happy Diwali for all our readers – Animated Flower Pot Cracker in Excel for you…
- Employee training tracker & calendar – tutorial & download
- Can you extract numbers from text – homework
- Save a range as text file using VBA [tutorial]
- Contest: Visualize KPI data
- CP047: Best Excel tools for Entrepreneurs
- Formula Forensics No. 039 – Find the Cell Address for a value (2D & 3D Reverse Lookup)
- Formula Forensics No. 038 – Find Which Worksheet a Max or Min Value is located on
- CP046: Gantt charts & project planning using Excel
- Use NUMBERVALUE() to convert European Number format
- Excel is 30!!! – what was your earliest memory of Excel? [weekend poll]
- Weighted Sorting in Excel [video]
- Unpivot data quickly with Power Query [tutorial]
- CP045: Introduction to Monte Carlo Simulations in Excel
- How countries spend their money – chart alternatives
- Show forecast values in a different color with this simple trick [charting]
- Excel Links – Dashboards book delayed edition
- CP044: My first dashboard was a failure!!!
- Cropped chart: when some values are too big to fit
- Case Sensitive Lookups
- Weekend poll: Formulas or Pivot Tables?
- Book Announcement: Dashboards for Excel is launching on 15th September
- Thank you for making Awesome August a success
- How to create cascading drop downs in Excel – video
- Build models & dashboards faster with Watch Window
- Make a quick funnel chart in Excel to track sales performance [video]
- Monthly Planner Template [downloads]
- CP043: My favorite time saving features of Excel, Revealed.
- How to use GETPIVOTDATA with Excel Pivot Tables
- Summarize only filtered values using SUBTOTAL & AGGREGATE formulas
- Dynamic Print Areas
- Save time & paper with print areas in Excel
- How to import web data to Excel using Power Query
- Dashboard best practice: Highlight user selection [video]
- Give descriptive titles to your charts for best results
- Reconcile debits & credits using Solver [Advanced Excel]
- Use mail merge to create custom letters, invoices, labels and more
- A simple trick to make your dashboards user friendly [video]
- In-cell 5 star chart – tutorial & template
- Work with charts faster using selection pane & select object tools [quick video tip]
- CP042: Financial Analysis & Modeling concepts – 101
- Format faster with paste special & double click [video]
- VLOOKUP the last value
- Make bar charts in original order of data for improved readability [charting tip]
- Declutter your reports by showing icon only
- Use shapes to enhance your Excel charts [tip]
- Remove duplicate combinations in your data [quick tip]
- CP041: 6 charts you’ll see in hell – v2.0
- Save time with custom ribbons in Excel [tutorial]
- Calculate sum of top 10 values [formulas + homework]
- How to highlight overdue items [video]
- How to create dynamic sparklines for latest 30 days [video]
- Clean data quickly with Flash Fill
- CP040: Intro. to Power Query – What is it and how to get started – with Miguel Escobar
- Shading an area chart with different colors for up & down movements [case study]
- Announcing Awesome August
- CP039: May the FOR Loop be with you – Introduction to For Loops in Excel VBA
- How to find out if a text contains question? [Excel formulas]
- Quickly filter a table by combination of selected cell values using VBA
- CP038: Data to Ink Ratio – What is it, How to optimize it, Techniques & Discussion
- Are you an analyst? Use these 25 shortcuts & tricks to boost your productivity
- What is the coolest thing you made with Excel? [weekend poll]
- 15 Quick & powerful ways to analyze business data
- CP037: Error error on the wall, How do I fix you all? – Understanding & Fixing Excel Errors
- Introduction to Slicers – What are they, how to use them, tips, advanced techniques & interactive reports using Excel Slicers
- Calculating Billy’s total working hours [solution & discussion]
- Use Paste Special to multiply (or add, divide etc.) a range with a variable [quick tip]
- CP036: How to do trend analysis using Excel?
- What functions is Excel missing ?
- How many hours did Billy work? [Solve this]
- Changing stubborn opinions with visualizations [case study]
- CP035: on Solver, its story and future – Interview with Dan Fylstra
- Narrating the story of change using Excel charts – case study
- Ensure cleaner input dates with conditional formatting [quick tip]
- How would you train your boss to use Excel better? [Weekend Survey]
- Use arrow keys to select small, unreachable chart series [quick tip]
- Santa Clara Chronicles [personal]
- CP034: Advanced Excel Essentials book talk with Jordan Goldmeier
- Find and Highlight all blank cells in your data [Excel tips]
- How to insert a blank column in pivot table?
- Excel Links – PASS BA 2015 Edition
- CP033: There is an Easter egg in this podcast!!!
- CP032: Rules for making legendary column charts
- Use apply names to create readable formulas [quick tip]
- Conditionally Format Chart Backgrounds
- Formatting shortcuts for keyboard junkies
- Share your favorite Excel tip & you could win Beats Headphones [Podcast Anniversary Celebrations]
- Check if 2 ranges have same values (set equality problem)
- Celebrate Holi with this colorful Excel file
- CP031: Invisibility Tricks – How to make things disappear in Excel?
- CP030: Detecting fraud in data using Excel – 5 techniques for you
- Who is the most consistent seller? [BYOD]
- Revenue vs. Commission growth – Getting the message across [BYOD]
- How to consolidate data that is different shapes [BYOD]
- CP029: Impress your boss with Excel charts – 6 step road map for you
- Custom Number Formats – Colors
- 2 Must watch Excel webinars for you
- What is the length of longest winning streak? [Excel homework]
- Doing Cost Benefit Analysis in Excel – a case study
- CP028: How to tell business logic & rules to Excel?
- 3 Course Meal of Excel Awesomeness for You
- Unleash the pattern power with Excel Fill [quick tip]
- How can I help you become awesome this year?
- How to check for hard-coded values in Excel formulas?
- 8 Reasons you must get better at Excel in 2015
- CP027: 15 proven strategies to be awesome in 2015
- Write faster formulas with Auto-correct
- Free 2015 Calendar, daily planner templates [download]
- Best of Chandoo.org – 2014
- People & websites that helped me in 2014 [thank you message]
- Merry Christmas & Happy New Year 2015 [Holiday Gift Inside]
- Compare 2 sets of data by letter or word & highlight mismatches [vba]
- Excel to the Next Level by Mastering Multiple Occurrences
- Excel Links – 2014 Holiday Sale Edition
- CP026: All about Excel !@#$%^+/*(}][
- Creating In-cell charts with markers for average (or target) values
- Export iPhone contacts to Excel using this free template
- Calculate Pi by throwing Frozen Hotdogs !
- Can you calculate the sales commission? [homework]
- Open & Save files faster in Excel 2013 [quick tip]
- Download today – Introducing Excel Dashboard Templates from Chandoo.org
- Looking up when data won’t play nice – few more alternatives
- Formula Forensics No. 003b – Lukes Reward – Part II
- CP025: Sexy on spreadsheet, Ugly on Printout
- Ready to use Excel Dashboard Templates – Official Trailer
- Looking up when the data won’t co-operate (case study)
- What would you wear to an Excel themed Halloween party?
- CP024: Customize Excel to boost your productivity
- The ultimate VLOOKUP trick – Multi-condition Lookup
- Back after a while & 3 announcements
- Introducing…Structured References for PivotTables
- CP023: My experience with Hudhud Cyclone [personal story]
- CP022: What’s a Macro? Introduction to Excel VBA, Macros & Automation
- A better chart to visualize “Best places to live” – Top 100 cities comparison Excel chart
- Charmed Price Problem
- CP021: How to quickly compare 2 lists in Excel
- ABC Inventory Analysis using Excel
- Drag to multi-select slicer items [quick tip]
- CP020: Top 10 time saving strategies for business analysts
- Thank you, Houston meetup & Bonus tip
- Please help me design our new course – “50 ways to analyze your data”
- 3D Max Formula for Excel
- Replace formulas with values with a simple wiggle
- Teach me (and rest of our community) something this Teachers’ Day
- CP019: 6 Tips for Best Practice Modeling – Interview with Danielle from Plum Solutions
- Quickly convert numbers stored as text [tip]
- CP018: Dont be a Pivot Table Virgin!
- Convert fractional Excel time to hours & minutes [Quick tip]
- What is the average speed of this road trip? [Solution & Discussion]
- CP017: Top 10 non-Excel MS Office tips for you – Interview with Paul Woods – Office MVP & Blogger
- Mapping relationships between people using interactive network chart
- What is the average speed of this road trip? [homework]
- CP016: 3 Must have books for aspiring analysts
- A dashboard to visualize this FIFA worldcup [guest post]
- Story of my first ever 200KM bike ride (plus an Excel dashboard with ride stats)
- Become awesome in data analytics, charting & Power Pivot with Houston Masterclass [reminder]
- CP015: Handling big data, Controlling model railroad sets, Overcoming Excel obsession & more – ASK CHANDOO
- Formula Forensics No. 037 – How to Count and Sum Filtered Tables
- Ask me your Excel questions & You could win an eBook
- How fireworks animated chart is made [video tutorial]
- CHOOSE() me, an introduction to Excel CHOOSE function
- Here is a simple solution to your forgetful, leaky brian – “Just put it in a spreadsheet”
- CP014: How to create awesome dashboards – 10 step process for you
- Come join me at Excelapalooza conference in Dallas or Masterclass at Houston this September
- Winners of state migration dashboard contest
- 4th of July Fireworks – an Excel animation for you
- CP013: Is this a FIFA worldcup of late goals, lets ask Excel [How to analyze data to answer questions like these…]
- A quick Excel tip for you while on a long bike trip…,
- CP012: Top 10 Excel Keyboard Shortcuts for you
- Is this a FIFA worldcup of late goals? Lets ask Excel
- Vote for your favorite US state migration dashboard
- CP011: 5 Excel magic tricks to impress your boss
- Top 10 things we struggle to do in Excel & awesome remedies for them
- Excel Dashboards – 49 dashboards to visualize US State to State migration trends
- Matching transactions using pivot tables [video]
- Matching transactions using formulas [Accounting]
- CP010: Averages are Mean – 8 Techniques for making your analysis above average
- I struggle doing __________ with Excel. Fill in the blanks…,
- CP009: Averages are Mean – Know these things before you make any more AVERAGE()s
- Implementing Modular Spreadsheet Development – a walkthrough
- Excel Links – Delay in State migration visualization results edition
- CP008: 6 Tips to handle workbooks made by someone else, #4 is something I struggle with too!
- Building a simple timer using Excel VBA to track my Rubik’s cube solving speed [case study]
- Modular Spreadsheet Development – A Thought Revolution
- Create a line chart with bands [tutorial]
- What is your passion? [weekend poll]
- CP007: aweSUM() – Overview of SUM functions in Excel
- Calculate CAGR (Compounded Annual Growth Rate) using Excel [Formulas]
- How to become an MVP in Excel [case study]
- CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects
- Modeling tiles in a room using Excel Conditional Formatting
- There are Easter Eggs in this Excel file!!!
- CP005: Introduction to Form Controls – an interview with Debra Dalgleish
- Multiplying 24ft 9inches with 6ft 3inches using Excel
- Excel for iPad – Demo & Introduction [video]
- Visualize state to state migration data and you could win an iPad or Galaxy Tab [Datavis Contest 2014]
- Hui’s Calendar Tool (as Borrowed from Chandoo)
- CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them
- VBA Serenity
- Tables, PivotTables, and Macros: music to your ears
- CP003: Business Intelligence for Masses – Interview with Mike Alexander
- Calculating Maximum Change [solutions & discussion]
- Why you should close down Excel completely
- Calculate maximum change [homework]
- Free Invoice Template using Excel – Download
- CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you
- You can move formula help box with your mouse!!! [quick tip]
- CP 001: Chandoo.org Podcast First Episode – Introduction, What to expect, Show formalities & Special gift
- Excel links – What is your next Excel book edition?
- Chandoo.org Podcast: Launching on March 6th
- Handle Volatile Functions like they are dynamite
- Can you extract first name & last name from email address? [Formula Challenge]
- Robust Dynamic (Cascading) Dropdowns Without VBA
- What should we call our Podcast?
- Last day to join Advanced Power Pivot class & Bundles – Enroll to become awesome
- I won’t eat donut with a thread inside, but lets make one anyway!
- Heads up! Our Join Power Pivot class
- Quick and easy Gantt chart using Excel [templates]
- Learn how to create these 11 amazing dashboards
- Dynamic (Cascading) Dropdowns that reset on change
- Power Pivot course is now open, Please join to become awesome
- What is your favorite Excel book? [open thread]
- Details about upcoming Power Pivot course
- Combine pie and xy scatter charts – World Polls chart revisited
- Thank you and Excel, We have a new car
- How to select a random sample from all your data [trick]
- 5 reasons why you should learn Power Pivot
- Did Jeff just chart?
- Right-click from the keyboard, not the mouse.
- Big trouble in little spreadsheet
- Find first non-blank item in a list with formulas
- Quickly combine text in multiple cells using this trick! [Formulas]
- 42% of the world goes to polls around a pie chart – Like it or hate it?
- Bar chart with lower & upper bounds [tutorial]
- Top 10 things I learned using Excel for a decade
- Free 2014 Calendar, daily planner templates [download]
- Best of Chandoo.org – 2013
- People & Websites that helped me in 2013 [thank you message]
- Merry Christmas & Happy New Year 2014 [Holiday Gift Inside]
- Sporadic Totals in Excel [video]
- Countif – Quick Tip
- What is the coolest Excel trick you have learned this year?
- How to find what is in the hidden cells? [quick tip]
- Creating Triangular Plots using Excel
- Making a slick on/off switch using Excel & little bit of VBA [case study]
- Holiday Sale is on, Save upto $50 on your favorite Excel courses
- Chandoo.org Holiday SALE, Starts on Wednesday – 4thDecember!
- Ask me anything
- Formula Forensics-No. 036: Calculating Costs that Vary by Year and Age
- Find last day of any month with this simple trick [formulas]
- Secret Agent KV’s Chops…what’s in HIS Personal Macro Workbook?
- What would James Bond have in his Personal Macro Workbook?
- Thank you Sachin [a small tribute]
- Show pop-up calendar upon right click [Excel VBA]
- Replace formulas with values using this shortcut [quick tip]
- Closing gaps in this Gender Equality Gap chart…
- What areas of Excel scare you most? [survey]
- The VLOOKUP book is ready, pick up your copy today & Become Awesome
- I am writing a book [and its coming soon]
- 42 tips for Excel time travelers
- Chandoo.org produces it’s Second MVP.
- Formula Forensics No. 035 Average the last 3 values greater than 0
- PowerPivot – the ULTIMATE anti-bloat feature
- I said your spreadsheet is really FAT, not real PHAT!
- What are best Excel interview questions? [survey]
- How to Solve an Equation in Excel
- 7 reasons why you should use INDEX() formula in Excel
- Using Arrays To Update Table Columns
- Formula Forensics No. 34. Extract words from a cell, where they occur in a list of words.
- Calculating average of every nth value [Formula tips]
- Sort by Birthday [Quick tip]
- Last day for enrollments – Join our Power Pivot class & become awesome analyst
- How to find the lowest value? [Quick tip]
- How to create a Then vs. Now interactive chart in Excel?
- Power Pivot online classes – now open for you
- Excel Links for you – Busy busy edition
- Details about upcoming Power Pivot course (and a bonus tip on dashboards)
- Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 4.)
- Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 3.)
- Are you interested in learning Power Pivot?
- Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 2.)
- Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 1.)
- Never use simple numbers in your dashboards (bonus tip: how to fix default conditional formatting)
- What do you use Tables for? [poll]
- How to use Excel Data Model & Relationships
- 5 Keyboard shortcuts for writing better formulas
- Introduction to Structural References
- How to get VLOOKUP + 1 value?
- Are you ready for 2,000 miles, 15 days & 10 Excel tips road trip?
- We Want You – Revisited
- A quick Excel tip while on bike…
- Excel Project Risk Map Generator – using VBA
- How to find sum of top 3 values based on filtered criteria [video]
- How to transpose a values in a row to column using formulas… [Quick tip]
- I am meeting Mr. Excel aka Bill Jelen tomorrow. What do you want to ask him? (book giveaway too)
- Excel Links – from USA edition
- How to create a column chart with background image in Excel ?
- Thank you, we are flying to US tonight
- 10 Rookie mistakes to avoid when making dashboards [video]
- How to create an Interactive Chart in Excel? [Tutorial]
- Chart for wall hygrometric physic (or how to create a chart with custom x axis intervals?)
- Learn Top 10 Excel Features
- Some charts try to make you an April fool all the time (or why 3d pie charts are evil)
- How to create interactive calendar to highlight events & appointments [Tutorial]
- What is your favorite feature of Excel? [poll]
- How well do you know your LOOKUPs? – Quiz Answers & Discussion
- 10 things that wowed me in Excel 2013
- Unlock “Angy Formulas” – an Angry Birds like game hidden in Excel using this trick!!!
- There is an Easter egg in this chart!
- Join my Excel Dashboard Masterclass in USA [May-June 2013]
- How well do you know your Lookups? [Quiz]
- Finding Nearby Zipcodes using Excel Formulas
- How to remove all cells containing John (or anything else) [Quick tip]
- Finding Conversion ratio using Pivot Table Calculated Items
- Work with several Excel files everyday? – Save them as a workspace [Quick tip]
- Use Advances vs. Declines chart to understand change in values
- Last day for enrollments – Join our Power Pivot course & become awesome analyst
- Love letters to Chandoo.org
- Shading above or below a line in Excel charts [tutorial]
- Distinct Count & Blanks – Power Pivot Real Life Example
- Formula Forensics No. 033 – Interpolation
- Power Pivot & Advanced Excel course is open, Join us today!
- Transpose a table quickly using Copy – Paste [Quick tips]
- Transpose a table of data using Excel Formulas
- Details about our Power Pivot Course [and a video for those of you not interested]
- Introduction to DAX Formulas & Measures for Power Pivot
- Can you calculate vacation days in a period? [Homework]
- Designing a dashboard to track Employee vacations [case study]
- What is Power Pivot – an Introduction [video]
- Top 10 Formulas for Aspiring Analysts
- Insert Multiple Columns at once [Quick tip]
- Introducing ‘Finance for Non-finance people’ training program
- 3 upcoming courses to Make you awesome [Announcements]
- To-do List with Priorities using Excel
- Creating an Agenda template in Excel
- Please take our readership survey and help me make you awesome in 2013 [Surveys]
- Best of Chandoo.org – 2012
- People & Websites that Helped me in 2012 [Thank you message]
- 2013 Calendar – Excel Template [Downloads]
- Merry Christmas & Happy New Year 2013
- Monitoring Monthly Service Levels using Excel Charts [Example]
- Show hide list boxes using VBA
- Can you find that pattern? [Homework]
- Highlight best week & month in a trend chart [tutorials]
- Dressing Financial Statements – What Motivated Mr. Bean to Defraud Latte?
- How the tax burden has changed over the years – Excellent chart by NYTimes & Redoing it in Excel
- Formula Forensics No. 032 – Creating Dynamic Charts with Non-Contiguous Data
- Become Awesome in Excel while saving money
- Chandoo.org Holiday SALE, Starts on Monday – 3rd December!
- Macros for Automatically Implementing Modeling Best Practices
- Extract data using Advanced Filter and VBA
- Excel Links – Lets meet in Chennai this Sunday edition
- Financial Ratios – Cappuccino or Latte?
- Project Portfolio Dashboard in Excel [Part 2 of 2]
- Project Portfolio Dashboard – Official Trailer
- Happy Diwali [Animated Chart inside]
- Pie of a Pie of a Pie chart [Good or Bad?]
- Highlight Quarters, Weekends in pivot reports using styles [quick tip]
- Show monthly values & % changes in one pivot table
- Write a formula to check if two dates are in same month? [homework]
- Journey of Hurricane Sandy – Animated Excel Chart
- Why am I killing Vitamin XL?
- Designing a Project Portfolio Dashboard [Part 1 of 2]
- Even faster ways to Extract file name from path [quick tip]
- Extract file name from full path using formulas
- Please help me design our new product: Vitamin XL
- Check Cells for Equality – Follow Up [Quick Tip]
- Last day to join Excel School + Excel Hero Academy
- Write a formula to check few cells have same value [homework]
- Formula Forensics No. 031 – Production Scheduling using Excel
- Use Indexed charts when understanding change [Charting Techniques]
- Excel Formatting Tips – Gangnam Style [open thread]
- Formula Forensics No. 030 – Extracting a Sorted, Unique List, Grouped by Frequency of Occurrence
- Using pivot tables to find out non performing customers
- 18.2 Tips on Rounding numbers using Excel Formulas
- Introducing Excel School + Excel Hero Academy Bundle
- Confessions of a dad [personal]
- Using Excel for Business Analysis by Danielle [Book Recommendation]
- Formula Forensics No. 029 SumIf with Inconsistent Column Layouts
- Customize Zebra lines Quickly using Table Styles [tip]
- OFFSET formula – Explained
- How many values are common in 2 lists? [homework]
- Interactive Pivot Table Calendar & Chart in Excel!
- A Spreadsheet walks in to a bar … [open mic]
- Formula Forensics No. 028 – It’s Just a Jump to the Left
- Show Decimal Points if needed [Quick Tip]
- Excel Links – Going to Togo Edition
- Best Practice Modeling – Make these 5 changes today
- Excel Salary Survey Dashboard Contest Winners
- Formula Forensics No. 027 – Remove Leading Zeroes
- Growing a Money Mustache using Excel [for fun]
- Homework: Can you extract dates from text?
- One race, Every medalist ever – Interactive Excel Visualization
- How fast can you finish this Excel Hurdles Challenge [Spreadsheet Olympics]
- Formula Forensics No. 026 – Highlight Only Duplicate Entries
- Excel Salary Survey Dashboards – Choose the winner [poll]
- Making your dashboards interactive [Dashboard Essentials]
- How to make Box plots in Excel [Dashboard Essentials]
- Visualize Excel salaries around world with these 66 Dashboards
- Welcome to Chandoo.org – A short introduction to our site
- Formula Forensics 025. Count Unique Values in a Range
- Show only few rows & columns in Excel [Quick tip]
- Analyzing 20,000 Comments
- Financial Modeling School Price Hike from Tomorrow
- How do you explain Excel to a small kid? [poll]
- Formula Forensics 024. Is this number a Prime Number ?
- Highlight Row & Column of Selected Cell using VBA
- Visualizing Roger Federer’s 7th Wimbledon Win in Excel
- Creating a Masterchef Style Clock in Excel [for fun]
- Find the last date of an activity
- How to make a Spoke Chart
- Check if a list has duplicate numbers [Quick tip]
- Extract Numbers from Text using Excel VBA [Video]
- Visualize Excel Salary Data & You could win XBOX 360 + Kinect Bundle [Contest]
- My Australian Experience [Personal]
- Join our Financial Modeling Class before fee hike [Quick update]
- Extracting numbers from text in excel [Case study]
- Use MAX to find latest date in a list [Quick tip]
- Thermo-meter chart with Marker for Last Year Value
- Formula Forensics 023. Count and Sum a Filtered List according to Criteria
- Sort Pivot Tables the way you want [Quick tip]
- Oops, I did not do it [Site down time update]
- Do you work on Excel? How much salary you make? [Surveys]
- Formula Forensics 022. Sum the Odd Numbers between 1 and 100
- Chandoo Visits Perth Australia
- Highlight Employees by Performance Rating – Conditional Formatting Challenge
- Catchup with Chandoo in Perth
- Formula Forensic No. 021 – Find the 4th Slash !
- Please Enroll in our Excel & Dashboards Masterclass – Melbourne
- VBA Move data from one sheet to multiple sheets
- Interactive Sales Chart using MS Excel [video]
- Displaying Text Values in Pivot Tables without VBA
- Formula Forensic 020. Bhavik’s Monthly Workingdays Formula
- Excel Links – Live from Sydney Edition
- Thank you, I am flying to Australia today!
- Adding Macros & Final Touches to Customer Service Dashboard [Part 4 of 4]
- An IF Formula Challenge for you
- Lets meet when I am in Australia
- Send mails using Excel VBA and Outlook
- Formula Forensic No 019. Converting uneven Text Strings to Time
- Creating Customer Service Dashboard in Excel [Part 3 of 4]
- Creating Cash Flow Statement by Indirect Method – II
- Compare 2 Excel Files using View side by side Mode [Quick Tip]
- Last chance to sign-up for my Australian Excel Masterclass [Reminder]
- Formula Forensics 018. Retrieving the Nth number from a Range which has Gaps.
- Creating Cash Flow Statement by Indirect Method – I
- Consolidate data from different excel files (VBA)
- There are Easter eggs in this file!!!
- Formula Forensics No. 017 – A Solution to Maljzm’s problem.
- Sign-up for my Excel Dashboard Masterclass in Australia
- Using Excel As Your Database
- Comprehensive Guide to VLOOKUP & Other Lookup Formulas
- Formula Forensics 016. Suzannes DJIA Average
- 75 Excel Speeding up Tips Shared by YOU! [Speedy Spreadsheet Week]
- Excel Speedup & Optimization Tips by Experts [Speedy Spreadsheet Week]
- Happy Ugadi
- Optimization Tips & Techniques for Excel VBA & Macros [Speedy Spreasheet Week]
- Speeding up & Optimizing Excel – Tips for Charting & Formatting [Speedy Spreadsheet Week]
- This week, Speed up your Spreadsheets – Your Action Required
- Data and Calculations for our Customer Service Dashboard [Part 2 of 4]
- What is so special about Go To Special? [15 tips]
- Formula Forensic No. 015 – Cornelia’s Price Rises
- In Cell Text Formats – 2 Quick Tips
- Yet Another Sales Funnel Chart in Excel
- Do you use Pivot Tables? What do you use them for & where do you struggle [Survey]
- Formula Forensic 014 – Faseeh’s Formula
- 14 ways to check if an year is leap year, using Excel [just for fun]
- How to add your own Macros to Excel Ribbon [quick tip]
- Join my Excel Dashboard Masterclass in Australia [May-June 2012]
- Designing a Customer Service Dashboard in Excel [Part 1 of 4]
- Formula Forensics 013. – On Vacation
- Formula Forensics 012. – A Neat Formula
- Use Text Format to Preserve Leading Zeros in Excel [Quick Tip]
- Reporting Scenarios using Offset
- Learn Statistics & Probability using MS Excel
- How would you customize Excel after installing? [poll]
- Formula Forensics 011. Lykes Formula
- Using external software packages to manage your spreadsheet risk [Part 4 of 4]
- Comparing 2 Lists with a Twist
- Formula Forensics No. 010 Count How Many Times a List of Values Occurs in a Range
- Custom Number Formats (Multiply & Divide by any Power of 10)
- Excel Links – Live from Bangkok Edition
- Cleaning Up Imported Data – A Recent Case Study
- Formula Forensics No. 008 – Elkhan’s MaxIf
- Excel’s Auditing Functions [Spreadsheet Risk Management – Part 3 of 4]
- Formula Forensics. 009 – Pradhishnair’s Chainage Problem
- Six Quick Updates
- Finding Friday the 13th using Excel (and learning cool formulas along way)
- Announcing Online VBA Classes from Chandoo.org, Please Join Today
- Use CTRL+Enter to Enter Same Data in to Multiple Cells [Quick Tip]
- Quick Update about VBA Classes & Discount Expiry!
- How Companies Can Manage Spreadsheet Risk [Part 2 of 4]
- Free Picture Calendar Template – Download and make a personalized calendar today!
- Best of Chandoo.org – 2011
- People & Websites that Helped me in 2011 [Thank you message]
- 2012 Calendar – Excel Template [Downloads]
- Merry Christmas & Happy New Year 2012
- Formula Forensics. No 007 – Sumproduct
- Join Excel School & Become Awesome in Excel Today!
- Formula Forensics 006. Palindromes
- Shortcut for Long Models
- Learn Any Area of Excel using these 80 Links
- Formula Forensics No. 005 – Zebras and Checker-Boards
- Introduction to Spreadsheet Risk Management
- What is one area of Excel you want to learn more? [Survey]
- Make VBA String Comparisons Case In-sensitive [Quick Tip]
- Congratulations Chandoo.org 1,000,000 Page Hits
- Formula Forensics No.004 – Fred’s Problem
- Maintenance Work Complete
- Christmas Gift Shopping List Template – Set budget, track your gifts using Excel
- Add Data to Charts with Copy Paste [Quick Tip]
- Formula Forensics No. 003 – Lukes Reward
- Making Small Multiples in Excel [Charting Technique]
- Excel for Project Managers program is open, Please join today
- Calculate Payment Schedule [Homework]
- Excel for Project Managers is coming up next Monday (14th), Details Inside…
- Formula Forensics No. 002 – Joyces Question
- Fancy Posts – using HTML Display Codes in Chandoo.org Posts
- A Technique to Quickly Develop Custom Number Formats
- Using an Array Formula to Find and Count the Maximum Text Occurrences in a Range
- Compare 2 Lists Visually and Highlight Matches
- Tell us what you would like to learn in our Excel for PMs course [Survey]
- Excel Links – After a long time edition
- Thank you, We have a home [personal story]
- Split an Excel File in to Many using VBA [Videos]
- Quickly Fill Blank Cells in a Table [Reader Tip]
- Commercial Aspects of Project Management
- Filter values where Fruit=Banana OR Sales>70. In Other Words, How to use Advanced Filters?
- Offset() function to Calculate IRR for Dynamic Range
- A Challenge from Hui
- Incell Sales Funnel Charts
- Sum of Values Between 2 Dates [Excel Formulas]
- Analyzing Performance of Stocks using Excel [Example]
- Refresh All Pivot Tables at once [Quick Tip]
- Our VBA Class Registrations Close in Few Hours, Join Now & Learn Excel VBA
- Participate in Microsoft BI DataMashUp Contest & You could win $3000 Prize
- Hui’s Excel Report Printer
- Excel Training Recommender – Interactive Excel Tool for you
- Suicides & Murders by US States – An Interactive Excel Chart
- My Top 10 Tips for Mastering VBA & Excel Macros [Part 5 of 5 – VBA Crash Course]
- Announcing Online VBA Classes from Chandoo.org, Please Join Today
- Putting It All Together – Our First VBA Application [Part 4 of 5 – Excel VBA Crash Course]
- How to use Cells, Ranges & Other Objects in Excel VBA
- Understanding Variables, Conditions & Loops in VBA [Part 2 of 5]
- What is VBA & Writing your First VBA Macro in Excel [VBA Crash Course Part 1 of 5]
- Excel School Prices Going up from 29th August, Join Now to save!
- Simple KPI Dashboard using Excel
- Split Text on New Line using Excel & VBA [Macros]
- Custom Chart Axis Formating – Part 2.
- Selective Chart Axis Formating
- Join Excel Formula Crash Course & Master Excel Formulas
- 5 Announcements for You [Quick Read]
- Check if a Word or Phrase is Palindrome using Excel Formulas [Weekend Fun]
- MLB Pitching Stats Dashboard in Excel+VBA by our VBA Class Student
- Simplicity is a Virtue – BASE Rule
- 10 Excel Keyboard Shortcuts I can’t live without!
- Create PowerPoint Presentations Automatically using VBA
- Shift Calendar Template – FREE Download
- Get busy this weekend, with OR XOR AND [Excel Homework]
- Financial Modeling School is Open, Please Join Today!
- Scenario Analysis for the Project Valuation [Financial Modeling]
- Video Tutorial on Interactive Dashboard using Hyperlinks
- We Want Your Ideas – Results
- Interactive Dashboard in Excel using Hyperlinks
- Accumulated Depreciation using Mixed References
- Details about our Financial Modeling Class
- Create Dynamic Hyperlinks in Excel [Video]
- Sumproduct function to Consolidate Revenues?
- 3D Dancing Pendulums
- NPV() function to calculate Present Value
- Last Chance to Join our Singapore Excel Bootcamp [also, our training calendar for rest of the year]
- Winners of the Sales Analysis Chart Contest + One more Giveaway
- Sales Analysis Charts in Excel – 78 Alternatives
- Excel Links – Updates on Singapore Workshop Edition
- Automating Repetitive Tasks
- We Want Your Ideas
- Analyse Data like a Super Hero
- Register for our Excel & Financial Modeling Bootcamp in Singapore [Details inside]
- Win Loss Chart from a Series of Win, Loss Data
- Comparing Lists of Values in Excel using Array Formulas
- Amount Donated vs. Pledged [Excel Formula Homework]
- How to create a Win-Loss Chart in Excel? [Tutorial & Template]
- 10 Excel Formula Myths – Busted!
- Do you want to attend an Excel Workshop in Singapore? [Survey]
- Switch Scenarios Dynamically using Slicers
- How Would You Visualize Product Sales Data? [Excel Challenges #2]
- Advanced Sumproduct Queries
- Mod() function in excel to Implement Escalation Frequency [Financial Modeling Tutorials]
- Use Copy & Paste to Preserve References to Tables [Quick Tip]
- VBA Classes Registration Closing in a Few Hours – Join Now!
- Data Tables and Monte Carlo Simulations (Update)
- Count-down Timer App in VBA to Remind you about the VBAClasses Closing Time!!!
- Lost Excel Functions
- Introduction to Programming – Demo Lesson from our VBA Class
- Using Solver to Assign Items to Buckets
- VBA Classes are Open now. Please join today!
- 5 things you should know about VBA Classes + a Demo Lesson
- Dummy Data – How to use the Random Functions
- 80% Discount on PUP & PowerPivot Contest – Hurry up!
- Online VBA Classes by Chandoo.org – Details & Dates
- Place Key Information in Golden Triangle on your Reports, Dashboards etc. [Quick Tips]
- Update Report Filters using simple macro – a Dynamic Pivot Chart Example
- Comparing Sales of One Product with Another [Excel Techniques]
- There is an Easter Egg in Excel!
- What are Pivot Table Report Filters and How to use them?
- Are You Ready for Online VBA Classes? I need your help!
- Celebrating India’s Worldcup Cricket Victory – In Excel Dashboard Style!
- How to make a 5 Star Chart (Similar to Amazon)
- Auditing Spreadsheets? – Disable Direct Editing Mode to save time [quick tip]
- Show Details On-demand in Excel [Tutorial + Training Program]
- Give more details by showing average and distribution [Charting Tips]
- Excel Links – Congratulations Team India Edition
- March 2011 is best month ever and other news
- Beam Me Up Scotty – Excel Hyperlinks
- Form Controls – Adding Interactivity to Your Worksheets
- Learning Dashboards? – Go thru these 33 Recommended Resources
- KPI Dashboard – Revisited
- Executive Review Dashboard in Excel [Dashboard Week]
- Customer Service Dashboard using Excel [Dashword Week]
- Health-care Dashboard in Excel [Dashboard Week]
- Announcing Dashboard Week – Submit your entries now!
- Calculating Sum of Digits in a Number using Array Formulas [for fun]
- Use Analytical Charts to Make your Boss Love You
- Convert ISERROR formulas to IFERROR formulas [macro]
- IFERROR Excel Formula – What is it, syntax, examples and howto
- Excel Challenge #1 – Make Nuts without Going Nuts
- Financial Modeling School is closing in a Few Hours – Join Now!
- Quickly Remove Data Validation Rules using Paste Special
- 3+1 Ways to Learn Advanced Excel
- Get Rid of Page Break Lines with a snap [macros]
- Excel Teens are out to get you & Other findings from our Survey
- Financial Modeling School is Open, Please Join Today
- The Grammy Bump Chart in Excel
- Details about upcoming Financial Modeling School
- Printing Excel Reports via a Word Document
- Modeling Interest During Construction (IDC) – Excel Project Finance
- Quickly Compare Data using Row Differences
- How long have you been using Excel? [poll]
- Simple Excel Formula to Calculate All-time High, Trailing 12 Month High Values [Quick Tip]
- Introduction to Project Finance Modeling in Excel
- Make Awesome Data Entry Forms by using Conditional Formatting + Data Validation
- My trip to Maldives…, [travelogue + bonus Excel tip]
- A Huge Collection of Spreadsheets for Teachers [What Excel Can Do]
- How do Business Analysts use Excel [Guest Post from a Rock-star BA]
- Holiday Request Form in Excel [Awesome Ways our Readers are using Excel]
- Are You Trendy ? (Part 3)
- Are You Trendy? (Part 2)
- Worksheet Properties via a Menu
- Are You Trendy ?
- 220 Excel Tips, Tutorials, Templates & Resources for You [Celebrating 20k RSS Members]
- Find the Average of Closest 2 Numbers out of 3 [formula challenge]
- Excel Links – My First International Excel Workshop Edition
- Happy Birthday Hui, An Excel Dashboard to prove you are awesome!
- Join Excel School & Become Awesome in Excel
- How to Embed Youtube videos in to Excel Workbooks?
- Using Array Formulas to check if a list is sorted.
- Do you want to Learn Excel? Consider Joining Excel School
- How to Filter Odd or Even Rows only? [Quick Tips]
- Excel Links – What are your plans for 2011?
- Best of Chandoo.org – 2010
- People & Websites that helped me in 2010 – A Big, Heartfelt Thank You
- 11 Excel Trackers & Templates to help you Rock 2011
- Merry Christmas & Happy New Year 2011
- Use Filter By Selected Cell’s Value to save time [Quick Tips]
- How would you Visualize World Education Ranking Data [Homework + Video]
- 2011 Calendar – Excel Template [Downloads]
- Do you use (or make) Excel Dashboards? Tell us about yourself to win a free training kit
- 6 Christmas Cards in Excel – Download and Spread Joy
- Excel Links – Next Dashboard Contest Edition
- Mutant Cell Modeling Problem [Homework]
- Make Dynamic Dashboards using Pivot Tables & Slicers [Video & Download]
- Merge Cells without Losing Data [Quick Tip]
- Make a Christmas Card, and you can Win a $50 Gift Card
- The Selection Pane
- Show Top 10 Values in Dashboards using Pivot Tables
- Excel Animation without Macros!
- Homework – When does Thanksgiving Day occur on same date again?
- Using WordArt in Excel
- An Excel Dashboard to Visualize 10,007 Comments [Dashboard Tutorial]
- Splitting a number into integer and decimal portions
- VLOOKUP Formula Cheat-sheet – FREE Download
- Scheduling Variable Feed Sources
- Show Months & Years in Charts without Cluttering
- Welcome to Chandoo.org. A short introduction to this website
- Formatting Multiple Worksheets? Use Group Sheets option to Speed up [Quick Tip]
- 90% of you can see up to cell M26 & other findings [visualization]
- Highlighting Data Points in Scatter and Line Charts
- Getting the 2nd matching value from a list using VLOOKUP formula
- How to write 2 Way Lookup Formulas in Excel?
- Using Lookup Formulas with Excel Tables [Video]
- Extract Values from Several Columns [VLOOKUP Quick Tip]
- 3 Lookup Formula Challenges + 2 Jokes + 1 Link [VLOOKUP Week]
- A Technique for Analysing Large Tables of Data
- Excel Hero Academy – Recommended Online Excel Training Program
- 6 Tips for Writing Better VLOOKUPs
- How to Look up Based on Multiple Conditions
- How to Lookup Values to Left?
- Mix VLOOKUP with Data Validation for some magic! [VLOOKUP Week]
- Making VLOOKUP formulas go wild [VLOOKUP Week]
- VLOOKUP formula in excel with examples
- Celebrating the Lookup Formulas – VLOOKUP Week @ Chandoo.org
- What is the last visible cell in your excel window? [Poll]
- Hiding Error Messages – Quick Tip
- Financial Modeling School Closing in a Few Hours – Join Now!
- How to make a Birthday Reminder in Excel ? [Video]
- Analyze Competition with Scatter Plots – A business chart example
- FREE Excel Financial Model for Analyzing an IPO – Download Today
- Excel Links – Happy Birthday Edition
- Learn an Excel Feature: Picture Links (or Camera Snapshots)
- Financial Modeling School is now Open – Register today!
- Are you a Solver Virgin? Watch this tutorial video …,
- Financial Modeling School Coming on Monday [Details Inside]
- Insert Currency Symbols & Other Special Characters in Excel [Quick Tip]
- Finding 2nd Largest Item in a List that meets a Criteria [Excel Array Formulas]
- Bad News & VLOOKUP Contest
- Thanks half a million… (and 2 excel tips)
- Excel School Closing in a Few Hours – Join Now!
- Show Zebra Lines when Value Changes [Excel Conditional Formatting Homework]
- Remove duplicates & sort a list using Pivot Tables
- Displaying & Selecting a Scenario using VBA [Modeling in Excel]
- How I Analyze Excel School Sales using Pivot Tables [video]
- Putting it all together – Final Project Evaluation Model [Part 6 of 6]
- Show all the names & their References [Spreadsheet Audit]
- You are invited [personal]
- A round-up on Circular References
- Excel School is Open – Join Today
- Make your data validations dynamic! [quick tip]
- How to Calculate Working Hours Between 2 Dates [Solution]
- 10 things you should know about Excel School
- How to Paste Numbers Only [quick tip]
- Share an excel link and win $14.85 gift card from Amazon
- August 2010 – Best Month Ever (and 2 charting tips inside)
- Modeling & Building Cash-flow Projections for Project Valuation [Part 4,5 of 6]
- How to cook a delicious dynamic chart that will have your boss drool
- We have updates!!!
- How many hours did Johnny work? [Excel Homework]
- Excel Everest – Recommended Excel Training Program
- Building Inputs & Assumptions Sheets – Excel Financial Modeling [Part 3 of 6]
- How do you make charts when you have lots of small values but few extremely large values? [Debate]
- Excel Wedding Planner is here, Get your copy today!
- Jump to Any Cell / Worksheet using Name Box [Quick Tip]
- What is the most unusual thing you have used Excel for? [Quick Poll]
- Take your Excel Baby Steps with 89 Minutes of FREE Online Training
- Winner of Excel Expense Tracker Contest – RomeoG
- 9 Excel Tips & Downloads Submitted by Our Readers [Reader Awesomeness Week]
- Download Excel Wedding Planner Today
- 12 Rules for Making Better Spreadsheets
- How Francis Landed on Chandoo.org, Become Awesome and Made a Superb Dashboard, all in ONE Weekend
- Immigrants in Denmark – An Excel Infographic
- Announcing Reader Awesomeness Week – Submit your Tips, Stories, Workbooks and Ideas
- 5 Rules for Making Better Charts (and one fun chart)
- Introducing Excel Wedding Planner
- Building a Layout for Project Evaluation Model & Best Practices [Part 2 of 6]
- How to show Indian Currency Format in Excel?
- 7 Links and One Question for You
- Introduction to Financial Modeling using Excel [Part 1 of 6]
- Select Expressions to Find their Values [Macro Debugging Tip]
- 7 Personal Expense Trackers using Excel – Download Today
- 4 Alternatives to Export Excel Dashboards as Web Pages
- Gantt Box Chart Tutorial & Template – Download and Try today
- Thank you (and thank you Excel), We have a Car!
- A Gantt Chart Alternative – Gantt Box Chart
- Find-out Days Overlaped [Excel Formula Homework]
- Do You Want to Learn Excel Financial Modeling?
- Football anyone? [off-topic]
- Even Faster Way to Compare 2 Lists in Excel [Quick Tip]
- Excel Links – Change in Posting Schedule Edition
- Office 2010 Contest Winners are here!!!
- Between Formula in Excel [Quick Tips]
- Use Excel For Rapid UI Prototypes [Awesome uses of Excel]
- A Hairy Update [personal]
- Excel Heros who Reviewed and Recommending Excel School
- Excel School Closing in a Few Hours – Join Now!
- What new chart types you want to see in Excel? [poll]
- Become a Comparison Ninja – Compare 2 Lists in Excel and Highlight Matches
- Super-mini Quick Update on Excel School
- Excel Quotation Template [Spreadsheets for Small Business]
- Join Excel School Today
- FIFA Worldcup Excel Spreadsheets [Roundup]
- 6 things you should know about Excel School
- Football Betting Sheet Template
- How to Add your Macros to QAT or Excel toolbars?
- Convert Text to Sentence Case using Excel Formulas [Quick Tips]
- Average of Top 5 Values [and some homework]
- Win a Netbook – 10000 RSS Contest
- Get Stock Quotes using Excel Macros [and a Crash Course in VBA]
- Check if two ranges of dates overlap [Excel Formulas]
- Updates on Website, Office 2010 Contest
- Official FIFA World-cup Soccer Balls since 1930 in an Excel Chart [Excel Fun]
- Use CTRL+Back Space to jump to active cell [Shortcut]
- Dynamic Dashboard in Excel – Pulling it all together [Part 4 of 4]
- Display Alerts in Dashboards to Grab User Attention [Quick Tip]
- An Excel Hero indeed [blog recommendation]
- Understanding Backstage view in Excel 2010
- Attend Free Excel Training Session by Me on May 25th
- Customize Excel ribbon – How-to guide, FAQs and Help
- New Features in Excel 2010 Conditional Formatting
- What is new in Microsoft Excel 2010? [Office 2010 Week]
- Evolution of Privacy Policies on Facebook – a Panel Chart in Excel
- Introduction to Panel Charts using Excel – Tutorial & Template
- Exclude Hidden Rows from Totals [How to?]
- How to become really awesome in Excel? [Reader Questions]
- Important Update: Dilbert is gone!
- Data Tables & Monte Carlo Simulations in Excel – A Comprehensive Guide
- Change Data Labels in Charts to Whatever you want [Quick Tip]
- How to Get “Either-Or” Condition in Data Validation?
- Excel Links – Project Management Edition
- Wow!!!, Thank You :)
- Quarterly totals when you have multi-year data [SUMPRODUCT again]
- Find Quarterly Totals from Monthly Data [SUMPRODUCT Formula]
- SUMIF works in 2D too [quick tip]
- Childhood Dream comes true [personal story]
- What are your favorite colors for charts?
- Making a Dynamic Dashboard in Excel [Part 3 of 4]
- Budget vs. Actual Profit Loss Report using Pivot Tables
- How to pick a chart type – Charting 101
- Quickly Turn off Gridlines in Excel 2003 using Forms Toolbar [Excel Tips]
- Updates on Excel School [and 3 free lessons]
- Speaking at TechEd 2010 on “How to Select the Right Chart for your Data”
- Survey Results in Dot Plot Panel Chart [followup on Incell Panel Chart]
- Make your Chart Legends Legendary
- Use CTRL+Click to speed up your formula entry [Quick Tips]
- Automatic Rolling Months in Excel [Formulas]
- There are Easter Eggs in this Post!!!
- How to Visualize Survey Results using Incell Panel Charts [case study]
- 101 Excel Secrets – Recommended E-Book
- Making a Dynamic Dashboard in Excel [Part 2 of 4]
- How to Check whether a Table is Filtered or not using Formulas
- What do you use Excel for? [Weekend Poll]
- My First Podcast!!! – Listen to know some cool charting and dashboard stuff
- Quarterly & Half-Yearly Profit Loss Reports [Part 5 of 6]
- How to Convert Text to Dates [Data Cleanup]
- Introducing PHD Sparkline Maker – Dead Simple way to Create Excel Sparklines
- Super Timesaver Tip – Add “Select Objects” to Quick Access Toolbar
- Making a Dynamic Dashboard in Excel [Part 1 of 4]
- Excel Links – Back to India Edition
- 31 Excel Tutorials – Learn and Be Awesome in Excel
- Introducing Flag Project – A fun way to Learn Excel Charting
- Get a Copy of Excel Project Management Templates Today!
- Exploring Profit & Loss Reports [Part 4 of 6]
- Writing “Either Or” formula in Excel [Formula Howtos]
- Annual Goals Tracker Sheet [awesome ways to use excel]
- Sachin Tendulkar ODI Stats – an Excel Info-graphic Poster
- Adding Calculated Fields to Pivot Table P&L [part 3 of 6]
- Use Paste Special to Speed up Chart Formatting [Quick Tip]
- Find and Remove Blank Items from a Range of Cells [personal experience]
- Comprehensive List of Excel Keyboard Shortcuts
- How do you consolidate data from multiple sheets in to one? [open thread]
- Excel School Last Call, Closing in Few Hours – Join Now!
- Save a ton of time by using Mouse scroll-wheel to Navigate Excel Ribbon
- Excel Links – Winner Takes it all Edition
- Welcome to Pointy Haired Dilbert – Know a Little About YOU
- Only 5 days left, Sign-up for Excel School Today!
- What is the most useless feature in Excel? [poll]
- Group Project Activities to Make Readable Gantt Charts
- Preparing Profit / Loss Pivot Reports [Part 2 of 6]
- What is Excel SUBTOTAL formula and 5 reasons why you should use it
- Excel School is Open for Admissions
- Excel School Registration Opens on Monday (8th Feb, 2010)
- Best Month Ever (and a charting tip inside)
- P&L Reporting using Excel [Part 1 of 6 on Excel & Accounting]
- Excel Keyboard Shortcuts – Open Thread
- Data Validation using an Unsorted column with Duplicate Entries as a Source List
- Excel Links of the Week – now even more downloads edition
- Fix Incorrect Percentages with this Paste-Special Trick
- Pivot Table Tricks to Make You a Star
- Delete Blank Rows in Excel [Quick Tip]
- Excel School Online Training – More Details
- Flu Trends Chart in Excel [Yes, we can edition]
- Use “Playbill” font to make your incell charts realistic [quick-tips]
- Interactive Mortgage Calculator to know how much you can borrow (with Excel)
- Extract usernames from E-mail IDs [using LEFT and FIND formulas in Excel]
- Best Sales Dashboards, as Voted by You [Visualization Challenge #2 – Winners]
- Would you be interested in an online excel training program?
- Flu Trends in a City chart from Google is Awesome!
- Product Recommendation – Excel Dashboard Training Kit
- A Brief History of Microsoft Excel – Timeline Visualization
- Collapse, Expand Excel Charts using this hidden trick
- Excel Links – What are your plans for 2010 Edition
- What is PowerPivot? (and does it really wear underwear on top of pants !?!)
- A New Year Resolutions Template that Kicks Ass
- Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]
- Conditionally Formatting Dates in Excel [Part 1 of 2]
- Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations
- Best of Pointy Haired Dilbert – 2009
- Track Your Mutual Fund Portfolio using Excel [India Only]
- How to Find Dates of Public Holidays using Excel
- Merry Christmas & Happy New Year 2010
- Print Worksheets in One Page Across [Quick Tips]
- The 1000th Post
- Best Charts to Compare Actual Values with Targets – What is your take?
- Make a Quick Thermometer Chart to Compare Targets and Actuals
- How to Print Excel Comments
- How to hide “0” in chart axis [quick tip]
- 2010 Calendar – Excel Template [Downloads]
- Use CTRL+F1 to collapse ribbon [super-mini-quick-tip]
- How to pick a random date? [Formulas]
- Christmas Gift List – Set your budget and track gifts using Excel
- Dilbert on Excel, Spreadsheets and Cell C23
- Use Shapes and Images to make Prettier Charts [Dashboard Tricks]
- 50% off on ExcelUser’s Dashaboard Kit [2 days only]
- Group Smaller Slices in Pie Charts to Improve Readability
- Excel Links – Learn Excel Online Edition
- Format Charts Faster in Excel 2007 [quick tips]
- The Zoho Visualization Challenge – Deadline Extended to 5th Dec
- Announcing PHD Thanksgiving Sale
- Findout Thanksgiving Day’s Date for Any Year [Excel Formulas]
- Why do you visit PHD?
- Personal Budget Spreadsheet [Downloads]
- 10 Supercool UI Improvements in Excel 2010
- One Hundred Project Managers have chosen to be better, what about you?
- Reverse a List using Formulas [Using Excel INDEX() Formula]
- Download Excel 2010 Beta today [Office 2010 Updates]
- Transpose Excel Rows and Columns [Quick Tip + Video]
- Grouping Dates in Pivot Tables
- Excel Links of the Week [Excel Dashboards Edition]
- What is the most embarrassing charting mistake you made? [weekend poll]
- Zoho sponsors our Visualization Challenge #2
- Top X chart – Show Top X values of a chart Interactively
- Chart this Sales Data and get an iPod Touch [Visualization Challenge #2]
- What is Excel SUMPRODUCT formula and how to use it?
- PHD Gets a Facelift (again)
- Excel Links of the week [After a long time edition]
- Lets Pimp a Gauge Chart [Chart Porn Friday]
- Product Recommendation – Excel Lookup Toolbox
- Dashboard Best Practice – Google Analytics Intelligence Report
- 10 Tips to Make Better and Boss-proof Excel Spreadsheets
- Switch Rows and Columns in Charts [Quick Charting Tip]
- Sweet Sweet Testimonial from a Sweet Sweet Lady
- Making Interaction Plots using Excel
- Copy Data Validations from one cell to another [quick tip]
- Project Dashboard + Tweetboard = pure awesomeness!!!
- Prevent Duplicate Data Entry using Cell Validations
- Solve Sudoku Puzzles using Excel [because it is weekend]
- Get a free copy of Project Management Bundle
- Meet Nakshatra & Nishanth (and say Happy Birthday to PHD)
- How to get Excel 2003 Toolbars in Excel 2007 [productivity hack]
- Making a chart with dynamic range of values
- The Project Management Bundle for Excel is Here, Download your copy today
- Baby Feeding Chart using Excel
- Visualization Lessons from Eiffel Tower [Chartbusters in Paris]
- Another Reason why Tables are so awesome [quick tip]
- Project Management Dashboard / Project Status Report using Excel [Part 6 of 6]
- Make a Bubble Chart in Excel [15 second tutorial]
- What buttons you have in the excel quick access bar ? [weekend poll]
- Use Cell Styles to Make your Spreadsheet Models User-friendly [Quick Tip]
- Recipe for a Donut Bar Chart
- 5 Things you probably dont know about this site
- Twins, Clones and Duplicates – 6 Excel Shortcuts from an Excited Dad
- Pointy Haired Dad
- Calculate Elapsed Time in Excel [Quick Tips]
- 7 ideas Excel can pick-up from iWork Numbers
- Master Excel 2007 Ribbon with this Free Learning Guide
- Excel Check Boxes, Even Simpler Way
- How to get tick marks in Excel? [custom cell formatting]
- Member of Month and Other Updates
- Pimp your comment boxes [because it is Friday]
- Issue Trackers & Risk Management using Excel [Project Management using Excel – Part 5 of 6]
- Pin Frequently Used Documents to File Menu to Save Time
- Get cell comments using Excel Formula
- Pareto Charts – How to do pareto analysis using Excel?
- 5k Giveaway – Excel is a Superhero – Winners
- Nightmarish Pie Charts [because it is weekend]
- Dynamically Grouping Related Events [Excel Combo Charts with Pizzazz]
- Using Combo Charts to Group Related Time Events [Charting Goodness]
- Make a Pivot Table in Excel [15 Second Tutorial]
- 29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]
- 50 Best Cities for Finding a Job [Incell Dashboard using Excel]
- Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]
- Only 2 more days to get prizes worth $425, Hurry
- Hide Grid Lines [Quick Tip]
- Member of month, Excel links and Cooked HDD
- Waterfall Charts using Excel
- What would you do if a co-worker makes ugly chart? [weekend poll]
- Count the number of unique values in a range [Quick Tip]
- Excel Time Sheets and Resource Management [Project Management using Excel – Part 4 of 6]
- If Excel is a Superhero … [5k Contest and Giveaway]
- The funnest way to learn excel formulas
- Twitter Formula Contest – We are 5000 strong now
- Are you excited about this twitter chart?
- Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu
- Build a Retirement Calculator using Excel (learn how to use Goal Seek as a bonus)
- Charting Lessons from Optical Illusions
- Introducing PHD Forums (and some other updates)
- We cant Cure Cancer, But we can Cure this Medicare Chart [Chart Busters]
- Sumif with multiple conditions [quick tip]
- Use burn down Charts in your project management reports [bonus post]
- Generating invoice numbers using excel [reader questions]
- 2 Great Pieces of Advice for Chart Makers, Dashboard Designers and Story Tellers Everywhere
- Formula 1 Style Sorting of Times (Durations) in Excel
- 14 Basic Skills for Chart Makers (Big question: How many do you have?)
- Make an Impressive Product Catalog [spreadsheets for small business]
- Project Management: Show Milestones in a Timeline [Part 3 of 6]
- How to Round and Sort Data using Excel Formulas?
- Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial]
- Best month ever [blogging updates]
- Fix this chart [excel homework #1]
- Create a number sequence for each change in a column in excel [Quick Tip]
- Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]
- Excel Links – Bacon bits are good edition
- Remove Duplicates [Quick Video Tip]
- Asset Allocation Chart Turns Zombie [ChartBusters #1]
- Creating New Cell, for real
- Are you focusing on F word or S word? [Charting Principles]
- Gantt Charts – Project Management Using Excel [Part 1 of 6]
- Interview With Presentation Zen’s Garr Reynolds on Charting & Telling Stories
- Welcome to Pointy Haired Dilbert
- Bring out your bad charts, the ChartBusters are here…
- Do you know these Double-click Tricks in Excel?
- Interviewing Garr Reynolds on this Friday, send me your questions
- Incell Dot Plots in Microsoft Excel
- Networkingdays() an improved version of networkdays formula
- Excel Formula 1 – Really Fast way to learn Excel Formulas
- How to Hide a Cell’s Contents in Excel? [Quick Tip]
- Converting Excel to PDF – Everything you need to know
- Venn Diagrams in Excel
- Tweetboard Implementations – Download and make your twitter style dashboard today
- Statistical Distributions in Excel [spreadcheats]
- Array formula to check if a number is prime [just for fun]
- Intraday Candlestick Charting [Stock Charts]
- Hide Formula Errors While Printing [Quick tip]
- Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)
- Excel Links – Dilbert is Recession-proof Edition
- Now Edit Google Spreadsheets using MS Excel
- Signup for Microsoft Excel 2010 Technical Preview [Office 2010]
- Create a Dynamic Chart in Excel in 2 Minutes [spreadcheats]
- and then Dilbert is fired too
- Share Your Excel Tips for Your Week – Open Thread
- Excel Tips Submitted by You [Part 4]
- Excel Tips Submitted by You [Part 3]
- Excel Tips Submitted by You [Part 2]
- A Good Chart is a Story [Charting Principles]
- Excel Tips Submitted by You [Part 1]
- Announcing “Your Week” @ PHD
- Tweetboards – Alternative to traditional management dashboards
- Most Popular Posts in PHD – The March and April edition
- Use Mouse to Edit Formula Ranges [quick tip]
- Bonavista Chart Tamer Kicks ass.
- Web Analytics Dashboard by Percent Mobile is Fun [Dashboard Reviews]
- Analyzing Search Keywords using Excel : Array Formulas in Real Life
- Calculate Moving Average
- Excel Links of the Week – What is really happening Edition
- Hide a Workbook from Nosy Colleagues [quick tip]
- and the Winner is…
- Excel Formula Errors – Understand and Debug Them
- There is an Easter Egg in this Post
- Using Credit Card Numbers in Excel
- Budget vs. Actual Charts – 14 Charting Ideas You can Use
- Search a Spreadsheet Full of Data using Conditional Formatting
- Interview with John Walkenbach on Excel and Banjo Charts…
- Using Array Formulas in Excel – Find if a list has duplicate items
- Excel Links of The Week – Malmo Edition
- Skip Blank doesnt skip blank cells ?!?
- Visualization Challenge – Budget vs. Actual Performance
- Highlight Top 10 Values using Excel Conditional Formatting
- New Improved Version of Excel Formula Help
- Hot or Not – McKinsey’s Innovation Heatmap
- Excel Conditional Formatting Basics
- Us vs. Them – Compare Sales Performance using Charts & Form Controls
- How to use Excel Chart Templates and Save Time
- Excel Links of the Week – Free E-Book Edition
- RSS Icon using Donut Charts – Because it is Weekend
- Open Thread For First Time Commenters – What do you like in Excel?
- Japanese Candlestick Chart – Excel Tutorial
- February 2009’s Most Popular Posts
- 5 Areas where Mouse Kicks Keyboard’s Butt
- Weekly Excel Links – After a Long Time Edition
- How Many Bubbles are Too Many Bubbles?
- How to Change Shapes in Microsoft Office 2007
- What would you like to ask John Walkenbach – Famous Excel Author and Guru?
- What is Your Opinion on Pie Charts?
- Welcome Robert & ClearlyAndSimply.com to Blogging
- Market Segmentation Charts using Conditional Formatting
- Google Spreadsheets Introduces Data Validation, Sweet!
- “Too Many Worksheets” Driving You Nuts? Read This!
- A Good Bubble Chart About the Bust
- Excel Colors Somehow Getting Changed ?
- Make a Dynamic Chart using Data Filters
- PHD reader gears up for a promotion despite recession and makes my day
- Weekly Links – Even More Downloads Edition
- Review of PTS Clustered Stack Chart
- Professional Resume or Data Visualization Fail? [poll]
- Write Your Own Twitter Client using Microsoft Excel
- Employee Satisfaction Surveys using MS Excel
- One more method to find unique values in excel and you can call me a dork
- Best of PHD – Jan 2009
- PHD Excel Formula Helper – Now an E-Book
- [Weekend Poll] How do you Sex up your Charts?
- Colors in Chart Labels [Quick Tip]
- 100 Excel Tips & Resources
- Excel Links of the Week – Minor Changes to PHD edition
- Do you know how to KISS, Wall Street Journal Does!
- How to Hide Worksheet Tabs in Excel Workbook
- [Reader Poll] Stacked, Seperated or Mirrored ?
- Visualizing Search Terms on Travel Sites – Excel Dashboard
- Sorry, I screwed it up…
- Why No One Likes Your Pie Charts (And What to Do About It)
- What are the formulas you wish Excel had ?
- Excel Links of the Week [Jan 12]
- Featured Visualizations – Jan 09
- Sales Funnel Charts in Excel – Tutorial
- Automatically insert timestamps in excel sheet using formulas
- Weekly Excel Links – Issues with Hosting of PHD
- Excel Basics – What are Combination Charts and How to Make One?
- Featured Visualizations – Jan 02
- Great News: Chandoo becomes MVP
- Happy New Year to all PHD Readers
- Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]
- Excel 2007 Review – 10 things that WOWed me
- Excel Links of the week – the Christmas edition
- 5 Awesome Info-graphics for your Inspiration [Dec 19]
- Use Alt+Enter to get multiple lines in a cell [spreadcheats]
- Creating Excel Art from Images [spreadsheet fun]
- Custom Views in Excel – Save filter and header settings for quick reference
- 2009 Calendar Template in Excel – Now with week starting on Monday
- Formula Debugging in Excel – Tip [spreadcheats]
- Excel Links of the Week [Dec 15]
- Interview with Charley Kyd on Everyday Excel
- Brick Charts in Excel – an Alternative to Gridlines
- Free Excel Calendar Template for year 2009 (and all years up to 9999)
- Parking Tickets in New York – Cool Interactive Visualization from NYTimes
- What is camera tool and how to use it? [spreadcheats]
- Are you making Blow charts? [charting tips]
- Best of Pointy Haired Dilbert – Nov 2008
- Excel Links of the Week [Dec 1]
- 5 things that helped me run 10k
- Say thanks with an excel tip
- Prevent users from scrolling away on your dashboards [dirty little trick]
- Advanced Data Validation Techniques in Excel [spreadcheats]
- Fun way to clean up modern art with visualization
- Excel Links of the Week – PHD’s new tag line [Nov 24]
- Introducing Excel Formula Helper
- Google Spreadsheets Holiday Art Template
- 5 visualizations to inspire you [Nov 21]
- Generating Random Phone Numbers
- The new Mac vs. PC web ad by Apple is really cool
- What would you like to ask Charley Kyd of Exceluser.com in an interview?
- Make your VBA macros work anywhere: Enable Relative References
- Excel Links of the Week – Do you want to run 10k with me edition
- Ads that are also Infographics – 10 Dazzling Examples
- 5 Visualizations for Your Inspiration [Nov 14]
- Seperating digits from a number [excel formulas]
- Is your (chart’s) underwear showing?
- How to present changes in Market Share using Charts?
- PHD Welcomes Readers from Lifehacker
- Eight ways to exploit COUNTIF() … and sumif() too [spreadcheats]
- Excel Formula for Finding Repeated Words in a Cell
- Excel Links of the Week – All Downloads at One Place Edition
- 5 Visualizations for your Inspiration [Nov 07]
- Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]
- Select & Show One Chart from Many
- US Poll Trackers – Live Dashboards Ooze Visualization Goodness
- Relative vs. Absolute References in Formulas [spreadcheats]
- Minor Changes to PHD’s Look and Feel
- Excel Links of the Week [Nov 3]
- Best of Pointy Haired Dilbert – Oct 2008
- Infographics of the week – Food, Maps, Privacy & Politics [Oct 31]
- Introducing Spreadcheats – Become Supergood with Excel in 30 days
- Soon you can use Excel on the Web
- Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]
- Making Pie-charts look Sexy – The CNN’s tax burden analysis chart
- How to NOT spend $ 150,000 and still dress up your charts
- Excel Links of the Week – What the heck happened to photographic fridays edition
- 5 Beautiful Visualizations [Oct 24]
- Sports Statistics Dashboard in Excel – Few More Alternatives
- Sorting Text in Excel using Formulas
- Reader Poll: Should the axis for bar charts always start at zero?
- Sports Dashboards in Excel – A Tutorial
- Excel Links of the Week – Birthday Edition
- Use Enter to Paste Copied Values in Excel [Quick Tip]
- 5 Superb Visualizations of the Week [Oct 17]
- The New Poor – Internet Penetration Rates by Country
- 15 MS Excel Tips to Make you a Productivity Guru
- The shower curtain & rings sense of designing products
- More than 3 Conditional Formats in Excel
- Excel Links of the Week – The Mt. Rainier edition
- Windows 98 – Photographic Fridays #17
- Visualizations of the Week [Oct 10]
- KPI Dashboards – Compare 2 Decision Parameters [Part 5 of 6]
- Replace Radar Charts with Tables to Make Comparison Easy
- Red vs. Blue – 35 Cool Visualizations on 2008 US Presidential Election
- Excel Links of the Week [Oct 06]
- Major Updates to Google Docs Spreadsheets App – Menus, Named Ranges, Toolbar
- Come, Lets Celebrate – Photographic Fridays # 16
- Deal or No Deal – Download and Play the Popular TV Game Show in Excel
- Info-graphics of the week [Oct 3]
- Display decimals only when the number is less than 1 [Excel number formatting tip]
- Visualizations at Seattle Public Library – What Community is Reading?
- The Best of Pointy Haired Dilbert : September 2008
- Simple Todo List application using Excel – Download and become productive
- Clean up Incorrectly Formatted Phone Numbers using Excel
- How to WOW your customers with tracking – Dominos pizza example
- Excel Links of the Week [Sep 29]
- Sun Flower – Photographic Fridays # 15
- Google Maps Walking Directions Bug ?!?
- Visualizing Sex & Love – 10 Infographics You Must See
- Save a quarter buck everytime you buy coffee at starbucks
- Handling spelling mistakes while searching your data using excel
- Sorting a list of items in random order in excel – using formulas
- Gmail Labs 2 new useful features – Mark as Read, Label Auto Suggest
- SQL Queries from Excel
- Weekly Excel Links – Moved to Seattle Edition
- Steel Patterns – Photographic Fridays # 14
- Microsoft says ‘I am PC’ and it is brilliant
- Charts of the Week [Sep 19]
- You are NOT spider man, so why do you use radar charts?
- Visualization Challenge – How to show market share changes?
- Calculating Paydays in a calendar year using Excel
- Web Page Monitor using Google Docs
- Power Outage & 99 Excel Tips to keep you Busy
- American Bald Eagle – Photographic Fridays # 13
- Infographics of the week [Sep 12]
- Tracking your stock portfolio using Google Docs
- Excel KPI Dashboards – Adding Micro Charts [Part 4 of 6]
- Hack together a Gauge Chart in Excel without sweat
- Excel links of the week [Sep 8]
- Splitting text in excel using formulas
- Either the glasses are floating or you are drunk – Photographic Fridays # 12
- Cool Info-graphics of the Week [Sep 5]
- Microcharting in Excel – 7 Alternatives Reviewed
- KPI Dashboards – Highlight KPIs Based on Percentile [Part 3 or 6]
- 6 charts you will see in hell
- Initials from Names using Excel Formulas
- Introducing new design of Pointy Haired Dilbert
- Photographic Fridays #11 – It stretches all the way you can see
- Cool Visualizations of the Week [Aug 29]
- Aligning charts, objects on spreadsheet [excel layout tip]
- What they dont teach you in any school – Appreciation
- Creating KPI Dashboards in Microsoft Excel [Part 2 or 6] – Adding One Click Sort
- Excel links of the week – weekend without wire [Aug 26]
- Quickly process text using split() spreadsheet function in google docs
- Photographic Fridays #10 – At the Niagara Falls
- 5 wonderful visualizations you must see [Aug 22]
- Tiger Woods walks on water to please a fan – Awesome advertising
- Display symbols in excel chart axis
- Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]
- Dell tells me to buy a finger print reader in order to have another color on the system
- It is show time baby! – better designer clocks to display time in your spreadsheets
- Switch between firefox tabs using mouse scroll wheel
- Excel Links of the week – What do you dream about? [Aug 19]
- Polar clock using donut chart [Excel Visualization fun]
- Photographic Fridays #9 – Here now, gone later
- Is this Google adsense ad misleading?
- Charts of the Week [Aug 15]
- Plot your data around the clock [Excel charting idea]
- Simulating Dice throws – the correct way to do it in excel
- Beyond If and Sum, 15 really useful excel formulas for everyone
- The Olympic Medals by Country Chart – Improved now
- Excel Links of Week – Who is Obama edition? [Aug 12]
- Use min-max charts to show the spread of data – Charting Best Practice
- Search restaurants by cuisine – Google maps
- Photographic Fridays #8 – Somewhere in the paradise
- 5 Infographics that can WOW you [Aug 7]
- Dashboarding Fun – Display Smileys in your excel dashboards
- Doing the NY times Olympic medals by country year visualization in excel
- Vizooalization: 5 things I have learned about visualization at the zoo
- Analyze your blog post’s readability with Google docs
- Add more superstars to your gmail
- Excel links of the week : ‘what can excite you most’ [Aug 4]
- Conditionally play sounds when a cell value changes
- Amul is Seriously Good – How agile is your brand?
- Welcome readers from Lifehacker and Delicious
- Photographic Fridays #7 – What makes you run?
- Excel can be Exciting – 15 fun things you can do with your spreadsheet in less than 5 seconds
- 500+ subscribers, great content, wow this site must be good !
- Cool infographics around the web – [july 31]
- Want to Feed RSS to your Excel Sheet? Read this!
- Windows Mojave Experiment Kicks Ass
- Excel Links of the week
- 11 very useful excel keyboard shortcuts you may not know
- Which teacher inspired you most?
- Shuffle a list of numbers / items in excel spreadsheet
- Dear Microsoft, Blog is a real word
- Photographic Fridays #6 – Where do you want to go today?
- Mute conversations in Gmail to not follow a specific thread of mails
- Cool infographics around the web
- Watch out if you are buying insurance online at GEICO – your password is not encrypted
- Extract URLs from an excel spreadsheet cell using UDFs
- Changing Sort Orientation in Excel – Sorting across columns instead of rows
- Google Maps adds directions by Public Transport – Wow
- Excel Links – to iPhone or not to iPhone edition
- Excel Bullet Graphs
- Photographic Fridays #5 – Dawn
- Awesome folks at flickr introduce instant zoom for photos
- Improve your in-cell charts with colors and negative values
- Worst bar chart ever? – World’s Most Expensive Places to Have Sxx
- Bingo / Housie Ticket Generator in Excel
- Incell Bar charts – Revisited
- Use Google docs to track your bucks – [spreadsheet forms idea]
- myRoom.makeSuperCool()
- Photographic Fridays #4 – Fireworks
- Yahoo hopes to create more apps than no. of atoms in observable universe
- Partition Charts – Continuation – [More visualization fun]
- Partition Charts in Excel – alternative to pie charts [visualization hack]
- How to count words in a cell using excel functions
- Photographic Fridays #3 – Daisies
- Vodafone – creativity gone awry
- Excel Paste Special Tricks & How to
- Skip weekends while autofilling dates in excel
- Google maps 3d building outlines – wow
- Are you ready to solve problems differently?
- Photographic Fridays #2 – Marbles
- Hot Thermometer Charts in Excel – here is a cool way to do them
- Get Stock Quotes in Excel
- Most bizarre print ads – Indian version
- Photographic Fridays # 1 – Ground Zero
- Quickly display unique items in an excel list using advanced filters
- Stop feeling lucky, its just a google sari
- Here is a simple way to get Rs. 70 Lakhs when you are 55 – DONT touch your PF
- Formatting numbers in excel – few tips
- Incredible hulk strikes IMDB – awesome online ad
- Sunset
- App. idea for iPhone developers (for other location aware phones as well)
- Learn Excel IF Formula – 5 Tricks you Didnt know
- Cool outdoor advertising by Google Russia
- Am I a Japanese Translator?
- “I am feeling lucky” Firefox Search plug-in
- Email marketing is NOT distributing pamphlets
- How simple is your product?
- Improve productivity by opening same excel sheet in 2 windows – quick tip
- Inspiring
- Brooklyn Bridge in the night
- How to add a range of cells in excel – concat()
- Road Rage on Memorial weekend
- Get crazy CNN headlines on your t-shirt
- Welcome to Pointy Haired Dilbert – Chandoo.org
- Gantt in 60 seconds – churn out an excel project plan in no time
- Citibank’s brilliant “no panga sab changa” ad
- Rediff unLOCKS mystery of successful CEOs
- Here is a free idea for Starbucks
- MPD
- Creating in-cell bar charts / histograms in excel
- Shootout @ Hocking hills state park
- Dhoni sizzles in Tamilified ads
- Create in-cell pie charts in Excel
- on vlookup()
- Open your favorite sites directly from Windows XP run dialog box
- 7 Most innovative software job titles
- Calorie card : a sound business idea for gyms / health clubs
- Lenevo x300 ad mocks Macbook Air
- Vodafone pug is happy to help you .. or really?
- Another web advertising failure – shoppers stop
- Purnography on the lake – trip to Ashtabula county, put-in-bay
- Telling a kid how software development teams work
- Hot Fuzz – must watch for comedy lovers
- Create Cool Tag Clouds in Excel using VBA
- Do not disturb : I am scheduling a meeting
- Generate organization charts in excel – howto?
- frAGILE software development
- Focus on customers, not on your brand
- How to get more colors in excel chart – simple trick
- Google menu – does it lack common sense?
- Powerpoint Cartoons #3 – Auto fill
- Best of Indian Outdoor Advertising
- Change cell formats with find-replace in excel
- Few good Indian print ads – horlicks, maggi, zandu balm and head & shoulders
- Gmail custom time – fools day present for time travelers
- Null Pointer Exception
- 73 Free Designer Quality Excel Chart Templates – Grab now and become a charting superman
- PHD’s Regular Blah #12
- Did you see the moon-walking bear? – nice ad
- Wow! – Traveling salesman in the age of ebay
- Track / share your goals using Google Spreadsheet Gadgets
- Car gets PHD, nobody is hurt
- CNN-IBN messes up global warming with local warming
- Powerpoint Cartoons #1
- Nike’s new “my better is better than your better” ad kicks a$$
- 3 excel keyboard shortcuts that can save a lot of time for you
- PHD gets lifehacked deliciously !!!
- Conditional Formatting in Excel – 5 Tips to make you a Rockstar
- IIM Indore 2008 Placements
- Hackers sneak into Serena Williams on Ramp
- Pulsar Mania – Bajaj’s new kickass advertisement
- Red is new black … or what?
- IT Mafia – hilarious spoof on Indian IT Industry
- Custom Cell Formatting in Excel – Few Tips & Tricks
- Why do notebook page layouts suck?
- Busy!
- 5 !!! I Did it
- Nationwide Paintbucket Guerrilla ad – nicely done
- Super(b) Tuesday!
- Proud owners of Macbook
- How not to hang your clothes?
- Huh!
- PHD’s Regular Blah #11
- How to: sharing trip expenses using excel
- Subliminal Soup Ad from Potbelly
- Weekend @ Washington
- Mobile Banking Innovation from ICICI Bank
- Business Idea : Train / Flight Ticket Printing Machine
- Pointy growth inside nose and other such meaningless junk
- Amazon’s recommendation system – is it crazy?
- How I redirect traffic from blogger pages to wordpress posts
- Mera Jahan
- Lessons from music industry
- CAT 2007 results out!
- Tales of riding an auto in Chennai
- Auto tagging your old blog posts
- Normal is Boring : Having fun in whatever you do
- Happy New Year
- Economics of commission
- Lakdi Ki Kathi
- Comedy Movies – Must Watch
- How NOT to do Online Advertising – Lessons from Rediff
- Moved to WordPress from Blogger
- Proud Owner of iPod Nano
- My life in a mini-feed
- Please enter todays date to continue …
- Software or Strictware ?!?
- Welcome to Ummrica!
- PHD Regular Blah – the Nth installment
- Pay money but seek no control !
- Wear… Will you? (2.0)
- Australian Team Spirit
- Back in Hong Kong
- RIP
- My screen just widened!
- Hong Kong – Made for tourists
- Off to Hong Kong
- 3 years and counting
- Question for MBAs
- Refreshing online ad
- The Art of Excel Charting
- 2 hours in Mediterranean
- PHD’s Regular Blah #9
- Shift
- An Irish Evening
- in Dublin Now!
- Busy!
- Amul – an agile brand
- In Mumbai Now
- First and Last Golden Rule of Any Business – Know Your Customer
- Toothpic!
- Looking for a house in Chennai…
- Big Bazaar’s Innovative Parking Scheme
- Source of Happiness
- Business Idea: Community Water Purifiers
- Mobile Tailor
- PHD’s Regular Blah #8
- Start Early
- Pelli Photos
- Making sense out of NEWsense
- Fresh MBAs and IT Companies
- The problem with B-schools
- The Calvin Fund!
- Say NO to Default Charts Forever!
- Busy!
- PHD’s Regular Blah # 7
- Is Monopoly Fair?
- Do you know that Excel cant …
- Are fund managers poor marketers?
- Excel Charting Hacks #1
- newsXXX
- Find out whether you need a house or not in 60 seconds
- Welcome to Madhu2.0
- Musings of a Married Manager
- I am back…
- Blog Holiday!
- PHD’s Regular Blah #6
- 10 good things about Seoul
- Birds of different feather flock together
- PHD’s Regular Blah #5
- The Art of Imitation
- Merry Christmas
- Good news for Indian Movie lovers
- Desk-top Purnography
- PHD’s Regular Blah #4
- Dongdaemun
- I love missing the last bus to office
- Creating New MFs – the SBI way
- PHD’s regular blah #3
- Competition
- Purnography in Seoul
- Weekend Plans
- Seoul First Impressions
- In Seoul now…
- Supply Creates Demand
- Innocent Websites, pissed off clocks and such like …
- PHD’s regular blah # 2
- Sweet Nothings
- Howto: Excel Based Mutual Fund Portfolio Tracker
- Lessons in Pricing from Murugan Idli Shop
- 3 Cheers to IIM Indore
- Redif(f)ining art of converting news to scoops
- Why arent IT jobs glorified in B-school Placements?
- Purnography – some latest work
- PHD’s Regular Blah!
- Offer for PHD Readers
- Carl Sagan, Frying Pan and Local Election
- New-Clear Advertising
- In the age of Adsense and TRPs
- Blue Dart Rocks!
- Coimbatore Bus Mafia and Adventure Trip to Ooty
- You Know …
- Relationships & Banks
- Cameras: Most Popular vs. Most Clicked
- Dhud! Dhud! Dhud! Dhud!
- Google Life!
- Porok, Call back Ads and Simple Joys of Life
- US Legal Firms, Infosys Employees and Online Advertising
- Welcome to PHD!
- 3 Steps to Create cool dashboards in excel
- R1C1 – Excel Here Launched
- How to Get Unique Items using Excel
- Importing blogger posts to wordpress
- Shoot the guy in eyes, you could get some discout…
- The biggest error message ever!
- Google Grrs at Google
- 2 seconds to go!
- Duct tape found! Three men arrested!!!
- How too many dishes spoiled the cook…
- A dream that is three and half years old…
- Orbit Musings and other things
- A date with my plate!
- A bachelors guide to renting a house in Chennai
- CATvertising
- Learnings of the week that was
- Now Adsense in Hindi
- Bombay – Pune Expressway : A travelers Delight
- How to serve the customer
- Wear, will you?
- HOT HOT Advertising
- Chennai – First Impressions
- Happy Weekend :)
- Chennai it is
- Updates…
- Overheard
- Super Copy
- Purnography @ Khandala
- In search of khandala…
- Aati kya khandala?
- A Day without Internet :)
- Whats cooking PHD? – Part 2
- Focus on Details = Satisfied Customers
- Sunstroke and other things
- A trip I waited too long to make
- Understanding Customer – Insights from street
- Whats cooking PHD?
- Broad Band baj gaya!!!
- Now…
- Bas Dimag Lagao!
- The Art of Doing Nothing
- Welcome to Cashless world
- New number
- IIM Indore Convocation – 2006
- in Campus
- Trip to North East India – frist cut
- Done with the trip
- Crash Reported, No dead bodies found!
- unSafexpress and other stories …
- in Cyderabad
- More on placements, graduation etc.
- TCS it is
- Farewell Party and the deadly hangover
- Loading MBA … ;)
- What is keeping me busy?
- The "notag pact" tag
- 12 days… :(
- Magazine advertising gets better
- MMT rocks again
- Unmaking of Business Sense (part 1)
- Low Dick Space
- 20 years: longest time to make another brick?
- How not to do advertising online?
- Moving to WordPress…
- 9 sureshot ways to kill your audience using powerpoint
- A new press to publish PHD Blog!!!
- My blog is infected….
- SBI Life: Message that hits
- Misguided Enthusiasm?
- a lot of nothing
- HIV/AIDS – Interactive Campaign
- Absolut Shift
- Photographer and a lazy afternoon
- Welcome to the miraculous world
- <50 left …
- Happy Sankranthi
- My date with a mall
- Innovative New year calendar from Kotak
- Brands, Stop assuming customers are dumb!
- How Much Pointy Haired are you?
- 10 things that I cherish about 2005
- CAT 2005 Results
- New Year
- PHD Blogmela
- PHD Blogmela, coming tomorrow :)
- Rediff Shopping – another failure
- Merry Christmas…
- Where will the multiplex go now?
- PHD Blogmela
- Some things and Some links…
- Surprisingly Banks
- Bah’k
- Hols…
- Winter makes this place sexier
- JIT – Writer’s notes from implementation
- The lastmile of online shopping
- Shareholders, value creation and all that bushllit
- How we think!
- CAT
- Major Audio System Change Reported in Indore!!!
- 500 days of PHD
- IRIS 2005
- IRIS all the way
- Tell me where I can fit this
- PHD in new Avatar
- Salmagundi of sense and nonsense
- Many Many Happy Returns of the Day!
- Online Advertising
- Emote your customers
- My friend calls me "anti-bloggers, pro-iipm, pro-information secrecy dude", but …
- MarkeThink!
- The Good Old Days of Coding!
- mAdness?
- Life with out ‘i’
- Purnography – September Sky
- IRISING
- getLatestUpdates()
- Finally I am 10+
- Doing Nothing
- Recipe of my L!fe
- Leh Trip – Part 3
- Sins of earlier lives
- Business (non)sense?
- Blogger for Word
- Leh Trip – Part 2
- Feel Like God!
- Leh Trip – Part 1
- Bah’k!
- bLAW bLAW bLAW!
- All set to go
- Ladakh Itinerary
- What the hell is this?
- Meeting with Mr. Barber
- And one day…
- Who can teach you to be passionate?
- Wanted to blog…
- Photo Quiz
- Perdition and Paradise – 2
- Perdition & Paradise
- G O V A R gets visibility
- Busy and how?
- Busy!
- Water Fight Ver. 2.1
- Sportstar ads
- Brand Extension
- You have got mmmmmmmmmmmmmail!
- They are back
- Dude! where is my fullstop?
- World through my window..
- Fundu Error Message
- Why is selling soaps over-hyped?
- Come again?
- Purnography – offroad style!
- Usage Masks
- iShuffle!
- Purnography – Still worshipping the beauty
- Freedom
- Welcome ‘Link Yard’
- Beautiful days are here again
- Know your internship insideout
- Bhooth Bangla or Plain Residential Complex?
- atTAG of the clones!
- Skype’d
- MBA is all about…
- Purnography – in the night
- Which one’s better?
- Is Mallika Sherawat the next bigthing happening to India?
- 2nd year begins ahoy!
- Its raining baby…
- News – where have you gone?
- A-305 2 C-320
- Bah’k
- Purnography – The VT ishtyle
- Adness or Madness?
- Eat Out!
- Smart Tagging or Dumb Tagging?
- Busy!
- Purnography – Delayed but Delightful
- A beer that costed too much
- What is brain?
- Blurb
- B2B
- Heat waves and gujju looks
- Picture ? Puncture!
- PG on TV
- Nagpur dossiers
- Orange City
- The ultimate management book series
- Theobroma Delicacies!
- travailogue
- Pune!
- What a life…
- A nights tale
- Local Advertising
- A weekend that was…
- Purnography – 3
- Vimukthi from world of cubes…
- Otherwise a lazy weekend
- Lazy Weekend
- Purnography 2
- Chowpatti beach
- A date with just another mumbai bar & restaurant
- Updates
- From Bombay
- 1/2 and how?
- Purnography 1
- Updates…
- First time and How!
- 3 Things
- LWD, 360, 4Ps, 5Ms, 3Cs and other not-so boring stuff…
- Who has the bigger one? You or me?
- Error
- Rang Barse…
- Holi Haiyeeeeee!
- Of career and electives…
- Freebees… No please!
- Convocation 2005
- Convocation Today
- Thoughts in mind
- In retrospect: 3rd Block Rocks
- Almost forgot this…
- :)
- :(
- Presented Propaganda and Other Stories
- Urgently Needed
- Unlever or Unilever?
- PoWAH
- Leader or Manager? What is my calling?
- T4 – Treak To Table Top
- The PHD Blogmela
- The PHD Blogmela (update)
- How to feel wonderful?
- Noteven a wink
- 5000 words
- Back to BUSIness
- My Hindi Sucks
- The Blog Mela – PHD Way
- Madhu
- Midterms over. Now what?
- Midterms and nothingelse
- Thinking
- About Classroom Humor & IT Textbooks
- 10000 visitors
- FINdigestible!
- midterms
- You are simply the BEST
- busy!
- 206
- Power Salad and Other Valentine Stories
- of bulging, purging, choking and loving (BPCL)
- its a beautiful day!
- Exposed!
- It is a strict reGYM, your HIGHness!
- The holiday in a B Schoolers life
- My First Night (out) @ I
- Yahooligans
- Last 24 hours
- My appointment with Dr. Lecter
- Sunsets @ I
- Think
- Are we far from reality?
- All I Wanted to Say about GD/PI
- My current playlist
- What did you say your name is???
- Accounting of Exams !
- Latest @ PHD
- UtsAHA Pics…
- Ideas … Infinite!
- Host problem
- The AHA Effect!
- Happy Sankranti
- Busy
- Time of my life
- bah’k
- on Vacation
- help
- Of exams and holidays
- 27 and counting down
- how true!!!
- Kaisa chal raha hi?
- festive time in I
- Merry Christmas
- busy
- no time to blog :(
- outLOGging, 100 percentiles and Spamming
- See the learning
- Things my girlfriend and I have argued about…
- Feeling mighty good
- derivated humor
- its quiztime baby!
- c’est la vie
- Syndicating a day of my life!
- Its official now
- Three Things
- Kingsize weekend
- The legend passes away
- Duh!, even I did it
- Welcome to Chandoo.org !
- Moved !
- alphabetical grades and assorted updates…
- Marcovian queues, arranged marriages and forefathers !!!
- When machines get better than humans
- Escape to Reality – Part III
- Escape to Reality – Part II
- Escape to Reality – Part I
- I stink, therefore I exist
- grades, links, threads and deadlines
- Yuhoo !!!
- 150 days of Blogging and B School Life
- are you doing BLOWJOB???
- 210 minutes of tragedy and 120 minutes of comedy …
- FIN-OM-ania
- Billi ka Shubh Din
- moc(k) shocks and research rags
- 4Ls – Link, Laughter, Lazyness, Losses
- bullCheat, bto and gut feelings
- Amazing reality of marketing surveys
- Awesome Diwali Night
- Strategic Repositioning of Blog
- Macro Gibberish
- Happy Diwali
- Random Thoughts
- The making of huge cutouts
- Who blinks first?
- Smirnocked!!!
- Its beeness as usual at I
- Mission Statement of Group 7
- Age old theory of age !!!
- of Fishes and Idiots and Outsourcing
- Pick the Pix
- Making Location & Capacity Decisions
- when 30 becomes 29 …
- Long time, no see
- Start
- The mother of all terms
- T1 – An Interim Status Report
- MMF
- And the proverbial Nail in the coffin…
- aAH 2 mORE dAYS
- Superb Tail Piece
- Janmastami and other good things are here !!!
- So, What is happening???
- Subject-ed Humor
- Its all in Game Theory Stupid!!!
- Of Lines and the troubles associated with them…
- I want a day like this everyday !!!
- Do you masturbate in class???
- ‘sleeper’ class-apart
- Wake up man, You have a meeting now!!!
- Jargon Stanle-i
- Snapshots from hell
- Fasting, ‘Present’ations and Future Tensions
- Mad Termination
- New Timings, Same Work
- Messenger Cometh
- The Rape that i was talking about….
- New Template, New Life
- Cliched but Yes..
- alive and getting kicked
- Cold calls and Other insights
- Bizzee Busted and other stories
- Newsh…
- My Dreams (???)
- Announced Surprize,Words of the day and Armageddon
- Bartended!!!
- Full Swing
- What a weekend it has been….
- Sexy Atmo
- Bizzy Bees
- Informal Night & other stuff
- I is Wet…
- Learnings all the way
- updates from a weakling…
- Jet, set and go
- Pictures
- more cases and saturday night party
- sleep depravation and power point ragging
- Added Later…
- Life slowly begins
- First Day – First Show
- … and thus born Modus Indoramus
- Closes tonight – Save up to $100 on your favorite Excel courses [holiday sale]
- Ends tonight – Save up to $50 on your favorite Excel courses [holiday sale]
|
Archives by Month:
|
By Category:
Category with most articles on top
|
