Excel Classroom Training in chennai

Excel Classroom Training in chennai

 

  • Early Bird Offer

    Sale Date Ended

    INR 3500
    Sold Out
  • Regular

    Sale Date Ended

    INR 5000
    Sold Out

Invite friends

Contact Us

Page Views : 215

About The Event

 Excel Classroom Training in chennai

Overview

      Our Excel courses can benefit you with the knowledge of how to use Excel more effectively and efficiently. This training helps the users to enhance their understanding of Formatting a Worksheet, Managing your workbooks, editing a Workbook, Formulas, Working with the Forms Menu, Creating & Working with Charts, Data Analysis & Pivot Tables. 


Agenda

The Basics

    1. Creating a New Workbook
    2. Navigating in Excel
    3. Moving the Cell Pointer
    4. Using Excel Menus
    5. Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
    6. Entering Values in a Worksheet and Selecting a Cell Range
    7. Previewing and Printing a Worksheet
    8. Getting Help from the Office Assistant
    9. Saving a Workbook & Re-opening a saved workbook


Formatting a Worksheet

    1. Creating Headers, Footers, and Page Numbers
    2. Adjusting Page Margins and Orientation
    3. Adding Print Titles and Gridlines, rows to repeat at top of each page
    4. Formatting Fonts & Values
    5. Adjusting Row Height and Column Width
    6. Changing Cell Alignment
    7. Adding Borders
    8. Applying Colors and Patterns
    9. Using the Format Painter
    10. Using AutoFormat
    11. Merging Cells, Rotating Text, and using AutoFit
    12. Using AutoFill


Managing your workbooks

    1. Switching Between Sheets in a Workbook
    2. Inserting and Deleting Worksheets
    3. Renaming and Moving Worksheets
    4. Protecting a Workbook
    5. Hiding Columns, Rows and Sheets
    6. Splitting and Freezing a Window
    7. Inserting Page Breaks
    8. Advanced Printing Options


Editing a Workbook

    1. Entering Date Values and using AutoComplete
    2. Editing, Clearing, and Replacing Cell Contents
    3. Cutting, Copying, and Pasting Cells
    4. Moving and Copying Cells with Drag and Drop
    5. Collecting and Pasting Multiple Items
    6. Using the Paste Special Command
    7. Inserting and Deleting Cells, Rows, and Columns
    8. Using Undo, Redo, and Repeat
    9. Checking Your Spelling
    10. Finding and Replacing Information
    11. Inserting Cell Comments


Formulas

    1. Creating a basic Formula
    2. Calculating Value Totals with AutoSum
    3. Editing & Copying Formulas
    4. Fixing Errors in Your Formulas
    5. Formulas with Several Operators and Cell Ranges


Working with the Forms Menu

    1. Sorting, Subtotalling & Filtering Data
    2. Copy & Paste Filtered Records
    3. Using Data Validation


Creating & Working with Charts

    1. Creating a Chart
    2. Moving and Resizing a Chart
    3. Formatting and Editing Objects in a Chart
    4. Changing a Chart’s Source Data
    5. Changing a Chart Type and Working with Pie Charts
    6. Adding Titles, Gridlines, and a Data Table
    7. Formatting a Data Series and Chart Axis
    8. Annotating a Chart
    9. Working with 3-D Charts
    10. Selecting and Saving a Custom Chart
    11. Using Fill Effects
    12. Mapping Data
    13. Modifying a Map


Data Analysis & Pivot Tables

    1. Creating a PivotTable
    2. Specifying the Data a PivotTable Analyzes
    3. Changing a PivotTable’s Calculation
    4. Selecting What Appears in a PivotTable
    5. Grouping Dates in a PivotTable
    6. Updating a PivotTable
    7. Formatting and Charting a PivotTable


Working with Other Programs

    1. Inserting an Excel Worksheet into a Word Document
    2. Modifying an Inserted Excel Worksheet
    3. Inserting a Linked Excel Chart in a Word Document
    4. Inserting a Graphic into a Worksheet


Takeaway

    1. High quality training from industry experts
    2. Practical exercises to supplement theoretical learning
    3. Learn advanced mathematical formulas and use them for statistical analysis
    4. Manage and share workbooks in Excel
    5. Learn to use Forms
    6. Learn to Format a Data Series and Chart Axis
    7. Use Pivot Charts for professional representation of data
    8. Create and manage PivotTables in Excel


Prerequisite

      Candidate should bring their Laptop with MS-Excel installed.(preferred 2013)


Who can attend?

  1. Business Analysts
  2. Pricing Analysts
  3. Marketing Professionals
  4. Management Executive
  5. MIS
  6. Finance
  7. HR
  8. Sales
  9. Students
  10. Professionals who use Microsoft Excel to perform daily activities

Venue Map