All articles with 'Learn Excel' Tag

Winner of Excel Expense Tracker Contest – RomeoG

Published on Aug 10, 2010 in blogging

Remember the excel expense tracker contest we did when our little blog hit 10,000 RSS Subs? Well, the results are out, and the winner is RomeoG. His (or her?) workbook (shown below) received 31 votes. RomeoG will receive the Toshiba net-book (this one). Thanks everyone for participating & voting. You can see the winning entry […]

Continue »

9 Excel Tips & Downloads Submitted by Our Readers [Reader Awesomeness Week]

Published on Aug 9, 2010 in Charts and Graphs, Excel Howtos, Learn Excel, VBA Macros
9 Excel Tips & Downloads Submitted by Our Readers [Reader Awesomeness Week]

Last week I announced Reader Awesomeness Week to celebrate the passion, attitude and knowledge of our little community here. I got 9 interesting and beautiful entries from our readers. In this post you can see 9 tips & downloads submitted by our readers. These include a project management template, a macro to remove blanks, a technique to make Google Earth maps using Excel and several other interesting tips & tricks.

Go ahead and read them, download attached workbooks and become awesome in Excel. :)

Continue »

Download Excel Wedding Planner Today

Published on Aug 6, 2010 in excel apps, products
Download Excel Wedding Planner Today

I am very happy to tell you that Excel Wedding Planner is ready download.

Continue »

12 Rules for Making Better Spreadsheets

Published on Aug 5, 2010 in Financial Modeling, Learn Excel
12 Rules for Making Better Spreadsheets

As part of reader awesomeness week, today I am featuring a list that Larry sent me with 12 beautifully defined rules for making better spreadsheets. He says that spreadsheets should be easy to understand, have a clearly defined purpose and should use Excel features as much as possible. I totally agree with him.

Read the rest of this post to find the rules and download a poster containing these rules. Thanks Larry.

Continue »

How Francis Landed on Chandoo.org, Become Awesome and Made a Superb Dashboard, all in ONE Weekend

Published on Aug 4, 2010 in Charts and Graphs, Featured, Learn Excel

As part of our Reader Awesomeness Week, Francis shares with us a travel site dashboard he made for his company. Francis took just two days to prepare this awesome dashboard which uses concepts like bullet charts, sortable KPI grid, Date based filtering, dynamic charts and more. I was really moved by Francis’ gesture in sharing his work with us, so much that, I did a video review of his work. You can see it in the embedded youtube video to the left.

Read the rest of the article to know how this dashboard is made and get a copy of the file.

Continue »

Immigrants in Denmark – An Excel Infographic

Immigrants in Denmark – An Excel Infographic

Faheem (@FaheemH) from Denmark sent me this beautiful infographic depicting various facts about Immigrants in Denmark. Immigrants in Denmark – Excel Infographic: [view high res] How is this Info-graphic made? Faheem used a variety of tricks to create this infographic. Some of the key ideas are, Using text boxes and drawing shapes Using bar charts […]

Continue »

Announcing Reader Awesomeness Week – Submit your Tips, Stories, Workbooks and Ideas

Published on Aug 2, 2010 in Learn Excel
Announcing Reader Awesomeness Week – Submit your Tips, Stories, Workbooks and Ideas

It is no secret that our readers are awesome. We have tons of creative, passionate & caring members in our community who just kick ass day in day out. Just look at the comments in any post and you are going to find amazing display of skill, intelligence and mastery of Excel craft. To celebrate all this, we are going to dedicate this week (August 2nd thru 6th) as Reader Awesomeness Week.

What is Reader Awesomeness Week?

Through out this week, I am going to share excel workbooks, ideas, tips & tricks that our readers have submitted to me. First 3 days (Tuesday thru Thursday) I will be posting contributions I already received thru Email.

On Friday, I will be posting all the tips, downloads submitted by you. Click here to contribute.

Continue »

Introducing Excel Wedding Planner

Published on Jul 29, 2010 in products
Introducing Excel Wedding Planner

About a month ago, I got an email from Kevin. The crux of this email is,

I am working on a wedding planner based in Excel. Do you want to collaborate?

