9007 Power courses

Getting Started The CMI Level 3 Award in Principles of Management and Leadership is designed for practising or aspiring junior-level managers and supervisors responsible for first-level management. The CMI Level 3 Principles of Management and Leadership course enhances the skills of junior managers and supervisors in effective decision-making, communication and motivating the employees to attain maximum productivity and achieve clearly defined outcomes. Our CMI Level 3 Award is a concise and shorter course than the Certificate and Diploma, providing you with complete professionalism to become an efficient junior manager or supervisor. You'll develop essential management and supervisory techniques, enabling you to manage workplace problems with maximum competence. You'll have a wide range of units to choose from, and depending on your career goals, you can select the modules that will be most effective for your progression. Key Benefits For Learners: Support and monitor goals Provide instructions around objectives Give direction and guidance Support day-to-day operations Effective project planning Providing an overview of the roles and responsibilities required for managers and developing the skills required to succeed Foundation Chartered Manager offers professional recognition and access to the tools to facilitate continuing professional development (CPD) against our Professional Standard For Organisations: Making sure teams can meet organisational objectives Provides extensive knowledge and skills required to be a manager as part of an organisation The capability to apply learning in the context of another organisation or industry sector Key Highlights Are you a practising or aspiring manager and want to supervise or manage a team to achieve clearly defined outcomes? Then, the CMI Level 3 qualification in Principles of Management and Leadership offered by the School of Business and Technology London is the ideal starting point for your career journey. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our CMI-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways The CMI Level 3 Principles of Management and Leadership can open many career pathways including, but not limited to: Team Leader, with an estimated average salary of £31,051 per annum Supervisor, with an estimated average salary of £34,000 per annum Shift Manager, with an estimated average salary of £36,216 per annum Project Officer, with an estimated average salary of £37,451 per annum About Awarding Body Chartered Management Institute established over 60 years ago as the British Institute of Management back then; it has developed the UK's very first diploma in management studies. In the years that followed CMI has consistently been at the forefront of all aspects of management and leadership. Today CMI is the only chartered professional awarding body committed to offering the highest standards in management and leadership excellence. Presently over 100,000 managers use its unique services daily. CMI qualifications aim for managers and leaders at any level, and it remains the only Awarding Body which can award Chartered Manager status - the ultimate management accolade. Employers highly value the qualifications awarded by CMI, and boost your career prospects. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 6 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by CMI-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies Access to CMI Management Direct. It has 100,000s of reliable and validated management and leadership resources, including company and industry reports, videos, checklists, E-books, and journals. You have access to CMI Membership and Support for the duration of your study. Assessment For each module you study, you will complete a written assignment of 2000 to 2500 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your CMI-approved tutor. Entry Requirements This course is designed for practising or aspiring junior-level managers and supervisors. You don't need any formal qualifications to study this course. However, to be eligible for this course, you must:  Be 18 years of age and over Possess the ability to complete the Level 3 course Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression There are numerous progression opportunities will be available on successful completion of a Level 3 qualification in Principles of Management and Leadership, Progression to other qualifications at the same level (E.g. from Level 3 Award to Level 3 Certificate etc.) Progression to other qualifications at the next level (E.g. from Level 3 Certificate to Level 4 or 5 Certificate) Why gain a CMI Qualification? The CMI Level 3 Award in Principles of Management and Leadership is aimed at practising or aspiring managers who will supervise or manage a team to achieve clearly defined outcomes. Our CMI Level 3 Award in Principles of Management and Leadership will provide you with the key skills and competencies required to be a manager in an organisation. Once you complete this course, you can progress to further learning within the suite of Level 3 Qualifications in Principles of Management and Leadership - i.e. achieving an Award and topping up to a Certificate or Diploma. You may also wish to further your ongoing personal and professional development by accessing other CMI courses, such as the CMI Level 5 in Management and Leadership, with the goal of becoming a Chartered Manager. Studying for a CMI qualification offers you more than just academic standing. When you enrol with us for the CMI Level 3 Award in Principles of Management and Leadership, you will have access to CMI Membership and Support for the duration of your study alongside your qualification. CMI graduates achieve remarkable things: 72% agree that their CMI qualification gave them a competitive edge in the job application process. 89% agree they use the skills learnt on their accredited qualification in their current role. 88% agree that the accredited qualification gave them good career prospects. Recent CMI graduates earn a median of 28k compared to just 21k for a typical business studies graduate. Employers highly value the qualifications awarded by CMI, and over 80% of managers agree that a CMI qualification is essential to becoming a professional manager. Learners must complete at least one unit to a minimum of 40 TUT hours, 4 credits to achieve this qualification. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Building Stakeholder Relationships Using Effective Communication Reference No : CMI 305 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Know the purpose of building stakeholder relationships 2. Understand different channels and types of communication used to build relationships with stakeholders. 3. Know how to respond to barriers when communicating with stakeholders. UNIT2- Managing Daily Activities to Achieve Results Reference No : CMI 312 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the purpose of daily work activities in the context of an organisation. 2. Understand how to prioritise and set objectives for daily work activities. 3. Know how to organise and allocate work. UNIT3- Principles of management and leadership Reference No : CMI 301 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand how organisations operate. 2. Understand the management role 3. Understand the application of management and leadership approaches. UNIT4- Developing the Knowledge, Skills and Abilities of Individuals and Teams Reference No : CMI 307 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Know the purpose of developing the knowledge, skills and abilities of individuals and teams. 2. Know different types of development opportunities available to support individuals and teams. 3. Be able to identify and select development opportunities for individuals and teams. UNIT5- Managing a Team to Achieve Results Reference No : CMI 302 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the role and purpose of teams 2. Be able to recognise the characteristics of a high performing team. 3. Know how to lead, communicate with and motivate a high performing team. UNIT6- Managing Individuals to be Effective in their Role Reference No : CMI 303 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand an individual's work role and responsibilities 2. Know how to set objectives with individuals. 3. Know how to support individuals to perform well UNIT7- Principles of Communication in the Workplace Reference No : CMI 304 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Know the channels and types of communication used in the workplace. 2. Understand the communication cycle. 3. Be able to plan communication for a target audience. UNIT8- Managing Budgets and Resources Reference No : CMI 314 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the importance of managing resources in own area of responsibility. 2. Understand the use of budgets in an organisation. 3. Understand how to manage costs within a budget. UNIT9- Managing Data and Information Reference No : CMI 318 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the reasons for collecting data and information. 2. Know how to manage data and information. 3. Know how to interpret data and information and communicate findings. UNIT10- Managing Meetings Reference No : CMI 319 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the purposes and types of meetings. 2. Understand how to prepare for meetings. 3. Understand how to facilitate and chair meetings. UNIT11- Managing Own Personal and Professional Development Reference No : CMI 321 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the benefits of personal and professional development. 2. Know how to identify opportunities for personal and professional development. 3. Know how to create and monitor a personal and professional development plan. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. Management Direct As part of the program, you will get access to CMI Management Direct, which provides a rich foundation of management and resource for students. The Management Direct is packed with content, including: E-Books Articles Leader videos Idea for leaders Models and so much more... How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

