Archive for August, 2013

5 simple rules for making awesome column charts

Published on Aug 29, 2013 in Charts and Graphs
5 simple rules for making awesome column charts

For every column chart that is done right, there are a dozen that get messed up. That is why lets talk about 5 simple rules for making awesome column charts.

Tip: Same rules apply for bar charts too.

Continue »

Sort by Birthday [Quick tip]

Published on Aug 26, 2013 in Excel Howtos
Sort by Birthday [Quick tip]

Lets say you have a list of employees and their birthdays. Now you want to sort this list, based on their birthday, not age. How would you do it?

Continue »

Last day for enrollments – Join our Power Pivot class & become awesome analyst

Published on Aug 16, 2013 in Power Pivot

Hurry up, Enrollments for Power Pivot online classes closing in few hours - Join nowHi folks,

I have a quick announcement & a creative dashboard to share with you. First the announcement.

Only few hours left to join our Power Pivot course…

As you may know, I have opened enrollments for our 2nd batch of Power Pivot course few days ago. The aim of this course is to make you awesome in Excel, Advanced Excel, Dashboards, Power Pivot & Advanced Power Pivot.

We will be closing the doors of this program at midnight, today (11:59 PM, Pacific time, Friday, 16th of August).

If you want to join us, click here and enroll now.

Continue »

How to find the lowest value? [Quick tip]

Published on Aug 12, 2013 in Excel Howtos
How to find the lowest value? [Quick tip]

Lets say you are the head of purchasing department at Big Corp Co.

You are obviously very busy. Every day starting with a large cup of coffee and ends with a big smile, as you save your company thousands of $s by negotiating best deals, finding best providers and being awesome.

Today, let me share a small Excel tip with you that will make you even more awesome.

Continue »

How to create a Then vs. Now interactive chart in Excel?

Published on Aug 6, 2013 in Charts and Graphs
How to create a Then vs. Now interactive chart in Excel?

You have been there before.

Trying to compare last year numbers with this year, or last quarter with this quarter.

Today, let us learn how to create an interactive to chart to understand then vs. now.

Demo of Then vs. Now interactive chart

First, take a look the completed chart below. This is what you will be creating.

Continue »

Power Pivot online classes – now open for you

Published on Aug 1, 2013 in Power Pivot, products
Power Pivot online classes – now open for you

Hi friends, readers and supporters,

I am very glad to announce that our Power Pivot & Advanced Power Pivot classes are now open for you. If you are ready, Click here to join us.

Those of you new to this, read on.

What are these classes?

These days almost any job requires data analysis & presentation of results. While anyone can put a list of values in Excel & sum them up, not everyone can do advanced analysis, create charts, make them interactive, summarize data intelligently, present output in an intuitive dashboard or slice & dice data using Pivot tables & Power Pivot. Having these vital skills can make you invaluable to your organization & expose you to new opportunities. Not to mention the amount of time, money & effort you can save by efficiently using Excel.

That is why we have created 3 powerful courses – Excel School, Power Pivot & Advanced Power Pivot classes. Think of these as steps in a ladder.

Continue »