Excel for Beginners - The Complete Course

About Course

What You Will Learn

By the end of this course, you will be able to:

Understand the basic structure and terminology of Excel, including workbooks, worksheets, rows, columns, cells, ranges, and the Excel interface (ribbon, tabs, formula bar, name box, and toolbars).
Create, open, save, and manage Excel workbooks efficiently.
Enter, edit, move, copy, and clear data in cells using both mouse actions and keyboard shortcuts.
Use autofill and autocorrect features to quickly populate data and create number patterns.
Insert, delete, and resize rows and columns, and adjust column widths for better readability.
Navigate spreadsheets effectively using keyboard commands and selection techniques.
Build basic formulas using mathematical operators and cell references.
Understand and apply relative and absolute cell references, and know when each should be used.
Edit formulas accurately using the Formula Bar to reduce errors.
Create and use named cells and ranges to make formulas easier to read and manage.
Use essential Excel functions, including:
- SUM to add values
- AVERAGE to calculate averages
- MAX and MIN to find highest and lowest values
- COUNT to count numeric entries
Format data professionally by:
- Applying number formats (General, Currency, Accounting, Dates, Percentages)
- Aligning text and numbers
- Formatting rows, columns, and headers
- Using Format Painter to copy formatting quickly
Create basic charts to visually represent data and understand how charts enhance data analysis.
Prepare spreadsheets for printing, including page layout, scaling, and print settings.
Understand basic publishing and sharing options for Excel workbooks.

By the end of this course, you will be able to:
Understand the basic structure and terminology of Excel, including workbooks, worksheets, rows, columns, cells, ranges, and the Excel interface (ribbon, tabs, formula bar, name box, and toolbars).
Create, open, save, and manage Excel workbooks efficiently.
Enter, edit, move, copy, and clear data in cells using both mouse actions and keyboard shortcuts.
Use autofill and autocorrect features to quickly populate data and create number patterns.
Insert, delete, and resize rows and columns, and adjust column widths for better readability.
Navigate spreadsheets effectively using keyboard commands and selection techniques.
Build basic formulas using mathematical operators and cell references.
Understand and apply relative and absolute cell references, and know when each should be used.
Edit formulas accurately using the Formula Bar to reduce errors.
Create and use named cells and ranges to make formulas easier to read and manage.
Use essential Excel functions, including:
SUM to add values
AVERAGE to calculate averages
MAX and MIN to find highest and lowest values
COUNT to count numeric entries
Format data professionally by:
Applying number formats (General, Currency, Accounting, Dates, Percentages)
Aligning text and numbers
Formatting rows, columns, and headers
Using Format Painter to copy formatting quickly
Create basic charts to visually represent data and understand how charts enhance data analysis.
Prepare spreadsheets for printing, including page layout, scaling, and print settings.
Understand basic publishing and sharing options for Excel workbooks.

Course Content

Creating Workbooks, The Anatomy of a Spreadsheet, and Spreadsheet Terminology
This section introduces how to start Excel, create new blank workbooks, and understand templates. It then delves into the basic structure of a spreadsheet, explaining terms like sheets, workbooks, columns, rows, cells, active cells, and ranges, as well as how to describe and reference them. also covers the Excel layout, including tabs, ribbons, groups, launch buttons, scroll bars, zoom sliders, view buttons, the name box, quick access toolbar, and the formula bar. The segment concludes with instructions on saving a new workbook for the first time.

Creating Workbooks, Spreadsheet Anatomy & Excel Terminology
1. What Is Excel?
2. Creating a New Workbook
3. Anatomy of a Spreadsheet
4. Excel Interface Components
5. Saving a Workbook
🧪 Practice Activity
A workbook?
Application

