For More Detail Contact Us

Phone: +919460573900

Phone: +918949921445

Phone: +919460576431


Live Classes

Why to Choose Live Advanced MS Excel Course?

Tally Prime Course

Qualified Teachers & Hand- holding Guidance

Tally Prime Course

Valid Certification after Course Completion

Tally Prime Course

Career-oriented Syllabus

Tally Prime Course

Professional Guidance

Tally Prime Course

Regular Test Excersices

Tally Prime Course

ISO 9001-2015 Certified Institution

Who can Take This Course

Tally Prime Course


Tally Prime Course

Working Professionals

Tally Prime Course


Tally Prime Course


What You'll Learn in This Course

  • Microsoft Excel Fundamentals
    • Launching Excel
    • Microsoft Excel Startup Screen
    • Introduction to the Excel Interface
    • Common Excel Shortcut Keys
  • Entering and Editing Text and Formulas
    • Entering Text to Create Spreadsheet Titles
    • Working with Numeric Data in Excel
    • Working with Cell References
    • Relative Versus Absolute Cell References in Formulas
  • Working with Basic Excel Functions
    • The structure of an Excel Function
    • Working with the SUM() Function
    • Working with the MIN() and MAX() Functions
    • Adjacent Cells Error in Excel Calculations
    • Using the AutoSum Command
    • Using the AutoFill Command to Copy Formulas
  • Formatting Data in an Excel Worksheet
    • Working with Font Formatting Commands
    • Formatting Data as Currency Values
    • Using Excel's Format Painter
    • Merging and Centering Cells
    • Using Conditional Formatting
    • Editing Excel Conditional Formatting
  • Inserting Images and Shapes into an Excel Worksheet
    • Inserting Images
    • Inserting Excel Shapes
    • Formatting Excel Shapes
    • Working with Excel SmartArt
  • Creating Basic Charts in Excel
    • Creating Basic Charts in Excel
    • Working with the Excel Chart Ribbon
    • Adding and Modifying Data on an Excel Chart
    • Working with Excel Pie Charts
  • Printing an Excel Worksheet
    • Viewing your Document in Print Preview
    • Changing the Margins, Scaling and Orientation
    • Adding Header and Footer Content
    • Printing a Specific Range of Cells
  • Working with Excel Templates
    • Intro to Excel Templates
    • Opening an Existing Template
    • Creating a Custom Template
  • Working with an Excel List
    • Understanding Excel List Structure
    • Sorting a List Using Single & Multi-Level Sorts
    • Using Custom Sorts in an Excel List
  • Excel List Functions
    • Introduction to Function
    • Excel DSUM Function with Single,OR, AND Criteria
    • Other Functions like - DAVERAGE(), DCOUNT(), SUBTOTAL() etc.
  • Excel Data Validation
    • Creating an Excel Data Validation List
    • Adding a Custom Excel Data Validation Error
    • Dynamic Formulas by Using Excel Data Validation Techniques
  • Importing and Exporting Data
    • Importing Data Into Microsoft Excel
    • Importing Data from Text Files
    • Exporting Data to a Text File
  • Excel PivotTables
    • Understanding Excel PivotTables
    • Creating,Formatting an Excel PivotTable
    • Creating PivotCharts
    • Filtering PivotTable Data with the Slicer Tool
  • Working with Excel's PowerPivot Tools
    • Introduction to Excel Power Pivot
    • Activating the Excel PowerPivot AddIn
    • Creating Data Models with PowerPivot
    • Creating PivotTables based on Data Models
  • Working with Large Sets of Excel Data
    • Using the Freeze Panes Tool
    • Grouping Data (Columns and/or Rows)
    • Consolidating Data from Multiple Worksheets
    • Linking Worksheets (3D Formulas)
  • Working with Large Sets of Excel Data
    • Using the Freeze Panes Tool
    • Grouping Data (Columns and/or Rows)
    • Consolidating Data from Multiple Worksheets
    • Linking Worksheets (3D Formulas)
  • Working with Excel's Conditional Functions
    • Working with Excel Name Ranges
    • Advantages and Disadvantages of Excel Name Ranges
    • Using Excel's IF() Function
    • Nesting Functions with Excel
  • Working with Excel's Lookup Functions
    • Microsoft Excel VLOOKUP() Function
    • Microsoft Excel HLOOKUP() Function
    • Microsoft Excel INDEX(), MATCH() Function
    • Creating a Dynamic HLOOKUP() with the MATCH() Function
  • Working with Excel's Text Based Functions
    • Using Excel's LEFT(), RIGHT() and MID() Functions
    • Using Excel's CONCATENATE() Function
    • Using Excel's LEN() Function
  • Protecting Excel Worksheets and Workbooks
    • Protecting Specific Cells in a Worksheet
    • Protecting the Structure of a Workbook
    • Adding a Workbook Password
  • Auditing an Excel Worksheet
    • Tracing Precedents in Excel Formulas
    • Tracing Dependents in Excel Formulas
    • Working with the Watch Window

Frequently asked Questions

The ideal duration of Advanced MS Excel Course is 1 month Still it depends on the learning ability of the learner.

After attending 1 day demo class you will have to deposit full fee of course.

Your Advanced Excel Online Course Instructor is Ms. Rekha Ma’am who has taught more than 2000 students in her offline & online classes, she is also certified by Microsoft & Tally. She also possesses a badge of Microsoft for her excellence in MS Excel. Rekha Ma’am has also been appreciated by Success Gyan, Digisakshan & Guinness World Records.

Yes, you will get a free trial/demo class then you may decide to proceed further.

Yes, definitely, you will receive a free digital certificate after the successful completion of the course by TILS Education, if you want to get the hard copy of the certificate then you will have to pay courier charges extra for the same. TILS Education is an ISO 9001:2015 certified institute & it is known for its excellence that is the reason TILS Education has been featured by news channels like ZEE5, ANI NEWS, JIO NEWS, Your Story, Startup Times, Entrepreneur View, Lokmat Times etc.

Per class duration is going to be 40 Minutes & it can get extended as per the requirement from trainer & students sides.

No you don’t need any knowledge, Instructor will teach you from scratch. If you have good knowledge of basic computer then it becomes easy for the instructor to teach you directly the MS Excel Software which may make your course take faster than usual.

Yes, It is a must to have a Laptop or PC, then only you will be able to practice while learning the things from the trainer in ONLINE mode.