I replied to him asking for more details as I got curious about the project. Kevin sent me a work-in-progress version of his wedding planner which blew my mind. Although I have only one wedding experience and even that I hardly planned (as it is traditional for parents to take care of the wedding ceremonies in India), I found Kevin’s planner quite comprehensive, useful and easy.

So we worked on it together and I am happy to announce the Excel Wedding Planner

Continue »

Building a Layout for Project Evaluation Model & Best Practices [Part 2 of 6]

Published on Jul 28, 2010 in Financial Modeling
Building a Layout for Project Evaluation Model & Best Practices [Part 2 of 6]

In the second part of our tutorial we will learn how to prepare the layout of our model to do project evaluation.

If you know basic referencing and formula framework in excel, you can write a model that calculates numbers. Good vs Bad financial model would be decided by the layout of the model.

Before we start discussing on how to build a good layout, lets see the layout that I have in mind. The layout is based on my experience of working as an investment banker and as a consultant and I find it neat.

Continue »

How to show Indian Currency Format in Excel?

Published on Jul 26, 2010 in Excel Howtos
How to show Indian Currency Format in Excel?

This is a guest post by our excel ninja – Hui. Today we will learn how to format numbers and amounts in Indian currency format. Indian numbers are grouped differently than standard English numbers. English Grouping              123,456,789.01 Indian Grouping               12,34,56,789.01 Quick and easy fix to show numbers in Indian format: A custom number format of: […]

Continue »

7 Links and One Question for You

Published on Jul 23, 2010 in Learn Excel
7 Links and One Question for You

Darren writes one of my favorite blogs – Problogger, it is a blog about blogging. It is super helpful for people like me who write, connect, share and sell online. A week back, Darren asked his readers to participate in a fun experiment by posting 7 links on their blogs. It seemed like an interesting […]

Continue »

Introduction to Financial Modeling using Excel [Part 1 of 6]

Published on Jul 21, 2010 in Featured, Financial Modeling, Learn Excel
Introduction to Financial Modeling using Excel [Part 1 of 6]

In this and next 5 posts, we are going to learn how to build a financial model to do project evaluation using Excel. The 6 parts of this tutorial are,

  1. Introduction to Financial Modeling
  2. Building a layout for Project Evaluation Model – Best practices
  3. Building Inputs and Assumptions Sheet
  4. Building Projections for Project Evaluation
  5. Modeling the Cash Flow Statement and Projections
  6. Putting it all together – Final Project Evaluation Model

What is financial modeling?

Financial modeling is creating a complete program/ structure, which helps you in coming to a decision regarding investment in a project/ company. Now this could be on a simple piece of paper or in excel. The advantage with excel is that, even if you have calculation speed and accuracy like me (this is one place where I am like Einstien!), then also you would be able to come to the right conclusion!

Continue »

Select Expressions to Find their Values [Macro Debugging Tip]

Published on Jul 19, 2010 in VBA Macros
Select Expressions to Find their Values [Macro Debugging Tip]

Here is a quick macro tip that I stumbled on to while debugging some code yesterday (ya, ya, call me workaholic for coding on a weekend…) You can select expressions in your code and place mouse pointer on that for a second to find what value it evaluates to (of course, this works only on […]

Continue »

7 Personal Expense Trackers using Excel – Download Today

Published on Jul 16, 2010 in Charts and Graphs, excel apps
7 Personal Expense Trackers using Excel – Download Today

Keeping track of your expenses is one of the fundamentals of living good life. So I asked you to prepare a personal expense tracker as part of our 10,000 RSS Subscriber Milestone contest. I have received 7 excellent entries in this contest, each capable of making expense tracking a breeze while providing good analytics of […]

Continue »

4 Alternatives to Export Excel Dashboards as Web Pages

Published on Jul 14, 2010 in Charts and Graphs
4 Alternatives to Export Excel Dashboards as Web Pages

This article is written by Alex Kerin from Data Driven Consulting. “When expensive dashboard software doesn’t work, do it with Excel” stated Stephen Few back in 2006. This was before the release of Tableau, and some of the other solutions now available for visualizing your data, but Excel remains a great choice for creating dashboards when you […]

Continue »