All articles with 'list posts' Tag
Today, let’s travel in time. Pack your photon ray guns, extra underwear, buckle your seat belts and open Excel!
Of course, we are not going to travel in time. (Come to think of it, we are going to travel in time. By the time you finish reading this, you would have traveled a few minutes)
We are going to learn how to travel in time when using Excel. In simple terms, you are going to learn how to move forward or backward in time using Excel formulas.
So are you ready to hit the warp speed? Let’s beam up our Excel time machine.Continue »
Today lets get cozy. Lets start a fling (a very long one). Lets do something that will make you smart, happy and relaxed.
Don’t get any naughty ideas. I am talking about INDEX() formula.
Of all the hundreds of formulas & thousands of features in Excel, INDEX() would rank somewhere in the top 5 for me. It is a versatile, powerful, simple & smart formula. Although it looks plain, it can make huge changes to the way you analyze data, calculate numbers and present them. It is so important that, whenever I teach (live or online), I usually dedicate 25% of teaching time to INDEX().
Enough build up. Lets get cozy with INDEX.Continue »
For every column chart that is done right, there are a dozen that get messed up. That is why lets talk about 5 simple rules for making awesome column charts.
Tip: Same rules apply for bar charts too.Continue »
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).Continue »
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.Continue »
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 […]Continue »
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.Continue »
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…Continue »
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
- Readers (that is you) pick a winner and runner-up using online voting.
- 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.Continue »
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.Continue »
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.Continue »
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.Continue »
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.Continue »
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.Continue »