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
3.9 Instructor Rating
213 Reviews
12,692 Students
13 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Yesterday
Limited Time
Office Productivity
English
Excel Data Analysis With Pivot Tables & Pivot Charts - 2025
Data analysis excel, data analysis, Pivot Chart, Microsoft excel, advanced excel, ms excel, Data An…
Free 100% Off
Yesterday
Limited Time
Office Productivity
English
Google Sheets at work : Impress Your Boss with Smart Works
MS Excel, Spread sheets , Microsoft Excel , G sheets , google spreadsheet, Google Workspace (G Suit…
Free 100% Off
Yesterday
Expires in 3 days
Office Productivity
Arabic
Microsoft Project from Zero to Pro بروجكت من الصفر للاحتراف
كورس مايكروسوفت بروجكت الكامل بالعربية
Free 100% Off
Yesterday
Expires in 3 days
Office Productivity
English
Mastering Power BI Report Design - Beginner to Advanced
A Full Guide to Creating Insightful Reports, Interactive Dashboards, and Effective Data Storytellin…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.