Advanced MS Excel 2016 Online Training | MS Excel Certification Course | Edureka

Advanced MS Excel 2016 Certification Training

Preview this course

    Excel has become one of the prerequisites for almost all jobs in the analytics and consulting sector. Through this course, you’ll learn the advanced functions that are used by analysts on a day to day basis. You’ll also get accustomed to even more advanced stages of excel use like Macros which further come handy. Throughout the course, you’ll be given hands-on assignments and case-studies to put the theoretical knowledge to practical.
6K+ satisfied learners Read Reviews
Why should you take Advanced MS Excel course ?

"Companies such as NVIDIA, Dell, Walmart have a demand for data analysts with advanced excel knowledge" -

As per, the average salary for a Data Analyst with MS Excel skill is Rs. 354,974 per year

"Excel is the most in-demand software skill for Indeed job posts" -

Online self - paced learning

Online Self Learning Courses are designed for self-directed training, allowing participants to begin at their convenience with structured training and review exercises to reinforce learning. You'll learn through videos, PPTs and complete assignments, projects and other activities designed to enhance learning outcomes, all at times that are most convenient to you.
15 Off
EMI Option availableCall us: +91 96060 58413
100% Satisfaction guaranteed

Learn BI and Visualization Live Online from top industry professionals

Live online training

Interactions with an Live Expert, get your doubts cleared in Real Time.

Classroom Experience

Access to World Class Instructors, from anywhere

Personal Learning Manager

Your guide from Edureka, to ensure you achieve your learning goals.

Get Assured Certification

Live course assures 6 times more probability of getting certified

Learning Objectives: In this module, you will get introduced to new features in MS Excel 2016. It also discusses advanced MS Excel 2016 concepts.

  • What’s New in MS Excel 2016
  • Advanced Concepts

  • Introduction to new features in MS Excel 2016
  • Familiarization to Advanced MS Excel 2016 concepts

  • Hands-on on basic excel functions to get you started
  • How to access shortcuts in excel
Learning Objectives: In this module, you will learn about custom and conditional formatting. This module covers topics on customizing Quick Access Toolbar. It also explains various conditional formatting available in MS Excel 2016. 

  • Customization of Quick Access Toolbar
  • Application of Conditional Formatting

  • Customizing Quick Access Toolbar
  • Conditional Formatting

  • Customizing Quick Access Toolbar
  • Conditional Formatting
Learning Objectives: In this module, you will learn how to apply advanced functions and formulas. This module covers topics on advanced logical, text, lookup and reference functions. It also discusses how to trace errors and evaluate formulas. 

  • Application of advanced functions and formulas
  • Tracing errors and evaluating formulas

  • Logical Functions
  • Text Functions
  • Lookup and Reference Functions
  • Formula Auditing
  • Randbetween
  • Name Ranges and application

  • Using logical functions, lookups in excel
Learning Objectives: In this module, you will learn how to work with advanced data tools. This module covers topics on advanced data tools like converting text to columns and data validation. It also discusses how to implement what-if tools. 

  • Understand advanced data tools

  • Text to Column
  • Data Validation
  • What-If Analysis
  • Duplicate Removal
  • Data Sanitation through excel - Sorting, Filtering

  • Data Validation through excel using the given assignment
Learning Objectives: In this module, you will learn how to use pivot tables and charts to analyze data. This module covers topics on pivot tables, pivot chart, sparklines. It also demonstrates the application of advanced filters. 

  • Implementation of Pivot tables and charts
  • Application of advanced filters

  • Data analysis using normal charts, formatting of charts, secondary axis use, scatter plots
  • Data analysis using a Pivot table and pivot charts, sparklines
  • Running Regression in excel, ANOVA, etc.
  • Cover basic stats through excel - Functions like correlation, stddev, average, regression functions

  • Data analysis through excel using Pivots, charts, regression
Learning Objectives: In this module, you will be introduced to recording and using Macros. This module covers topics on how to record and run Macros. It also discusses how to edit Marcos. 

  • Comprehension of Macros
  • Application of Macros

  • Introduction to Macros
  • Record Macros
  • Run Macros
  • Edit Macros

  • Recording, editing and running Macros
Learning Objectives: In this module, you will learn how to restrict and protect your data. This module covers topics on protecting cells, sheets, and workbooks. It also discusses how to assign edit range function. 

  • Protection of Cells, Sheets, and Workbook
  • Customization of ranges for individual users

  • Protect Cells
  • Protect Sheet
  • Protect Workbook
  • Protect Ranges

  • Protecting cells, sheets, workbook and ranges on the workbook created in Module 7
