Call Us +91 933 4518 306 , 705 0382 914

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