Basic Excel Course

Module 1: Introduction to Excel

• Duration: 30 minutes
• Overview of Excel interface
• Understanding workbooks and worksheets
• Basic navigation and shortcuts

Module 2: Data Entry and Basic Formulas

• Duration: 1 hour
• Entering and editing data
• Basic formulas (SUM, AVERAGE, MIN, MAX, ETC)
• AutoFill and Flash Fill

Module 3: Formatting Worksheets

• Duration: 1 hour
• Formatting cells (font, color, borders)
• Number formatting (currency, percentage, date)
• Conditional formatting
• Data presentation

Module 4: Managing Data

• Duration: 1 hour
• Sorting and data filtration
• Using tables & Formats.
• Data validation
• Data Reading

Module 5: Basic Charts and Graphs

• Duration: 1 hour
• Creating and formatting charts
• Types of charts (bar, line, pie)
• Customizing chart elements
• Pareto Diagram

Module 6: Basic Data Analysis

• Duration: 1 hour
• Using PivotTables
• Basic data analysis tools (SUMIF, COUNTIF)
• Introduction to What-If Analysis

Module 7: Printing and Sharing

• Duration: 30 minutes
• Page layout and print settings
• Exporting to PDF
• Sharing workbooks

Module 8: Final Project

• Duration: 2 hours
• Applying learned skills to a real-world project
• Creating a comprehensive report
• Peer review and feedback