What You'll Learn
- Overview of Microsoft Excel Interface
- Navigating the Ribbon, Tabs, and Menus
- Understanding Workbooks, Worksheets, and Cells
- Basic Shortcuts to Improve Productivity
- Entering and Formatting Data
- Performing Basic Calculations
- Sum, Subtraction, Multiplication, and Division
- Formatting Basics: Fonts, Borders, and Colors
- Adjusting Row Height and Column Width
- Sorting and Filtering Data
- Data Validation for Accurate Inputs
- Removing Duplicates
- Basic Functions:SUM, AVERAGE, MIN, MAX
- Logical Functions:IF, AND, OR, NOT
- Lookup Functions:VLOOKUP, HLOOKUP, XLOOKUP
- Text Functions: CONCATENATE, LEFT, RIGHT, MID, LEN, TRIM
- Date and Time Functions: TODAY, NOW, NETWORKDAYS, DATEDIF
- Error Handling Functions: IFERROR, ISERROR
- Summarizing Data with Pivot Tables
- Creating Pivot Charts
- Grouping, Filtering, and Slicing Data
- Using Named Ranges
- Introduction to Macros
Requirements
- No prior knowledge required
- A computer with internet access
- Eagerness to learn
Who This Course is For
- Anyone who wants to work smarter and more efficiently with data
- Business professionals, students, entrepreneurs, and job seekers
- Who want to upgrade their skills to an basic to advanced level
- Who want to learn Excel from scratch
Your Instructor
Experienced Instructor
Professional Educator
An experienced instructor with expertise in this field and a passion for teaching.
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Limited Time
Mastering Excel Data Analysis Techniques: Unlock Insights
Learn Advanced Excel Tools, Functions, and Visualization Methods to Analyze Data and Make Smarter B…
Free 100% Off
Today
Limited Time
SAP AI Engineering Bootcamp: Joule, AI Core & Apps
Build enterprise AI apps with SAP BTP, Joule & AI Core. Go from beginner to SAP AI Engineer with re…
Free 100% Off
Today
Limited Time
SAP Production Planning (PP) Module
Learn SAP Production Planning (PP) Module along with certification based practice test and Mock Int…
Free 100% Off
04 August 2026
Limited Time
Mastering Excel Data Visualization with Design Chart & Graph
Master Excel’s Visualization Tools to Build Dynamic Dashboards and Communicate Data Effectively.
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.