Advanced Excel Training in Hyderabad

Taught by Microsoft Certified Trainers

  • (1541)

It's a 16 hours program (4 Saturdays) covering core fundamentals of Excel to the most Advanced Level including 60+ Functions, Dashboards, Pivots, Charting, What-If Analysis, Validation, Data Protection etc.

  • Levels:
  • Basic, Intermediate, Advanced
  • Course Duration:
  • 16 Hours (4 Saturdays)
  • Mode of Training:
  • Classroom, Instructor-Led

Our 5 Steps Learning Process

Excel Learning Redefined.


LEARN from Microsoft Certified Trainers


PRACTICE with 50+ Assignments


REVISE with 350+ Video lessons


SPEED-UP with our Excel Shortcut Tool


ON-JOB Support to implement learnings

What's included in your training?

  1. Pre-Course Assessment
  2. Hands-On Instructor Led Training
  3. 50+ Assignments and Real-time exercises
  4. 30 Days Post Training Support (On Job)
  5. Free Study material (Online Excel Help) for 30 Days

What will you be able to do post-training?

  1. Have high comfort working with Excel leading to quick turnaround time
  2. Use right formulas for the given scenario
  3. Write Complex Formulae with ease
  4. Handle Excel related situations more maturely
  5. Present Data with better interpretation

Course Content - Overview

  1. A overview of the screen, navigation and basic spreadsheet concepts
  2. Understanding workbooks, worksheets, rows, columns, cells
  3. Various selection techniques
  1. Entering, Editing and Deleting Text, Numbers, Dates
  2. Using Auto Lists
  3. Moving and Copying data
  4. Inserting, Deleting and Hiding Rows & Columns
  5. Inserting, Deleting, Moving and Copying Sheets
  6. Using navigation techniques
Customizing Excel
  1. Customizing the Ribbon
  2. Customizing the Quick Access Toolbar
  3. Using and Customizing AutoCorrect
  4. Changing Excel’s Default Options
  5. Creating a Custom AutoFill List
  6. Creating a Custom Number Format
  7. Customizing Excel Review
Managing and Navigating large Workbooks
  1. Using Workbook Views
  2. Selecting and Switching Between Worksheets
  3. Splitting and Freezing a Window
  4. Creating Headers and Footers
  5. Hiding Rows, Columns, Worksheets, and Windows
  6. Working with Multiple Workbook Windows
  7. Creating a Template
  8. Managing Workbooks Review
Creating and Editing Formulae
  1. Concept of Formulae
  2. Creating Formulae, Editing Formulae
  3. Bodmas : Mathematical Order
  4. Copying Formulae
  5. Using Functions - Sum, Average, Max,Min, Count, Counta
  6. Applying Absolute (Fixed) Referencing
Referencing Techniques
  1. Relative Reference
  2. Absolute Reference
  3. Mixed Reference
  4. Moving Range Reference
