Over Easter, while we were all busy eating our Easter Eggs, at the Chandoo.org/Forums, Slk213 was worried about how to retrieve the Nth number from a row of data which had gaps in it.
Today in Formula Forensics we will look at how to solve this problem.Continue »
If there was a challenge in any Finance 101 course at any B School, I think Creating the Cash Flow Statement would score the max. When I was pursuing my MBA, the biggest enigma for me was to go from the Balance Sheet and Income Statement to the Cash Flow statement via the indirect route. I could never get it right!
There were two challenges, the bigger was obviously unclear concepts plus I didn’t know how to play with Excel! I have worked hard on both and let me show you, how they can be used to get the right cash flow statement in no time!
Actually the concept is simple and excel makes it run on steroids!Continue »
Last week, we learned how to use SQL and query data inside Excel. This week, lets talk about how we can use VBA to consolidate multiple data sheets from different workbooks into one single worksheet.Continue »
Happy Easter 2012
It is Easter time again. It has been our tradition to hide some Easter eggs so that you have fun discovering them. I usually hide the eggs in the blog post. But this year, I went one more step and created an Excel file with 3 hidden Easter eggs.
Go ahead and find the eggs. I am sure you will love themContinue »
Today Faseeh, from the Chandoo.org Forum, joins Chandoo.org as a contributor with his first post.
Faseeh, helps find a solution to Maljzm’s problem of looking up time values from a list and comparing them to determine if a value meets some criteria.
We pause the regular broadcast of Excel awesomeness to share something exciting. As you may know, I will be running a series of Advanced Excel Dashboard Masterclasses in Australia this May & June. So if you live in (or nearby) Sydney, Melbourne, Canberra, Perth or Brisbane and want to one up your dashboard skills, you know what to do next.
I am conducting these masterclasses in partnership with Plum Solutions.
Read this short post or Click here to know more about this masterclass.Continue »
Often I have thought, if I could have write “Select EmployeeName From Sheet Where EmployeeID=123″ and use this on my excel sheet, my life would be simpler. So today we will learn how to do this.
People spend a lot of time thinking whether to use Excel as their database or not. Eventually they start using Access or SQL Server etc.
Today we will learn how to use Excel as a Database and how we to use SQL statements to get what we want. We will learn how to build a form like above.Continue »