Course Modules
- Review of Basic Formulas: SUM, AVERAGE, COUNT
- Logical Functions: IF, AND, OR, NOT
- Advanced Lookup: VLOOKUP, HLOOKUP, INDEX, MATCH
- Text Functions: CONCATENATE, LEFT, RIGHT, MID, TRIM
- Date & Time Functions: DATE, TODAY, NETWORKDAYS
- Array Formulas & Functions
- Dynamic References using INDIRECT & OFFSET
- Error Handling: IFERROR, ISERROR
- Custom Functions with Formula Bar
- Introduction to Data Analysis
- PivotTables & PivotCharts
- Slicers & Timelines for Interactive Filtering
- Advanced Filtering & Criteria
- Data Validation: Drop-Downs & Rules
- Conditional Formatting: Advanced & Custom
- What-If Analysis: Scenarios, Goal Seek, Data Tables
- Analysis ToolPak for Statistical Analysis
- Advanced Charts: Combo, Waterfall, Sparklines
- Customizing Chart Elements
- Chart Templates & Dynamic Charts with Named Ranges
- Conditional Formatting in Charts
- Choosing Appropriate Chart Types
- Introduction to Macros & Recording
- Editing Macros in VBA Editor
- Creating Button Controls & Assigning Macros
- VBA Basics: Variables, Loops, Conditions
- Simple Automation via VBA
- Best Practices for Safe Macro Use
- Importing Data: Text, CSV, Databases
- Power Query for Transformation & Cleaning
- Connecting to SQL, Access, Web Data
- Refreshing Data & Managing Connections
- Exporting Excel Data: PDF, CSV
- Protecting Workbooks & Worksheets
- Sharing Workbooks & Tracking Changes
- Excel Online Collaboration
- Documenting & Commenting Best Practices
- Tables, Structured References & Database Functions
- Data Consolidation & Named Ranges
Is This For You?
- Take your Excel skills to the next level
- Analyze complex data sets efficiently
- Automate repetitive tasks and improve productivity
Why Learn Advanced Excel?
- Boost Your Career: Highly sought after in industries
- Increase Efficiency: Automate tasks & streamline workflow
- Make Informed Decisions: Analyze & visualize data
- Stand Out: Advanced Excel skills differentiate you
Enroll / Request Batch
To request a new batch or enroll in the course, please contact us directly using the details provided on this page. Our team will get back to you with schedule and batch availability.
Contact Details
SGM Computer Education
Email: info@sgmcomputereducation.com
Phone: +91 9742266359