Formatting and Proofing
  1. Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
  2. Basic conditional formatting
  3. Copying and Clearing Formats
  4. Working with Styles
  5. Spell Check, Find & Replace and AutoCorrect
  1. SumIf, SumIfs
  2. CountIf, CountIfs
  3. AverageIf, AverageIfs
  4. SumProduct, Subtotal
  1. Vlookup / HLookup
  2. Match
  3. Dynamic Two Way Lookup
  4. Creating Smooth User Interface Using Lookup
  5. Offset
  6. Index
  7. Dynamic Worksheet linking using Indirect
  1. Nested If ( And Conditions , Or Conditions )
  2. Alternative Solutions for Complex IF Conditions to make work simple
  3. And, Or, Not
  1. Upper, Lower, Proper
  2. Left, Mid, Right
  3. Trim, Len
  4. Concatenate
  5. Find, Substitute
  1. Today, Now
  2. Day, Month, Year
  3. Date, DateDif, DateAdd
  4. EOMonth, Weekday
  1. Round
  2. RoundUp
  3. RoundDown
  4. MRound
  1. isNa
  2. isErr
  3. isError
  1. Paste Formulas
  2. Paste Formats
  3. Paste Validations
  4. Paste Conditional Formats
  5. Add / Subtract / Multiply / Divide
  6. Merging Data using Skip Blanks
  7. Transpose Tables
  1. Sorting on Multiple Fields
  2. Dynamic Sorting of Fields
  3. Bring Back to Ground Zero after Multiple Sorts
  1. Filtering on Text, Numbers & Date
  2. Filtering on Colors
  3. Copy Paste while filter is on
  4. Advanced Filters
  5. Custom AutoFilter
  1. Working with Themes
  2. Setting Up Print Area
  3. Printing Selection
  4. Branding with Backgrounds
  5. Adding Print Titles
  6. Fitting the print on to a specific defined size
  7. Customizing Headers & Footers
  1. From Web Page
  2. Exporting to XML
  3. Creating Dynamic Dashboards and Reports Using Data on Other Applications
  4. Using Text To Columns
  1. Goal Seek
  2. Scenario Analysis
  3. Data Tables
  1. Number, Date & Time Validation
  2. Text Validation
  3. List Validation
  4. Handling Invalid Inputs
  5. Dynamic Dropdown List Creation using Data Validation
  1. File Level Protection
  2. Workbook Level Protection
  3. Sheet & Cell Level Protection
  4. Setting Permissions for Specific Tasks
  5. Track changes
  1. Consolidating data with identical layouts
  2. Consolidating data with different layouts
  3. Consolidating data with different Sheets
  1. Creating Basic Conditional Formats
  2. Managing Conditions Created
  3. Dynamic Formatting using Formulas in Conditional Formatting
  1. Creating Simple Pivot Tables
  2. Basic and Advanced Value Field Setting
  3. Sorting based on Labels and Values
  4. Filtering based on Labels and Values
  5. Grouping based on numbers and Dates
  6. Drill-Down of Data
  7. GetPivotData Function
  8. Calculated Field & Calculated Items
  1. Bar Charts / Pie Charts / Line Charts
  2. Dual Axis Charts
  3. Dynamic Charting
  4. Other Advanced Charting Techniques
  1. Bar Charts / Pie Charts / Line Charts
  2. Planning a Dashboard
  3. Adding Tables to Dashboard
  4. Adding Charts to Dashboard
  5. Adding Dynamic Contents to Dashboard

About the Trainer

Mr.Sami (MCT, MOS, MEE)

Mr. Sami, Microsoft Certified Trainer, with his qualifications in Finance and IT brings in 14 years of Industry experience. He has successfully trained 6000+ professionals by now, and the counting is still on.

He has undertaken the renowned VBA assignments with IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.


Sami, I am very happy to share my feedback about your training to me. You have been an extraordinary trainer for me for the following reasons:
  1. The Sure -ity (The conviction in which you teach is Awesome)
  2. The thorough-ness in your knowledge about the steps...   Read More

Training Schedule

Loading Schedule..

Contact Us

  • ExcelGoodies Software Private Limited
  • 6-2-984, Unit No – 404,
  • Pavani Plaza, Khairatabad Road,
  • Khairatabad, Hyderabad – 500004
  • +91 91779 37631, 040 40047975


  • 1. Excel Guru from Excelgoodies Consulting, Inc. View
  • 2. MOS from Microsoft, Inc. View Certificate

    (Microsoft Examination fees as applicable)

Connect us on

Learner stories around the world!


  • Trainer's Expertise
  • Course Structure
  • Course Content
  • Quality of Assignments
  • Certification Process

C.Jagan Mohan Rao

Senior Manager

I could see the difference in me when I joined the course just as a beginner or rather I would say the novice to the Excel and now when I am able to apply the advanced excel features at work.

I appreciate Sami for his real time and personalized approach. It was good. . God bless ...

Madhiha Khan


I am happy to be certified! Thank you, Sami, for being highly patient in teaching complex formulae. Your art of teaching is something I would always cherish for a long time...

Rajiv Manchandia

Business Analyst

As a trainer I think you have done an excellent job as you have been able to teach some of the most complex scenarios in excel is a very simple to understand way and have also provided us ways in which to refer back to what was taught if at any point in time it actually slips our mind for not using a particular formula etc...


Finance Manager

After undergoing this training, the things which I use to take 15-20 hrs, now I am able to do it in just couple of minutes. It made me to understand the importance of structuring the worksheets, organizing it and you have some wonderful analysis in your hand...

Krishna Kumari

Senior Manager

The course was well paced dealing with the practical use of Excel. Concepts were made pretty simple to understand as well as to remember. Thanx to Sami & Team Excelgoodies...