Ms-Excel

Duration : 01 Months

1. MS Excel
2. Spreadsheet
3. MS Excel Interface: Title Bar, File Menu, Quick Access Toolbar, Ribbon, Formula bar, Name box, Status Bar(Microsoft Office Frame), Worksheet, Sheet tab bar, Sheet tabs, Tab scrolling buttons, Insert Worksheet tab
4. WORKBOOK
5. Worksheet
6. Rows & Columns in Excel
7. Cell Introduction
8. Save Workbook in Excel 2010
9. Home tab : Clipboard, Font, Alignment, Number, Styles, Cells, Editing
   1. Copy Paste using Office Clipboard
   2. Copy Paste in Special way
   3. Setting Cell Type in Excel
   4. Formatting Cell
   5. Various Cell Formats
   6. Rotate Cells in Excel
   7. Setting Colors in Excel
   8. Changing Background Color
   9. Changing Foreground Color
   10. Text Alignments in Excel
   11. Change Alignment from Home Tab
   12. Change Alignment from Format Cells
   13. Merge Cells
   14. Wrap Text and Shrink to Fit
   15. Borders and Shades in Excel
   16. Conditional Format in Excel
   17. Find & Replace in Excel
10. Insert tab : Table, Illustrations, Charts, Links, Text
    1. Pivot Tables
    2. Pivot Charts
    3. Adding Graphics in Excel : Insert Shape, Insert Smart Art, Insert Clip Art, Insert Word Art,
    4. Charts in Excel
    5. Header and Footer in Excel
    6. Using Symbols
    7. Using Special Characters
11. Page Layout Tab : Themes, Page setup, Scale to fit, Sheet options, Arrange
    1. Adjust Margins in Excel
    2. Page Orientation in Excel
    3. Options in Sheet Options Dialogue
12. Formulas Tab : Function library, Defined Names, Formula auditing, Calculation
13. Creating Formulas in Excel
14. Elements of Excel Formula : References, Operator, Constants, Functions
15. Cell References in Formulas : Relative Cell References, Absolute Cell References, Mixed Cell References
16. Built-in Functions in Excel
    1. Math & Trig : SUM(),PRODUCT(),POWER(),SQRT(),Round(),Roundup(),Rounddown(),ABS(),GCD(),LCM(),QUOTIENT(),MOD(),RANDBETWEEN(),ROMAN()
    2. Text Functions : CONCATENATE(),UPPER(), LOWER(),PROPER(),LEN(),LEFT(),RIGHT(),MID()
    3. STATISTICAL FUNCTIONS : AVERAGE(),MAX(),MIN(),COUNT(),COUNTA()
    4. DATE FUNCTIONS : NOW(),TODAY()
    5. LOGICAL FUNCTION : IF(),AND(),OR()
    6. Cross Referencing in Excel : VLOOKUP(),HLOOKUP()
17. Defined Names
    1. Types of names : Defined name, Table name, Define a name for a cell or cell range
18. Data Tab
    1. Get external Data
    2. Filters in MS Excel
    3. Sorting in MS Excel
    4. Data Validation in Excel
19. The Review Tab : Proofing, Comments, Changes
20. Spell Check in Excel
21. Insert Comments in Excel
22. The View Tab : Workbook Views, Show/hide, Zoom, Window, Macros