Microsoft Excel: Basic Excel Course

About Course

This Basic Excel Course is designed for beginners who want to learn the fundamentals of Microsoft Excel. The course covers essential functions, formulas, and tools to help users create, format, and manage spreadsheets effectively. Whether you’re a student, professional, or business owner, this course will provide you with the foundational skills to improve productivity and data organization.

Course Objectives

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

Understand the Excel interface and navigation
Enter, format, and manipulate data in spreadsheets
Use basic formulas and functions (SUM, AVERAGE, COUNT, etc.)
Create and format tables for better data organization
Apply basic charts and graphs for data visualization
Use sorting and filtering to manage data efficiently
Work with basic cell references and simple conditional formatting

Course Content

1. Introduction to Microsoft Excel

1. What is Excel?
2. Why it is used Excel?
3. The Excel Interface: Ribbons, tabs, Quick Access Toolbar, and the worksheet grid.
4. Workbooks and Worksheets: Creating, saving, and opening files (.xlsx format).
5. Navigating Excel: Using the mouse, keyboard shortcuts, and scroll features.
6. Quick Access Toolbar: Customizing the Quick Access Toolbar
Quizzes

2.Working with Cells and Data

3.Basic Formatting

4.Performing Calculations

5.Managing Worksheets

6.Managing Data in Excel

7.Creating Simple Charts and Tables

8.Introduction to Tables

9.Printing and Sharing

Student Ratings & Reviews

No Review Yet

About Course

Course Objectives

What Will You Learn?

Course Content

1. Introduction to Microsoft Excel

1. What is Excel?

2. Why it is used Excel?

3. The Excel Interface: Ribbons, tabs, Quick Access Toolbar, and the worksheet grid.

4. Workbooks and Worksheets: Creating, saving, and opening files (.xlsx format).

5. Navigating Excel: Using the mouse, keyboard shortcuts, and scroll features.

6. Quick Access Toolbar: Customizing the Quick Access Toolbar

Quizzes

2.Working with Cells and Data

1. Row Column: Understanding cells, rows, and columns, Insert, Delete, Hide

2. Entering Data: Typing text, numbers, and dates into cells.

3. Adjusting Row & Column: Adjusting row height and column width.

4. Editing Data: Modifying cell contents, undoing/redoing changes.

5. Copy, Cut, and Paste: Moving and duplicating data within a worksheet.

6. AutoFill: Using the Fill Handle to quickly populate data series

Quizzes

3.Basic Formatting

1. Font Adjustments: Changing font size, style, and color.

2. Cell Formatting: Applying borders, fill colors, and alignment (left, center, right).

3. Number Formatting: Formatting numbers as currency, percentages, dates, etc.

4. Row and Column Adjustments: Resizing rows and columns, inserting/deleting them.

Basic Formatting Quizz

4.Performing Calculations

1. Basic Formulas: Introduction to the equals sign (=), addition (+), subtraction (-), multiplication (*), and division (/).

2. Common Functions: Using SUM, AVERAGE, MIN, MAX, and COUNT.

3. Cell References: Understanding relative references and copying formulas.

4. Order of Operations: How Excel handles parentheses and operator precedence.

Quizzes

5.Managing Worksheets

1. Worksheet Basics

2.Freezing Panes

3. Sorting Data

4. Filtering Data

Quizzes

6.Managing Data in Excel

1. Sorting and filtering data

2. Using Find and Replace

3. Data validation (drop-down lists)

4. Removing duplicates

Quizzes

7.Creating Simple Charts and Tables

1. Excel Tables: Converting data ranges into tables for easier management.

2. Basic Charts: Creating bar, column, pie, and line charts.

3. Chart Customization: Adding titles, labels, and adjusting colors.

Quizzes

8.Introduction to Tables

1. Creating and formatting tables

2. Sorting and filtering data in tables

3. Using table styles

Quizzes

9.Printing and Sharing

1.Page Layout: Setting margins, orientation (portrait/landscape), and page breaks.

2.Print Preview: Checking how the spreadsheet will look when printed.

3. Saving Options: Saving as Excel file, PDF, or sharing via email/OneDrive.

Quizz

Student Ratings & Reviews