Tuesday, May 8, 2012

Use of Pivot Table in MS-Excel

Pivot table is one of the most important and useful feature of MS Excel. Normally pivot table is used for Zonal sale analysis or such kind of other analysis where you have to analyze the thing category wise. Let’s have an example, where we are assuming that 24 Managers of an electronic company are posted at 24 different cities of India. And we have selected these cities according to four zones i.e. North, East, South and West.

From pivot

First step to prepare Pivot table is to select data from A1 to I25
Next step is to click on Insert --> Pivot Table --> Pivot Table

From pivot

The following dialog box will appear on the screen:

From pivot

If you have not selected the range from A1 to A25 then you can select the range by clicking the red-arrow. Just press OK to get Pivot table on new worksheet. The Pivot table will appear on new worksheet :
From pivot

On the right side of excel screen there is field list. Now Just by clicking on Zone and Total we can get the total zone wise sales.
From pivot

By this way we can click on Manager-Total, State-TV, Zone-WM etc. This way Pivot table give us freedom to revolve our different analysis around few clicks.

Tuesday, July 26, 2011

Entrepreneurial Motivation Factors

Entrepreneurial Motivation Factor

1. Educational background (Engineering degree in textile )

2. Occupational Experience

3. Desire tο work independently (Autonomy)

4. Desire tο branch out tο manufacturing

5. Family background ( Marwadi, Sindhis, Baniyas in Indian Society)

6. Aѕѕіѕtаnсе frοm Government (e.g. PMRY in India)

7. Aѕѕіѕtаnсе frοm financial institution

8. Availability οf technology/raw material

9. Profit margin

10. Desire fοr taking personal responsibility

11. Anticipation οf future possibilities

12. Success ѕtοrіеѕ οf entrepreneurs

13. Tο gain social prestige

14. Heavy Demand

15. Technical knowledge
"It is better to be a Job Provider rather than a Job Seeker"

Sunday, April 4, 2010

Microsoft Excel 2007

Microsoft Excel 2007
  • Spreadsheet program
  • extension: *.xlsx
  • Now each sheet contains 16384 columns and 1048576 rows( 17179869184 cells)
  • Very easy handling of functions, charts, pivot table and other features.
  • Contains ribbon with 7 tabs i.e. Home, Insert, Pagelayout, Data, Formula, Review, View.

Thursday, March 11, 2010

Control Menu Shortcuts

Shortcuts for 'window' control buttons: 
Maximize:- Alt+Space Bar+X  
Minimize:- Alt+Space Bar+N 
Close:-   Alt+ Space Bar+C 
Restore:- Alt+Space Bar+R