Microsoft Excel Training in Chennai:

Learn the concepts of Microsoft Excel Training in chennai location  from the best microsoft excel training institute from beginner level to advanced level taught by experienced and talented working professionals. End of the training you will learn the concepts in expert level in practical manner. Microsoft developed the application Excel for storing and managing the data in the form of spread sheet. Using different functions and options in excel we can be able to analyse the data.

There are high end options available in Excel that helps in analysing the data, creating presentable dashboards that assist you in taking decisions. We can also keep the data with password protection or allows editing for targeted audience. We provide excellent training to our students who have great passion towards learning excel. Our trainers provide coaching like nook and corner about the application in order to cope up with the organization needs and requirements. Our trainers are experienced and are working professionals with real time experience. We provide the option of customization in syllabus based upon the request and needs. Job opportunity in excel sector is always on rise. There is always a bright option for those who master in excel and is a high demand for professionals for MIS operation that deals with analysis of data. We hold the No. 1 Microsoft Excel training institute in Chennai for the professionally crafted syllabus from industry work professional guidance. Thus we provide best Microsoft Excel training in Chennai branches Velachery, OMR and in Tambaram.

We are the best Microsoft Excel training institute in Chennai and we hold the pride of placing more than 1500+ students in top MNC’s. On completion of course we provide certification offered by Microsoft for every module of MS-office suite.

MicroSoft Excel Training Syllabus

Basic Topics

  • Introduction to Excel
  • Improvements in Excel from 2003 to latest version
  • What’s new in latest versions
  • Excel Options
  • Commands/Shortcuts in Excel
  • Charts
  • Tables
  • Pivot tables
  • Protection of cells, Sheets, Workbooks
  • Data Import, Export
  • Cell Referencing In Excel
  • Relative Referencing
  • Absolute Referencing
  • Difference Between Relative & Absolute Cell Referencing

Advanced Topics

  • Dashboards in Excel and many more
  • Lookup Functions
  • Logical Functions
  • Statistical Functions
  • Text Functions
  • Date and Time Functions
  • Flash Fill
  • Spark Lines
  • Hyperlink
  • What if Analysis
  • Nesting of functions
  • Creating add-ins
  • Creating Workbooks, Worksheets, and Data
  • Saving and Printing Data
  • Formatting Cells and Worksheets
  • Formatting Data
  • Presenting Data using Conditional Formatting
  • Performing Calculations Using Functions
  • Data Search, Data Validation
  • Creating and Customizing Visual Elements
  • Customizing Options and Views
  • Manipulating Data
  • Advanced Conditional Formatting
  • Linking In Excel Across Sheets/Workbooks
  • Data Connections to multiple Sources
  • Referencing Working with Options and Macros
  • 3D Reference
  • Working With 2D and 3D Charts
  • Pivot Tables with Advance Features
  • Creating Pivot Table Using Wizard / Layouts
  • Formatting Pivot Table With Auto Formats and
  • Creating Pivot Charts by using Source data
  • Modifying The Pivot Charts
  • Creating a Pivot Table Report
  • Slicers and its usages
  • Sorting with Multi Levels by using Clauses
  • Adding Form Wizards
  • Data Validation with Advance Options
  • Subtotals with Multi level Grouping Levels
  • Filtering by using Auto and Advanced Filters
  • Filtering by using Multiple Criteria Levels
  • Filtering and Sorting by Color Levels
  • Customization of toolbar and Quick Access Tool Bars
  • Auditing Excel Sheet
  • Working and editing with Hyperlinks