MS Excel – You will Love Excel Just in 05 Hours

Dive into the world of Microsoft Excel with this easy-to-follow course. It’s perfect for those starting out or looking to refresh their skills. You’ll learn the basics of Excel, from understanding the layout to organizing data neatly. We’ll guide you through creating eye-catching charts, performing simple calculations, and managing lists effectively. Plus, you’ll get tips on how to keep your data safe and share it with others smoothly. By the end of this course, you’ll be comfortable using Excel for everyday tasks, making your work or study life easier and more organized.

Syllabus Content

I. Introduction to Excel

1. Basic Parts of Excel Window
2. How to Save
3. How to Page Setup & Print

II. Data Entry and Formatting

1. Items in Group Clipboard (Home Tab)
2. Items in Group Font (Home Tab)
3. Items in Group Alignment (Home Tab)
4. Items in Group Number (Home Tab)
5. Inserting Pictures, Shapes & Smart Art
6. Inserting Equation & Symbol
7. Insert a Dropdown List
8. Check Spelling
9. How to Hide Gridlines

III. Data Manipulation and Analysis

1. Items in Group Editing (Home Tab)
2. Sum, Average, Rank, Max & Min
3. Count & CountA
4. Upper, Lower & First Letter Capital
5. Combine Word from Different Cells
6. Columns to Rows & Vice Versa
7. Group Ungroup Columns and Rows
8. Remove Duplicates
9. Splitting Data in a Cell
10. Converting Numbers into Words
11. Finding Number of Characters in a Cell
12. Using LEFT, RIGHT, and MID Functions
13. Removing Extra Spaces Inside a Cell

IV. Data Visualization

1. Working with Charts
2. Inserting Graphs Inside a Cell
3. Use of Slicer
4. Interactive Dashboard using Hyperlink
5. Pivot Tables

V. Data Organization and Reference

1. Items in Group Cells (Home Tab)
2. Items in Group Styles (Home Tab)
3. Freeze Rows & Columns
4. Relative, Absolute, and Mixed References
5. How to use VLOOKUP
6. How to use HLOOKUP
7. Using ISNA with VLOOKUP
8. Trace Precedents
9. Trace Dependents
10. Monitoring Cells with Watch Window

VI. Advanced Excel Functions

1. IF function
2. Eliminating Blank Rows
3. Adding Current Date and Time
4. Auto Time Using VBA
5. Locking Certain Cells in a Worksheet
6. Protecting a Workbook
7. Password Protect Excel File
8. Calculating Loan Installments
9. Using Scenario Manager for What-If Analysis
10. Implementing Goal Seek for Data Optimization
11. Using Match Formula
12. Basic Macro

VII. Data Integration and Collaboration

1. Import Data Using Queries
2. How to use Smart Lookup
3. How to use Translate
4. How to use Comments
5. Finding Age
6. Finding Hours Worked
7. Workbook Statistics