Booking options
£25
£25
On-Demand course
2 hours 34 minutes
All levels
ð 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! ð¡
Section 1 - Excel - Advanced
Excel Advanced Introduction
01:39
Advanced Shortcut Keys
02:58
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
Compete High: Your