26885 Management courses in Garforth delivered Online

Drug and Alcohol: Drug and Alcohol Awareness Course Online When it comes to the risk of drugs and alcohol in the workplace, our Drug and Alcohol: Drug and Alcohol Awareness Course offers your staff the knowledge of all people's principles and obligations at the workplace. The Drug and Alcohol: Drug and Alcohol Awareness Course takes the learner through the safety responsibilities, testing requirements, and processes for drugs and alcohol in the workplace, as well as the implications of any positive tests. By the end of this Drug and Alcohol: Drug and Alcohol Awareness Course, learners will understand the effects of drugs and alcohol on work fitness and how they can contribute to a safe workplace. Learning Outcomes of Drug and Alcohol: Drug and Alcohol Awareness Course After completing this Drug and Alcohol: Drug and Alcohol Awareness Course, the learner will be able to: Understand the basic concepts of substance misuse. Demonstrate a thorough understanding of the different types of illegal drugs. Understand the legal, health, and social implications of drug and alcohol abuse. Understand how organizations and individuals are expected to handle substance misuse issues. Demonstrate an understanding of the statistics on drug and alcohol abuse in the UK. Describe the various types of drug treatment services available in the UK. Plan a drug intervention and understand when someone requires assistance. Special Offers of this Drug and Alcohol: Drug and Alcohol Awareness Course This Drug and Alcohol: Drug and Alcohol Awareness Course includes a FREE PDF Certificate. Lifetime access to this Drug and Alcohol: Drug and Alcohol Awareness Course Instant access to this Drug and Alcohol Awareness: Drug and Alcohol Awareness Course Get FREE Tutor Support from Monday to Friday in this Drug and Alcohol: Drug and Alcohol Awareness Course Drug and Alcohol: Drug and Alcohol Awareness Course Bundle: Course 01: Drug and Alcohol Awareness Course 02: Suicide Awareness Training Course 03: Level 5 Mental Health Care - MCA and DOLS Course 04: Diploma in Counselling and Psychology [ Note: Free PDF certificate as soon as completing the Drug and Alcohol: Drug and Alcohol Awareness Course] Drug and Alcohol: Drug and Alcohol Awareness Course Online Industry Experts Designed this Drug and Alcohol: Drug and Alcohol Awareness Course into 06 detailed modules. Course Curriculum of Drug and Alcohol: Drug and Alcohol Awareness Course Module 01: Introduction Module 02: Historical Overview Module 03: Nature of Addiction Module 04: Policy Initiatives and Strategy in Alcohol and Drug Use Module 05: Understanding Alcohol Abuse Module 06: Drug Addiction & Abuse Assessment Method of Drug and Alcohol Awareness After completing each module of the Drug and Alcohol Awareness: Drug and Alcohol Awareness Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Drug and Alcohol Awareness After completing the MCQ/Assignment assessment for this Drug and Alcohol Awareness: Drug and Alcohol Awareness course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Drug and Alcohol: Drug and Alcohol Awareness Course Online This Drug and Alcohol Awareness: Drug and Alcohol course is designed for those working in high-risk industries like hospitality and construction and anyone who manages or works with vulnerable people like adolescents. Requirements Drug and Alcohol: Drug and Alcohol Awareness Course Online Students who intend to enrol in this Drug and Alcohol Awareness: Drug and Alcohol Awareness course must meet the following requirements: Drug and Alcohol Awareness: Good command of the English language. Drug and Alcohol Awareness: Must be vivacious and self-driven Drug and Alcohol Awareness: Basic computer knowledge. Drug and Alcohol Awareness: A minimum of 16 years of age is required Career path Drug and Alcohol: Drug and Alcohol Awareness Course Online This Drug and Alcohol Awareness: Drug and Alcohol Awareness course opens a new door for you to enter the relevant job market. It also gives you the opportunity to gain in-depth knowledge along with the necessary skills to grow in no time. Certificates Certificate of completion Digital certificate - Included

