This learning path covers advanced Excel functions, data modeling, and automation
alongside Access database design, query optimization, and integration. By mastering
these tools, learners are equipped for careers in data analysis, database management, and
business intelligence.
Advanced Excel
- Data visualization with advanced charts and PivotTables.
- Complex formulas and functions (e.g., VLOOKUP, INDEX-MATCH, Power Query).
- Automation using macros and VBA.
Advanced Access
- Database design principles and normalization.
- Advanced queries, forms, and report customization.
- Automating tasks with Access macros and SQL.
Data Integration and Analysis
- Importing/exporting data between Excel and Access.
- Data cleaning, transformation, and reporting.
- Building dashboards and actionable insights
Career Outcome
- Data Analyst
- Junior Database Manager
- Business Analyst
- Data Coordinator
- Database Administrator
- Business Intelligence Specialist
- Data Consultant
Fee and Duration
- Course Duration: 3 months
- Mode of Delivery: Online only
- Cost: E3500 once off or E1250/month
Information