How Would You Visualize Product Sales Data? [Excel Challenges #2]
We have a new Excel Challenge folks!
I know our friends in US are away celebrating Memorial Day weekend. But that should not leave rest of us from fun. So, we have a new Excel Challenge. This time, you need to make a chart, to visualize product sales data.
And what more, one lucky person could get an Amazon Kindle Reading Device (Wi-fi version) by making the chart.
Advanced Sumproduct Queries
How often have you had a simple table where you want to lookup a value or add up some values meeting a criteria?
This post looks at a simple way to do a 2D Lookup or 2D Sum of a values from within a 2D range with multiple criteria, without complex Sum, Offset, Index, Match, Sumifs or other functions, simply using Sumproduct
Mod() function in excel to Implement Escalation Frequency [Financial Modeling Tutorials]
You take an apartment on rent at $1000 per month and the owner puts an escalation clause saying 10% increment each 3 years. How do you model this in excel? In this tutorial we understand how escalations at certain frequency can be implemented using the mod function in excel. What is the mod() function Simply […]
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
VBA Classes Registration Closing in a Few Hours – Join Now!
I have a quick announcement for you.
Registrations for our VBA Class will be closing in a few hours
As you may know, we have opened registrations for our first batch of Online VBA classes on May 9th. This program is aimed at beginners & intermediate level VBA users. The aim of this course is to make you awesome in VBA. We will be closing registrations for this program in few more hours (exactly at 11:59 PM, Pacific time, on 20th May 2011)
Data Tables and Monte Carlo Simulations (Update)
Data Tables & Monte Carlo Simulations in Excel – A Comprehensive Guide, has had some housekeeping carried out.
Count-down Timer App in VBA to Remind you about the VBAClasses Closing Time!!!
Here is a cool count-down timer application made in VBA to remind you about our VBAClasses registration closing time!
Read the rest of this post to learn how this particular app is built.
If you want to learn VBA, then click here to join our class.