Learning Objectives: This is a training module to get you ready for the certification project 

  • Perform and implement advanced tools and techniques in Excel 2016

  • Implement Excel 2016 abilities and techniques
Like the curriculum? Enroll Now
Structure your learning and get a certificate to prove it.
Enter a valid mobile number
    Advanced Excel 2016 training course will help you facilitate and gain expertise in Advanced Excel techniques covering concepts like Lookup functions, Logical functions, Formula Auditing, Data validation, What-if Analysis, Pivot tables, Pivot charts, Advanced Filters, Sparklines, Macros, and Data Security.
    After the completion of this training, you will be able to:

  • Learn new features in MS Excel 2016 and implement advanced excel concepts
  • Customize Quick Access toolbar and apply conditional formatting to personalize the sheet
  • Apply advanced functions and formulas to enhance Excel’s productivity
  • Perform What-if analysis command to experiment with data
  • Apply data validation to restrict data input
  • Design Pivot tables and Pivot charts to analyze data and apply slicer and timeline to add more interactivity
  • Use Macros to automate routine tasks in Excel
  • Integrate passwords to protect Excel files
  • Use Excel shortcuts wherever applicable
    Advanced MS Excel 2016 Course will help you master your Excel skills and kick it up a notch. This course is designed to equip you with skills to create and work on MS Excel capabilities like:

  • New features of 2016 to help you optimize the platform to the best of its ability
  • Master advanced functions and formulas to perform calculations, data tools to manipulate data, and use Macros to automate routine tasks in Excel
  • Use advanced charts, graphs, and Pivot tables to perform advanced data analysis
  • Provide data protection solution using data security capabilities
    The following professionals can take up this VBA in Excel course:

  • Data Analyst
  • Financial Analyst
  • Advanced Excel User
  • Fresher seeking jobs in Analytics/Consulting job streams
    There are no prerequisites for this course. However, a basic understanding of Microsoft Excel will be supportive.

Edureka’s Proficient in MS Excel Certificate Holders work at 1000s of companies like

5000 Total number of reviews
4.57 Aggregate review score
80% Course completion rate
No data found
Souvik Kundu link Learning to code the web, big data & cloud computing. Aspiring Developer

I'm currently enrolled in a lot of courses offered at Edureka, so I'm attending live classes and using their study materials, course projects, have access to support staff and teachers. I can confidently say Edureka staff is very hard working and committed to help students which is reliable. Course instructors are experienced candidates from industry who know what they are teaching. Course materials are pretty comprehensive and students need to work very hard to finish course projects, pass the project interviews and gain certification. I say, it is worth it.

Venkat Ramana link Test Architect at NCR corporation pvt ltd

Thanks for the quick reply and solving the issue. I was really impressed by your 24/7 support even during the festive period. I appreciate your service and the trainer for Bigdata is very friendly and we've learnt the subject in very effective way. Thanks Edureka for doing such a great things.

Puneet Jhajj

I have done Spring Framework and Hadoop framework training from Edureka. I am very happy with the training and help they are providing.The sessions were very informative. The instructors are highly knowledgeable.They provide a set of videos from a previous session, so you can watch the course before you participate. This way you can get the most out of the course.Excellent Customer Service starting with signing up of the course. I really appreciate Edureka Support team. They are really doing a fantastic job. All my queries were answered properly and promptly.You get recording of the classes, presentations and labs in LMS. And good feature is you have lifetime access to LMS of course you have taken, so you can refer, revise any topic when you want.I can safely say Edureka is one of the best training company.

Manoj Josh link Associate Manager at Accenture, Mumbai

I have attended Edureka's Spring and Design Patterns course. Very engaging and I liked the course structure very much. One good part is , before the course begins you have access to previous courses sessions which helps in understanding whether this course is covering all the topics for you. If not , your required topics can also covered during the actual live sessions. This is one unique company which has really evolved and matured as a solid technical education provider. Great job !!! And I look forward to taking more courses from you!

Sudha Kargi link AVP, Business Optimization and BPO Relationship | PMP Certified | Zions Bancorporation

I took PMP online classes with edureka. Just wanted to let you know that I was successfully able to pass the PMP exam couple of weeks ago. I enjoyed learning the concepts of PMP through edureka by the excellent laid out structure.Instructor's method of teaching was very helpful. During the classes he went over the concepts in detail and also clarified all the questions very patiently. He also shared his real world experiences which helped the student to relate to the topic. Even after the completion of course work, while reviewing the chapters in LMS, I struggled in few areas and when I reached out to the instructor without any hesitation, he explained it to me by providing some good examples.Wanted to take a moment to thank the people who contributed the most in my success.

