Excel 2021 Advanced
Excel 2021 Advanced
- DURATION: 10h 10m
- VIDEOS: 87
- LEVEL: Advanced
- Description
- Course Resources
Welcome to “Excel 2021 Advanced,” a course designed to elevate your Excel proficiency by unlocking the full potential of dynamic arrays and advanced functions. Throughout this course, you will explore dynamic arrays, spills, and arrays, gaining expertise in sorting, filtering, and performing complex lookups with functions like SORT, FILTER, and XLOOKUP.
You’ll delve into advanced data analysis techniques, mastering 2-way lookups, ranking data, rounding values, and utilizing specialized rounding functions. Discover the power of LET and LAMBDA functions, enabling you to create more efficient and customized formulas.
As you progress, you’ll learn advanced PivotTable customization, how to create calculated fields and items, and how to utilize Form Controls for enhanced data interaction. Harness the capabilities of Power Query for seamless data importing, transforming, and combining files directly within Excel.
Take your forecasting skills to the next level by learning to create linear and seasonal sales forecasts with confidence levels and forecast sheets. Delve into the world of Macros and learn how to automate tasks, record multi-step processes, and create custom macro ribbons to streamline your workflow.
Throughout the course, you’ll acquire practical skills in efficiently finding, extracting, and manipulating data. Upon completion, you should be equipped with advanced Excel techniques to analyze data, automate tasks, and enhance your overall productivity. Take your Excel skills to new heights and stand out in the world of data analysis and automation!
In this ten-hour advanced course, students will learn how to:
- Use the NEW Dynamic Array functions to perform tasks.
- Create advanced and flexible lookup formulas.
- Use statistical functions to rank data and calculate the MEDIAN and MODE.
- Produce accurate results when working with financial data using math functions.
- Create variables and functions with LET and LAMBDA.
- Analyse data with advanced PivotTable and PivotChart hacks.
- Add interactivity to reports and dashboards by incorporating form controls.
- Import and clean data using Power Query.
- Predict future values using forecast functions and forecast sheets.
- Record and run macros to automate repetitive tasks.
- Understand and make minor edits to VBA code.
- Combine functions to create practical formulas to complete specific tasks.
WHAT YOU GET
Certificate of Completion
- Earn a certificate each time you complete a course.
- Showcase your commitment to continuous growth and professional development.
- Impress potential employers.
- Enhance your professional profile.
- Available in PDF format to Download or Print.
INSTRUCTOR
Deborah Ashby
Meet Deb, your go-to guide in the exciting world of Excel and beyond! With her infectious enthusiasm and razor-sharp expertise, she's on a quest to turn everyone into Excel wizards. Deb doesn't just stop at Excel, though. She'll lead you through the fascinating realms of Microsoft Word, PowerPoint, and other Microsoft 365 apps, helping businesses and individuals alike to unlock their full potential. But she's no ordinary trainer. Boasting an impressive track record of over 25 years and revered by past and current learners alike, Deb's teaching prowess is unparalleled. To top it off, she's a proud recipient of the coveted Microsoft MVP (Most Valuable Professional) award. Buckle up and join Deb on this exhilarating learning journey!
The course comes with course and exercise files compressed into .zip format. You will need to download the .zip file to your PC or Mac (the files are not compatible with a mobile device) and unzip it. Once unzipped, all of the exercise files will reside in one folder.
Click on the below links to download the zip files.
What people are saying
Trusted by
Start Your Membership
Simon Sez: “Let’s make you a software superstar!”
From Excel to photo editing, experience quality courses that ensure easy learning.
START YOUR MEMBERSHIPLearn More