I have a question and an announcement for you.
Question: Are you interested in learning Power Pivot? Do you want to connect, analyze and visualize lots of data using Excel?
IF(Your_answer="YES", "Read Announcement", "Read Announcement anyway!")
Announcement: 2nd Batch of Power Pivot coming on August 1st.Continue »
Today we look at the third place winner from our inaugural Formula Challenge, a neat solution provided by Sajan.Continue »
This new series introduces a new author to Chandoo.org, Jeff.
Jeff will pose a number of Excel based Formula Challenges and then explain how some of the solutions work in a manner similar to the Formula Forensics series.
In this first post of the series we look at how to extract a string from the right of a block of Numbers in a larger string.Continue »
Pop quiz: What is wrong with above report?
At first glance, it looks alright. But if you observe closely, you realize that it is not telling the entire story. Just looking at regional sales numbers, you have not much clue what is going on with them.
So how to improve it?Continue »
What do you use Excel Tables for?
I will go first, I use them for,
1) Maintaining all my raw data, so that I can use structural references
2) Maintaining various trackers, for example I am tracking all our expenses in USA in a table.
3) For quick formatting of data (zebra lining, filters, sorting etc.)
What about you? What kinds of data are you holding in tables and how are you using them. Please share using commentsContinue »
Have you ever been in a VLOOKUP hell?
Its what happens when you have to write a lot of vlookup formulas before you can start analyzing your data. Every day, millions of analysts and managers enter VLOOKUP hell and suffer. They connect table 1 with table 2 so that all the data needed for making that pivot report is on one place. If you are one of those, then you are going to love Excel 2013’s data model & relationships feature.Continue »
As an analyst (or manager), I bet a good portion of your Excel time is spent writing formulas and getting the results.
So today, let us learn 5 important keyboard shortcuts that will save you a lot of time and help you write better formulas.Continue »