AdvanceD Excel

Course Objective

Advanced Features of Ms-Excel. In this module student learns many complex functions such as cells formatting, macro, using graphical representations in spreadsheets, financial formulas, logical complex formulas, uses of advanced filters and the list keeps on going. Advanced Excel course enables the student to utilize, the advance features taught in this course in an office environment with maximum efficiency.

  • Introduction to MS Excel
  • Formatting Cells, Rows, Columns and Sheets
  • Sorting Data
  • Lookup and Reference Functions
  • Logical Functions
  • Statistical Functions
  • Date and Time Functions
  • Math and Trigonometric Functions
  • Creating Pivot Tables using Pivot Table options
  • Hyper/Data Linking
  • Security and Protection for Worksheets