🎙️ Unlock the Power of Persuasion and Captivate Any Audience with 'Art of Oratory: Elevate Your Communication Skills' by Arvee Robinson! 🌟 Are you ready to command attention every time you speak? Master the art of persuasive communication and captivate your audience effortlessly. Join Arvee Robinson, the acclaimed communication expert, in a transformative online course designed to skyrocket your speaking prowess! 🔥 What You'll Learn: Craft Compelling Speeches: Learn the secrets to crafting engaging and persuasive speeches that resonate with any audience. Masterful Delivery Techniques: Hone your delivery skills, from body language to vocal modulation, to convey your message with impact and authenticity. Overcome Stage Fright: Conquer nervousness and exude confidence on stage or in any speaking scenario. Winning Presentation Strategies: Discover winning strategies to connect emotionally, inspire action, and leave a lasting impression. Effective Storytelling: Harness the power of storytelling to make your message unforgettable and relatable. 🌟 Why Choose 'Art of Oratory'? Expert Guidance: Benefit from Arvee Robinson's decades of expertise in public speaking and communication. Practical Insights: Gain practical, actionable techniques you can implement immediately for tangible results. Interactive Learning: Engage in exercises, drills, and real-life scenarios to enhance your skills. Lifetime Access: Enjoy lifetime access to course materials, allowing you to learn at your own pace. 🚀 Elevate your professional presence, persuade with finesse, and become a magnetic communicator in any setting. Enroll now in 'Art of Oratory: Elevate Your Communication Skills with Arvee Robinson' and step into the spotlight with confidence! Join the ranks of successful speakers who have transformed their communication style and achieved remarkable results. Don't miss this chance to unlock your full speaking potential. Enroll today and embark on your journey towards becoming a captivating orator! 🎤✨ Course Curriculum Public Speaking Mastery with Arvee Robinson Introduction - Your Message Matters 00:00 MESSAGE-Your Message Matters 00:00 AUDENCE- Your Message Matters 00:00 GET TRAINED - Your Message Matters 00:00 TRANSFORMATION - Your Message Matters 00:00 ELEVATE - Your Message Matters 00:00 REVENUE - Your Message Matters 00:00 STORIES - Your Message Matters 00:00

🌿 Unlock Your Inner Harmony: Join 'Harmony Within' - Your Journey to Personal Growth with Zen Principles! 🌿 Are you ready to embark on a transformative journey towards inner peace, balance, and personal growth? Introducing our exclusive online course, 'Harmony Within: Exploring Zen Principles for Personal Growth.'   🧘‍️ What's Inside? 🌸 Module 1: Zen Foundations Dive deep into the essence of Zen philosophy. Learn the art of mindfulness and living in the present moment. 🌼 Module 2: Finding Balance Discover how to balance work, relationships, and self-care. Embrace simplicity and let go of unnecessary complexities. 🍃 Module 3: Inner Peace Practices Explore meditation techniques for a calm and centered mind. Cultivate a sense of inner peace that radiates in your daily life. 🌺 Module 4: Embracing Change Understand the Zen approach to change and impermanence. Transform challenges into opportunities for personal growth. 🎋 Module 5: Mindful Living in Action Apply Zen principles to your everyday life. Foster meaningful connections and nurture positive habits.   🌈 Why Choose 'Harmony Within'? ✨ Expert Guidance: Led by seasoned instructors well-versed in Zen philosophy and personal development. 🌟 Flexible Learning: Access modules at your own pace, anytime, anywhere. 🌿 Community Support: Join a community of like-minded individuals for discussions, insights, and encouragement. 📚 Comprehensive Resources: Access a wealth of supplementary materials, including guided meditations and reflective exercises. 🎓 Lifetime Access: Enjoy ongoing access to course updates and new content.   🤝 Who is This Course For? Anyone seeking a more harmonious and balanced life. Individuals navigating life changes and seeking personal growth. Those interested in integrating Zen principles into their daily routines.   Invest in yourself and embark on a life-changing adventure. Join 'Harmony Within' today and start living a life guided by Zen principles. 🌸 Enroll now and discover the transformative power of inner harmony! 🌸 Course Curriculum Harmony Within: Exploring Zen Principles for Personal Growth Beginning Concepts 00:00 What is ZEN? 00:00 Past- Future Problem/Trap 00:00 Major ZEN Teachings 00:00 The 5 Precepts 00:00 The 5 Roots Of Suffering 00:00 Thinking & Beliefs 00:00 The Problem of 'EGO' 00:00 Watching the Thinker 00:00 Defeating Negative Thinking 00:00 Escaping Your Prison 00:00 The Sword Of Meditation 00:00 More ZEN Concepts - Part 1 00:00 More ZEN Concepts - Part 2 00:00 More ZEN Concepts - Part 3 00:00 Powerful ZEN Philosophies - Part 1 00:00 Powerful ZEN Philosophies - Part 2 00:00 Learning Powerful Emotional Control 00:00 BONUS VIDEO - Embrace Your Gifts 00:00

