Excel Beginner Course (12hrs)

Objective: Gain foundational Excel skills, including data entry, formatting, and basic formulas.

Module 1 : Introduction to Excel ( 2hrs)

  • Overview of the Excel interface and ribbons
  • Creating, saving, and opening workbooks
  • Understanding rows, columns, and cells
  • Basic data entry and editing

Module 2 : Formatting and Customization (2 Hours)

  • Cell formatting (font, colors, borders, alignment)
  • Number formatting (currency, date, percentage, custom formats)
  • Adjusting row height and column width
  • Merging and centering cells
  • Freezing panes and splitting windows

Module 3 : Basic Formulas & Functions (2 Hours)

  • Introduction to formulas and cell references
  • Arithmetic operations (addition, subtraction, multiplication, division)
  • Common functions: SUM, AVERAGE, MIN, MAX, COUNT
  • Autofill and Flash Fill

Module 4 :Managing Worksheets & Workbooks (2 Hours)

  • Adding, renaming, and deleting sheets
  • Moving and copying data across sheets
  • Workbook views and page setup for printing

Module 5 : Introduction to Charts & Graphs (2 Hours)

  • Creating basic bar, line, and pie charts
  • Customizing chart elements
  • Printing and exporting charts

This course provides a structured learning path from beginner to advanced Excel skills, covering data analysis, automation, business intelligence tools, and real-world applications.

Scroll to Top