Introducing Spreadcheats – Become Supergood with Excel in 30 days

blogging , Learn Excel - 11 comments

spreadcheats-excel-spreadsheet-productivity-tipsStarting next week, PHD is going to feature a 30 post series on spreadcheats. The purpose of these posts is to make day to day spreadsheeting a breeze. Each post will be less than 200 words in size and aspires to make your day at office a little bit more productive.

I have already identified around 25 simple topics for discussing like: relative vs. absolute reference in functions, chart formatting, printing and sharing workbooks etc.  But please feel free to drop your suggestions on what you would like to know. I like learning and sharing new stuff and your requests can motivate me to do that.

All the posts in this series will be tagged with “spreadcheats“. Once the series has a meaningful number of posts, I will create a seperate page where you can get all the links and discussion in one place.

Watch out for the first installment on next week. 🙂

Chandoo

Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.

Related articles:

Written by Chandoo
Tags: , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

11 Responses to “Introducing Spreadcheats – Become Supergood with Excel in 30 days”

  1. AlexJ says:

    Chandoo,
    Topics that come to mind include:
    Conditional Formating
    Data Validation
    Use of the OFFSET function
    How to make a valid data list
    Basic pivot tables

  2. Robert says:

    Chandoo,

    I think this will be quite a challenge: "supergood in Excel in 30 days". I am looking forward to the series.

    A few more ideas:

    - selection of the most powerful functions: OFFSET (as Alex already said) the LOOKUPs, MATCH, INDEX, SUMPRODUCT, SUMIF, COUNTIF, SMALL, LARGE, INDIRECT, etc.

    - Array formulas

    - Autofilter, special filter and SUBTOTAL

    - Custom number formats

    - Use of form controls

    - Keyboard shortcuts

    - Customizing the toolbar(s)

    - Trendlines for charts

    - Solver

    - Error handling in formulas

    - Range names

    - the must-have add-ins (Power Utility Pak, Name Manager, etc.)

  3. CraigM says:

    Chandoo,
    Date sorting intricacies - by week, month, quarter, year, etc independent of format

  4. Ketan says:

    Dear,

    Following topics are very useful :
    Solver
    Goal Seek
    Scenario
    List
    Query writing
    ABC of Visual Basic(for layman)

  5. Denise says:

    Mr PHD - I also struggle big time with OFFSET - I know that it is a mighty fine function - If only I could get to grips with it!

    Another function - INDEX. Can you try to cover this as well please.

    Many thanks Mr Chandoo
    Denise

  6. Cheryl says:

    I am really looking forward to this! I also would like to see some fundamental Visual Basic info. Are you going to be doing this in '07 or '03?
    BTW, I just learned a new keyboard shortcut and I can't believe it took me this long to find it -- shift F11 for a new sheet.

  7. nixnut says:

    Are you aware that juiceanalytics also did something in this area some time ago? See http://www.juiceanalytics.com/writing/excel-training-worksheet/

    regards,
    nixnut

  8. BDA says:

    Hey,

    Sounds interesting and am waiting for the updates 🙂

  9. chandoo says:

    @All: thanks so much for the suggestions. It is nice to know that you are eager to make me learn and share all these ideas.

    Few clarifications:
    - all of these would be based on excel 2003 (dont worry, most of them may work with 2007)
    - the intention is to share simple answers to day to day excel problems that I have learned the hard way
    - SInce the posts are going to be bite sized (200 words max) I wont be able to learn or share some of the more complex excel spreadcheat suggestions you have given like : array formulas, form controls or solver etc. But let me understand some of these things in depth and write a bigger post whenever I can.

    Thanks once again. Let us use this thread to post any suggestions you may have. 🙂

  10. Bruno@Brazil says:

    Chandoo, nice idea you had!

    I'm interested in these topics that had been already suggested. But I'd like also to suggest you to comment something about tips for saving a worksheet in smaller files. Several times we need to send a worksheet by e-mail, but my worksheets get only bigger and bigger. Internet gets faster every day, but some people complain if they have to open a 10 Mb attachment... I don't know if it's related with the way I use formulas, I'd like to hear something about it from you.

  11. Robert says:

    Bruno@Brazil,

    ozgrid provides several methods that might help you:

    http://www.ozgrid.com/Excel/ExcelProblems.htm

Leave a Reply


« »