Level 1: Excel Basics

Duration: 10 Days

Part 1: Introduction to Microsoft Excel

• Understanding the Excel interface
• Workbook and worksheet basics
• Navigating and selecting cells
• Saving and opening files

Part 2: Data Entry and Formatting

• Entering data into cells
• Basic cell formatting (font, alignment, borders)
• Using fill handles for quick data entry
• Creating simple tables

Part 3: Basic Formulas and Functions

• Introduction to Excel formulas
• Basic mathematical operations (SUM, AVERAGE, COUNT)
• Relative and absolute cell references
• AutoSum and AutoFill

Part 4: Intermediate Formulas and Functions

• Using logical functions (IF, AND, OR)
• Working with text functions (CONCATENATE, LEFT, RIGHT)
• Date and time functions
• Error handling with IFERROR

Part 5: Data Manipulation

• Sorting and filtering data
• Basic chart creation (column, pie, bar)
• Introduction to data validation
• Printing and page setup

part 6: Practical Exercises and Review

• Real-world scenarios and problem-solving
• Review of course topics
• Q&A and open discussion