Advanced MS Excel Training Course Content
- Entering Data
- Referencing in Formulas
- Name Range
- Understanding Logical Functions
- Getting started with Conditional Formatting
- Advanced-level Validation
- Important Formulas in Excel
- Working with Dynamic table
- Data Sorting
- Data Filtering
- Chart Creation
- Various Techniques of Charting
- Pivot Tables in Excel
- Ensuring Data and File Security
- Getting started with VBA Macros
- Core concepts of VBA
- Ranges and Worksheet in VBA
- IF condition
- Loops in VBA
- Debugging in VBA
- Messaging in VBA
- Practical Projects in VBA
- Best Practices of Dashboards Visualization
- Principles of Charting
- Getting started with Pivot Tables
- Creating Dashboards
- Creation of Interactive Components
- Data Analysis
Login with Google