Skip to main content

CERTIFICATE IN ADVANCED EXCEL

Enables professionals to boost productivity, streamline workflow, and maximize efficiency through advanced Excel functionalities such as Macros, Pivot Tables, Data Analysis, and more.

What Will You Learn?
  • Design forms and formatting
  • Data analysis and formulas
  • Advanced charting and graphing functions
  • Learn advanced features like data validation, shearing and productivity
  • Comparing and combining work book or worksheets
  • Analyze data with Excel like external database file, pivot tables, goal seeking, spark lines etc.
  • Maximize the power of Excel with VBA and macros
  • Advanced conditional formatting techniques
  • Validating and queuing data
     
₹9,360.00
Course Details
Division
Category
Credits
2
Duration
60 hours
Level
Master
Price
₹9,360.00
Includes
  • 6 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
*Additional University and GST charges applicable.

This course is outlined in a way that it covers majority of enriched features in Microsoft Excel, including Macros, Pivot tables, Audit and Analyze worksheets, Use Advance Formulas and Functions, work with multiple Worksheets and Workbooks etc., which in turn increases productivity, improves efficiency by streamlining the workflow thus becomes a major asset for professional employees.

Lessons Of Course

Module 1

30 Hours

Topic Duration
Introduction to Excel
Working with formulas and functions
Data sorting and filtering
Auditing
Charts and tables
Working with data
What if analysis
Exporting importing and reviewing a worksheet
VBA Macro