Microsoft Excel – Basic Excel Course

About Course

“This Microsoft Excel Basic Course is designed for beginners to build a strong foundation in Excel. You’ll learn how to navigate the interface, manage data, apply formatting, use basic formulas & functions, create charts, and prepare professional reports. Perfect for students, professionals, and business owners to improve productivity and confidence with Excel.”

Course Content

1. Introduction to Microsoft Excel

Overview of Excel: What is Excel, and why is it used?
The Excel Interface: Ribbons, tabs, Quick Access Toolbar, and the worksheet grid.
Understanding Workbooks and Worksheets: Creating, saving, and opening files (.xlsx format).
Navigating Excel: Using the mouse, keyboard shortcuts, and scroll features.
Quick Access Toolbar: Customizing the Quick Access Toolbar
Data Types: Text, Numbers, Dates, and Formulas

2. Working with Cells and Data and basic excel operation

3. Formatting Worksheets

4. Formulas and Basic Functions

5. Managing Worksheets

6. Managing Data in Excel

7. Charts and Graphs

8. Data Formatting

9. Introduction to Tables

10. Printing and Page Layout and Sharing

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

1. Introduction to Microsoft Excel

Overview of Excel: What is Excel, and why is it used?

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

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

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

Quick Access Toolbar: Customizing the Quick Access Toolbar

Data Types: Text, Numbers, Dates, and Formulas

2. Working with Cells and Data and basic excel operation

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

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

Adjusting Row & Column: Adjusting row height and column width

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

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

AutoFill: Using the Fill Handle to quickly populate data series 3. Basic Formatting: – Font Adjustments:

3. Formatting Worksheets

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

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

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

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

Hide/Unhide Rows and Columns

4. Formulas and Basic Functions

Introduction to formulas (operators, cell references)

Basic Arithmetic Formulas: (+, -, *, /)

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

Understanding Relative, Absolute, and Mixed Cell References

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

Cell References: Understanding relative referencesand copying formulas.

5. Managing Worksheets

Insert, Rename, Move, Copy, Delete Worksheets

Freeze Panes, Split Screen, and Zoom

Sorting Data: Arranging data alphabetically or numerically

Filtering Data: Using simple filters to view specific data subsets.

6. Managing Data in Excel

Sorting and filtering data

Using Find and Replace

Data validation (drop-down lists)

Removing duplicates

7. Charts and Graphs

Creating basic charts (column, bar, line, pie)

Formatting Charts (Titles, Labels, Colors)

Sparklines for in-cell visuals

8. Data Formatting

Conditional formatting (highlight cells, data bars)

Cell styles and themes

9. Introduction to Tables

Creating and formatting tables

Sorting and filtering data in tables

Using table styles

10. Printing and Page Layout and Sharing

Page setup (margins, orientation, headers/footers)

Print areas and scaling

Setting Print Area and Page Breaks

Exporting to PDF/email

Student Ratings & Reviews