Course Syllabus
📊 ADVANCED EXCEL COURSE SYLLABUS
1. Excel Fundamentals (Revision)
- Interface overview, ribbons, shortcuts
- Data entry & formatting
- Basic formulas (SUM, AVERAGE, COUNT)
2. Advanced Formulas & Functions
- Logical: IF, IFS, AND, OR
- Lookup: VLOOKUP, HLOOKUP, XLOOKUP,
- Text: LEFT, RIGHT, MID, LEN,
- Date & Time functions
3. Data Management
- Sorting & Filtering
- Conditional Formatting
- Data Validation (drop-downs, rules)
- Remove duplicates
4. Pivot Tables & Charts
- Creating Pivot Tables
- Pivot Charts
- Slicers & Timelines
- Data summarization techniques
5. Advanced Data Tools
- What-if Analysis (Goal Seek, Scenario Manager)
- Consolidation
6. Dashboard Creation
- Interactive dashboards
- Charts & visualizations
7. Macros & Automation
- Introduction to Macros
- Recording Macros
💼 TALLY PRIME COURSE SYLLABUS
1. Introduction to Tally Prime
- Features & interface
- Company creation
- Company alteration & deletion
2. Accounting Basics
- Accounting principles
- Ledger creation
- Groups in Tally
3. Voucher Entry
- Payment, Receipt, Contra
- Sales & Purchase vouchers
- Journal entries
4. Inventory Management
- Stock groups & categories
- Units of measurement
- Stock items creation
- Godowns (warehouses)
5. GST (Goods and Services Tax)
- GST setup in Tally
- GST ledger creation
- GST entries (sales & purchase)
- GST returns overview
6. Banking & Reconciliation
- Bank accounts in Tally
- Bank reconciliation
- Cheque printing
7. Payroll Management
- Employee creation
- Salary structures
- Payroll processing
8. Reports & Analysis
- Balance Sheet
- Profit & Loss Account
- Trial Balance
- Stock reports
9. Advanced Features
- Budgeting & controls
- Cost centers
- Security controls
- Backup & restore
🎯 Course Outcome
After completing this course, students will be able to:
- Handle advanced Excel data analysis and reporting
- Create dashboards and automate tasks
- Manage complete accounting in Tally Prime
- Handle GST, payroll, and financial reporting
Bestseller
