Advanced Excel Training in Bangalore

Get Trained from Microsoft Certified Trainers

Excel Prodigy is one of the Leading Excel Training Company in India. We provide Advanced Excel Training in Bangalore 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.”

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 Corporate Training ?

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:

“Training covered some of the aspects which are difficult to find in internet and was very useful. Some topics like Table formats and Pivot tables were dealt in detail and helped us in understanding lot more options in excel than what we could do otherwise. Overall it was nice learning process with right amount of exercises and teaching.”
–Nithin S, Price Waterhouse Coopers (Attended our Advanced Excel Training in Bangalore)

“This training was very useful to me as it was important for me to be proficient and familiar with the Excel Program. It was more informative than other usual Excel training programs that I had previously attended. Hope there are many more such similar training in the near future, so that I can update my technical skills and knowledge.”
-Kripa Thomas, PWC (Attended our Advanced Excel Program Bangalore)

“Even though I had sufficient knowledge of Excel but trainer did help me in exploring and discovering new techniques that would improve my efficiency at work and hence more accuracy.”
-Upasana Gautam, HP (Attended our Corporate Excel Training in Bangalore)

“The Training is quite a valuable one. The practice session coupled in the training is the highlight and in fact that resolved most of our practical errors that we are used to while using excel on our day to day.”
-G KalyanaRaman, PWC (Attended our Excel Corporate Training in Bangalore)

Why Advanced Excel Training in Bangalore:

Excel is one of the most ought courses in cities like Bangalore. Since Bangalore is one of the largest IT Hub, many IT firms take this Advanced Excel Course for their employees to increase their work productivity. So, Excel Prodigy teaches how to preform calculations, Manipulate, Present and Combine data in Various Ways. Also, MS Excel is one of the key tool in IT Workplace in Bangalore and an Essential skills for many job roles.

Excel Prodigy has been associated with many corporates in Bangalore for the Advanced Excel & PowerPoint Training like Hitachi, HCL, Credit Suisse, Godrej, VMWare & NetApp.

Our training methods for IT Companies like Bangalore are so customized and we give them the real time IT scenarios examples for all the Topics. Training conducted as In-House Programs and workshop in Bangalore, we make the participants to understand the Logic behind all the topics in Excel which make them to remember it when they see the data’s in future. This is one of our practice we follow in all our trainings.

Our Excel Trainings will make participants to master all their data management and reporting needs in corporate world. Also there are many small business owners and entrepreneurs in Bangalore where they maintain all their data’s in Excel, which is easier for them to maintain their marketing data’s and for accounting purpose. These companies will uses most of the Charts, Tables & Graphs options to pictorially depict their data to their clients. So, we Excel Prodigy provide them the Basic Excel & Advanced Excel training in very feasible cost to this clients.

​how can we help you?

Drop Email For Corporate Training Across India & International or Call

+91 893989 8008