What You'll Learn
- Understanding the Basics of Formulas in Excel
- Cell References: Relative, Absolute, and Mixed
- Basic Arithmetic Operations in Excel
- Working with Text Functions (LEFT, RIGHT, MID, CONCATENATE)
- Using Logical Functions (IF, AND, OR)
- Basic Date and Time Functions (TODAY, NOW, DATE)
- Using Mathematical Functions (SUM, AVERAGE, ROUND, COUNT)
- Text Manipulation Functions (TRIM, LEN, SUBSTITUTE)
- Advanced Lookup Functions (XLOOKUP, MATCH)
- Advanced Statistical Functions (MEDIAN, MODE, STDEV)
- Financial Functions (NPV, IRR, PMT)
- Data Analysis with Logical Functions
- Combining Multiple Functions in a Single Formula
- Building Custom Functions with VBA
- Creating Dynamic Ranges with OFFSET and INDIRECT
- Advanced Charting Techniques with Formulas
- Automating Data Visualizations with Dynamic Formulas
Requirements
- No Excel Experience needed
Who This Course is For
- Anyone who uses Microsoft Excel and wants to significantly improve their skills.
- Students, professionals, data analysts, finance professionals, administrative staff, and anyone dealing with data.
- Intermediate Excel users looking to expand their knowledge and learn advanced techniques.
- Anyone preparing for job interviews that require strong Excel skills.
Your Instructor
Bright Path
Instructor at Udemy
4.2 Instructor Rating
625 Reviews
27,810 Students
12 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.