This course outline accommodates the 20-hour duration for the entire module, with a focus on basic-level skills relevant to hospitality management. Three Free one-on-one sessions ( 1 hour each ) are included in this course, any additional session can be booked @Rs.250/- per hour.

This Basic Course serves as a foundation for participants before they transition to the more advanced Intermediate Excel Mastery course focused on Hospitality. The live support sessions allow for a seamless transition and provide ongoing assistance as they delve into more complex Excel functionalities.
This Basic Course titled "Introduction to Basic Excel," designed as a precursor to the Intermediate Excel Mastery course focused on Hospitality:

Module 1: Excel Fundamentals (2.5 hours)

• Session 1: Welcome and Overview (30 mins)

  • Introduction to the Excel software
  • Importance of Excel in business and data management

• Session 2: Navigating Excel (1 hour)

  • Excel interface overview
  • Basic navigation, cell selection, and shortcuts

• Session 3: Data Entry and Formatting (1.5 hours)

  • Entering data into cells
  • Basic formatting techniques for clarity

Module 2: Basic Formulas and Functions (2.5 hours)

• Session 1: Introduction to Formulas (1 hour)

  • Understanding cell references
  • Basic mathematical operations

• Session 2: Common Functions (1.5 hours)

  • SUM, AVERAGE, COUNT functions
  • Introduction to basic logical functions

Module 3: Data Management (2.5 hours)

• Session 1: Sorting and Filtering (1 hour)

  • Sorting data in Excel
  • Filtering data for analysis

• Session 2: Basic Charts and Graphs (1.5 hours)

  • Creating simple charts for data visualization

Module 4: Introduction to Collaboration (2.5 hours)

• Session 1: Basic Data Sharing (1 hour)

  • Overview of sharing workbooks
  • Sending and receiving Excel files

• Session 2: Introduction to Comments and Collaboration (1.5 hours)

  • Adding comments to cells
  • Basic collaboration features in Excel

Module 5: Live Support and Transition to Intermediate Course (5 hours)

• Session 1-5: Weekly Live Support and Q&A Sessions (1 hour each)

  • Addressing specific challenges faced during the Basic Excel course
  • Clarification on concepts and techniques

• Session 6: Overview and Transition to Intermediate Course (1 hour)

  • Preview of the Intermediate Excel Mastery course
  • How the advanced concepts build upon the basics

Additional Information:

• Resources and Materials:

  • Provide templates, sample data sets, and additional resources for continued practice.

• Assessment:

  • Short quizzes after each module.
  • Completion of basic projects demonstrating understanding.