🌟 Unlock Your Public Speaking Potential in Just One Hour! 🌟   Master the art of confident and impactful public speaking with our groundbreaking online course - 'Public Speaking Mastery in One Hour'! Are you tired of feeling nervous or uncertain every time you have to speak in public? Do you want to captivate your audience, communicate with authority, and leave a lasting impression? Look no further! This transformative course is meticulously crafted to equip you with the essential skills and techniques to become a compelling and persuasive speaker in just one hour.   What You'll Gain: ✨ Proven strategies to overcome stage fright and boost your confidence instantly. ✨ Insider tips on structuring your speech for maximum impact and engagement. ✨ Techniques to refine your body language, voice modulation, and delivery style. ✨ Secrets to connect with your audience on a deeper level and leave a lasting impression. ✨ Practical exercises and real-world examples to apply your newfound skills immediately.   Why Choose 'Public Speaking Mastery in One Hour'? 🚀 Efficient Learning: Concise and focused modules ensure rapid skill acquisition without wasting time. 🎓 Expert Guidance: Learn from industry-leading public speaking experts with years of experience. 📈 Immediate Impact: Apply what you learn right away to see instant improvements in your speaking abilities. 💡 Lifetime Access: Enjoy unlimited access to the course materials, allowing you to revisit and reinforce your skills whenever needed.   Join thousands of satisfied students who have transformed their public speaking prowess with our course! Don't let fear hold you back-empower yourself and become a confident, influential speaker today.   Enroll now in 'Public Speaking Mastery in One Hour' and unleash your full potential on stage or in any public speaking arena!   🌟 Limited Time Offer: Enroll Today and Get Started on Your Journey to Public Speaking Excellence! 🌟 Course Curriculum INTRODUCTION 1-Hour Public Speaking Presentation Skills Class 00:00 PUBLIC SPEAKING TACTICS & STRATEGIES Quick Wins! The Secret to Using Speaker Notes Effectively 00:00 Avoiding The Initial Wrong Turn Most Speakers and Presenters Make 00:00 Developing Expert Judgment for Your Public Speaking and Presenting Opportunity 00:00 The Radical Yet Simple Solution to Finding Great Messages 00:00 Your Stories Will Make Your Ideas Unforgettable 00:00 Your PowerPoint Will Create Engagement, Not Slumber 00:00 Building an Ethical Cheat Sheet Just for You 00:00 This Is The Do Or Die Moment for Your Speaking Improvement 00:00 There Is a Perfect Test for Your Speech and Presentation 00:00 I Will Give You a Personalized Professional Presentation Critique Right Here 00:00 Continuing Your Path of Public Speaking and Presentation Skills Improvement 00:00

