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

ADVANCED EXCEL

Course Fee : 12 USD

  • Course Duration : 4 Hours
  • Validity : 60 Days
Certificates

This course includes certification from TATA STEEL

Description

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

4

Course Rating

36%
35%
28%

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


Help & Support