What You'll Learn
- Introduction to Excel Formulas and Functions
- Understanding the Excel Interface and Formula Bar
- Using Cell References (Relative, Absolute, Mixed References)
- Order of Operations in Excel Formulas
- SUM, AVERAGE, COUNT, MIN, MAX Functions
- Date and Time Functions (TODAY, NOW, DATEDIF, YEAR, MONTH, DAY)
- Logical Functions (IF, AND, OR, NOT).
- Combining INDEX and MATCH for Flexible Lookups
- Handling Errors with ISERROR and IFERROR
- COUNTIF, SUMIF, AVERAGEIF, and Their Plural Counterparts (COUNTIFS, SUMIFS, AVERAGEIFS)
- RANK, LARGE, SMALL, and PERCENTILE Functions
- Analyzing Trends with TREND and FORECAST Tunctions
- Dynamic Arrays and Spill Behavior
- Functions Like FILTER, SORT, UNIQUE, SEQUENCE, and RANDARRAY
- Practical Use Cases for Dynamic Arrays
- Nesting Multiple Functions Within One Formula
- Using Conditional Formatting With Formulas
- Advanced Logical Functions (IFS, SWITCH)
- Error Handling with ISNUMBER, ISBLANK, and CHOOSE
- PMT, IPMT, PPMT For Loan Calculations
- NPV, IRR, and XIRR for Investment Analysis
- CONVERT Function for Unit Conversions
- Goal Seek and Solver Add-ins for Optimization Problems
Requirements
- No prior knowledge required
- A computer with internet access
- Eagerness to learn
Who This Course is For
- Anyone who wants to save time and get the most out of Microsoft Excel.
- Anyone who wants learn Microsoft Excel.
- Students and professionals who want to improve their excel skills.
- Entrepreneurs and office workers who prepare financial report regularly.
Your Instructor
Experienced Instructor
Professional Educator
An experienced instructor with expertise in this field and a passion for teaching.
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Limited Time
The Complete Microsoft Excel Course: Master All Levels
Learn Excel the smart way — automate tasks, analyze data, and make informed business decisions.
Free 100% Off
Today
Limited Time
Microsoft Excel: Data Analysis, Management and Visualization
Become an Excel expert! From basic spreadsheets to advanced data analysis, automation, and dashboar…
Free 100% Off
20 July 2026
Limited Time
Microsoft Office: Word, Excel, PowerPoint من الصفر للاحتراف
تعلم برامج الاوفيس ; الوورد , البوربوينت و الاكسل من المستوى المبتدئ للمستوى المتقدم - 3 كورسات في 1
None$ None% Off
20 July 2026
Limited Time
www.udemy.com
تعلم برامج الاوفيس ; الوورد , البوربوينت و الاكسل من المستوى المبتدئ للمستوى المتقدم - 3 كورسات في 1
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.