Ber Season Sale! Get 10% off when you enroll for courses now with code BER2022. *T&C applies

MS Excel Advanced Features

Gain and apply advanced techniques on using MS Excel for your day-to-day work


Why should you go for this course?

Work productivity is a constant concern that many companies have, which is why many  companies allocate a significant budget for developing the skills of their employees and managers. Achieving this type of productivity has now become a sort of “holy grail” that many organizations hope to achieve. This has led to the demand for higher levels of capabilities by employees / managers.


Key Highlights

  • Revisit the basics and move on to the advanced level functions designed to simplify your work flows. 
  • 2 Days of Intensive Live Virtual Training taught by an Expert Trainer
  • Theoretical + Hands-On Approach 
  • Our MS Excel courses are conducted by certified instructors who will help you master a comprehensively structured curriculum supplemented with practice datasets.  

Training Options

Virtual Instructor-Led

  • Self-Paced Learning
  • Live, online classroom training by top instructors and practitioners
  • Lifetime access to high-quality self-paced elearning content curated by industry experts
  • 24×7 learner assistance and support


  • Customized learning delivery model (self-paced and/or instructor-led)
  • Flexible pricing options
  • Enterprise-grade learning management system (LMS)
  • Enterprise dashboards for individuals and teams
  • 24×7 learner assistance and support



Contact us



Pre-requisites for MS Excel Advanced Features

  • Participants must have at least a basic knowledge of MS Excel and must have MS Excel installed on their system
  • For Virtual Training:
    1. Computer/ Laptop with Microphone & Camera in working condition
    2. Good Internet
    3. Access to Google Forms / MS Forms


MS Excel Advanced Features Course Curriculum

Data Management Using Name Manager
  • Data Management Using Name Manager
Performing Text and Date Function
  • Performing Text and Date Function
Performing Logical Functions
  • Performing Logical Functions 
Measure to Learn
  • Measure to Learn
Data Security and Visualizations
  • Data Security and Visualizations 
Managing Big Data in Excel
  • Managing Big Data in Excel
Data Analysis Pivot Table and Chart
  • Data Analysis Pivot Table and Chart
Automate Tasks Using Excel Macro
  • Automate Tasks Using Excel Macro 
Talk to a Learning

Inquiry For:

Who should Attend?

  • Middle to Senior Management
  • Accountants
  • Business Analysts
  • Project Managers
  • Designed for existing MS Excel users (who have at least 2 years of continuous use)


HR Specialist


“Great training! There were activities after discussion which ensured retention.”

Cost Accounting Supervisor


“The trainer was very patient in explaining each topic and asked participants questions from time to time.”


Western Visayas Santarium

“Very helpful training. I’ve learned a lot and I can confidently say that this training will be beneficial with my work moving forward.”

MS Excel Advanced Features - FAQs


On successful completion of the course, you will receive a course completion certificate issued by APEX Global Learning. 

MS Excel Advanced Features course enables professionals to gain proficiency in handling advanced formulas and tools. This training helps them to enhance their skills in function with calculation, graphic tools, pivot tools, converting lists to a table and more. This will in turn, increase the organization’s overall productivity and efficiency as they will be able to automate and eliminate repetitive tasks.

Working knowledge of Excel is vital for most office-based professionals today. Thus, it is important to take advantage of everything Excel has to offer to provide the best results for the organization.

In an online classroom, students can log in at the scheduled time to a live learning environment which is led by an instructor. You can interact, communicate, view and discuss presentations, and engage with learning resources while working in groups, all in an online setting. Our instructors use an extensive set of collaboration tools and techniques which improves your online training experience.

The trainers are highly qualified instructors who have thorough knowledge of the subject matter.

Please send in an email to [email protected], and we will answer any queries you may have.


Talk to a Learning

Inquiry For:


Thank you, our learning advisor will contact you soon.

Get in touch with our experts to learn more about our services

Hurray! Our learning advisor will contact you soon.