Learn Excel from the ground up — master formulas, functions, charts, and data analysis tools for real world success.
Sub Category
- Microsoft
{inAds}
Objectives
- 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
Pre Requisites
- You only need access to Microsoft Excel (Office 365, 2019, 2021 or recommended) and a computer.
- No microsoft excel experience needed
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)