Dressing Financial Statements – What Motivated Mr. Bean to Defraud Latte?
Did you know What Happened at Last Coffee Day?
Mr. Bean “dressed up” the financial statements and was caught in the fraud. But he was the CEO of Latte! So why did he commit fraud in his own company??
Any Guess?
Take a cappuccino and I will give you a hint – How was Mr. Bean’s Bonus to be decided?
Read on to know more…
How the tax burden has changed over the years – Excellent chart by NYTimes & Redoing it in Excel
If I need some charting inspiration, I always visit New York Times. Their interactive visualizations are some of the best you can find anywhere. Clear, beautifully crafted and powerful. Long time readers of Chandoo.org knew that I like to learn from visualizations in NY Times & redo them using Excel.
Today let me present you one such chart. This is based on an interactive visualization prepared by NY Times explaining how the tax burden has changed over years for various income groups.
Take a look at tax burden chart – Excel implementation
Read on to learn how to create this chart using Excel.
Project Portfolio Dashboard in Excel [Part 2 of 2]
In this 2 part tutorial, we will learn how to design a project portfolio dashboard. Part 1 discussed user needs & design. Part 2 will show you Excel implementation.
Click here to get your copy.
Final Implementation – Project Portfolio Dashboard
First lets take a look at the finalized dashboard implementation. Continue reading to learn more & download this dashboard.
Write a formula to check if two dates are in same month? [homework]
Its Home work time folks. Sharpen your Excel pencils and get cracking.
Find out if 2 dates are in same month
Lets say you have 2 dates in A1, A2.
Q1. What formula tells us if both of them are in same month?
Both dates must be in same month & year!
Go ahead and post your answer in comments.
Extract file name from full path using formulas
Today lets tackle a very familiar problem. You have a bunch of very long, complicated file names & paths. Your boss wants a list of files extracted from these paths, like below:
Of course nothing is impossible. You just need correct ingredients. I cannot help you with a strong cup of coffee, so go and get it. I will wait…
Back already? well, lets start the formula magic then.
Check Cells for Equality – Follow Up [Quick Tip]
Excel contains an often overlooked function
The Excel = Function
Today we quickly review what it can do for us.
Write a formula to check few cells have same value [homework]
Lets test your Excel skills. Can you write a formula to check few cells are equal?
Your homework:
- Let us say you have four values in cells A1, A2, A3, A4
- Write a formula to check if all 4 cells have same value (ie A1=A2=A3=A4)
- Your output can be TRUE/FALSE or 1/0 to indicate a match (or mis-match)