twg-group-chennai

microsoft excel course in chennai | microsoft excel training in chennai | microsoft excel institute in chennai | microsoft excel training institutes in chennai | microsoft excel training and certification in chennai | microsoft excel training and coaching center in chennai | microsoft excel training center in chennai | microsoft excel in chennai

MICROSOFT EXCEL TRAINING IN CHENNAI :

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

FOR MORE DETAILS :

Cell : 93810 77677 / 76679 78887
Email : twggroupchennai@gmail.com

CONTACT ADDRESS :

CHENNAI BRANCH

no.5, boopathy street, virugambakkam,
virugambakkam - bus stop opposite chennai , tamil nadu , india.
tel: 044 - 420 77677, 044 - 430 72173
cell : 093845 77677
email : twggroupchennai@gmail.com

KOCHI BRANCH

Near LULU Shopping Mall
Edappally Toll Junction,
Opposite - Metro Bridge Piller No. 387,
V.P Marakkar Building,
V.P Marakkar Road,
Via - Vanitha and Vinitha Theatre
Edappally P.O, Kochi - Kerala
Contact :073580 27788 , 093810 48884,
Email : twggroupcochin@gmail.com ,
Email : twggroupchennai@gmail.com

MUMBAI BRANCH

crescent business square" No.810, kherani road,
opposite - sj studios sakinaka metro
junction, andheri (east) mumbai - 400 059.
cell : 093810 48884, 073580 27788, 093810 77677
email : twggroupmumbai@gmail.com
email : twggroupchennai@gmail.com

TRICHY BRANCH

sri gem plaza no.3, 4th floor,
sankaran pillai street, s.r.c.college road,
chathiram bus stand, trichy - 620 002
Tamil nadu , india.
contact : jenifer : 093845 77677, 93810 77677
contact : suganya : 093825 88890
email : twggroupchennai@gmail.com

COIMBATORE BRANCH

dheepam complex no.574 to 581, 100 feet road,
near g.p.signal, landmark: kalyan jewellery,
gandhipuram, coimbatore - 641 012 tamil nadu , india.
contact : jasmine : 093810 77677, 093845 77677,
contact : sandhiya : 093825 88890
email : twggroupchennai@gmail.com

VIZAG BRANCH

twg group vizag no. 8 - 12 - 1/1,
2nd floor, gayathri nilay, gokul nagar,
karur vysya bank back side opposite - holy cross church,
old gajuwaka junction, vishakapatnam - 530 026.
Andhra pradesh , india.
contact : 073580 27788, 093810 48884, 76692 48884.
email : twggroupchennai@gmail.com

BANGALORE BRANCH

No.54, 15th Main Road ,
2nd Floor,
East of Chord Road
Vijaya Nagar,
Opposite Vijaya Nagar Metro Station,
Bangalore - 560 040.
Karnataka, India.
Contact : 073580 27788 , 093810 77677
Email : twggroupchennai@gmail.com

HYDERABAD BRANCH

twg group hyderabad contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

DELHI BRANCH

twg group delhi contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

PUNE BRANCH

twg group pune contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

TRIVANDRUM BRANCH

twg group trivandrum contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

CALICUT BRANCH

twg group calicut contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

TRAINING COURSES