This comprehensive Microsoft Excel Course is designed to take learners from basic spreadsheet skills to advanced data analysis techniques. With a total of 30 hours of practical training, the program covers essential Excel functions, data handling, visualization, and automation tools used in modern workplaces.
Participants will begin by learning Excel fundamentals such as data entry, formatting, formulas, and charts. The course then progresses to advanced topics including lookup functions, PivotTables, dashboards, data cleaning, and basic automation using macros.
Through hands-on exercises and real-world examples, learners will gain the confidence to use Excel efficiently for academic, professional, and business purposes.
Course Structure (ADVANCED LEVEL – MICROSOFT EXCEL):
- Module 1: Excel Basics & Interface (2 Hrs)
- Module 2: Data Entry, Formatting & Validation (3 Hrs)
- Module 3: Basic Formulas & Functions (4 Hrs)
- Module 4: Conditional Formatting & Basic Charts (3 Hrs)
- Module 5: Introduction to PivotTables & Data Handling (3 Hrs)
- Module 6: Advanced Formulas & Functions (4 Hrs)
- Module 7: Data Cleaning & Large Dataset Handling (3 Hrs)
- Module 8: Advanced PivotTables & PivotCharts (3 Hrs)
- Module 9: Charts, Dashboards & Reports (3 Hrs)
- Module 10: What-If Analysis & Basic Automation (2 Hrs)
- Final Assessment : Practical
Learning Outcomes:
- Understand Excel interface, workbooks, worksheets, and navigation
- Enter, edit, and format data professionally
- Apply number formats and data validation tools
- Use basic formulas and core functions (SUM, AVERAGE, COUNT, etc.)
- Apply conditional formatting to highlight important data
- Create and interpret basic charts
- Sort, filter, and summarize data using simple PivotTables
- Use advanced formulas including IF, AND, OR, VLOOKUP, XLOOKUP,
- SUMIFS, and COUNTIFS
- Apply text functions to clean and structure data
- Handle large datasets efficiently
- Clean and organize inconsistent data
- Create advanced PivotTables and PivotCharts
- Design interactive dashboards with slicers
- Perform what-if analysis for decision making
- Record and use simple macros for automation
Target Audience:
- Beginners with little or no Excel experience
- Students preparing for academic or professional work
- Office staff and administrative professionals
- HR, finance, and business professionals
- Entrepreneurs and small business owners
- Anyone who wants to improve productivity using Excel
Certification : Certificate provided upon completion of the Final Assessment and attendance. (70% attendance is a must to receive the certificate. Special permission must be taken if there are difficulties in joining.)
Customized sessions available:
Can book sessions for required topics or to clarify doubts.
Training per hour: 2500/=
Group Training: 15,000/=
Installments:
Reg Fee: LKR 5,000/=
End of first month: LKR 5,000/=
End of second month: LKR 5.000/=