Live virtual Basic Excel Course Outline
A live virtual beginner Excel course teaching essential skills like formulas, formatting, charts, and data management through hands-on practice.
Mode online: Zoom ID will be shared via email and mobile with Specific timing and dates
Total Course Duration: 8 hours
Fee INR 1499/$299
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