Microsoft Excel 2019 – Advanced Level Training
- Lifetime Access
- Duration: 6 hours
- Last Update: November 28, 2025
Looking to purchase at bulk for your team?
Please contact us with your team size and desired course titles at [email protected]
🌟 Unlock the Full Power of Microsoft Excel 2019! 🌟
Ready to take your Excel skills to the next level? Dive into our comprehensive online course – “Microsoft Excel 2019 – Advanced Level Training” – designed to transform you into an Excel maestro!
🚀 Here’s What You’ll Master:
📊 Section 1: Excel – Advanced – Get hands-on with advanced techniques and shortcuts to streamline your workflow.
📂 Section 2: Working with Multiple Workbooks – Seamlessly manage multiple workbooks and boost your productivity effortlessly.
🔒 Section 3: Protecting Worksheets and Workbooks – Learn how to safeguard your data with robust protection strategies.
📝 Section 4: Conditional Formulas – Unravel the power of conditional logic and unleash the true potential of formulas.
🧮 Section 5: Advanced Functions – Elevate your Excel expertise by mastering complex functions for data analysis.
📚 Section 6: Text Based Functions – Manipulate text effortlessly and efficiently with advanced text-based functions.
🔍 Section 7: What IF Tools – Explore the ‘What If’ analysis tools to make informed decisions and predictions.
🏁 Section 8: Excel Advanced – Conclusion – Wrap up with a comprehensive understanding and practical application of advanced Excel features.
🎁 Section 9: Bonus #1 – Advanced Pivot Tables – Delve into bonus content covering advanced techniques for Pivot Tables, a must-have skill for data analysis pros.
🌟 Why Choose Our Course?
🔐 Expert Guidance: Led by seasoned Excel professionals, ensuring clarity and depth in learning.
🔄 Practical Assignments: Apply your newfound skills through real-world exercises.
📈 Career Growth: Elevate your career prospects by mastering sought-after Excel abilities.
🌐 Accessible Learning: Study at your own pace from anywhere, anytime with our user-friendly online platform.
🤝 Join our vibrant community of learners dedicated to mastering Excel’s advanced functionalities.
💡 Enroll now and revolutionize your Excel prowess with “Microsoft Excel 2019 – Advanced Level Training”! Don’t miss this chance to become an Excel wizard! 💡
- CPD International Quality Accredited
- Meets UK & EU legal requirements
- Instant e-certificate and eligibility of ordering hardcopy
- Developed by Industry Experts
- Learn anytime from anywhere
- Use any internet-connected device
- 24/7 Live Support
- Discounts on bulk purchases
Course Curriculum
Section 1 – Excel – Advanced
-
Excel Advanced Introduction
01:39 -
Advanced Shortcut Keys
00:00
Section 2 – Working with Multiple Workbooks
-
Tracing Precedents
00:00 -
Tracing Dependants
00:00 -
Watch Window
00:00 -
Show Formulas
00:00
Section 3 – Protecting Worksheets and Workbooks
-
Protecting Cells in a Worksheet
00:00 -
Protecting the Workbook Structure
00:00 -
Encryption with Passwords
00:00
Section 4 – Conditional Formulas
-
Name Ranges
00:00 -
Simple IF Function
00:00 -
IF, AND
00:00 -
IF, OR
00:00 -
Nested Formulas
00:00 -
CountIF and CountIFs
00:00 -
SumIF and SumIFs
00:00
Section 5 – Advanced Functions
-
Advanced VLookUp
00:00 -
IF and IS Error – Part 1
00:00 -
IF and IS Error – Part 2
00:00 -
Advanced Index Match
00:00 -
Dates – Part 1
00:00 -
Dates – Part 2
00:00 -
Replace and Substitute – Part 1
00:00 -
Replace and Substitute – Part 2
00:00
Section 6 – Text Based Functions
-
Left, Right and Mid Function
00:00 -
Search Function
00:00 -
Concatenate and Search
00:00 -
Indirect – Static
00:00 -
Indirect – Dynamic
00:00
Section 7 – What IF Tools
-
Goal Seek
00:00 -
Data Tables
00:00 -
Scenarios
00:00 -
Solver
00:00
Section 8 – Excel Advanced – Conclusion
-
Excel Advanced – Conclusion
00:00
Section 9 – Bonus # 1 – Advanced Pivot Tables
-
Building a Mini Dashboard
00:00
- Lifetime Access
- Duration: 6 hours
- Last Update: November 28, 2025
Looking to purchase at bulk for your team?
Please contact us with your team size and desired course titles at [email protected]
The Course is Accredited