How Long Can I Access The Course For?
For as long as you like, one payment, lifetime access.
Trusted by
Why Study This Course
Step up to Excel mastery with advanced techniques that transform your data analysis capabilities. This course explains Excel 2021's most powerful features in detail, including dynamic arrays, advanced lookup functions, and sophisticated statistical tools.
You'll learn to efficiently manage large datasets with advanced PivotTables and PivotCharts, integrate new functions like LET and LAMBDA for streamlined calculations, and employ form controls for interactive data presentation.
Discover how to automate repetitive tasks with Macros and VBA and enhance your predictive analytics skills through advanced forecasting methods.
Whether aiming to refine your data processing skills or becoming a go-to Excel expert in your workplace, this course provides the tools and knowledge to leverage Excel at its full potential.
Join now and turn complex data into clear insights that inform strategic decisions, ensuring you remain indispensable in any data-driven role.
STUDENT SUCCESS STORIES
My Excel skills have improved more than I ever imagined. The variety of courses is amazing, and the trainers are easy to follow and understand.
Sheryl Watts
Your step-by-step explanations and exercises helped me a great deal.
Frank Uchegbu
Everything is thoroughly explained in a clear and concise way, starting from the very beginning so that anyone without any prior knowledge can easily follow the explanations.
Bianca Esteban
CURRICULUM
Browse the curriculum of our video-led course to see all the topics covered.
Watch the Free Preview lessons to get a taste - try before you buy.
Section 1: Introduction
Available in
days
days
after you enroll
Section 2: Dynamic Arrays
Available in
days
days
after you enroll
- What are Dynamic Arrays? (2:14)
- Introduction to Spills and Arrays (10:49)
- Extract and Count Unique Entries (6:14)
- Unique vs Distinct (3:23)
- Extract Unique Values with Multiple Criteria (3:11)
- Extract Unique Values by Column (4:23)
- The SORT Function (8:53)
- The SORT Function - Horizontal SORT (6:06)
- The SORTBY Function (6:10)
- The SORTBY Function - Horizontal SORT (3:05)
- Simple SEQUENCE and Unstacking Records (10:10)
- The FILTER Function (6:51)
- FILTER with Logic: + Operator (OR) (4:48)
- FILTER with Logic: * Operator (AND) (5:39)
- FILTER with Logic: = Operator (Both or Neither) (4:11)
- FILTER with Logic: - Operator (One or the Other) (4:49)
- Using RANDARRAY and RANDBETWEEN to Randomize Data (9:44)
- Using XLOOKUP to Perform Complex Lookups (12:22)
- Using XMATCH (6:20)
- Exercise 02 (13:09)
Section 3: Advanced Lookup and Reference Functions
Available in
days
days
after you enroll
Section 4: Statistical Functions
Available in
days
days
after you enroll
Section 5: Math Functions
Available in
days
days
after you enroll
Section 6: New Functions - LET and LAMBDA
Available in
days
days
after you enroll
Section 7: Advanced PivotTables and Pivot Charts
Available in
days
days
after you enroll
- Creating a Custom PivotTable Style (9:47)
- Applying Custom Number Formatting (10:01)
- Sorting Using Custom Lists (4:38)
- Applying Multiple Filters to Data (5:06)
- Adjusting Slicer Settings (12:02)
- Locking Workbooks but not Slicers (3:18)
- Creating a Calculated Field (8:01)
- Creating a Calculated Item (6:30)
- Solve Order (8:11)
- GETPIVOTDATA (11:57)
- Using GETPIVOTDATA - Dependent Data Validation Lists (8:37)
- Creating a Dynamic Pivot Chart Title (10:41)
- Adding a Dynamic Series to a Pivot Chart (12:47)
- Adding Totals to a Stacked Column Chart (5:52)
- Exercise 07 (10:10)
Section 8: Form Controls
Available in
days
days
after you enroll
- Introduction to Form Controls (4:14)
- Combo Box - Select from a List (7:21)
- Check Box - Check/Uncheck Option (6:48)
- Option Button - Choose an Option (6:30)
- Spin Button - Move Up and Down a List (5:54)
- List Box - Select from a List of Items (4:59)
- Scroll Bar - Scroll Through a List (5:01)
- Exercise 08 (5:57)
Section 9: Working with Power Query
Available in
days
days
after you enroll
Section 10: Forecasting
Available in
days
days
after you enroll
Section 11: Macros and VBA
Available in
days
days
after you enroll
Section 12: Practical Excel - Advanced Formulas
Available in
days
days
after you enroll
Section 13: Course Close
Available in
days
days
after you enroll
Meet Your Instructor
Deb is an Excel maestro with 25+ years of experience covering Microsoft 365 apps. Her passion and expertise have earned her the prestigious Microsoft Most Valuable Professional (MVP) award.
Renowned for transforming beginners into tech wizards, join her on this transformative journey!
Why Study with Stream Skill?
Master In-Demand Skills & get a certificate
Learn valuable software skills, and after completion, download your certificate to stand out to employers.
Learn on Your Schedule with No Expiry
Pay just once for lifetime access to this course. Flexible learning at your own pace.
Expert-Led, Structured Learning
Our experienced instructors (20+ years on average) will guide you through the course with clear explanations and practical exercises.
Flexible & Risk-Free Learning
Try us out with a 14-day money-back guarantee. Get a full refund if you're not satisfied.
YOU MAY ALSO LIKE
Join Over 2 million students
"Since joining my Excel skills have improved more than I ever imagined. The variety of courses is amazing, and the trainers are easy to follow and understand. I look forward to my training and being able to receive my certificates, which I proudly have on display."
Sheryl Watts
"Enrolling in Microsoft Project for beginner course really helped me become proficient with Microsoft Project and project management. I now think more critically with my projects."
Patrick Loyola
"I actually came to your courses because I want to master the IT aspects of project management. The course was very detailed. I will be recommending this course to other aspiring PMPs."
Frank Uchegbu
"I enjoyed the logical structure of course. It helps beginners to follow easily."
Charlenee Huynh
"I have always used Excel at work, but because I learned to use it on my own, I had never been able to make use of all the possibilities that the software offers. I have learned a lot thanks to this course."
Blanca Esteban
"Exactly the training I was looking for!
Its been an amazing experience would recommend to anyone who wishes to get onboard with Microsoft Project.
The lecturer is experienced and knowledgeable in project management, and as a result, his explanations are very good. I enjoyed the course and will recommend it to my friends.
In summary a well worth course so glad to have enrolled."
Haroon Riaz
"I enrolled in the Microsoft Excel for beginners course. I enjoyed every bit of the course and easy to understand and the pattern of teaching was top-notch. I will recommend this course to others including my colleagues. This course has also made me more confident at work because most of our work is usually done in an Excel spreadsheet."
Umar Abdulqadir
"This has already helped me set up my project better and gives me the confidence that I'll be able to keep tracking the project using the software."
Ann Lauzau
FAQs
How Do I Pay For the Course?
You can pay via the secure payment pages of our website. 🔒
You can pay by card 💳 or PayPal. We accept cards issued by Visa, Mastercard, American Express, and JCB.
When Does the Course Start and Finish?
This course is delivered on-demand when you want it. You can start immediately after purchase or save it for a rainy day.
Will I Get a Certificate for the Course?
Yes, if you complete the course and pass the quiz at the end, you can download your certificate to keep and share.
What If I Don't Like The Course?
We're so confident you will that we offer a 14-day money-back guarantee. If you don't like the course, contact us within the first 14 days after purchase and we'll provide you with a full refund.
What is Stream Skill?
Stream Skill is the website platform used to study and learn the courses you are looking at today. Stream Skill courses are available with lifetime access for a single course, or you can buy access to all courses for a monthly (or annual) recurring fee.