Changing the Orientation for MS Excel

Changing the Orientation :
              Most documents are portrait (tall)  oriented,  but many worksheets may be easier to read in the landscape (wide)  mode-In addition,  changing the orientation can also help to fit a large worksheet to one sheet of paper.  After changing the orientation,  you may need to proceed with Changing the Paper Size.

1. Select the Page Layout tab 
2. Select the Orientation icon
3. Under Orientation, select the desired option (Portrait or Landscape) 

Page layout for MS Excel

Page Layout 
             Excel 2010's page Layout view gives you an instant view of how printed Excel pages will look.  You activate this view by clicking either the Page Layout View button (the center one)  to the immediate left of the Zoom slider on the Status bar,  or the Page Layout View command button on the view tab of the Ribbon. When you switch to Page Layout view,  Excel adds horizontal and vertical rulers to the column letter and row number heading.  In the Work sheet area,  this view shows the margins for each printed page,  with any heading and footers defined for the worksheet,  along with the breaks between each page.
Note: To see all the pages required to print the active worksheet,  drag the slider button m the Zoom slider on the Status bar to the left until you decreases the screen magnification sufficiently to display all the pages of data.
             In order to girl information on a page or change the appearance of the page,  you may want to customize your page layout Several methods of changing the layout,  located in the Page Setup dialog box,  are described here.

• Changing the Orientation changing the Pepar Size 
• Adjusting the Scale & Adjusting the Margins
• Centering the Worksheet on the Page 

Apply Conditional Formatting for MS Excel

Apply Conditional Formatting
This option is used to format the cell depending upon the condition.  Following are the steps

• Select one or more cells in a range,  or table that is on be Apply formatting. 
• On the Home tab,  in the Styles group,  click Conditional Formatting icon. 
• Select Highlight cells Rules and click Between. 
• From the Between dialog box displayed,  choose the formatting you wish to use from the dropdown.  Line default is a Tight Red with Dark Red Text".
• Click OK. 
• The background color of all values that appear more that once in the selected ranges will chow the selected formatting. 

Create a chart for MS Excel

Create a chart 

• Click on any cell within the data containing the information that you wish to display as a chart,  or highlight the exact data area that you wish to display as a chart. 
• On the Insert menu,  in the Charts group,  click the chart type you require.  A gallery of thumbnail images for the related chart subtypes will appear. 
• Click the required chart subtype to create the chart,  or click All Chart Types to open the Insert Chart dialog box and choose from all available chart types. 
• When you have selected a subtype,  a chart will be created as an object in the worksheet and Chart Tools will appear on the Ribbon incorporating Design,  Layout, and Format tabs. 
• For example,  when choose the '3-D Clustered Column' subtype, the chart created as follow :
• Alternatively,  click the Charts group Dialog Box Launcher to open the Insert Chart dialog box and see all the available chart types. 
• You can also change the default chart type in the Insert Chart dialog box by selecting a chart type and clicking the Set as Default Chart button. 

Note : To quickly create a chart of the selected data (based on the default chart type)  as an object in the current worksheet,  press Alt+FI. To create a chart of the selected data as a new sheet press F11. 

Creating Chart from Data in a Worksheet for MS Excel

Creating Chart from Data in a Worksheet 
               Once you have entered the data you want to display as a chart into a worksheet and decided which type of chart you require,  you can create it with just a few mouse clicks.  Use the following illustration to quickly create a chart on the current worksheet.
Open Excel 2010 and create a worksheet as illustrated below. 

Creating Charts for MS Excel

Creating Charts :
                Charts group is one of the most useful groups of Microsoft Excel 3010 and it has been improved and came around with some new features which were not available with the Excel 2007. The Excel 2010 charts have a great new look.  That is why today Excel is one of the most commonly used application for creating charts.   Before you can create a chart,  you must have some numbers (data)  that stored in the cells in an Excel worksheet Normally,  the data that a chart uses can be resides in a single worksheet;  or us3 data that's stored in other worksheets. 

Insert Tab for MS Excel

Insert Tab :
             The Insert tab of Excel 2010 Ribbon is one of the most interesting one to discover and it had so many visually attractive feature that will allow users of Excel 2010 to produce amazingly professional looking graphs and tables.  The insert button consists of Tables,  Illustrations, Charts, Sparkling's, Filter,  Links,  Text,  Symbols groups and all these group consists of many icons that have been designed to provide a perfect Excel 2010 experience