Advanced Excel
The real power of Microsoft Excel lies in the advanced functionality it offers. Having been designated as one of the prerequisites expected from the aspiring candidates aiming to join the industry, Microsoft Excel is considered to be an indispensable Management Information Systems (MIS) tool employed by the end-users.
Vision Academy is one of the most reputable institutes in Delhi that provides courses in Basic and Advanced Excel.
Whether there are basic tasks like entering data, saving and opening sheets, formatting content and creating formulas or advanced tasks like manipulating data with Pivot Tables, handling complex and large calculations, presenting data with charts and drawing up advanced analysis reports, our courses will help you THINK in Excel.
Course Highlights
Introduction to Microsoft Excel
- User Interface
- Formatting Data
- Conditional Formatting
- Data Sorting & Filter
- Data Validation
- Freeze Panes
Formulas & Functions
- Date & Time Functions
- Text Functions
- Math & Trig. Functions
- Logical Functions
- Lookup Functions
- Nested Functions
Data Management
- Data from other Sources
- Dealing with Invalid Data
- Group and Outline Data
- Data Consolidation
- Text to Column
- Removing Duplicate
Data Analysis
- Creating a PivotTable
- PivotTable Analyzes
- What Appears in a PivotTable
- Scenario Modeling
- Goal Seek
- Data Table
Advance Functions
- Arrays & Index Match
- Indirect Functions
- Financial Formulas
- Macros
- Smart Printing
- Sharing and Protection
Dynamic Projects
- Event Budget
- Employee Performance
- Marketing Plan
- Timecard
- Income Statement
- Management Dashboard
