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
627 Reviews
27,930 Students
13 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 1 day
Microsoft Excel for Beginners: Excel for Everyday Use
Learn Essential Excel Skills to Organize Data, Create Reports, and Simplify Everyday Tasks with Con…
Free 100% Off
Today
Expires in 1 day
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
Yesterday
Expires in 1 day
Data Analysis and Data Visualization with Copilot in Excel
Create and insert Excel formulas, pivot tables, charts etc. and run Python in Excel for advanced an…
Free 100% Off
Yesterday
Expires in 1 day
Advanced Excel: Power Query, Power Pivot and DAX
Master Data Import, Cleaning, Modeling, and Analysis Using Power Query, Power Pivot, and DAX in Exc…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.