Basic Excel Course Syllabus

This foundation course is designed for beginners and working professionals who want to gain hands-on skills in Microsoft Excel for data entry, analysis, and productivity.

Module 1: Introduction to Microsoft Excel

• Overview of Excel Interface
• Workbook, Worksheet, Rows, Columns, and Cells
• Saving, Closing, and Opening Files
• Basic Excel Terminology

Module 2: Basic Data Entry and Formatting

• Entering and Editing Data
• Formatting Cells (Text, Numbers, Dates)
• Changing Font Style, Size, and Color
• Cell Alignment and Merge
• Applying Borders and Shading
• Using the Format Painter

Module 3: Basic Formulas and Functions

• Introduction to Formulas
• Basic Mathematical Operators (+, -, *, /)
• Common Functions: SUM(), AVERAGE(), MIN(), MAX(), COUNT()
• Copying Formulas with Autofill
• Relative and Absolute Cell References

Module 4: Working with Rows, Columns, and Sheets

• Inserting and Deleting Rows/Columns
• Hiding and Unhiding Rows/Columns
• Renaming, Adding, Deleting Worksheets
• Moving and Copying Worksheets

Module 5: Sorting and Filtering Data

• Sorting Data (Ascending/Descending)
• Applying Basic Filters
• Custom Sorting Options
• Clearing Filters

Module 6: Basic Charts and Visualization

• Introduction to Charts
• Creating Column, Bar, Line, and Pie Charts
• Formatting Charts (Title, Labels, Colors)

Module 7: Page Setup and Printing

• Adjusting Page Layout
• Print Preview
• Setting Margins and Orientation
• Adding Headers and Footers
• Printing Worksheets

Module 8: Basic Data Validation

• Understanding Data Validation
• Creating Drop-down Lists
• Preventing Invalid Data Entry

Module 9: Shortcut Keys and Productivity Tips

• Common Shortcut Keys
• Quick Navigation Techniques
• Tips for Efficient Data Entry

Module 10: Practical Assignments

• Hands-on Practice Files
• Real-life Examples (Sales Data, Attendance Sheets, etc.)
• Mini Projects for Practice

Register Now