Introduction for beginners, virtual
 
1. Basic Interface and Concepts (15 minutes)
Excel Window:
Ribbon, Quick Access Toolbar, Formula Bar, Status Bar
Cells, Rows, and Columns:
Selecting cells, rows, and columns
Data Types:
Numbers, text, dates, times, formulas, functions
Basic Operations:
Entering data, formatting cells, saving and opening files
2. Formulas and Functions (20 minutes)
Basic Formulas:
Arithmetic operations (+, -, *, /, ^)
Order of operations
Common Functions:
SUM, AVERAGE, COUNT, MAX, MIN
Cell References:
Relative, absolute, and mixed references
Creating formulas with cell references
3. Formatting (10 minutes)
Cell Formatting:
Number formats, alignment, fonts, colors
Conditional Formatting:
Creating rules to highlight data based on conditions
4. Creating Charts (10 minutes)
Basic Chart Types:
Column, line, pie, bar, area, scatter
Creating a Chart:
Selecting data, choosing chart type, customizing appearance
5. Additional Topics (5 minutes)
Sorting and Filtering:
Arranging data in ascending or descending order, filtering data based on criteria
Data Validation:
Restricting data entry to specific values or ranges
Freezing Panes:
Keeping rows or columns visible while scrolling