An exciting 10-week course to build your Spanish skills from scratch. Practical applications for travel & conversation. Enlarge your vocabulary, improve your grammar in a pain-free, step-by-step way, working with a tutor with 10+ years' experience & a small group of learners.

An exciting 10-week course to build your Spanish skills from scratch. Practical applications for travel & conversation. Enlarge your vocabulary, improve your grammar in a pain-free, step-by-step way, working with a tutor with 10+ years' experience & a small group of learners.

Course Overview Learn the secrets to creating successful presentations in PowerPoint, with this step-by-step masterclass. This PowerPoint Presentation: Slide Creation course will guide you through the process of creating slideshows in PowerPoint, step-by-step. It will teach you everything you need to know to add life to your slides and make your presentations flow, holding your audience's attention from start to finish. By the end of the course, you will be able to write compelling content for any audience, use images to add impact, and break down information into digestible content. You will be fully familiar with PowerPoint's key features and tools to create winning presentations every time. Enrol today and take your PowerPoint presentations to the next level. This best selling PowerPoint Presentation: Slide Creation has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth PowerPoint Presentation: Slide Creation is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The PowerPoint Presentation: Slide Creation 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 PowerPoint Presentation: Slide Creation 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 PowerPoint Presentation: Slide Creation, 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 PowerPoint Presentation: Slide Creation 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 PowerPoint Presentation: Slide Creation 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.

