All articles with 'Excel 2010' Tag

Creating Customer Service Dashboard in Excel [Part 3 of 4]

Published on Apr 18, 2012 in Charts and Graphs, Learn Excel
Creating Customer Service Dashboard in Excel [Part 3 of 4]

Welcome back. In third installment of our Customer Service Dashboard series, we will learn how to construct the charts in our dashboard. We will understand the sparklines, traffic lights & dynamic chart setup. To help you learn better, I have recorded a short video too. Go ahead and enjoy.

Continue »

How to add your own Macros to Excel Ribbon [quick tip]

Published on Feb 27, 2012 in Excel Howtos, VBA Macros
How to add your own Macros to Excel Ribbon [quick tip]

Do you know that in Excel 2010 you can create your own Ribbon tabs and add anything to them, including your own macros? Today, we are going to take a look at this useful feature and learn how to add your own macros as buttons to Excel Ribbon. Steps to Add your own macros to […]

Continue »

How to create a Win-Loss Chart in Excel? [Tutorial & Template]

Published on Jun 9, 2011 in Charts and Graphs
How to create a Win-Loss Chart in Excel? [Tutorial & Template]

Win Loss Charts are an interesting way to show a range of outcomes. Lets say, you have data like this:

win, win, win, loss, loss, win, win, loss, loss, win

The Win Loss chart would look like this:

Win Loss Charts in Excel - Template & Tutorial

Today, we will learn, how to create Win Loss Charts in Excel.

We will learn how to create Win Loss charts using Conditional Formatting and using In-cell Charts.

Continue »

Switch Scenarios Dynamically using Slicers

Published on Jun 1, 2011 in Pivot Tables & Charts
Switch Scenarios Dynamically using Slicers

Slicers are my new favorite feature in Excel. Introduced in Excel 2010, Slicers are like visual filters.

Now, we can use slicers creatively to make an interactive scenario manager in Excel, as you can see below. We will learn how to create this in Excel in today’s post.

Continue »

Make Dynamic Dashboards using Pivot Tables & Slicers [Video & Download]

Published on Dec 8, 2010 in Charts and Graphs, Pivot Tables & Charts
Make Dynamic Dashboards using Pivot Tables & Slicers [Video & Download]

Do you know that Excel 2010 makes creation of dynamic dashboards very simple?

Yes, that is right. Using slicers feature, you can create dynamic excel dashboards from your data in very little time. Today we are going to learn a technique that will help you create a dashboard like below.

Read rest of this post to find out how to construct a dynamic dashboard in Excel & download the example workbook.

Continue »

Updates on Website, Office 2010 Contest

Published on May 31, 2010 in blogging
Updates on Website, Office 2010 Contest

We have updates!!! Chandoo.org on Cloud: Everybody and their grandmother is going cloud these days. Although I am quite nebulous about this cloud thing, over the weekend, I mustered some courage and messed with Amazon Cloud Front. I am happy to tell you that Chandoo.org should feel faster and more responsive as I moved some […]

Continue »

Understanding Backstage view in Excel 2010

Published on May 21, 2010 in Excel Howtos
Understanding Backstage view in Excel 2010

In the last installment of excel 2010 features, we will explore the backstage view (or file menu) in Excel 2010.
Background on Backstage view:

Most of the windows based applications have a File menu. This is the usual place you go to create, open, save, save as, print and close. In Office 2007, Microsoft ditched menu based navigation and introduced Ribbon. They moved all the formatting, pivot, charting, formula, print etc. options to various individual ribbon tabs. But they couldn’t move the functionality of File menu to a separate ribbon. Instead, they moved all this functionality to Office button – a clone of file menu.

Continue »

Attend Free Excel Training Session by Me on May 25th

Published on May 20, 2010 in Learn Excel
Attend Free Excel Training Session by Me on May 25th