🌟 Unlock Your Potential in Negotiations! 🌟   Are you ready to transform your negotiation game and achieve remarkable success in every deal? Introducing our groundbreaking online course:   🔑 Mastering Negotiation Strategies: Essential Tools and Techniques 🔑 Empower yourself with the indispensable skills and insights necessary to navigate any negotiation scenario with confidence and finesse. Whether you're a seasoned professional or just starting your journey, this course is tailored to elevate your negotiation prowess to new heights.   🚀 What You'll Gain from This Course: ✅ Comprehensive understanding of negotiation fundamentals ✅ Advanced strategies for complex deal-making ✅ Proven techniques to handle challenging situations ✅ Confidence to secure favorable outcomes ✅ Practical exercises and real-world case studies ✅ Personalized tips for different negotiation styles ✅ Insider secrets from industry experts   💡 Course Highlights: 🌐 Accessible anytime, anywhere - Learn at your own pace 📚 Engaging modules with interactive content 👥 Community support and networking opportunities 🎓 Expert-led sessions and in-depth tutorials 📈 Immediate application of learned strategies in your professional and personal life   🌟 Join thousands of successful negotiators who have transformed their approach and achieved unparalleled results. Take charge of your negotiations and set yourself apart in any situation! Enroll now and gain the skills to negotiate effectively in every aspect of your life. Don't miss this opportunity to become a master negotiator! Course Curriculum INTRODUCTION Killer Negotiating Tools - Introduction 00:00 10 KILLER NEGOTIATING TOOLS Tool 01 - Always Let the Other Person Go First 00:00 Tool 02 - Both Parties Must Feel Some Pain 00:00 Tool 03 - Put It In the Parking Lot 00:00 Tool 04 - Leave Your Ego At the Door 00:00 Tool 05 - Don't Negotiate With Yourself 00:00 Tool 06 - Know Your Deal Killers 00:00 Tool 07 - Put the Deal On Your Paper 00:00 Tool 08 - Escalate to God 00:00 Tool 09 - Be Careful of Deal Fatigue 00:00 Tool 10 - Know Thy Opponent 00:00

