Chandoo.org - Learn Excel, Power BI, Charting, Dashboards and VBA online

Latest Tips & Tutorials

Top 10 Formulas for Aspiring Analysts

Few weeks ago, someone asked me “What are the top 10 formulas?” That got me thinking.

While each of us have our own list of favorite, most frequently used formulas, there is no standard list of top 10 formulas for everyone. So, today let me attempt that.

If you want to become a data or business analyst then you must develop good understanding of Excel formulas & become fluent in them.

A good analyst should be familiar with below 10 formulas to begin with.

Read This »

January 16, 2013

Insert Multiple Columns at once [Quick tip]

Here is a quick tip to start your week. Ever wanted to insert a few columns in between like this? Here is how to do

Read This »

January 15, 2013

Introducing ‘Finance for Non-finance people’ training program

Dear readers & supporters of Chandoo.org,

I am very glad to announce that our brand new online course – “Finance for non-finance people” is now available for your consideration. Please take a few minutes to read this short message to understand what this program is & how it benefits you. If you are ready to join, please click here.

What is Finance for Non-finance people course?

This course aims to teach financial fundamentals & introduce you to the world financial analysis in a no-nonsense way.

We start by introducing financial analysis and the basic jargon. Then we talk about 3 important components of any company’s finances – Balance Sheet, Income Statement & Cash flow Statement.

Then we discuss about various analytical techniques like ratio analysis, valuation mechanisms, break-even analysis.

Finally we explain advanced accounting concepts like long-lived assets, depreciation, explore trend analysis and unit economics.

In a nut-shell, this course takes someone with no finance background and makes them proficient in world of finance.

Read This »

January 10, 2013

3 upcoming courses to Make you awesome [Announcements]

A quick announcement for all of you aiming to become awesome in Excel in 2013.

I am very happy to share our course timeline for first 3 months of 2013.
Upcoming Courses:
Here is a summary of courses I am planning to launch in next 3 months. I will be posting more details about these courses soon.

1. Finance for Non-finance people

Learn about financial basics, financial analysis thru Excel in our finance for non-finance people course. Designed by my partners at Pristine education, this course helps you gain insights to finance world quickly.

This course will be launched Thursday, January 10th – 2013

2. Power Pivot School

Jump in to power pivot, analyze data & extract insights like a pro by going thru this program. Aimed at Excel analysts & reporting professionals, this course helps you unleash power of PowerPivot to do awesome things.

This course will be launched on Wednesday, February 6th – 2013

…

Read This »

January 9, 2013

To-do List with Priorities using Excel

A while ago, we published a new year resolution template. This was a hit with our reader with thousands of you downloading it. During last week, Peppe, one of our readers from Italy, took this template and made it even more awesome.

The original template had tasks and completion check mark. As you finish each task, you can see the progress bar moving.

Peppe added priorities to this. With his new version, progress is measured based on how much priority we assigned that particular task. Pretty neat eh?!?

Read This »

January 7, 2013

Creating an Agenda template in Excel

When planning a meeting, an event or activity, we deal with many individual steps (each taking certain amount of time). Today let us understand how to create an agenda template in Excel using simple formulas.

Read This »

January 4, 2013

Please take our readership survey and help me make you awesome in 2013 [Surveys]

Hi friends & readers of Chandoo.org

I hope you had a fantastic start to 2013. Mine was awesome so far.

This year, I am even more committed to making you awesome in what you do. As a first step, I have created a small survey to know how we can help you better this year.

Please take our 2013 readership survey [takes less than 5 mins to answer]

That is all for now. Wishing you an awesome, Excellent new year 2013.

Read This »

January 2, 2013