ADVANCED EXCEL

Course Fee : USD 25

Course Fee : USD 10

  • Course Duration : 4 Hours
  • Validity : 60 Days

Description

Advance Excel is a comprehensive tutorial that provides a good insight into the latest and advance 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 complex data. It will help all those readers who use MS Excel regularly to analyze data.

Course Objective

In this course you will learn advances features of MS-Excel, that will help you to handle huge amount of data in less time with more efficiant and effective. By the end of the course you will learn Auto Filter & Advanced Filter, Sorting, D-finctions, Charts, Conditional Formating and many more.

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