Certificate in Advanced MS Excel 2010

Make powerful dashboards, analyze data like a professional and bring efficiency in your day to day work life.

  • 90+ hours
  • 8661 Learners
  • Expert
  • 24x7 Online LMS

Select Batch

Array ( [0] => 12 )
  • Sat, 12/17/2016

Quick Stats

MS Excel still reigns supreme when it comes to spread sheet usage in business.

Most companies, banks & financial institutions, accounting firms, IT/BPO companies look for professionals with Excel skills.

Professionals with certification in advanced Microsoft Excel start earning from 2 to 4 lakhs INR pa at entry level. 


Gain Industry Relevant Skills

Learn Advance Excel skills and techniques which are applicable to any industry.

Learn Data Analysis Techniques

Learn through case studies which explain data analysis in a real time scenario. 

Career Growth

The program will be a great value-add to your resume, which can help you pursue a promising career.

Prep for Microsoft Office Specialist Exam

The program is oriented towards preparing you for Microsoft Office Specialist certification exam.

Enhanced Job Opportunities

Get hired as Data Analyst, Business Analyst, Operations Manager, Financial Analyst, Accountant, Sales and Marketing & HR Specialist etc.

Discuss Industry Trends

Live Web based sessions (classes) with faculty for discussion on current industry trends and doubt clearance of concepts.

Program Highlights:

Program Highlights

Industry Recognised Certificate
Globally valid Certificate in Advanced MS Excel by Manipal ProLearn.
Vital Essential Techniques
Learn to use MS Excel 2010 components like Charting, Power Functions, PivotTables and more.
Comprehensive Course Curriculum
Comprehensive e-learning course explained through reading material, videos, case studies, live webinars & simulations.

Who Should Attend

  • A must for every professional from entry to senior level managers in any industry
  • Engineering & IT graduates BTech/ BE, BSc-IT, BCA, MCA, MSc-IT etc
  • Management graduates – MBA, BBA
  • For students aspiring for entry level jobs in any domain this is mandatory.

Course Outcome

After doing this program, you will be considered a strong and competent Excel professional. You will be ready to take Microsoft certification exam after the successful completion of the course. This course will help you:

  • Master Excel Functions and Formulas that saves time and increases productivity 
  • Cut hours of labour by using Pivot tables to analyse data
  • Discover new tools to share your work
  • Find new and more efficient ways to analyse data
  • Add colour and images to improve readability and get messages across to the audience more effectively
  • Learn the tricks to produce professional charts and graphs
  • Include diagrams in marketing reports and sales presentations to boost sales and readability
  • Find new ways to visualize data 
  • Reduce workload each month by automating repetitive tasks by using macros
  • Import data using Power Pivot
  • Exam Preparation - Tips, Tricks & Strategies


  • Working with Excel Files
    Entering data
    Working with numbers
    Formatting data
    Managing your data in excel worksheet
    Working with text and date
  • Manipulating data
    Working with charts
    Working with pivot table
    'What if' analysis
  • Macros
    Printing Excel files
    Managing Excel files
    Grouping and outlining data
    Shortcut keys and references