Fantastic news folks… As part of Office 2010 launch, Microsoft India is arranging a virtual launch event on May 25th and 26th. There are a ton of cool sessions on various Office products. I will be presenting on “Sparklines and Conditional Formatting” On May 25th between 3:30 – 5 PM IST (we are GMT + […]

Continue »

How to make new ribbons in Excel 2010?

Published on May 20, 2010 in Excel Howtos
How to make new ribbons in Excel 2010?

Starting Excel 2010, you can finally customize the ribbon UI and define your own tabs or groups. This can be a huge productivity boost for people using MS Office applications. In this post, learn how to customize excel ribbon to improve your productivity.

Continue »

New Features in Excel 2010 Conditional Formatting

Published on May 19, 2010 in Charts and Graphs, Learn Excel

Conditional formatting is one of favorite features in Excel. CF has helped me save the day at work more than a dozen occasions. I almost became project manager just because I knew how to make a gantt chart in excel using conditional formatting. I have written extensively about it.

So, I was naturally curious to explore what is new in Excel 2010’s Conditional Formatting. In this post, I will share some of the coolest improvements in CF.

Continue »

What are Excel Sparklines & How to use them? [Excel 2010]

Published on May 18, 2010 in Charts and Graphs
What are Excel Sparklines & How to use them? [Excel 2010]

As part of Excel 2010, Microsoft has introduced an exciting and new charting feature called as “sparklines”. Edward Tufte coined the term sparkline and defined it as, “intense, simple, word-sized graphics”. I think adding sparklines to Excel’s pack of visualizations is a huge step in the right direction. Sparklines (often called as micro-charts) add rich visualization capability to tabular data without taking too much space. While MS’ implementation of Sparklines in Excel 2010 leaves a lot to be desired, it provides a solid platform and introduces this powerful charting idea to masses.

In this post, we explore sparklines in excel 2010 and learn how to use them. You can find several tips and ideas on implementing sparklines in your upcoming report.

Continue »

What is new in Microsoft Excel 2010? [Office 2010 Week]

Published on May 17, 2010 in Featured, Learn Excel
What is new in Microsoft Excel 2010? [Office 2010 Week]

Office 2010, the latest and greatest version of Microsoft Office Productivity applications is going to be available worldwide in the next few weeks. I have been using Office 2010 beta since November last year and recently upgraded my installation to the RTM version. I was pleasantly surprised when I ran Microsoft Excel 2010 for first time. It felt smooth, fast, responsive and looked great on my comp.

This week, I want to celebrate the launch of Excel 2010 and write about the following new features in Excel 2010.

Also, you can win a copy of Office 2010 – home & student edition by leaving a comment on this or any of the other excel 2010 posts scheduled for this week

Continue »

Excel Links – Project Management Edition

Published on May 3, 2010 in excel links

It has been quite a while since we had an excel links post. It doesn’t mean that I am not reading anything new on excel or charting. I have been reading lots of awesome articles and useful content and sharing it on my google reader recommendation list. But it is just that I have been […]

Continue »

Sachin Tendulkar ODI Stats – an Excel Info-graphic Poster

Sachin Tendulkar ODI Stats – an Excel Info-graphic Poster

Sachin Tendulkar is undoubtedly the best cricketers to play One Day International Cricket. He is a source of inspiration and joy for me and many others. So, naturally I was jumping with joy when I heard that he scored the highest ever runs in a single match on 24th of Feb. He scored 200 runs […]

Continue »

What is PowerPivot? (and does it really wear underwear on top of pants !?!)

Published on Jan 8, 2010 in Charts and Graphs
What is PowerPivot? (and does it really wear underwear on top of pants !?!)

Along with Excel 2010, Microsoft released a free add-in called PowerPivot. According to MS, PowerPivot gives users the power to create compelling self-service BI solutions, facilitates sharing and collaboration on user-generated BI solutions in a Microsoft SharePoint Server 2010 environment, and enables IT organizations to increase operational efficiencies through Microsoft SQL Server 2008 R2-based management […]

Continue »