Edge Educations - Vivek Srivastava

Excel 2010 View Tab Lesson-9 View:- This bar provides different options for viewing the sheets in an Excel workbook. It also provides options for viewing different windows in Excel, for enlarging or reducing the size of the worksheet while it is being viewed, and what elements in the Excel window should be displayed. Normal - Displays the worksheet in the normal view. There is also a shortcut to this view in the bottom right corner of the status bar. Page Break Preview - Used for adjusting page breaks. There is also a shortcut to this view in the bottom right corner of the status bar. Page Layout - Displays the worksheet as it will appear on a printed page.Displays a very useful horizontal and vertical ruler plus you can add/change headers and footers, check margins, row/column headings and scaling options. Not to be confused with Print Preview. There is also a shortcut to this view in the bottom right corner of the status bar. Custom Views - The Custom Views feature allows you to s...

  Excel 2010   Review Tab Lesson-8 Review Tab:- Review in Excel has been divided into four Groups namely:- PROOFING Spelling Research Thesaurus Language All comment Changes Protect sheet Protect workbook Shared Workbook Protect & Share Track Changes COMMENTS New comment Delete Previous next Show/hide comment Spelling - (F7). Displays the "Spelling" dialog box. Allows you to check the spelling on the active worksheet. Research - Toggles the display of the Research Task Pane. Thesaurus - Toggles the display of the Research task pane defaulting the research service to the thesaurus. Translate - Toggles the display of the Research task pane defaulting the research service to the translation. New Comment / Edit Comment - (Shift + F2). Inserts a comment at the active cell. Delete - Deletes the selected comment. Previous Comment - Moves to the previous comment in the active workbook. Next Comment - Moves to the next comment in the active workbook. Show Comments - Toggles the...

Excel 2010 Data Tab lesson-7 Data:- We use Data tab for the large amount of data.It is useful to import the data by connecting with the server, and we can import data automatically from web, MS Access etc. ... Data connections are links to the data outside the workbook which can be updated if the source data changes. From Access:- Excel 2010 can import data from an Access 2010 database table into a worksheet, a process known as making an external data query. ... In Excel, click the From Access button in the Get External Data group on the Data tab. Excel opens the Select Data Source dialog box From Web:- Import data from a web page. From Text:- Import data from a text, comma-separated value or formatted text (space delimited) file.  From Other Sources :- On the Data tab, in the Get External Data group, click From Other Sources, and then click From Microsoft Query. The Choose Data Source dialog box is displayed.In the Choose Data Source dialog box, click the Queries tab.Double-clic...