Certificate Course in Advance Excel

Accelerate your Career. Stay Ahead of the Curve

Enroll Now

Jointly Delivered by eduplusnow and Industry Expert


  21 hours
  21 hours

Upcoming Batch Details
Training Mode(Online)
Date :07th Aug 2021-14th Aug 2021
Batch Type :Saturday-Sunday

About Advanced Excel

Advanced Excel training will expertise individual in spreadsheet capabilities, spreadsheet operations using tools, functions, diagrams etc.

Course Features

In detail coverage of Excel functions, reports, Lookups ,pivot tables etc.

Who Should Enroll?
  • Ideal for any Graduate, professionals from Banking, MIS, Back office, fiance MBA in any domain.
  • There are no pre requisites for Advance Excel training.

Tools Covered



Advanced Excel
  • Main Features and advantages of Excel – Overview
  •  Workbook, worksheets structure
  •  Options settings and configurations
  • Using the Paste Function tool
  • Cell Ref/Freezing Concept
  • Using Named Ranges in Formulas
  • Naming a Single Cell
  • Naming a Range of Cells
  • Naming Multiple Single Cells Quickly
  • Using Formulas That Span Multiple Worksheets
  • Using the IF Function
  • Using AND/OR Functions
  • Using the SUMIF, AVERAGEIF, and COUNTIF Functions
  • Using the LOOKUP Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the CONCATENATE Function
  • Using the TRANSPOSE Function
  • Using the PROPER, UPPER, and LOWER Functions
  • Using Max, Min, Large, Small
  • The TRIM Function
  • Text To Column
  • Using Date Functions
  • Using the NOW and TODAY Functions
  • Conditional Formatting
  • Using Excel as a database
  • Sorting Data
  • Custom sorts
  • Filtering using AutoFilter
  • The Advanced Filter tool
  • Data consolidation
  • Linking to another workbook
  • Linking to an external database
  • Getting data from the web
  •  Selecting the data to chart
  •  Creating a chart
  •  Choosing the right chart for the job
  •  Moving and re-sizing charts
  •  Customizing charts
  •  Saving and copying a chart's design
  •  Creating an Excel table
  •  Table formatting
  •  Adding rows and columns
  •  Automatic calculation in tables
  •  Protecting a workbook
  • Protecting worksheets and cells
  • Adding comments to cells
  • Sharing workbooks
  • Tracking changes
  • Auditing Workbooks
  •  Viewing formulas
  • Tracing precedents and dependents
  • Error checking
  • Golden Rule of Pivot
  • Create Pivot Table
  • Create multiple pages
  • Classic pivot table
  • Consolidate
  •  Merging Summary data from different sheets
  • Merging Summary data from different files
  •  Merging non-summary data
  • Concept and advantage of templates
  • Creating template
  • Using the template
  • Difference between Addins and Templates
  • Creating a AddIn
  • Using a AddIn
  • Concept and importance of Macro
  • Creating a macro
  • Running existing macros
  • Attaching Macro to Keyboard keys, Tool bar, Menu Bar or button-click
  • VBA Code overview

Learning Outcomes

  • By attending Advance Excel training at eduplusnow you will become master Microsoft excel from begineer to advanced with common excel functions, Vlookups, Index, Match Fuctions and many more..


Periodic assessment and case studies evaluations by the edu plus now and Industry Expert have been built in throughout the duration of the course.


Awarded by edu plus now

What our learners have to say about us!

Our Alumni work at

Course Fees : 8,000 (+GST)

Eduplusnow's Advanced Excel Training Course Will Master you in
  • Options Settings And Configurations
  • Working with Functions in Excel
  • Working with Data using excel
  • Using Excel As A Database
  • Macros and Templates in excel
  • Collaboration Tools
  • Tables in excel
  • Charting with Excel

"If a group of four or more participants enroll with us, a concession of 10% will be awarded to each one of them. For more details Contact us."    +91 8956167195

*Alumni of Eduplusnow, VIT, VIIT, VU Will Get Special Discount, To Grab your Discount coupon Please Contact   +918956167195.

Why edu plus now


Industry-Ready Courses

Learn industry-relevant skills that’ll make your resume stand out and ensure you’re ready to tackle the job market.


Flexible Learning

Access online learning resources anywhere, anytime to gain valuable skills and transform your life in meaningful ways.


Qualified Instructors

Connect with experts and qualified instructors from reputed universities to stay on top of the ever-evolving future of work.


Adavanced study plans

Learn complex technical skills with videos, quizzes and assignments to develop your career and build towards a degree.


Focus on target

Select the best online courses in India that are not only informative and helpful to your long-term career goals but also help close the skill gap in the industry.


Knowledge Platform

Take advantage of a complete in-built environment for programming and get hands-on experience to solve real-world problems practically.

About the Organization


edu plus now is an online educational platform that was launched in 2019 to bridge the skill gap between classroom learning, real business challenges and to help students achieve their career potential.

Aimed at providing learners with essential technical skills, edu plus now courses are created to be the perfect amalgamation of inputs from industry experts and highly-qualified professors from the country’s top educational institutions. This allows individuals and companies to close the skill gap quickly, innovate faster and achieve their key objectives. At edu plus now, we believe in preparing students for success in a changing world by providing online courses that pave the path for a successful career. Built under the aegis of the Vishwakarma Group, the online education platform provides flexible learning that fits a learner’s schedule.


Call Me Back

Get Free Career Advice By Putting Your Mobile Number Below, Our Counselor will get back to you

You can Directly Contact Our Counselor On Below Help-Line

Note: You will receive a call between Mon-Fri from 9AM - 9PM.