Entering Cell Values and Data in Excel
This part focuses on the process of inputting data into cells. It introduces the "select to effect" principle, demonstrating how to select a cell and type in values, then confirm entry with the Enter key. The video explains how to use the autofill handle to extend patterns for series of numbers or to quickly copy data. It also details how to edit existing cell contents by double-clicking and using the cursor, and how to navigate cells using Enter (down), Shift+Enter (up), Tab (right), and Shift+Tab (left). Additionally, it covers copying and pasting data using keyboard shortcuts (Ctrl+C, Ctrl+V), overwriting cell contents, and completely clearing cells or ranges using the Home tab's clear options. The section also shows how to insert new rows and columns, adjust column widths for fitting text, and use Find and Replace for quick data updates. Finally, it explores Excel's autocorrect features for automating text entry and how to move cell contents using drag-and-drop.

Entering Cell Values and Data in Excel
1. Selecting Cells: “Select to Effect”
2. Entering Data into Cells
3. Editing Existing Cell Data
4. Navigating Cells with the Keyboard
5. Copying and Pasting Data
6. AutoFill Handle (Very Important)
7. Clearing Cell Contents
8. Inserting Rows and Columns
9. Adjusting Column Widths
10. Moving Cell Data (Drag & Drop)
11. Find & Replace
12. AutoCorrect in Excel
🧪 Practice Activity
Knowledge Check
AutoFill
Application

Formulas
This segment explains the concept of formulas in Excel, emphasizing their role in performing calculations. It demonstrates how to start a formula with an equals sign and use mathematical operators like asterisk for multiplication. Crucially, it introduces the use of cell references (e.g., C2*D2) within formulas, explaining that these create dynamic calculations that update automatically if the referenced cell values change. The video highlights the convenience of clicking on cells to insert their references into formulas and explains the difference between relative and absolute cell references, demonstrating how dollar signs ($) can be used to make a cell reference absolute so it doesn't change when copied. It also touches on common formula errors and introduces the formula bar as a better place to edit formulas. Lastly, it briefly shows how to name individual cells or ranges for easier reference in formulas.

Lesson Objectives
1. What Is a Formula in Excel?
2. Mathematical Operators in Excel
3. Using Cell References in Formulas
4. Creating Formulas by Clicking Cells
5. Editing Formulas (Why Use the Formula Bar?)
6. Relative Cell References (Default Behavior)
7. Absolute Cell References
8. Mixed Cell References
9. Common Formula Errors
10. Naming Cells and Ranges
Practice Activity
Concept Check
Concept Check 2
Application)

Functions: SUM, AVERAGE, MAX, MIN, COUNT
This section clarifies the distinction between formulas and functions in Excel. It introduces the SUM function for adding numbers in a range, explaining how to type the function name followed by a parenthesis and then the cell range (e.g., =SUM(D2:D71)). It shows how to use the auto sum feature for quick summation. The video then demonstrates other common functions: AVERAGE for calculating the average of a range, MAX for finding the highest value, MIN for finding the lowest value, and COUNT for counting the number of cells containing numbers in a range. It also revisits how named ranges can be used with functions.

Lesson Objectives
1. What Is a Function in Excel?
2. Understanding Function Syntax
3. The SUM Function
4. The AVERAGE Function
5. The MAX Function
6. The MIN Function
7. The COUNT Function
8. Selecting Ranges Efficiently
9. Using Named Ranges with Functions
Practice Activity
Knowledge Check
Knowledge Check #2
Application

Formatting Numbers, Text, Cells, Rows, and Columns
This part focuses on enhancing the visual presentation of data. It shows how to change number formats, specifically distinguishing between "General," "Currency," and "Accounting" formats and their visual differences. It briefly mentions other number formats like dates, times, and percentages. For text, it explains the default left alignment and how numbers typically align to the right. The video demonstrates how to format entire rows, such as bolding column titles and centering text within cells using alignment options. It also introduces a shortcut for copying formatting from one cell to others using the "Format Painter."

