Advanced Excel Training

fa icon group 550+

star

doc 10+

clock 60 Hrs

Learn Advanced excel training in Chennai at Credo Systemz to understand the powerful spreadsheet application which is developed by Microsoft.

Our Advanced Excel training is framed to cover all the advanced features of excel application which help to enhance and improve your analyzing and reporting skills.

Our Advanced Excel training topics suits for the candidate who has a basic knowledge of Microsoft Excel.

Key Features

logo

Training from
Industrial Experts

logo

24 x 7
Expert Support

logo

Hands on
Practicals/ Projects

logo

Certification
of Completion

logo

100% Placement
Assistance

logo

Free
Live Demo

ADVANCED EXCEL TRAINING COURSE CONTENT

EMPTY

Course Features

  • Duration60 hours
  • Skill levelAll level
  • Batch Strength15
  • AssessmentsYes
  • Mock InterviewsYes
  • Resume BuildingYes
  • PlacementsYes
  • Flexible TimingYes
  • Fee InstallmentsYes
  • LanguageTamil/English
Section 1: Formatting
  • Freeze Titles
  • Conditional Formatting
  • Autoformat
  • Paste Special
Section 2: Protection
  • Protection
  • Worksheet And Cell Protection
  • Hiding Rows And Columns
  • Workbook Protection
  • Hiding Worksheets & Workbooks
Section 3: Cell Comments
  • Cell Comments
  • Display Comments
  • Create, Edit & Delete Comments
Section 4: Names
  • Names
  • Using Names In Formulas
  • Using To With Names
Section 5: Templates
  • Creating A Template
  • Using A Template
  • Editing A Template
  • Deleting A Template
Section 6: Formulas
  • Display Formulas
  • Formulas That Produce Errors
  • Custom Number Formats
Section 7: Scenarios
  • Creating Scenarios
  • Using And Editing Scenarios
  • Scenario Summary Report
Section 8: Linking
  • Linking
  • Creating Links
  • Linking Between Workbooks
  • Linking To A Word Document
Section 9: Sorting
  • Sorting
  • Multiple Column Sorts
  • Custom Sorts
Section 10: Lists
  • Lists
  • Creating A List
  • Filtering Lists
  • Autofilter
  • Custom Autofilter
  • Advanced Filtering
  • Extracting Filtered Data
  • Adding Subtotals
Section 11: Pivot Tables
  • Pivot Tables
  • Grouping Data In Pivot Tables
Section 12: Functions
  • Functions
  • Logical Functions
  • Date And Time Functions
  • Lookup Functions
  • Maths And Statistical Functions
  • Text Functions
  • Financial Functions
  • Database Functions
  • Nested Functions
Section 13: Charts
  • Formatting Chartsmodifying Charts
  • Insert Image In 2d Chart
Section 14: Data Tables
  • One Input Data Table
  • Two Input Data Table
Section 15: Macros
  • Macros
  • Recording Macro
  • Running A Macro
  • Assigning A Macro To A Toolbar Button
Section 16: Auditing
  • Auditing
  • Trace Precedents
  • Trace Dependents
  • Tracing Errors
Section 17: Importing Data
  • Import Delimited Text

You will be going through detailed 2 to 3 months of Excel Hands-on training

  • Detailed instructor led sessions to help you become a proficient Expert in Excel.
  • Build a Excel professional portfolio by working on hands on assignments and projects.
  • Personalised mentorship from professionals working in leading companies.
  • Lifetime access to downloadable Excel course materials, interview questions and project resources.
Valchery pic

Credo Systemz - Velachery, Chennai
Call Us +91 9884412301

Omr

Credo Systemz - OMR, Chennai
Call Us +91 9600112302

Check here for candidates feedback on Excel Training through

Advanced Excel Training in Chennai:

Credo Systemz provides Advanced Excel Training in Chennai Velachery as both online and classroom sessions. Our Advanced Excel course helps both beginners and working professionals in creating professional reports from complex data in the form of charts, tables, and pie charts.
Advanced Excel is one of the tool which is mostly used for a long period of time. Once you enter into the business world or in a position to analyze the data’s then it is important to learn Advanced Excel.

Related Trainings

Nearby Access Areas
Our Velachery and OMR branches are very nearby access to the below locations.
Medavakkam, Adyar, Tambaram, Adambakkam, OMR, Anna Salai, Velachery, Ambattur, Ekkattuthangal, Ashok Nagar, Poonamallee, Aminjikarai, Perambur, Anna Nagar, Kodambakkam, Besant Nagar, Purasaiwakkam, Chromepet, Teynampet, Choolaimedu, Madipakkam, Guindy, Navalur, Egmore, Triplicane, K.K. Nagar, Nandanam, Koyambedu, Valasaravakkam, Kilpauk, T.Nagar, Meenambakkam, Thiruvanmiyur, Nungambakkam, Thoraipakkam, Nanganallur, St.Thomas Mount, Mylapore, Pallikaranai, Pallavaram, Porur, Saidapet, Virugambakkam, Siruseri, Perungudi, Vadapalani, Villivakkam, West Mambalam, Sholinganallur.

Right Side icons