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.1 Instructor Rating
826 Reviews
32,750 Students
12 Courses
Related Courses
More free Office Productivity courses you might be interested in
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
The Complete Microsoft Excel Data Analysis Basic to Advanced
Microsoft Excel Data Analysis: Build Your Excel Data Analysis Skills from Scratch and Advance to Pr…
Free 100% Off
Today
Expires in 3 days
Microsoft Excel Formulas and Functions For Basic to Expert
Master Every Essential and Advanced Excel Formula & Function to Boost Productivity, Analyze Data & …
Free 100% Off
Today
Expires in 3 days
SAP Analytics Cloud - Beginner's Special
Simplifying SAP Analytics Cloud for New and advanced Learners
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.