Sales Analysis Charts in Excel – 78 Alternatives
Recently, I ran a contest asking you to analyze a bunch of sales data and present your results in charts. We received a total of 78 charts from 45 people. The contest entries had a mind-boggling variety of excel charts, techniques and ideas. It took me a while to go thru all the files and compile the results. Thanks for your patience. In this post, you can find all the charts along with my comments & links to download files.
Use Copy & Paste to Preserve References to Tables [Quick Tip]
With Excel 2007, Microsoft has introduced a powerful and useful feature called as Tables. One of the advantages of Tables is that you can write legible formulas by using structural references. That means, you can write easy to understand formulas like this,
But, there is a problem. When you write these formula and drag the formula cell sideways to fill remaining cells, Excel changes table column references and thus makes your formulas almost useless.
Well, there is a simple workaround for this problem
Lost Excel Functions
– Cue, alluring music.
Just like Jack and the crew of Oceanic Airlines flight 815, Excel has a number of LOST functions.
This post will look at some of Excel’s Undocumented, Unloved and Rarely used Functions
VBA Classes are Open now. Please join today!
Dear Readers & Friends,
I am very happy to announce that our first batch of VBA Classes is open for your consideration. Please read this short post to understand the benefits of this program and how you can join. Click here to join our class, if you are ready.
What is this VBA Class?
VBA Class is a structured and comprehensive online training program for learning Microsoft Excel VBA (Macros). It is full of real world examples & useful theory.
The aim of VBA Classes is to make a beginner an expert in VBA.
What are the benefits of this class?
Oh so many! Learning VBA one ups your Excel mojo. You will suddenly start saying “Yes” several work opportunities & challenges. Your boss might fall in love with you. You realize the potential to automate large chunks of your work and save time & money.
IFERROR Excel Formula – What is it, syntax, examples and howto
If IFERROR() were to be a person, I would hug her so hard that Jo (my wife) would get in to a cat fight with her. I know many a woman (and man) who get in to a fight with Excel formulas often. But thankfully, we avoid that as IFERROR is not a real person. It is, however a darned useful formula.
Since I cannot hug a formula anymore than I can get my son to sit tight, I will go ahead and sing an ode to her, in my style – by writing about how useful and powerful IFERROR formula is.
Quickly Compare Data using Row Differences
Lets say you have some data in 2 columns and you want to compare row by row to spot the differences. Of course you can write a formula or apply conditional formatting. But there is a quick and dirty solution that works just as fine.
How long have you been using Excel? [poll]
This week’s poll is dead simple. Just tell me since how many years you are using Excel. I will go first: I have first started using Excel in year 2003 to keep track of my MBA entrance exam preparation. It helped me a lot in recording practice test scores, listing all the mistakes I made […]