Quite helpful so long as an intermediate user with these advanced formulas takes the time to try and replicate exactly what the instructor is presenting before moving on to the next advanced function for a start. What would help even more is if the instructor could incorporate into the course several predominant mistakes in separate videos typically made in using each individual formula. Different practice scenarios after each function (or "challenges") would also be helpful.
Excel: Advanced Formulas and Functions
With Oz du Soleil
Liked by 5,892 users
Duration: 5h 10m
Skill level: Advanced
Released: 3/23/2023
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.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
LinkedIn Learning
Certificate of Completion
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
Timothy "Ed" Benner, MA
Timothy "Ed" Benner, MA
Writing Specialist/Coach at Ivy Tech Community College
-
Kylie Kuhn
Kylie Kuhn
Study Design Lead at Labcorp Biopharma Laboratory Services
-
Vernon Foxcroft
Vernon Foxcroft
KAM | Success through Focus
Contents
What’s included
- Practice while you learn 1 exercise file
- Test your knowledge 10 quizzes
- Learn on the go Access on tablet and phone