Login to online classes

Happy New Year to all PHD Readers

  • Last updated on March 2, 2009
Picture of Chandoo

Chandoo

Share

Facebook
Twitter
LinkedIn

Happy New Year to all my readers. I am sure 2008 has been many things to many people, but I am hoping it has been an year of productivity and happiness for you. Here is to wishing a great, no, fantastic 2009 for you and your family.

If you were busy through out 2008 and couldn’t really catch up on all the fun excel and charting ideas posted and discussed at PHD, here is your last chance to browse them. 2009 will be a fresh year. I am kidding, all the articles will be available in 2009 and beyond as well. But just go ahead and read them anyways.

Here is 10 posts from 2008 that are must read

15-excel-tips Excel can be Exciting – 15 fun things you can do with excel
excel-gantt Become a Conditional Formatting Rockstar – Learn 5 cool Excel tips
excel-chart-templates Make beautiful charts – use these gorgeous templates
ulgy-charts 6 Charts you will see in hell
charting-trick Select & Show one chart from many – Excel Charting Trick
kpi-charts Excel KPI Dashboards – 4 Post Tutorial and Free Downloads
excel-formulas 15 Microsoft Excel Formulas everyone should know
micro-charts-excel Micro-charting in Excel – Alternatives Reviewed
mf-portfolio Tracking your Mutual Funds and Stocks using Excel – Download included
paste-special Master Excel’s Paste Special – Learn these cool tips

Here is a list of top referrers to the site:

Life Hacker
Jon Peltier @ PTS Blog
Spreadsheet Page
Coliss
Digital Inspiration
XL Cubed Blog
Daily dose of Excel

I am so thankful to all my readers and commenters who supported PHD and helped me learn so many things.

Special thanks to Robert and Vishy who contributed to this blog through guest articles.

Once again, wish you all a very happy 2009 🙂

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my story • FREE Excel tips book

Want an AWESOME
Excel Class?

advanced-excel-dashboards-course-chandoo
Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst

FREE Goodies for you...

Excel formula list - 100+ examples and howto guide for you
100 Excel Formulas List

From simple to complex, there is a formula for every occasion. Check out the list now.

20 Excel Templates

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks
13 Advanced Pivot Table Skills

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Get started with Power BI

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Related Tips

2 Responses to “Celebrating the Lookup Formulas – VLOOKUP Week @ Chandoo.org”

  1. Frank Franco says:
    July 28, 2011 at 9:19 pm

    How did you arrive or formula when you ask me who made more sales Jackie or Jamie?? I could not figure the formula out yet??

    Reply
  2. Hui... says:
    July 29, 2011 at 12:35 am

    @Frank
    You need to sum up the sales for Jackie and compare them to the sales of Jamie over the same period.

    The practical parts depends on how and what data you have and how it is arranged.

    But it will either involve a Sum, Sumif, Sumifs or Sumproduct to accummulate the sales for each within a specified date range.

    Reply

Leave a Reply