What You'll Learn
- Relative and Absolute Cell References
- CONCATENATE function
- Date and DATEDIF Functions
- EDATE and EOMONTH Functions
- CHOOSE and SWITCH Functions
- LEFT, MID, RIGHT & LEN Functions
- UPPER, LOWER, PROPER & TRIM Functions
- YEAR, MONTH, DAY, HOUR, MINUTE & SECOND Functions
- SORT and SORTBY Functions
- FILTER and UNIQUE Function
- INDEX, MATCH, XMATCH and EXTACT Function
- Approximate MATCH and EXTACT Function
- VLOOKUP Function
- XLOOKUP Function
- Approximate MATCH with VLOOKUP Functions
- DROP DOWN List & Filtering
- Dependent DROP DOWN List
- Most Common Excel Shortcut Keys
Requirements
- No prior Excel experience is required
Who This Course is For
- Anyone who uses Excel and wants to save time and automate repetitive tasks.
- Students and professionals who want to improve their data analysis skills.
- Business owners and entrepreneurs who need to manage their finances and data more efficiently.
- Users looking to upgrade their skills and learn basic to advanced techniques.
Your Instructor
Skillify Academy
Data Analyst | Instructor at Udemy
4.1 Instructor Rating
286 Reviews
14,891 Students
13 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 3 days
Microsoft Excel Data Analysis: Become a Data Analysis Expert
Unlock Excel’s full power to clean, analyze, and visualize data—no experience needed to become a da…
Free 100% Off
Today
Expires in 3 days
The Complete Microsoft Excel Data Analysis and Pivot Tables
Master The Complete Microsoft Excel Data Analysis and Pivot Tables for Smarter Business Decisions &…
Free 100% Off
Today
Expires in 3 days
Advanced MS Word Excel PowerPoint Course for Job Success
MS Word Excel Powepoint From Beginner to Advanced for Professional
Free 100% Off
Today
Expires in 3 days
Advanced Microsoft Word With Job Success
Beginner to Expert Level - Fundamentals, Copy Cut, Paste, Font Design, Typography, Cases, Indent, A…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.