Advanced Excel Training in Chennai

Get Trained from Microsoft Certified Trainers

Excel Prodigy is one of the Leading Excel Training Company in India. We provide Advanced Excel Training in Chennai for Corporate and Working professionals. Our training courses will show you how to use Excel better, faster and more efficiently. You will learn how to save time, access new features and work with confidence.We provide a dynamic learning environment with lots of practical hands on exercise with real world examples. Our instructors are knowledgeable, experienced and patient computer training professionals with both Industry Expert and Microsoft Certified.

“Every trained individual from Excel Prodigy is an expertise in MS Excel and can proudly exhibit their Excel skills for their career growth.”

Apart from Advanced Excel Training, we also conduction Corporate In-house Training on Power BI, Tableau, VBA Macro & PowerPoint.

Request Callback

Advanced Excel Training Course Outline:
  • Intro Excel 2019
  • Auto Fill, Custom List & Fill Series
  • AutoComplete Option
  • Different methods of selecting Range
  • Useful Shortcuts
  • Special Formats – Numbers & Dates
  • Different File Format (XLS, XLSX, XLSM)
  • Insert, Delete & Rename Sheets
  • Copy and Move Sheets
  • Worksheet Groups
  • Using the Clipboard Group
  • Using Paste Special
  • Problems using Relative References
  • Using Absolute References
  • Using Mixed Reference
  • Basic IF statement
  • Nested IF statements
  • Combining IF with AND, OR, NOT
  • IFERROR & ISNA Function
  • UPPER(), LOWER(), PROPER()
  • LEFT(), RIGHT(), MID(); LEN()
  • TRIM(), SUBSTITUTE()
  • Join Cells using & (ampersand), CONCATENATE()
  • Create & modify charts
  • Different Chart Types
  • Adding data to existing chart
  • Combo Chart – Columns & Line
  • Secondary Axis Chart
  • Highlight & Remove Duplicate
  • Compare Reports
  • Converting Text to Number/Date
  • Find & Replace
  • Go To (Special) Options
  • Slicer
  • Spark Lines
  • VLOOKUP – Exact Match
  • VLOOKUP – Approximate Match
  • HLOOKUP
  • Nested VLOOKUP
  • VLookup & Match
  • Index & Match
  • VLookup & Indirect
  • COUNT(), COUNTA(), COUNTBLANK()
  • COUNTIF(), SUMIF(), AVERAGEIF()
  • COUNTIFS(), SUMIFS(), AVERAGEIFS()
  • PivotTable layout
  • Rearranging data
  • Filtering a report
  • Adding fields
  • Field settings
  • Refreshing data
  • Formatting a PivotTable
  • Showing detail
  • Create a calculated field
  • Advanced data field settings
  • Creating a PivotChart
  • Creating PivotChart Reports from scratch
  • Adding fields to a PivotChart
  • Custom & Multiple Sort
  • Subtotals
  • Advanced Filtering
  • Create automatic Subtotals
  • Text to Columns
  • Use the Group and Outline feature
  • Cell Rules
  • Top-Bottom Rules
  • Data bars, Gradient fills, Icon sets
  • Managing multiple conditional formata
  • Limiting the range of values
  • Drop down lists
  • Error alerts
  • Goal Seek
  • Data Table
  • Scenario Manager
  • Tracing precedent & dependants
  • Display/Hide formulas
  • Error Checking
  • Evaluate Formulas
  • Fixing Formulas Errors
  • Protecting cells/Range
  • Hide Formulas
  • Protecting Worksheet
  • Protecting Workbook

Why to Prefer us for Advanced Excel Training in Chennai?

Why Us

Our Achievements:

0 +
Average Feedback
0 +
Corporate Clients
0 +
Corporate Trainings
0 +
Professionals Trained

Few of our Corporate Clients:

Our Corporate Clients

Few Excel Corporate Training Testimonials:

“Trainer has extensive knowledge of the subject. Seems he has done lot of hard work coupled with R&D, As a participant I am really happy that I have I am privileged to attend this training.”
–Vijendar, L&T IDPL (Attended our Advanced Excel Training in Chennai)

“The training has helped me learn some amazing ‘tricks’ in Excel and Yousuf’s inexhaustible patience makes one interact with him ease, clearing any number of doubts, silly or big. The training definitely makes you more resourceful while working with reports and analysis.”
-ALEKHYA BOYALLA, PWC (Attended our Advanced Excel Program Chennai)

“Overall its a good program to enhance the excel skills which are very helpful to the daily activities by reducing the time spent and increasing the quality of the results.”
-Krishnakumari, Agilysys (Attended our Corporate Excel Training in Chennai)

“Yousuf’s design of the program and his hands on training approach were excellent. Even though our employees were reasonably well versed with Excel, they could pick up a lot of nuances. He provided good examples and explanations for all questions. Yousuf was extremely patient and ensured that the understanding was complete with all trainees before moving on to the next subject. For a change attending a training programme was also fun. I would strongly recommend this training for all levels.”
–Sreedhar Subramanian, Chief Financial Officer, ST-CMS Electric Company (Attended our Excel Corporate Training in Chennai)

“The trainer is knowledgeable. He has extensive experience. He taught all the nuances of Excel very patiently. I recommend this program for all the employees. I have been enriched by this training program. I am keen to apply the new acquired skill in work.”
-R. Dilip Kumar, Sr. GM Finance, Sundram Fasteners Limited (SFL) (Attended our Advanced Excel Course in Chennai)

Why Advanced Excel Training in Chennai:

Excel is the easiest and best way to do many tasks like create budget and record Expenses, build databases and do analysis in a work environment. Also, Excel has many Applications in which is why the basic and advanced excel courses are so popular in cities like Mumbai which is said to be financial city.

Our advanced excel training for many Individual participants have made them more employable and our training courses structure are in depth and address the most common mistake made by the individuals in day to day activity. Based on that, we have development the course flow and it will be most relevant to their work culture. Our trainers will initially understand the participants knowledge & their requirements to customize all the corporate training conducted.

​how can we help you?

Drop Email For Corporate Training Across India & International or Call

+91 893989 8008