Master Excel fundamentals in this comprehensive 2-hour tutorial that takes you from complete beginner to confident user. Start with Excel basics including interface navigation, workbook and worksheet management, and data entry techniques for numbers, dates, and times. Learn essential formatting skills including table creation, conditional formatting, and layout design, then progress to powerful formulas and functions such as SUM, AVERAGE, VLOOKUP, and XLOOKUP with proper cell referencing. Discover how to create and customize charts for data visualization, implement sorting and filtering for data analysis, and build pivot tables for advanced data summarization. Explore productivity features like flash fill for data manipulation, freeze and split panes for better worksheet navigation, and multi-worksheet management techniques. Gain practical skills in collaboration through worksheet protection, password security, workbook sharing, and version control. Complete your learning with comprehensive printing techniques including page setup, headers and footers, and print area customization to produce professional-looking reports and documents.

Syllabus

1-1. Introduction: Welcome to Excel for Beginners
1-2. Introduction: What is Excel
1-3. Introduction: How to get Excel
2-1. Main interface: Start screen
2-2. Main interface: Workbook and worksheet
2-3. Main interface: Tabs and ribbon
2-4. Main interface: Navigate through a worksheet
2-5. Main interface: Navigate through a workbook
2-6. Main interface: Help
3-1. Enter data: Numbers
3-2. Enter data: Column width and row height
3-3. Enter data: Dates and times
3-4. Enter data: Select cells to enter data quickly
4-1. Save workbook: Save workbook
4-2. Save workbook: Benefits of saving a workbook in the cloud
5-1. Format, layout, and design: Basic formatting
5-2. Format, layout, and design: Tables
5-3. Format, layout, and design: Insert rows and columns
5-4. Format, layout, and design: Copy and move
5-5. Format, layout, and design: Conditional formatting
5-6. Format, layout, and design: Hide rows and columns
5-7. Format, layout, and design: Find and replace
6-1. Formulas and functions: Status bar for basic metrics
6-2. Formulas and functions: Enter a basic formula with addition and subtraction
6-3. Formulas and functions: Repeat formulas
6-4. Formulas and functions: Relative and absolute references
6-5. Formulas and functions: Division
6-6. Formulas and functions: Order of operations
6-7. Formulas and functions: Commons functions including SUM, MAX, MIN, COUNT, and AVERAGE
6-8. Formulas and functions: VLOOKUP function
6-9. Formulas and functions: XLOOKUP function
7-1. Charts: Insert and format charts
7-2. Charts: Analyze data to generate charts
8-1. Sorting and filtering: Sort
8-2. Sorting and filtering: Filter
8-3. Sorting and filtering: Worksheet views
9-1. Pivot tables: All about pivot tables
10-1. Flash fill: Separate and merge data using flash fill
11-1. Adjust worksheet views: Freeze panes
11-2. Adjust worksheet views: Split panes
12-1. Multiple worksheets and workbooks: Rename and color worksheets
12-2. Multiple worksheets and workbooks: Add and delete worksheets
12-3. Multiple worksheets and workbooks: Hide and unhide worksheets
12-4. Multiple worksheets and workbooks: Move and copy worksheets
12-5. Multiple worksheets and workbooks: Worksheet groups
13-1. Share and collaborate: Protect worksheet
13-2. Share and collaborate: Protect workbook
13-3. Share and collaborate: Password protect workbook
13-4. Share and collaborate: Share workbook
13-5. Share and collaborate: Version history
14-1. Print: Print selection
14-2. Print: Set print area
14-3. Print: Hide column
14-4. Print: Page settings
14-5. Print: Adjust columns
14-6. Print: Repeat headers
14-7 Print: Headers and footers
14-8. Print: Show gridlines
14-9. Print: Page break view
15-1. Wrap up: Wrap up