Excel Links – PASS BA 2015 Edition

Posted on April 14th, 2015 in excel links - 5 comments

PASS BA conference - 2015In about 3 days, I am leaving to USA for participating in PASS Business Analytics conference – 2015. It is an annual event for people in analytics profession. This is the first time I am attending & speaking at the event. I am so excited for many reasons.

  • I will be meeting many Excel bloggers, authors & internet friends for the first time
  • I will be meeting many of you (readers, listeners, followers & customers of Chandoo.org) too
  • I will be speaking at an awesome conference
  • I will be visiting San Francisco for the first time in life
  • I will be meeting a few college friends too

All this excitement means, I have too much going on. But that shouldn’t leave you out. So here are a few awesome Excel links for you. Check out and learn.

Camera tool selfie

This is a bit old, but very cool. We all know about the camera tool (picture links). But you can create a recursive camera selfie with this cool trick. It generates some amazing patterns too. Check it out.

Ten tips to speed up VBA

Mike shares top 10 things you can do to speed up VBA. I did not know about 3,4,5 & 6. What about you? If you love optimizing code, also check out our VBA optimization tips page.

Track projects using Excel

Debra shares a cool project task tracker template. Download and use it to simplify your project management.
PS: a tongue twister for you: Tommy’s task tracker template thinks Trish’s too tall

Today() aint so bad

TODAY() is a very useful Excel formula. It returns current date. But it is also volatile. That means, everytime any cell in your spreadsheet changes, TODAY() formula gets evaluated again. This will be a big problem if your workbook has lots of data & calculations. An alternative… Jeff proposes a work around the volatilily of TODAY() using data validation. Read the rest of the tip at Daily Dose of Excel.

5 Easy & powerful Excel features you may not know

Excel is loaded with lots of powerful features, complex formulas and arcane menu options.Learning and mastering these can take a while. So here are a few really low hanging fruits of Excel. Easy pickings. Pluck them and use in your workbook for instantly gorgeous results. Check out Microsoft blog for the tips. No prizes for guessing who the author is.

That is all for now. See you again soon.

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

5 Responses to “Excel Links – PASS BA 2015 Edition”

  1. Doug Glancy says:

    Thanks for the liink Chandoo. Camera Tool Selfie is one of my favorite things that I've posted.

    Have a good time in San Francisco. I used to live there but haven't visited in years. I love just walking around the city- so much to see.

    • ANAND says:

      Dear Chanddoo,

      Wish you all the best for your San Francisco visit to participate in excel Business Analytics conference – 2015.

      With regards.

      CMA Anand

  2. Tim says:

    -Visit Fisherman's Warf for tourist items to bring back to the family.
    -It's crazy driving a rental in San Francisco. Try traveling on the trolley through town.
    -Try there clam chowder in a bread bowl. Fantastic!

    Enjoy your trip!

  3. Thanks Chandoo! Have a great time at the PASS BA conference, and don't use too many tongue twisters in your presentation!

  4. Shafahome says:

    its nice to know.
    my good wishes with you and i hope u rock the Business Analytics conference. (y)

Leave a Reply