Learn about basic Alias interface and various tools and surface creation ways! If you are new to Alias, this course is the best choice for you. Course Description We have released some lessons as a short Autodesk Alias tutorial so car design lovers can follow and learn Alias easily. Thanks to Mohammad, our mentor for providing tutorials. For more professional Alias modelling courses please visit MS3D Academy. Here's why you'll succeed Start with Zero KnowledgeThis course is good for beginners who want to start from zero. Full explanations will help you to understand Alias interface as well. Gold StartLearning Alias interface and useful tools will help you to understand basics of car 3D modeling better and get ready for full car courses. Experienced InstructorsAll lessons include step-by-step instructions by a highly talented instructor with extensive knowledge about Alias modelling. Course Lessons Start Start from here! Download Autodesk Alias Basic Tutorials Alias Basics 1 Alias Basics 2 Review The Course Alias Basics 3 Alias Basics 4 Alias Basics 5 The End! Upload Your First Alias Model Review The Course Next Step? Ready to help you anytime About this course Free 12 lessons 2 hours of video content FAQ What is Autodesk Alias? Autodesk Alias is the most professional software being used at automotive industries and design studios. The power of analyzing surfaces, high quality surfaces, nice flows and pro connections and other features have turned Alias into a very useful and professional software. Alias supports all formats of 3D files as inputs and export many useful formats which made Alias a compatible software. Alias focuses on automotive design as Autodesk introduce and promote it as the only professional 3D surface designer. How can I download and install Alias? You can download Autodesk Alias Surface 2021 from MS3D.net website. Autodesk Alias Surface and Autodesk Alias Auto Studio from 2020 to 2022 are what you have to download and install. Autodesk offers a FREE 30 days trial version to students. You can register at Autodesk website and download it. Although you may purchase the full version which is unlimited.] You can also use the cracked version if you just want to learn Alias at home. We do not guarantee the license whereas many websites offer that. How long do I get access to my courses? You will access the contents immediately after you purchased a course. You’ll have lifetime access to the course and all its contents, so you can watch them whenever you like. Most of the videos we provide are downloadable so you may download them and watch later. Can I register for a course if I am working full time? Yes, of course! All of our courses are pre-recorded. You can work on your own pace and will support your step-by-step to makes sure you make most benefit out of your investment. Most of our course contents are downloadable so even if you didn't have access to internet, you can still watch the contents. What is the language of the courses? The Language of the recorded videos is English. It is a very easy listening speaking with very responsive reactions along the video. For some students, is is very important to completely understand what the mentor is saying. So we respectfully inform you that the speaking is very understandable in all of the videos so even students who are not very proficient in English can use these videos. Many students with a low level of English knowledge were certified (from other courses) with satisfaction. What's Next? After you learned about Basics of Autodesk Alias, you can go one step forward and join our 3D Car Modeling courses provided by MS3D Academy to start your professional Alias car modeling career. We support you until the end!

Dive into the world of naturotherapy with our carefully designed Naturotherapy Essentials Course. This course offers a thorough introduction to the healing powers of natural therapies, where you’ll explore the essential principles and practices that have been honed over centuries. From the basics of herbal medicine to the key techniques used in holistic healing, this course lays the groundwork for anyone interested in pursuing a deeper understanding of natural wellness. Throughout the course, you’ll uncover a range of topics, including aromatherapy, reflexology, and the benefits of various natural treatments. By the end, you'll have a solid foundation in naturotherapy, allowing you to appreciate the powerful effects of nature-based healing. Whether you wish to enhance your personal wellness routine or explore the potential to pursue a career in this growing field, this course provides the knowledge you need. With a focus on theory, you’ll gain insights into how these therapies can be used to improve overall well-being, addressing common health concerns and promoting balance. Join us and begin your journey toward understanding the essential aspects of naturotherapy today. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Naturotherapy Module 02: Fundamentals of Human Biology and Physiology Module 03: Naturopathic Assessment and Diagnosis Module 04: Nutrition and Diet Module 05: Herbal Medicine Module 06: Alternative Medicine - Homeopathy Module 07: Physical Therapies in Naturotherapy Module 08: Mind-Body Connection and Therapies Module 09: Professional Practice in Naturotherapy Learning Outcomes: Analyse human physiology for holistic health assessments. Integrate nutrition principles into naturopathic practices effectively. Apply herbal medicine knowledge in holistic treatment plans. Demonstrate competence in alternative therapies like homoeopathy. Employ physical therapies for comprehensive naturotherapy practices. Establish professional naturotherapy practices with ethical considerations. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals passionate about holistic health. Aspiring naturopaths seeking in-depth knowledge. Health practitioners expanding their holistic skills. Wellness enthusiasts eager to explore alternative therapies. Those intrigued by the mind-body connection. Individuals committed to a comprehensive well-being approach. Students pursuing a career in natural healing. Anyone aspiring for a transformative journey in holistic health. Career path Holistic Health Consultant Naturopathic Practitioner Herbal Medicine Specialist Nutrition and Wellness Advisor Alternative Therapies Practitioner Holistic Lifestyle Coach Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Trying New Things Course Overview This course, "Trying New Things," is designed to encourage learners to step outside their comfort zones and embrace new experiences. It focuses on the value of trying new things and how it contributes to personal growth and professional development. The course will guide you through various strategies to foster an open mindset, improve adaptability, and gain confidence in tackling unfamiliar situations. Upon completion, you will have the skills and motivation to explore new opportunities in both your personal and professional life. This course aims to inspire you to take initiative, embrace change, and build resilience in navigating new challenges. Course Description "Trying New Things" offers learners the opportunity to explore the benefits of expanding their horizons and pushing boundaries. The course delves into techniques for overcoming fear and hesitation when faced with unfamiliar experiences. You will explore methods to develop curiosity, adaptability, and a growth mindset, while learning how to apply these skills in various aspects of life. Key topics include risk-taking, fostering creativity, and setting realistic goals for change. Through engaging learning materials, you will gain confidence in trying new things and be equipped with the mental tools to make sound decisions when faced with novel situations. By the end of the course, learners will have a comprehensive understanding of how embracing change and new challenges can lead to lasting personal and career growth. Trying New Things Curriculum: Module 01: The Power of Trying New Things Module 02: Overcoming Fear and Embracing Change Module 03: Developing a Growth Mindset Module 04: Setting and Achieving Personal Challenges Module 05: Building Confidence in New Experiences Module 06: Leveraging New Experiences for Career Growth Module 07: Reflecting and Adapting for Continued Success (See full curriculum) Who is this course for? Individuals seeking to enhance their personal growth and resilience Professionals aiming to improve their adaptability and innovation in the workplace Beginners with an interest in embracing change and self-improvement Anyone interested in developing new skills and expanding their potential Career Path Personal development coach HR professional Leadership and team development roles Innovation and creativity-focused industries Entrepreneurship and small business management

