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.