8283 Courses in Edinburgh delivered On Demand

ACCA AA, 100% Pass Guarantee, Full Learning and Revision Components, Tests, Mock Exam, Tutor Support and ACCA Approved Materials Included, Exceptional Pass Rates

ACCA FR, 100% Pass Guarantee, Full Learning and Revision Components, Tests, Mock Exam, Tutor Support and ACCA Approved Materials Included, Exceptional Pass Rates

ACCA TX (UK), 100% Pass Guarantee, Full Learning and Revision Components, Tests, Mock Exam, Tutor Support and ACCA Approved Materials Included, Exceptional Pass Rates

ACCA MA, 100% Pass Guarantee, Full Learning and Revision Components, Tests, Mock Exam, Tutor Support and ACCA Approved Materials Included, Exceptional Pass Rates

ACCA FM, 100% Pass Guarantee, Full Learning and Revision Components, Tests, Mock Exam, Tutor Support and ACCA Approved Materials Included, Exceptional Pass Rates

ACCA AA, 100% Pass Guarantee, Full Learning and Revision Components, Tests, Mock Exam, Tutor Support and ACCA Approved Materials Included, Exceptional Pass Rates

ACCA FR, 100% Pass Guarantee, Full Learning and Revision Components, Tests, Mock Exam, Tutor Support and ACCA Approved Materials Included, Exceptional Pass Rates

ACCA FA, 100% Pass Guarantee, Full Learning and Revision Components, Tests, Mock Exam, Tutor Support and ACCA Approved Materials Included, Exceptional Pass Rates

ACCA BT, 100% Pass Guarantee, Full Learning and Revision Components, Tests, Mock Exam, Tutor Support and ACCA Approved Materials Included, Exceptional Pass Rates

🌟 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! 💡   Course Curriculum 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