KEMBAR78
Excel + Advanced Excel Syllabus | PDF | Microsoft Excel | Information Science
Scribd
Upload
97 views5 pages

Excel + Advanced Excel Syllabus

The Excel + Advanced Excel Syllabus is a comprehensive 4-week program designed for beginners to advanced learners, targeting freshers from various backgrounds. It covers core Excel foundations, intermediate skills, advanced data analysis tools, and includes real-time projects along with resume building and interview preparation. The course aims to equip participants for job roles such as Data Entry, Business Analyst, and HR Executive, focusing on practical tasks and essential Excel functions.

Uploaded by

Jayeesh Pandey
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
97 views5 pages

Excel + Advanced Excel Syllabus

The Excel + Advanced Excel Syllabus is a comprehensive 4-week program designed for beginners to advanced learners, targeting freshers from various backgrounds. It covers core Excel foundations, intermediate skills, advanced data analysis tools, and includes real-time projects along with resume building and interview preparation. The course aims to equip participants for job roles such as Data Entry, Business Analyst, and HR Executive, focusing on practical tasks and essential Excel functions.

Uploaded by

Jayeesh Pandey
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

📘 Excel + Advanced Excel Syllabus

Duration: 3 to 4 Weeks​
Level: Beginner to Advanced​
Target: Freshers (2020–2025), Non-tech and Tech backgrounds

Week 1: Core Excel Foundations

✅ Basics of Excel
●​ Interface overview​

●​ Workbook, worksheet, cells, rows & columns​

●​ Data entry, formatting, autofill​

✅ Essential Formulas
●​ Arithmetic operations​

●​ SUM, AVERAGE, MIN, MAX​

●​ COUNT, COUNTA, COUNTBLANK​

✅ Cell Referencing
●​ Relative, Absolute, Mixed referencing​

✅ Data Handling
●​ Sorting & Filtering​

●​ Basic data validation​

●​ Freeze panes, split view​

✅ Practical Task:
●​ Create an employee database with salary calculations​

Week 2: Intermediate Excel Skills

✅ Logical & Conditional Functions


●​ IF, AND, OR, NOT​

●​ Nested IF statements​

✅ Lookup & Reference


●​ VLOOKUP & HLOOKUP (with examples)​

●​ XLOOKUP (latest)​

●​ INDEX & MATCH (real-time examples)​

✅ Text Functions
●​ CONCAT, LEFT, RIGHT, MID​

●​ LEN, TRIM, UPPER, LOWER​

✅ Date & Time Functions


●​ TODAY, NOW, DATEDIF, NETWORKDAYS​

✅ Practical Task:
●​ Student marksheet with grade logic and conditional results using formulas​

Week 3: Advanced Excel + Data Analysis Tools

✅ Data Analysis Tools


●​ Pivot Tables & Pivot Charts​

●​ Slicers & Timelines​

●​ Grouping/ungrouping data​

✅ Conditional Formatting
●​ Icon sets, data bars, custom rules​

✅ Advanced Charts
●​ Dynamic charts​

●​ Combo charts​

●​ Trend lines, forecast​

✅ What-If Analysis
●​ Goal Seek​

●​ Data Tables​

●​ Scenario Manager​

✅ Data Cleaning Techniques


●​ Remove duplicates, find & replace, text-to-columns​

●​ Use of Power Query (Basic)​


✅ Practical Task:
●​ Create a sales dashboard using Pivot Table & Charts with slicers​

Week 4: Real-time Projects + Resume Building + Interview Prep

✅ Mini Projects (Choose any 1–2):


1.​ MIS Report for HR or Admin Team​

○​ Monthly employee attendance, payroll summary, attrition analysis​

2.​ Sales Performance Dashboard​

○​ Region-wise performance, top products, target vs. achievement​

3.​ Data Cleaning + Reporting Automation​

○​ Raw data → clean → visual report generation​

✅ Bonus:
●​ Excel Shortcut keys & productivity hacks​

●​ Do’s and Don’ts in Excel Reporting​

●​ Resume tips focused on Excel-based job roles​

●​ Interview questions discussion (Excel + Scenario-based)​

🎯 Job Roles Targeted


●​ Data Entry / MIS Executive​

●​ Business Analyst (Intern/Fresher)​


●​ HR Executive (with reporting skills)​

●​ Operations Executive​

●​ Sales Coordinator / Admin Analyst​

●​ Support roles requiring Excel automation​

You might also like