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 Excel knowledge is necessary.
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
Skillify Academy
Data Analyst | Instructor at Udemy
4.1 Instructor Rating
292 Reviews
15,116 Students
13 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 3 days
The Complete Microsoft Teams Course - Master Microsoft Teams
Master Microsoft Teams: Managing Microsoft Teams - Microsoft MS-700 - Microsoft Office 365 - Sharep…
Free 100% Off
Today
Expires in 3 days
Learn Advanced Excel: Formulas, Functions, VBA Macros
VBA Automation in Excel Unleash its True Power - Excel Macros and Dashboards: Automate and Analyze …
Free 100% Off
Today
Expires in 3 days
Excel Data Management and Analysis for Basic to Expert Level
From basics to advanced—learn Excel data management and analysis using real-world functions and tec…
Free 100% Off
Today
Expires in 3 days
Microsoft Excel: Complete Excel from Beginner to Advanced
Master Excel from scratch: Formulas, Functions, Data Analysis, VBA, and More! Master Excel essentia…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.