Pramod Kunju link Data Warehouse Guru, Greater Los Angeles Area

I found the big data course from Edureka to be comprehensive, and practical. Course instructor was very knowledgeable, and handled the class very well in terms of making it interactive, keeping it interesting, and responding to all questions from students. The support staff was excellent as well, engineers assisted me remotely when I encountered an issue with HDFS even after the course was over. Overall, highly recommend Edureka for big data training and more.

Vijay Kalkundri link Principal Engineer at Reflektion, former Senior Test Engineer at Nokia

I had a great experience in taking the Hadoop course from Edureka. It is the only course in the market which facilitates the people from the Non development background to plug themselves into the Hadoop ecosystem. Edureka has provided a unique opportunity for the students around the world to connect to some of the best tutors. The tutors not only provide a very good theoretical explanation , but also help us to co-relate it with some real time examples. This gives a edge to the students and the working professional who attend the course.The best advantage of the Edureka course is the fact that we can attend the course from the comfort of our home as well as download the courses and listen to it over again and again. I am sure that Edureka will be playing a key role in filling the Gap of the Professionals which the Cloud ecosystem is currently facing. Cheers,Vijay Kalkundri - Good Session and one of the best instructor to have interfaced with at online.

Loved reviews? Enroll Now
Structure your learning and get a certificate to prove it.
Enter a valid mobile number
    The system requirement for this course is a Windows or Mac system having at least 2 GB of RAM
    All the practices will be done on MS Office 2016
    Following are the case studies / assignments will be part of the course:

    Assignment-1: In this assignment, you will go through the problem statements that are around basic excel functions like Sumif, Countif, Average, formatting the data, concatenate, round, offset, index on a data set containing the performance of a class containing 100 students.
    Assignment-2: In this assignment, you will customize the quick access toolbar and apply conditional formatting to the student dataset used in Module 1.

    Assignment-3: In this assignment, you'll be introduced to an actual dataset from an e-commerce company. This will be a relatively bigger dataset and will you the feel of an actual analytics problem. We will use logical, text and reference functions to collate our dataset and make it more readable.
    Assignment-4: A dataset is given to you in a single column. It contains sales and returns at an item level. Transform it into a readable dataset into different columns. Apply data-validation and perform What-if analysis to estimate Net Revenue with different Returns percentages.
    Assignment-5: The e-commerce dataset used in Module 3 will be used in full form and detailed analysis will be done on it. The objective is to identify the strengths and weaknesses of the e-commerce client using different data analytics techniques in excel.
    Assignment-6: Create Macros to replicate some of the tasks you did in earlier case studies. For eg: Create a Macro to do conditional formatting on the dataset.
    Assignment-7: A workbook is given to you - Password protect cells, worksheets, and workbook. You will learn how to password protect a given range of cells.
    Assignment-8: A supply chain firm is to optimize its supply routes, identify the time taken to deliver products, identify key issues being faced by it.

Self Paced Learning

    You will undergo self-paced learning where you will get an in-depth knowledge of various concepts that will be covered in the course.

Real-life Project

    Towards the end of the course, you will be working on a project where you are expected to implement the techniques learnt during the course.

Case Studies

    Each module will contain case study, which can be completed before going to next module.

Lifetime Access

    You will get lifetime access to all the videos, discussion forum and other learning contents inside the Learning Management System.

24 X 7 Expert Support

    We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.


    edureka certifies you as an expert in Advanced Excel based on the project reviewed by our expert panel.


    We have a community forum for all our customers that further facilitates learning through peer interaction and knowledge sharing.
    You will never miss a lecture at Edureka! 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.
    Your access to the Support Team is for the lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.
    All the instructors at edureka are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by edureka for providing an awesome learning experience to the participants.
    Yes, the access to the course material will be available for the lifetime once you have enrolled into the course.
    You can give us a CALL at +91 98702 76459/1844 230 6362 (US Tollfree Number) OR email at
For payments done using credit cards, to make this a No Cost EMI offer, the interest amount will be discounted from the price of the course. Your card will be charged for the course price minus the discounted interest. The total amount you will pay to the bank (excluding GST) will be equal to the price of the course. The bank will charge GST on the interest amount. For payments done using Razor Pay EMI, the price will not be discounted upfront. Instead, you will not be charged any interest for a No Cost EMI offer.
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Enter a valid mobile number