Excel: Advanced Formulas and Functions
With Oz du Soleil
Liked by 5,898 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
-
Virginia S.
Virginia S.
Sustainability, Procurement and Project Management
-
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
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