452 Courses

Course Overview Take your spreadsheet skills to the next level and become a Pivot Table pro, with this step-by-step instructor-guided training course. The Excel Pivot Tables Crash Course course will equip you with the practical skills to analyse large sets of information quickly and efficiently using Excel Pivot Tables. It will teach you how to perform a diverse range of tasks such as creating reports, using Pivot Table data for market analytics, identifying trends, and calculating profit. This course is open to learners of all levels. It is ideal for financial and market analysts, administrative assistants, project managers, and anyone whose role involves working with spreadsheet data. Gain in-demand analytical skills and learn up-to-date best practices by learning from the experts. This best selling Excel Pivot Tables Crash Course has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Excel Pivot Tables Crash Course is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Excel Pivot Tables Crash Course is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Excel Pivot Tables Crash Course is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Excel Pivot Tables Crash Course, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Excel Pivot Tables Crash Course will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Excel Pivot Tables Crash Course to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Welcome To Excel 2016 Advanced In this day and age can you imagine an office without Excel! No matter what profession you have, good Microsoft Excel skills will always come in handy. The Excel 2016 Advanced course is designed to show the learners A-Z of Excel 2016 to turn them into expert users. This course is packed in 65 easy to follow modules to help you understand all the tools and functions of Excel 2016. This course will guide you through using advanced if statements, automating with macros and formula auditing. You will also learn about complex text functions. During this course, you will have the opportunity to take an assessment to consolidate your learning. If you desire to comprehend all the advanced Excel 2016 skills, then this is the course. Upon completing this course, you will be able to raise your proficiency level and bring out your all potentials. So don't delay, enrol today! Excel 2016 Advanced is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector.  This course is accredited by CPD so you will get a career boost upon completing this course. Our Excel 2016 Advanced is packed with 65 modules and 3 hours, 1 minute of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website. It doesn't matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime.  Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

The comprehensive Advanced Diploma in Microsoft Excel has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Advanced Diploma in Microsoft Excel today, and learn from the very best the industry has to offer! This best selling Advanced Diploma in Microsoft Excel has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Advanced Diploma in Microsoft Excel is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Advanced Diploma in Microsoft Excel is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Advanced Diploma in Microsoft Excel is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Advanced Diploma in Microsoft Excel, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Advanced Diploma in Microsoft Excel will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Advanced Diploma in Microsoft Excel to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Discover how to organise your money, avoid reckless spending, and invest wisely by taking this comprehensive course on Excel in personal-finance (How to be effective in personal-finance with a hands-on Excel Class). Microsoft's benchmark platform and software can be a valuable aid for controlling your fiscal flow and keeping your savings supervised. With the help of this training and practical experience, you will gain confidence in your money-making abilities and know how to build profit without sustaining heavy losses. This Personal Finance tutorial will enable you to surpass your own expectations for gaining money management and investment acumen skills. Across eleven online educational units, you can expect a wealth of expert tips and recommendations for budgeting, saving, and spending. With easy-to-understand techniques and hands-on demonstrations, you will be shown how to set Smart goals, create financial plans, organise loans, evaluate investments, and maintain an excellent credit rating. Don't lose out on this opportunity and enrol now. This best selling Excel in personal-finance - how to be effective in personal-finance - Hands on Excel Class has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Excel in personal-finance - how to be effective in personal-finance - Hands on Excel Class is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Excel in personal-finance - how to be effective in personal-finance - Hands on Excel Class is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Excel in personal-finance - how to be effective in personal-finance - Hands on Excel Class is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Excel in personal-finance - how to be effective in personal-finance - Hands on Excel Class, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Excel in personal-finance - how to be effective in personal-finance - Hands on Excel Class will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Excel in personal-finance - how to be effective in personal-finance - Hands on Excel Class to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

. Certification After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

You can increase your understanding of various tools in Excel 2016 by completing this Excel 2016 Intermediate course. You will learn how to manage and view data in Excel. This skill will help you gain new career opportunities upon completion. In this Excel 2016 Intermediate course, you will be able to confidently work with workbooks, worksheets and more. This course will teach you how to use specific features such as conditional formatting and graphs. Learn how to easily understand pivot tables, work with date and time functions by taking this course. You can also practice what you learn throughout the course. Excel 2016 Intermediate is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector.  This course is accredited by CPD, so you will get a career boost upon completing this course. Our Excel 2016 Intermediate is packed with 76 modules and 4 hours, 3 minutes of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website. It doesn't matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime.  Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

This course will introduce you to the basics of Excel 2016. By completing this Excel 2016 Introduction course, you will have skills to stand out from the crowd. You will learn how to create and manage spreadsheets in Excel. You will learn how to use cells and themes in Excel. In this Excel 2016 Introduction course, you will be able to confidently add columns and rows to spreadsheets. This course will teach you how to use specific features such as calculation hierarchy. Learn how to easily modify worksheets, insert objects and enter data easily by taking this course. You can also practice what you learn throughout the course. Excel 2016 Introduction is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector.  This course is accredited by CPD, so you will get a career boost upon completing this course. Our Excel 2016 Introduction is packed with 68 modules and 3 hours, 46 minutes of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website. It doesn't matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime.  Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

. Certification After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

The Microsoft Excel course is designed to teach you everything you need to know about Excel from scratch. This comprehensive, instructor-guided training will help you gain a thorough understanding of Excel’s essential features and functions, enabling you to kickstart your career or enhance your current skills. Whether you are just starting out or looking to build on your knowledge, this course will equip you with the most in-demand skills required in today's competitive job market.

🌟 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