Master Excel formulas and functions to organize data, automate workflows, and create professional business dashboards!
Sub Category
- Microsoft
{inAds}
Objectives
- The difference between formulas and functions, and when to use each
- How to reference cells correctly (relative, absolute, mixed)
- Important math functions: SUM, AVERAGE, ROUND, and more
- Logical functions: IF, AND, OR, NOT
- Conditional calculations: SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIFS
- Text manipulation: LEFT, RIGHT, MID, TEXTJOIN, REPLACE, TRIM, SEARCH, FIND
- Date & time management: TODAY, WORKDAY, NETWORKDAYS, EOMONTH, DATEDIF
- Lookup mastery: INDEX, XLOOKUP, VLOOKUP, HLOOKUP, FILTER
- Error handling: IFERROR, ISERROR, ERROR.TYPE
- Charts, graphs, conditional formatting & the Analyze Data tool
- PivotTables, PivotCharts, GETPIVOTDATA & dynamic arrays
- Named ranges, dynamic print areas, and structured references
- Power Query fundamentals for automation
- VBA macro essentials
- How to design a professional sales dashboard
- How to use Excel Copilot to generate formulas, summaries, and insights
Pre Requisites
- Beginner knowledge of Excel is helpful but not required
- Microsoft Excel (2016 or later recommended)
- A desire to learn and practice!
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)