1. Why Formatting Matters
2. Number Formatting Basics
3. Currency vs Accounting Format
4. Formatting Text in Cells
5. Aligning Text and Numbers
6. Formatting Rows and Columns
7. Borders and Fill Colors
8. Using Format Painter
9. Adjusting Column Widths and Row Heights
10. Clearing Formatting
Practice Activity
Knowledge Check
Knowledgecheck #2
Application

Creating and Editing Charts
This segment briefly introduces the process of visualizing data using charts.

Lesson Objectives
1. Why Use Charts?
2. Preparing Data for a Chart
3. Selecting Data for a Chart
4. Creating a Chart
5. Common Chart Types and When to Use Them
6. Editing a Chart
7. Adding and Editing Chart Elements
8. Moving and Resizing Charts
9. Formatting Charts
🧪 Practice Activity
Knowledge Check)
Knowledge check #2
Application

Print Options and Publishing Options
This final section covers how to prepare and manage Excel workbooks for printing and publishing.

Lesson Objectives
1. Why Print Setup Matters
2. Accessing Print Options
3. Print Preview
4. Page Orientation
5. Page Size and Margins
6. Scaling Options (Very Important)
7. Setting Print Area
8. Page Breaks
9. Printing Titles on Every Page
10. Headers and Footers
11. Publishing and Sharing Options
12. Final Print Checklist
🧪 Practice Activity

Student Ratings & Reviews

No Review Yet

About Course

What You Will Learn

What Will You Learn?

Course Content

Creating Workbooks, Spreadsheet Anatomy & Excel Terminology

1. What Is Excel?

2. Creating a New Workbook

3. Anatomy of a Spreadsheet

4. Excel Interface Components

5. Saving a Workbook

🧪 Practice Activity

A workbook?

Application

Entering Cell Values and Data in Excel

1. Selecting Cells: “Select to Effect”

2. Entering Data into Cells

3. Editing Existing Cell Data

4. Navigating Cells with the Keyboard

5. Copying and Pasting Data

6. AutoFill Handle (Very Important)

7. Clearing Cell Contents

8. Inserting Rows and Columns

9. Adjusting Column Widths

10. Moving Cell Data (Drag & Drop)

11. Find & Replace

12. AutoCorrect in Excel

🧪 Practice Activity

Knowledge Check

AutoFill

Application

Lesson Objectives

1. What Is a Formula in Excel?

2. Mathematical Operators in Excel

3. Using Cell References in Formulas

4. Creating Formulas by Clicking Cells

5. Editing Formulas (Why Use the Formula Bar?)

6. Relative Cell References (Default Behavior)

7. Absolute Cell References

8. Mixed Cell References

9. Common Formula Errors

10. Naming Cells and Ranges

Practice Activity

Concept Check

Concept Check 2

Application)

Lesson Objectives

1. What Is a Function in Excel?

2. Understanding Function Syntax

3. The SUM Function

4. The AVERAGE Function

5. The MAX Function

6. The MIN Function

7. The COUNT Function

8. Selecting Ranges Efficiently

9. Using Named Ranges with Functions

Practice Activity

Knowledge Check

Knowledge Check #2

Application

1. Why Formatting Matters

2. Number Formatting Basics

3. Currency vs Accounting Format

4. Formatting Text in Cells

5. Aligning Text and Numbers

6. Formatting Rows and Columns

7. Borders and Fill Colors

8. Using Format Painter

9. Adjusting Column Widths and Row Heights

10. Clearing Formatting

Practice Activity

Knowledge Check

Knowledgecheck #2

Application

Creating and Editing Charts This segment briefly introduces the process of visualizing data using charts.

Lesson Objectives

1. Why Use Charts?

2. Preparing Data for a Chart

3. Selecting Data for a Chart

4. Creating a Chart

5. Common Chart Types and When to Use Them

Creating and Editing Charts
This segment briefly introduces the process of visualizing data using charts.

Print Options and Publishing Options
This final section covers how to prepare and manage Excel workbooks for printing and publishing.