Excel Training in Chennai

Excel Basic, Intermediate and Advanced Level Training in Chennai

Basic & Intermediate Option & Formulas

You will get Free access to our eLearning modules Includes 42 Session with practice material for each modules.

More Info

This session includes Microsoft Excel Basic and Intermediate Options and Functions. It covers Microsoft Excel Overview, Menus, Keyboard Shortcuts, Managing Workbooks, Worksheets, Cells, Formatting Cells, Printing, Copy, Paste, PasteSpecial, Basic and Intermediate level formulas etc.

Advanced Excel Options

You will get Free access to our eLearning modules Includes 33 Session with practice material for each modules.

More Info

This session includes Microsoft Excel Advanced level Options. It covers how to create Dashboard, Fitler, Advanced Filter, Complete PivotTable, Power Query, Record Macro, Charts, Subtotal, Text to Column, Name Manager, Data Validation, Grouping and Ungrouping, Goal seek etc.

Advanced Excel Formulas

You will get Free access to our eLearning modules Includes 28 Session with practice material for each modules.

More Info

This session includes Microsoft Excel Advanced Formulas. It covers how to work with different types of VLOOKUP, Various use of XLOOKUP, FILTER, IF, Nested IF, INDEX MATCH, Integrate multiple formulas, Multi criteria lookup, how to use Advanced Function with Advanced Options etc.

Excel Training in Chennai – Become an Excel Expert and increase your career potential

We provide Excel Training in Chennai from basic to advanced level with certification. Microsoft Excel has proven to be one of the most important applications for businesses around the world. Excel is the most widely used application in business today, but very few people maximize its potential.

Explore most of the underutilized powerful features in Excel which helps to boost your productivity, improve your speed, save time, eliminate manual and non-value added activities in your day to day process.

In our Excel Training in Chennai we teach Excel Basic, Intermediate and Advanced and Advanced+ Level. The syllabus covers all the required Formulas and Options used by working professionals who has 15+ years of experience, worked in various projects, companies and faced different challenges in their day to day process.

Our session will not just stop with teaching you the Excel Formulas and options, we go beyond to make you an expert in using the various options in real time scenario.

Our Excel Advanced Pro formulas have lot of surprise elements which you have never seen it before also it will make you to feel the power of Excel.

Why we should learn Microsoft Excel?

N

Excel will make you better at your job

N

Create Dashboard for better decision making

N

Makes calculations of complex formulas easy

N

Eliminate manual work through Automating reports

N

Save 1000+ hours through Automating reports

N

Improve your Company productivity

N

It will increase your Salary

N

Sell yourself in the competitive Industries

N

Analyze data and make forecasting predictions

N

Gain practical experience with large spreadsheets

Syllabus – Microsoft Excel Training in Chennai (Basic, Intermediate and Advanced Level)

Excel Basic and Intermediate Options
  • Microsoft Excel Overview
  • Excel Menu Overview
  • Excel Shortcut Key which covers most of the Excel Basic options (Direct, Indirect and Quick Access Shortcut)
  • Various Selection techniques
  • Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
  • Methods to Move, Copy & Paste data
  • Paste Special Options
  • Go To Options
  • Various Navigation techniques
  • Various Printing Technique like Page break preview, Headers and footers, Freezing print titles & Data Alignments
  • Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colors
  • Uses Conditional Formatting
  • Auditing features and Tracing Formula errors
  • Using Freeze Panes
  • Worksheets and Workbooks Calculation method
  • Comments and Note Options
  • Insert Shapes, Art, Smart Art, 3D Art, Screenshot
  • Window Features
  • Methods to Move and Copy, Hide, Unhide, Color sheets
  • Uses of Hyperlinks and Define Name
  • Absolute Cell References
Excel Basic and Intermediate Formulas

SUM, SUBTOTAL, ADDRESS, AVERAGE, COLUMN, COLUMNS, ROW, ROWS, CONCAT, COUNT, COUNTA, COUNTBLANK, EXACT, HYPERLINK, ISBLANK, RIGHT, LEFT, MID, LEN, LOWER, UPPER, PROPER, MAX, MIN, LARGE, SMALL, DATE, DAY, MONTH, NOW, YEAR, FIND, SEARCH, REPLACE, ROUND, SUBSTITUTE, TEXT, VALUE, ISTEXT, ISNONTEXT, ISNA, ISERROR, IFERROR, UNIQUE, TEXTJOIN, TODAY, TRIM, INDIRECT, DATEDIF, NETWORKDAYS, WEEKNUM, WEEKDAYS, NETWORKDAYS.INTL, WEEKDAYS.INTL.

Excel Advanced Formulas

XLOOKUP, VLOOKUP, ADVANCED VLOOKUP, HLOOKUP, FILTER, SORT, SORYBY, SUMIF, SUMIFS, CHOOSE, OFFSET, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, IF, NESTED IF, IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, OR, AND, INDEX, MATCH, INDIRECT.

Our Excel Advanced Pro formulas have lot of surprise elements which you have never seen it before also it will make you to feel the power of Excel.

The sessions will include:

  • Introducing the above mentioned formulas
  • Different types of VLOOKUP
  • Multi criteria lookup
  • Various types of XLOOKUP
  • How to use advanced formulas with advanced options
  • How to use two or more advanced formulas together
  • Various use of OFFSET function
  • How to use/apply the excel formulae in various situations
  • How to combine two or more excel formulae to get desired results
  • How to combine the formulae with IF Condition
  • When should use the “IF” Conditions?
  • Creation of Multiple IF Conditions in One Cell
  • Use the IF Conditions with the Other Advance Functions
  • How to use nested IF statements in Excel with AND, OR Functions
Excel Advanced Options
  • Various Methods and Options of Pivot Table (End to End – Pivot Table Options)
  • Various Methods of Filter and Advance Filter options
  • Creating and Updating Subtotals
  • Various Methods of Text to Column options
  • Uses of Data Grouping & Ungrouping and Consolidation options
  • Uses of Goal Seek and Scenarios Manager
  • Various Method of Sorting Data
  • Creating, Formatting and Modifying Chart
  • Data Validation, creating drop down lists using different data sources
  • Linking Workbooks and Uses of Edit Link options
  • Formula Auditing features and Trace formula error
  • Uses of Name Manager
  • Various way to Protect and Share Workbook, Worksheet and Cell ranges
  • How to use Record Macro
  • Various way to use Conditional Formatting
  • Data Import from Access and Web
  • Various way to use Power Query
  • Various way How to use Power Pivot
Excel PivotTable

 

  1. PivotTable Basic
  2. PivotTable Options, Grouping, Expand and Collapse
  3. PivotTable Slicer
  4. PivotTable Refresh, Change Source, Action and Calculation
  5. PivotTable Chart and Dashboard
  6. PivotTable Options
  7. PivotTable Other options
  8. PivotTable Dashboard Using Slicer New

Sign Up Today - 100% Satisfaction Guaranteed

Excel Training in Chennai

Lifetime Free

Affordable Price

Free Training Materials with Solutions

Free Practice Material

Certification Post Assessment

 

Enquiry - Excel Training in Chennai
Excel Training in Chennai | XL Pedia
%Advanced Excel Training%

We provide Excel Training in Chennai from Basic to Advanced Pro Level with certification. Explore most of the underutilized powerful features in Excel which helps to boost your productivity, improve your speed, save time, eliminate manual and non-value added activities in your day to day process.

Course Provider: Organization

Course Provider Name: XL Pedia

Course Provider URL: https://xlpedia.com/

Editor's Rating:
5