Excel: Microsoft Excel:

Microsoft Excel is a spreadsheet program. It features an intuitive interface, calculation and graphing tools. These tools could be used for business financial analysis and other administrative tasks. These features have made Excel one of the most popular microcomputer applications to date. In this module you will master Microsoft Excel.
Microsoft Excel is one of the most widely used Spreadsheet applications for performing financial, statistical and computational analysis for the purpose of business and administration.

The tool is so flexible enough to get integrated with other applications for providing the best output. For instance, it can be integrated to web servers and the students marks, percentile etc. calculated can be generated onto the web. Similarly it can be integrated with the other Office Applications for providing Charts, Statistics etc. It can also be used as a backend database for any applications involving high-end calculation of the data that is stored.

This Workshop Session on Microsoft Excel brings out the valid use of Excel Spreadsheets in a day to day life in both Corporate and Academic Scenarios. The tasks that have been designed trains the students to obtain the best possible knowledge about Microsoft Excel through applications/samples explaining the vast and widespread options and tools of the Microsoft Excel. These tasks are centered on practical exposure to the use of tools and also its applications in both the academic media and the corporate media.


TASK 1:
Creating a Scheduler:-Features to be covered: - Gridlines, Format Cells, Summation, auto fill, Formatting Text
PURPOSE:
To maintain a shift schedule with specifications
THEORY:
Grid lines:
1. Click the worksheet.
2. On the file menu, click page setup and the click the sheet tab.
3. Click gridlines.
4. Select the sheets on which you want to change the gridlines color.
5. On the Tools menu click options click the color you want in the color box.
6. To use the default gridlines color click automatic.
7. Lines you can add to a chart that make it easier to view and evaluate data. Gridlines extend from the tick marks on an axis across a plot area.
Format Cell:
1. Change the font and font size.
2. Change the text color.
3. Make selected text or numbers bold, italic or underlined.
4. Create a new style.
Auto fit:
1. Combine cells horizontally or vertically to make one large cell.
2. Add borders to cells.
3. Shade cells with colors.
4. Change the column width and row height
5. Change the font, font size or colors of text.
6. Align text vertically at the top, center and bottom of cell.
Formatting the text:
1. Select the text you want to format.
2. On the format menu click cells and then click number tab.
3. In the catalog box click text.
4. Enter the numbers in the formatted cells.
5. Click ok.
6. Then press enter and reenter the data.
PROCEDURE:
First click start button of the screen on status bar. Click on programs and then Microsoft excel. To get a new blank work sheet go to programs and then click on excel sheet. On the file menu click page setup and then click sheet tab click gridlines. In this way do the required changes using format cell, make the required changes using formatting text also make the required changes. Enter the data in the data in the worksheet consisting of week name person name and timings 7 a.m. to 3 p.m. Make all the above changes to the text.