Learn every essential Excel formula and function, from basic calculations to advanced data analysis techniques.
Sub Category
- Microsoft
{inAds}
Objectives
- 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
Pre Requisites
- No 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)