Embedded Files
Advanced Excel
Excel skills are as important as the subject knowledge. Those who know Excel can find a better paying job. An Excel Expert collects, edits, analyses data, creates databases and reports. The conclusions made by the data expert are helpful for organizations to forecast the business speculations.
Who Should Join
Who Should Join
• Accounting and Finance Students – Practical skills for managing data, preparing reports, and analyzing finances.
• Business and Management Students – Data-driven decision-making, budgeting, inventory management.
• Data Analysts and Aspiring Professionals – Pivot tables, formulas, scenario analysis for large datasets.
• Retail Store Managers and Logistics Staff – Inventory tracking, sales analysis, reporting.
• HR Professionals – Employee data, attendance, and performance management.
• Project Managers – Track progress, manage resources, scenario planning.
• Entrepreneurs & Small Business Owners – Budgeting, sales analysis, business optimization.
Syllabus Overview
Syllabus Overview
• Custom formats and layouts
• Advanced formulas (VLOOKUP, HLOOKUP, INDEX-MATCH, IF statements)
• Scenario use and analysis
• Pivot tables & charts
• Manage & share workbooks
• Data management basics
• Meta Data and Big Data concepts
• Dashboard creation (Power Query, Power Pivot Table)
• Macros creation and automation
• What-If Analysis Tools
• Financial, mathematical, and text functions
• Advanced charts and custom templates
• Sparkline, Power Map
• External data connections
• File conversion (PDF to Word)
• Google Sheets, Forms, Keep
• OpenOffice.org Writer, Calc
• Excel shortcuts and productivity tips
• Mail Merge and document comparison
• DBMS basics (MySQL, Oracle)
What You'll Learn
What You'll Learn
After completion of the course, you can get a suitable position in any organization as:
• Accounts Assistant
• Finance Analyst
• Retail Store Manager
• Data Analyst
Certification
Certification
• MKCL certificate provided upon successful course completion
Evaluation Pattern
Evaluation Pattern
Section Name | Total Marks | Minimum Passing Marks
• Learning Progression: 25 marks (Minimum 10)
• Internal Assessment: 25 marks (Minimum 10)
• Final Online Examination: 50 marks (Minimum 20)
• Total: 100 marks (Minimum 40 to pass)
• SUPWs (Assignments): 5 Assignments - Complete and Upload Minimum 2
Recommended Courses:
After completing Advanced Excel, you can enhance your Data Analyzing skills with:
Tally Prime with GST
Tally Prime with GST
120 Hrs
MS-CIT
MS-CIT
120 Hrs
Google Workspace
Google Workspace
120 Hrs
Page updated
Google Sites
Report abuse