Practice tests for Excel formulas, PivotTables, Power Query, charts, statistics, and VBA data analysis
Sub Category
- Microsoft
{inAds}
Objectives
- Apply Excel formulas and functions (VLOOKUP, XLOOKUP, SUMIFS, dynamic arrays) to solve real-world data analysis problems
- Build and analyze PivotTables, including grouping, slicers, calculated fields, and PivotCharts for reporting
- Clean, transform, and combine data sources using Power Query (Get & Transform) and the M language
- Test your knowledge of charts, conditional formatting, statistical analysis tools, and VBA macro automation
Pre Requisites
- A basic, working familiarity with Excel (opening a workbook, entering data, using simple formulas like SUM) is helpful but not required. Each practice test includes detailed explanations, so complete beginners can learn as they go, and no prior programming experience is 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)