Introduction

This is for all you excel lovers. I am starting this blog to help thousands of people who wish to know excel indepth. I always faced this challenge when I started excel reporting 7 years back. Today I head the MIS Reporting Team for a Multinational company. All this in 7 yrs. Imagine I did not know anything of excel 7 yrs back .....Its been a long journey....I want to share my learnings with everyone.Also I want to help others to learn excel and help them excel in life.This blog is aplatform for us to meet and help each other

Wednesday, September 14, 2011

Is 2007 Better Part 3

Are you fond of using shortcuts in excel? 2007 is the place to be for you. Why is that ? Its easy just press the alt button and discover the world of possibilities with 2007. It is important to go through the TABs before you start using the 2007 shortcuts. For example in case you want to turn the calculations of excel to manual you need to know in which TAB does it have that option. Its in the formula TAB
In order to use the shortcuts in 2007 it is essential to do some homework which you can start by spending some time browsing thru the tabs and knowing what lies where

Tuesday, September 13, 2011

Is 2007 better Part 2

If we look at the benefits of 2007 there are a lot of things that have been taken care of. Thats the speciality of this version as it takes into consideration the limitations of the all earlier versions. As a MIS person I always felt that excel is limited in terms of data and the resources it takes. With 65000 rows and 256 columns one may feel its enough however if you are a hard core MIS guy you would always feel its less as times goes by.
For those of you 2007 comes as a relief with increase in number of rows and columns.

Sunday, September 11, 2011

IS 2007 better Part 1

If you look at the interface of 2007 it looks rather vibrant and vast. The need for going into options for doing any action is very limited as all options are available in the toolbar right from formatting of cells to removing gridlines.Also all those who are used to 2003 shortcuts need not worry. Excel 2007 has the capability of working on 2003 shortcuts and it clearly states that you are using a 2003 shortcut

Saturday, September 10, 2011

Whats Best in 2007 as compared to 2003

Well everyone must be wondering why some of them are still working on 2003 and not 2007 ?
The answer is quite simple. Not every corporate has license to 2007 rather are happy with 2003 as its one of the most stable versions of MS Office and is compatible with all OS and low on resources.
So whats different in 2007 ? Is it just the interface or looks or much more.
Keep following this page for more

Monday, June 27, 2011

How to Present using Excel?

Excel is not only used to create dashboards or MIS. It can be used as a valuable tool to present your views. So how can you do this?
Its all about what you want to present? Who is your audience? What is the end result you are expecting out of this presentation? How valuable and important is this presentation to you?
These are some of the questions you should be asking yourself before you can create something in excel.
I agree that Powerpoint is the tool which is used for presentations but excel is equally useful.
The final outcome can go in PPT but the base design can be on excel