Advanced Excel
About Course
Course Details
Follow along with Excel MVP Oz du Soleil as he demystifies the many kinds of formulas and functions available in Excel. Oz starts with a few critical keyboard shortcuts that will speed up your work, and offers grounding in how to develop your own style working with formulas and functions. Next, Oz covers a variety of formulas such as the XLOOKUP/VLOOKUP and INDEX functions, counting and statistical functions, text functions, and date/time, array, math, and information functions. Oz provides practical examples to help viewers easily transition to using Excel’s most powerful formulas and functions in real-world scenarios. The course concludes with a series of challenges so you can test your knowledge.
Course Content
1. Introduction
-
Learning advanced formulas and functions using Excel
00:49 -
Developing your own style with formulas and functions
02:27 -
Challenges
01:12
2. Using table and dynamic arrays for data integrity and consistency
3. The world of if statements and conditions
4. Looking up, down, and all around: comparing and combining with lookups
5. Formula tips and strategies
6. Mid-term challenges
7. Date and time functions
8. Working with text and arrays
9. Statistical function
10. Math functions
11. Wild cards
12. New, handy, and fun functions
13. Find challenges
Student Ratings & Reviews
good
great course
This course is good for us to understand in advance other steps more in using excel and apply effectively to facilitate our daily work.