MS-Excel Tutorial PDF

MS- EXCEL MS-EXCEL Components of MS-Excel The Ribbon displays various commands and features of all the tabs. MS-Excel  Excel is an Microsoft Application that is mainly used for calculations and mathematical works. a) It is a spreadsheet application in which we can add sheets as per our re...

MS- EXCEL MS-EXCEL Components of MS-Excel The Ribbon displays various commands and features of all the tabs. MS-Excel  Excel is an Microsoft Application that is mainly used for calculations and mathematical works. a) It is a spreadsheet application in which we can add sheets as per our requirements. In a single sheet, it consists of rows and columns and cells, where every cell has different address. b) Sum, product, subtraction, division and many mathematical, logical functions are available within it. c) Other features include tables, charts, clip art and more. d) It is basically used for payroll, accounts, mathematical, and for other business purposes. Features of MS-Excel  Hyperlink. We can link one file to another file or page.  Clip art. We can add images and also audio and video clips.  Charts. With charts, we can clearly show a product(s) evaluation to a client. For example, you can display a chart showing which product is selling more or less by month, week, and so forth.  Tables. Tables are created with different fields (e.g. name, age, address, roll number, and so forth). You can add a table to fill these values.  Functions. There are both mathematical functions (add, subtract, divide, multiply), and logical ones (average, sum, mod, product).  Images and backgrounds. You can incorporate images and backgrounds into each sheet.  Macros. Macros are used for recording events for future use.  Database: With the data feature, you can add any database from other sources to it.  Sorting and filtering. We can sort and/or filter our data so that anything redundant or repetitive can be removed more easily.  Data validations. This tool can help you consolidate your data.  Grouping. The grouping feature helps you both to group your data and ungroup it so that you have subtotals and so forth.  Page layout. Themes, colors, sheets, margins, size, backgrounds, breaks, print, titles, sheets height, width, scaling, grids, headings, views, bring to front of font or back alignment, and many more are available for you to lay out your page. Arithmetic calculation Graphs And Charts Some Functions of MS-Excel Average Count Pi Sum Product Max If