Registrar by Ministry of Corporate Affairs (Govt. of India) ISO certified 9001-2015

 9123803436 / 9830220822

Data Analysis using Advance Features of Excel

Course details:

  • Data Analysis using Advance Features of Excel trains you in:

  • Auto Fill, Flash Fill & Auto Complete
  • Protect Sheet, Workbook, Workbook Structure
  • Finalize Work Book
  • Encrypt Workbook
  • Share Workbook, Protect & Share
  • Track Changes
  • Use Built-in Templates and Create Custom Templates
  • Define Name
  • Reference Types (Relative, Absolute, Mixed, 3D) and their uses
  • Advance formulas, Database Functions, Financial Formulas
  • Use of NPV & IRR Functions
  • Data Table

  • Advance uses of Lookup
  • Advance Filter
  • Scenario Manger
  • Goal Seek, Solver
  • Pivot Table & Pivot Chart
  • Trend Line
  • Sparkline
  • Add-Ins, Data Analysis Tool Pak (Anova, Histogram, Correlation, Covariance & many more)
  • Macro
  • Developer Tab
  • Many More…..

Register Today

Course duration:

  • 3 Month. Classes are typically held 2 hours a day/ 3 days a week.

Job opportunities:

On successfully completing the Data Analysis using Advance Features of Excel , you will be ready to join top national & international  companies.

*Note: Fees & duration may vary based on course & centre location