Here’s a comprehensive 5-week Microsoft Excel training program, with sessions of 4 hours each week, typically held on weekends. This 20-hour course covers essential Excel skills for beginners to intermediate users.

Week 1: Excel Basics and Formatting (4 hours)
1. Introduction to Excel (1 hour)
– Excel interface overview
– Navigating worksheets and workbooks
– Basic data entry techniques

2. Formatting Essentials (2 hours)
– Cell formatting (fonts, colors, borders)
– Number formatting
– Conditional formatting basics
– Applying styles and themes

3. Worksheet Management (1 hour)
– Inserting, deleting, and rearranging worksheets
– Freezing panes
– Setting print area and print options

Week 2: Formulas and Basic Functions (4 hours)
1. Formula Fundamentals (1.5 hours)
– Creating simple formulas
– Understanding order of operations
– Cell references: relative, absolute, and mixed

2. Essential Functions (2.5 hours)
– SUM, AVERAGE, MIN, MAX, COUNT
– IF statements
– Date and time functions
– VLOOKUP basics

Week 3: Data Management and Charts (4 hours)
1. Data Management (2 hours)
– Sorting data (single-level and multi-level)
– Filtering data
– Removing duplicates
– Data validation

2. Charts and Graphs (2 hours)
– Creating basic charts
– Customizing chart elements
– Choosing appropriate chart types
– Sparklines introduction

Week 4: PivotTables and Advanced Functions (4 hours)
1. PivotTables (2 hours)
– Creating PivotTables
– Customizing PivotTable layout and calculations
– Introduction to PivotCharts

2. Advanced Functions (2 hours)
– Nested IF statements
– INDEX and MATCH functions
– Text functions (LEFT, RIGHT, MID, CONCATENATE)
– SUMIFS and COUNTIFS

Week 5: Advanced Features and Final Project (4 hours)
1. Advanced Excel Features (2 hours)
– Goal Seek
– Scenario Manager
– Advanced conditional formatting
– Protecting worksheets and workbooks

2. Final Project and Review (2 hours)
– Comprehensive project applying learned skills
– Q&A session
– Course wrap-up and resources for further learning

This 5-week program covers a wide range of Excel skills, balancing between theory and hands-on practice. Each session builds upon the previous ones, allowing participants to gradually develop their Excel proficiency.

Would you like me to elaborate on any specific section or provide more details on certain topics?

♦ Please Call +91 7090305090 or email : training@suvipratech.com