Become an Excel expert: learn essential skills and advanced techniques in one course.
Sub Category
- Microsoft
{inAds}
Objectives
- Working with Date and Time Functions
- Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
- Introduction to Pivot Tables and Pivot Charts
- Using Excel for Basic Data Analysis
- Advanced Lookup and Reference Functions (INDEX, MATCH)
- Array Formulas and Dynamic Arrays
- Advanced Conditional Formatting and Data Highlighting
- Working with Complex Text Functions
- Creating and Customizing Charts and Graphs
- Building Interactive Dashboards
- Advanced Data Visualization Techniques
- Recording and Running Basic Macros
- Using Solver for Optimization Problems
Pre Requisites
- No prior Excel experience needed
- A computer with Microsoft Excel installed (preferably Excel 2016 or later)
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)