Tata Steel Digie-Shala Presents Exciting Offers On eLearning Courses, Packages & Assessments! For Details Click Here  


Course Fee : 12 USD

  • Course Duration : 4 Hours
  • Validity : 60 Days

This course includes certification from TATA STEEL


Microsoft Excel is one of the most valuable tools to perform the calculation, analysis, and visualization of data. Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in MS Excel 2013. This tutorial has been designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve handling and analysis of complex data.

Course Objective

In this course you will learn the most useful shortcuts, tricks, and advanced features of Microsoft Excel that will help you handle huge amounts of data more quickly and effectively, making you more efficient and setting yourself up for greater advancement. By the end of the course, you will learn Auto Filter & Advanced Filter, Sorting, D-functions, Charts, Conditional Formatting, and many more functions.

Course Curriculum

  • Advanced Filter
  • Sorting & Subtotal
  • D-Functions
  • Naming Concepts
  • SumIf & CountIf
  • Charts and IF-IS
  • Conditional Formatting
  • Data Validation
  • Series in Excel & Macro
  • Pivot Table & Freeze Panes
  • Goal Seek & Scenario, Solver
  • Errors in Excel
  • V-Lookup
  • Password Protecting Excel File

Student Feedback


Course Rating


Are you looking for some help
related to your course or assessment?

Help & Support