Microsoft Excel Training in Chennai

Learn how to use Microsoft – Excel from beginner level to advanced techniques which is taught by experienced working professionals. With our Microsoft Excel Training in Chennai you’ll learn concepts in expert level with practical manner.

Excel is an application developed by Microsoft for storing the data in the form of spread sheets, helps to analyse the data using different functions / options in Excel

Excel is facilitated with high end options to analyse the data, create a presentable dashboards that helps the management in taking the decisions. Data storage is made available with password protections or can allow editing for targeted audience

Excel opportunities are evergreen in market. Every Industry requires professionals who can analyse the data and helps in the decision making for the management. There is a huge demand for the MIS operations that deals with analysis of data.

Basic

• Introduction to Excel
• Improvements in Excel from 2003 to latest version
• What’s new in latest versions
• Excel Options
• Commands/Shortcuts in Excel
• Tables
• Charts
• 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
• 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 Optionsc
• 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

Course Duration:  2  to  3 Month, 2 hpd

Contact:  +91  9080334727

Mail:  info@velgrotechnologies.com