Excelgyan

  Formulas Tab Function Library Group Insert Functions  With the help of this option, we can edit the function (formula) of the current cell and insert the new function in the new cell. Apart from this, you can take offline help    related to the function.                Auto Sum With the help of this option, you can automatically add a range in the sheet in which the number data is written.                Recently Used            In this option, functions are found which have been used recently.                Financial            Financial options are available in this option. Like - PMT, PV, FV etc.                Logical            Logical functions are available in this option...

                                                                               Data Tab   Get External Data Group From Access  This option is used to import MS Access tables to Excel sheets. From Web    This option is used to import table from online browser to Excel sheet. From Text  This option is used to import a text file like Notepad to an Excel sheet. From Other Sources  Use this option from other sources like XML, SQL etc. Is used to import from Excel sheet.  Existing Connections By clicking on this option, we can see the name of the file that was added to our sheet. Connections Group Refresh All  When a file is imported into a sheet. And if changed in the imported file. The sheet is refreshed to show it in the sheet. Connections  In this ...

Page Layout Tab   In the page layout tab of MS Excel's options, we can set or modify setting related to page. Themes Group  Themes  This option is used to change the theme of the sheet. Colors  This option is used to change the color of the theme. Fonts  This option is used to change the font of the theme. Effects  Effect Option is used to change the theme of the graphic created Smart Art by the option from Insert Tab. Page Setup Group  Margins Margins are the leaving spaces on the side of the page. Through this option, the margins around the page are reduced or increased. You can see it in print preview or page layout view. Orientation  With this option, the orientation of the page is changed, there are two types - Portrait and Landscape. Size  This option is used to change the page size, such as - A4, A3, Letter etc. Print Area  With the help of this option, we select a range from the sheet and set it to print, which will print the sam...

                                                                        Insert Tab In the Insert tab of Excel 2007, the options are placed in which some inserts are done in the worksheet. Tables Group  Pivot Table  With this option, which normal table is used to convert into a pivot table. In this, we can put the fields of the normal table in special order. Pivot Chart With this option, we can create a pivot chart for the data of a column of the current table and the value from one or more columns for it from the worksheet. Table This option is used to convert any normal range in the sheet into a special table format. And you can modify the table using the options of the design tab that comes with it. Illustrations Group  Picture  Using this option, you can add a picture to a worksheet by s...