Listening Masterclass Course Overview: The "Listening Masterclass" is designed to enhance learners' listening abilities, focusing on effective communication and comprehension. This course delves into the key components of listening, exploring the difference between hearing and listening, as well as the nuances of active and passive listening. It highlights various listening types and offers techniques to improve listening skills. Upon completion, learners will be able to engage in more focused and empathetic conversations, benefiting both their personal and professional relationships. This course is ideal for those who wish to refine their communication abilities, develop stronger listening techniques, and understand the power of listening in various contexts. Course Description: This course provides a deep dive into the fundamentals of listening, including the distinction between hearing and listening, and the differences between active and passive listening. Learners will explore various types of listening, from empathetic to critical listening, and how each plays a role in communication. The course also covers practical strategies for enhancing listening skills, such as mindfulness techniques and the importance of body language. Learners will gain a comprehensive understanding of the benefits of listening, including improved personal interactions, better professional relationships, and enhanced problem-solving capabilities. By the end of the course, participants will be able to apply effective listening strategies in diverse situations, from the workplace to social interactions, resulting in stronger connections and more effective communication. Listening Masterclass Curriculum: Module 01: What are Good Listening Skills? Module 02: Difference between Active and Passive Listening Module 03: Difference between Listening and Hearing Module 04: Ways to Improve Your Listening Skills Module 05: Types of Listening Module 06: Benefits of Good Listening Skills Module 07: Conclusion (See full curriculum) Who is this course for? Individuals seeking to improve their communication skills. Professionals aiming to enhance their ability to engage with others effectively. Beginners with an interest in refining their listening abilities. Anyone looking to foster stronger personal and professional relationships. Career Path Customer Service Representative Human Resources Professional Sales and Marketing Specialist Public Relations Officer Educational Instructor or Trainer Mediator or Conflict Resolution Specialist Healthcare Provider (e.g., Nurses, Therapists)

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data. This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. Working with Multiple Worksheets and Workbooks Working with Named Ranges Link Cells Across Worksheets and Workbooks Use 3D References to Calculate Across Worksheets Consolidate Data Use Formula Auditing and Error Checking Reveal Formulas Trace Cell Precedents and Dependents Locate Errors in Formulas Watch and Evaluate Formulas Reviewing and Protecting Workbooks Control Data Entry via Data Validation Protect Workbook Access Protect Worksheets and Cell Content Add and Edit Comments Prepare a Workbook for Distribution Modify Excel's Default Settings Using Macros to Automate Workbook Functionality Create Macros via Recording Run Macros via Buttons and Shortcuts Assign Macros to the Quick Access Toolbar and Ribbon Assign Macros to Objects View Macro Code Forecasting and Analysis Data Use Conditional Formatting to Highlight, Sort and Filter Key Data Advanced Conditional Formatting using Formulas Create Sparklines to Visualise Data Add Trendlines to Charts to Visualise and Forecast Trends Use Data Tables and Scenarios to Project Potential Outcomes Use Goal Seek to Calculate Outcomes Forecast Data Trends Using Solver