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