Microsoft Excel (Basic + Advance)

4 Star Rating: Very Good 4.20 out of 5 based on 246 ratings.

Croma Campus Experts designed for “Microsoft Excel (Basic+Advance)” course for Freshers/College Students/Professionals (IT & Non-IT) to cater the needs of dynamic IT companies. We also offer professional real time projects for students in their final semester.

Course completion and project completion certificates will also be provided upon successful completion of the course. We have also partnered with major MNCs & Agencies to place candidates with our clients.

Key Features of Microsoft Excel (Basic + Advance) Training are:

  • Design POC (Proof of Concept): This process is used to ensure the feasibility of the client application.
  • Video Recording of every session will be provided to candidates.
  • Live Project Based Training.
  • Job-Oriented Course Curriculum.
  • Course Curriculum is approved by Hiring Professionals of our client.
  • Post Training Support  will helps the associate to implement the knowledge on client Projects.
  • Certification Based Training are designed by Certified Professionals from the relevant industries focusing on the needs of the market & certification requirement.
  • Interview calls till placement.

Ms Excel Basic

Presenting & Managing Data Effectively Using Ms-Excel

  • Creation of Excel Sheet Data
  • Range Name, Format Painter
  • Conditional Formatting, Wrap Text, Merge & Centre
  • Sort, Filter, Advance Filter
  • Different type of Chart Creations
  • Auditing, (Trace Precedents, Trace Dependents)Print Area
  • Data Validations, Consolidate, Subtotal
  • What if Analysis (Data Table, Goal Seek, Scenario)
  • Solver, Freeze Panes
  • Various Simple Functions in Excel(Sum, Average, Max, Min)
  • Real Life Assignment work

Ms Excel Advance


  • Multi-level sorting
  • Restoring data to original order after performing sorting
  • Sort by icons
  • Sort by colours

Lookup Functions

  • Lookup
  • VLookup
  • HLookup

Subtotal, Multi-Level Subtotal

Grouping Features

  • Column Wise
  • Row Wise

Consolidation With Several Worksheets


  • Auto Filter
  • Advance Filter

Printing of Raw & Column Heading on Each Page

Workbook Protection and Worksheet Protection

Specified Range Protection in Worksheet

Excel Data Analysis

  • Goal Seek
  • Scenario Manager
  • Data Table

Advance use of Data Tables in Excel

Reporting and Information Representation

  • Pivot Table
  • Pivot Chat
  • Slicer with Pivot Table & Chartwith Pivot Table & Chart

Generating MIS Report In Excel

Advance Functions of EXCEL

  • Math & Trig Functions
  • Text Functions
  • Lookup & Reference Function
  • Logical Functions & Date and Time Functions

MIS Reporting& Dash Board

  • Inventory Statement
  • Payroll Report
  • Salary Slip
  • Loan Assumption Sheet
  • Invoice Creation


Please write to us at for the course price, schedule & location.

Enquire Now

Frequently Asked Questions:


All training courses offered by us are through IT Professional with 10+ years of experience. Freshers/College Students/Professionals(IT & Non-IT) can spot the quality of training by attending one lecture. Hence, we provide one free demo class to all our trainees so that they can judge on their own.


No, you don’t have to pay anything to attend the demo class. You are required to pay the training fee after free demo only if you are fully satisfied and want to continue the training.


To register for free demo, visit our campus or call our counsellors on the numbers given on contact us page.


Yes, all the trainees shall work on live projects provided by Croma Campus after completing their training part.


You will never lose any lecture. You can choose either of the two options:
View the recorded session of the class available in your LMS.
You can attend the missed session, in any other live batch.

Please note, access to the course material will be available for lifetime once you have enrolled into the course.


Yes, Training certificate & Project completion will be issued by Croma Campus(ISO 9001-2000 Certified Training Center)


Yes, Croma Campus conduct special training programs on week end for college students throughout the year.


Croma Campus is the largest education company and lots of recruitment firms contacts us for our students profiles from time to time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don’t guarantee any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.


Yes, Course Fee can be paid in two equal installments with prior Approval.


Yes, Croma Campus offer various group or special discounts.


No, Lab is open from 8 A.M. to 8 P.M. seven days a week. This time can be extended upto 11 PM if need arises.


Yes, students can take breaks during their exams and can resume it later without paying any fee. Apart from this, Students can attend batches for revision even after completion of their courses.


Batch strength differ from technology to technology. Minimum batch strength at Croma Campus is 10 and maximum batch strength is 30.

Drop us a query

Our Valued Partners