• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Excel 2019 - Advanced Level Training

Microsoft Excel 2019 - Advanced Level Training

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 2 hours 34 minutes

  • All levels

Description

🌟 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

About The Provider

Tags

Reviews