All articles with 'list posts' Tag

As you may new, the newest version of Excel is out for a while. I have been using it since last 6 months and enjoying it. Today, lets understand 10 things in 2013 that wowed me (and probably you too).

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.

This year has been the busiest year since the inception of Chandoo.org. We had 161 posts, 8,900+ comments, 33,500+ forum posts. We have trained more than 2,500 students thru training programs like Excel School & VBA Classes this year alone. More than 6.5 million people visited our site this year (up 82%),  consuming a whopping [...]

Lets talk round numbers today.I have 18.2 tips for you on round numbers.

We can use a variety of formulas to round numbers in Excel depending on the situation. We have ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD and few more. To know how to use all these formulas and how to round numbers based on any criteria, just read on.

Our guest author, Myles Arnott discusses what Best Practice Modeling is and offers 5 practical, easy to implement tips to get you started.

Best Practice Tip #1: Apply a modeling life cycle
Best Practice Tip #2: Give structure to your spreadsheets
Best Practice Tip #3: Make cells consistent based on their behavior
Best Practice Tip #4: Use similar formulas
Best Practice Tip #5: Build error checks in to your models

Read on…

Recently, we published 66 dashboards visualizing Excel salaries around the world. Each of the contestants have put in great effort and hand-crafted these beauties. Now its time we picked a winner.

How does the voting work?

The voting has 2 components

1. Readers (that is you) pick a winner and runner-up using online voting.
2. Judges (2 of them) will also pick winners. Judges vote carries 20% weight.

Everyone likes to be in control. Even my 2 year old daughter jumps with joy when she lays her hands on TV remote. She pushes the buttons and assumes it is working. It is another story that we rarely watch TV at home.

By adding an element of control, we can make our dashboard reports fun. Interactive elements like form controls, slicers etc. invite users to play with your dashboard, get involved and understand data by asking questions. That is why I recommend making dashboards interactive.

Today lets understand how you can make dashboards interactive.

Ladies & gentleman, put on your helmets. This is going to be mind-blowingly awesome.

See how many different ways are there to analyze Excel salary data. Look at these 66 fantastic, beautifully crafted dashboards and learn how to one up your dashboard awesomeness quotient.

This week many Excel bloggers are celebrating VLOOKUP week. So I wanted to chip in and give you a comprehensive guide to VLOOKUP & Other lookup formulas. Read on …,

What is VLOOKUP Formula & how to use it?

I often tell my excel school students that learning VLOOKUP formulas will change your basic approach towards data. You will suddenly feel that you have discovered a superman cape in your attic. It is that awesome.

As part of our Speedy Spreadsheet Week, I have asked you to share your favorite tips & techniques for speeding up Excel. And what-a-mind-blowing response you gave. 75 of you responded with lots of valuable tips & ideas to speed-up Excel formulas, VBA & Everything else.

Thanks to all the contributors

Many thanks to everyone who shared their tips & ideas with us. If you like the tips, please say thanks to the contributor.

Read Excel Speeding-up tips by area

This page is broken in to 3 parts, click on any link to access those tips.

Read everything
Formula Speeding-up Tips
VBA / Macros Optimization Tips
Everything Else
Share your tips

Excel formulas acting slow? As part of our Speedy Spreadsheet Week, today lets talk about optimizing & speeding up Excel formulas. Use these tips & ideas to super-charge your sluggish workbook. Use the best practices & formula guidelines described in this post to optimize your complex worksheet models & make them faster.

1. Use tables to hold the data
2. Use named ranges & named formulas
3. Use pivot tables
4. Sort your data
5. Use manual calculation mode

… and more. Read on to learn these top 10 tips & ideas to improve performance of your excel formulas.

Today is February 29th, and that means, this year we have one more day to be awesome. So lets celebrate it in Excel style!

Lets learn 14 different ways to tell if an year is leap year, using Excel Formulas.

Why 14? because, we are awesome like that.

One of the most dreaded courses during my under-graduation is Probability, Statistics & Queuing Theory. We called it PSQT. I struggled to understand the significance and concept of this course as I could barely concentrate in the class. We had a professor, who is probably a genius, but the moment he started the class, I would magically fall in to one of my after-noon naps. When I woke up, we are either in the middle of an elaborate t-test or going thru intricacies of a Markovian queue.

This was all 11 years ago. Later in life, I have embraced the world of probability & statistics. I still fear queues. May be I will get there one day.

A good understanding of statistics & probability theory is necessary if you want to model complex real-life problems using Excel or similar tools. Naturally, Excel has several functions, features & supported add-ins to help you in this area.

Today, I want to share some of this with you. This article is broken down in to 3 parts.

1. Learning Statistics & Probability using Excel
2. Downloadable Excel Workbooks to understand
3. Full blown models & simulations in Excel

Obviously, everywhere you look this week, you find advice on how to do better in 2012.

While you don’t have to wait for a new year to become awesome at your work, You might use the occasion.

So, today I want to share 12 ways to become awesome in Excel. But first I have secret to confess…,

I think becoming awesome in Excel useless.

What we really want is, to become awesome in our work. Since we spend a lot of time using Excel (and other office software), knowing how to use these better can have a huge impact on how we do our work.

In that spirit, lets look at 12 steps to become awesome in your work using Excel.

This year has been the most hectic since we started Chandoo.org. We had 178 posts, more than 7,500 comments & 10,000 forum posts. We have trained more than 2,500 students thru Excel school, VBA Classes & Financial Modeling Classes this year alone.

More than 3.5 million people visited our site this year, spending an average of 2:30 minutes per visit, consuming a whopping total of 10.5 million page views. Just to give you a comparison, last year (2010), we had 1.5 million people visiting 5.5 million pages. We have also added 17,000 more RSS / Newsletter members this year. It is a hectic year for the site.

To wrap up the wonderful year, I want to share a list of posts that most of you loved.