Description: Knowing how to utilise the advanced features of Microsoft Excel 2007 opens an entirely new experience in utilising this spreadsheet program. This course is designed to provide you with everything you need to know about Microsoft Excel 2007. From the essentials to the most advanced tools, by the end of this course, you will have the skills to utilise Microsoft Excel 2007 at an expert level. Once you complete the course, your familiarity and confidence in using the advanced feature of Excel 2007 will increase, making Excel 2007 a more useful tool for you at work or home. Who is the course for? New users, beginners, intermediates and advanced Excel users can benefit from this course. This course would be ideal for individuals who wish to develop their skills of using Microsoft Office Excel application. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career path: The Microsoft Excel 2007 Advanced Level will be very beneficial and helpful, especially to the following professionals: Administrative Assistant. PA. Secretary. Administrator. Office Manager. Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2007 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2007 Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Excel 2007 Advanced Level 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. Therefore after completing this video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn different features of Excel program that allows you take the right business decisions for your company. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Excel Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Excel Beginners - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description MS Excel introduces multi-dimensional activities through its various feature. Do you want to be the first to look at the MS Excel 2016 Introduction course to learn its vivid use? Don't be late. Look at the MS Excel 2016 Introduction course and justify its authentic knowing its various fields. The course designs in such a way that helps you to know the basic functions of MS Excel and various use of Excel for making calculation, producing charts, and recording data of all kind of business. It teaches you how to create Excel data, simple PivotTable and charts, vivid use of IF, SUM, TOTAL, and AVERAGE. It enables the students to understand how Excel is used in business to analyze the existing data. It also teaches the functions of range, and cell to do different types of activities. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Excel 2016 Introduction is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our MS Excel 2016 Introduction is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:01:00 Getting Started with Excel What is Excel 00:02:00 Opening Excel 00:04:00 Navigating the Excel User Interface 00:07:00 Using the Excel Ribbon 00:03:00 Understanding Excel Work Components 00:04:00 Using the Backstage View 00:03:00 Creating Workbooks and Using Templates Creating a New Workbook 00:03:00 Creating Workbooks Using Templates 00:03:00 Saving an Excel Workbook 00:05:00 Using Convert and Checking Compatiblity 00:02:00 Entering Data Navigating a Worksheet by Mouse or Keyboard 00:05:00 Excel Data Types 00:03:00 Cell and Range Addressing 00:02:00 Data Selection Techniques 00:05:00 Common Excel Commands 00:07:00 Using the Autofill Handle 00:03:00 Excel Formula Basics Data What are Formulas and Functions 00:02:00 Components of a Formula 00:06:00 Calculation Hierarchy Using the Order of Operations_Revise 00:02:00 Creating Basic Formulas 00:08:00 Working with Basic Functions and Autosum 00:04:00 Using Cell References 00:04:00 Using the Quick Analysis Tool 00:01:00 Adjusting a Worksheet Modifying Columns and Rows 00:06:00 Hiding and Unhiding Columns and Rows 00:03:00 Formatting and Aligning Worksheet Data Formatting and Aligning Data 00:06:00 Merging Data 00:03:00 Wrapping Text Orientation 00:02:00 Formatting Numbers 00:03:00 Using Borders and Shading 00:03:00 Using the Format Painter 00:01:00 Removing Formatting Quickly 00:01:00 Using Cell Styles and Themes Understanding Cell Styles 00:02:00 Applying Cell Styles 00:04:00 Applying Themes 00:03:00 Inserting Objects and Graphics Inserting and Formatting Images 00:03:00 Inserting and Formatting Shapes 00:04:00 Inserting and Formatting Smart Art 00:04:00 Inserting Screenshots 00:02:00 Inserting Hyperlinks 00:03:00 Inserting Symbols and Equations 00:03:00 Inserting Word Art Or Text Boxes 00:04:00 Inserting Other Excel Objects 00:04:00 Arranging Objects 00:04:00 Proofing a Workbook Using Find and Replace 00:04:00 Finding and Replacing Formatting 00:01:00 Using Got to and Go to Special 00:02:00 Using the Spell Checker 00:03:00 Using the Theasaurus and Translation Feature 00:03:00 Printing an Excel File Printing and Previewing Excel Files 00:03:00 Creating Custom Margins and Scaling 00:05:00 Adding Headers and Footers 00:04:00 Formatting a Page with the Page Layout Tab 00:03:00 Printing Titles and Specific Worksheet Areas 00:05:00 Exporting to PDF and XPs 00:02:00 Managing Worksheets Renaming and Coloring Worksheet Tabs 00:03:00 Adding, Deleting, and Navigating Worksheets 00:03:00 Moving and Copying Worksheets 00:04:00 Hiding and Unhiding Worksheets 00:02:00 Navigating and Viewing Excel Files Viewing Workbooks 00:03:00 Using Zoom Tools 00:02:00 Configure Sheet Options 00:02:00 Using Freeze Panes and Split Commands 00:05:00 Working with Window Commands 00:04:00 Adjusting Workbook Properties 00:03:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: The Microsoft Excel program was designed to help people in their worksheets and spreadsheets. This course will teach you how to use SmartArt, pictures, text boxes and shapes to enhance your ability. You will learn to utilize many objects which have contextual tool tabs that appear when you select an object. Learn how to solve formula errors before they happen by using named ranges instead of cell references. Who is the course for? Professionals who want to learn about the Microsoft Excel 2013 advanced features. People who have an interest in knowing all the functions of Microsoft Excel 2013. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Excel Advanced course is a useful qualification to possess and would be beneficial for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager. Microsoft Excel - Advanced Level Module One - Getting Started 01:00:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel - Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel - Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Excel - Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. The course is divided into three parts - beginners, intermediate and advanced. Therefore after completing the bundle video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn the advanced features of Excel program that allows you take the right business decisions for your company. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Working with Functions Work with Ranges FREE 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Refer A Friend Refer A Friend 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00