17354 Other courses in Shepshed delivered Online

Duration 3 Days 18 CPD hours This course is intended for This course is for IT professionals who manage on-premises Windows Server environments and want to use Azure to manage server workloads and run their virtual workloads on Windows Server 2019. They also want to use existing Microsoft System Center products to implement and manage software-defined datacenters with Windows Server 2019. Overview Describe the Azure Stack portfolio, including Azure Stack HCI, Azure Stack Hub, and Azure Stack Edge Describe the Azure Stack HCI core technologies and management tools. Describe the process of a typical Azure Stack HCI implementation. Identify Azure Stack HCI hybrid capabilities. Implement, manage, and maintain workloads on Azure Stack HCI. Plan for and implement Azure Stack HCI Storage, including Storage QoS and Storage Replica. Plan for Azure Stack HCI Networking. Implement Software Defined Networks in Azure Stack HCI. This three-day course WS-013T00-A is intended primarily for IT Professionals who already have significant experience with managing an on-premises Windows Server environment. Its purpose is to cover advanced topics related to Windows Server software-defined datacenter, Azure Stack HCI, and other Azure Stack products. The course also describes the use of existing Microsoft System Center products to implement and manage software-defined datacenters with Windows Server 2019. This course is advanced and is designed for people that want to run their virtual workloads on Windows Server 2019 at medium-to-large scale using software-defined datacenter and hyper-converged principles. Introducing Azure Stack HCI Overview of Azure Stack HCI Overview of Azure Stack HCI technologies Overview of Azure Stack HCI management tools Overview of the Azure Stack HCI hybrid capabilities Operating and maintaining Azure Stack HCI Implementing and managing workloads on Azure Stack HCI Maintaining Azure Stack HCI Planning for and implementing Azure Stack HCI storage Overview of Azure Stack HCI Storage core technologies Planning for Storage Spaces Direct in Azure Stack HCI Implementing a Storage Spaces Direct-based hyper-converged infrastructure Managing Storage Spaces Direct in Azure Stack HCI Planning for and implementing Storage QoS Planning for and implementing Storage Replica Planning for and implementing Azure Stack HCI networking Overview of Azure Stack HCI core networking technologies Overview of network virtualization and Software-Defined Networking Planning for and implementing Switch Embedded Teaming Planning for and implementing Datacenter Firewall Planning for and implementing Software Load Balancing Planning for and implementing RAS Gateways

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modeling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. This course updates and replaces course 10985C previously published under the same title. 1 - Introduction to databases Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages 2 - Data Modeling Data Modelling Designing a Database Relationship Modeling 3 - Normalization Fundamentals of Normalization Normal Form Denormalization 4 - Relationships Introduction to Relationships Planning Referential Integrity 5 - Performance Indexing Query Performance Concurrency 6 - Database Objects Tables Views Stored Procedures, Triggers and Functions Additional course details: Nexus Humans 55313 Administering Configuration Manager, Part 1: Fundamentals and Asset Management training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55313 Administering Configuration Manager, Part 1: Fundamentals and Asset Management course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 4.125 Days 24.75 CPD hours This course is intended for The job roles best suited to the material in this course are: Individuals responsible for maintaining and improving the workplace safety, Occupational health and safety officers, consultants, and advisors, Professionals wishing to acquaint themselves with PECB's IMS2 Methodology for implementing an OH&S MS, Individuals responsible for maintaining the conformity of OH&S MS to ISO 45001 requirements, Members of OH&S teams, Individuals aspiring to pursue a career as OH&S MS implementers, consultants, or officers Overview Explain the fundamental concepts and principles of an occupational health and safety management system (OH&S MS) based on ISO 45001 Interpret the ISO 45001 requirements for an OH&S MS from the perspective of an implementer Initiate and plan the implementation of an OH&S MS based on ISO 45001, by utilizing PECB's IMS2 Methodology and other best practices Support an organization in operating, maintaining, and continually improving an OH&S MS based on ISO 45001 Prepare an organization to undergo a third-party certification audit This course is designed to equip you with the competence to establish, implement, manage, and maintain an occupational health and safety management system (OH&S MS) in accordance with ISO 45001:2018 requirements and guidance. This training course aims to provide an in-depth understanding of ISO 45001 requirements, as well as the best practices and approaches used for the implementation and subsequent maintenance of an OH&S MS. The ultimate ambition of this training course is to enable you to create the conditions for a safer workplace. Introduction to ISO 45001 and initiation of an OH&S MS implementation Training course objectives and structure Standards and regulatory frameworks Fundamental concepts and principles of OH&S Initiation of the OH&S MS implementation The organization and its context Implementation plan of an OH&S MS Leadership and worker participation OH&S MS scope OH&S policy and objectives Hazard identification and assessment of risks and opportunities Implementation of an OH&S MS Resource management Awareness and communication Documented information management Operations management Emergency preparedness and response OH&S MS performance evaluation, continual improvement, and preparation for the certification audit Monitoring, measurement, analysis, and evaluation Internal audit Management review Treatment of nonconformities and incidents Continual improvement Preparation for the certification audit Closing of the training course

Diet and Nutrition: Diet and Nutrition Course Online With this exclusive Diet and Nutrition: Diet and Nutrition Course, you can learn about the increasingly important role of the professional nutrition adviser while also developing valuable life skills. Discover why qualified nutritionists are in higher demand globally than ever before and start working toward a fulfilling profession for life. The general public is becoming more aware of the importance of dietary choices to overall human health all around the world. We are what we eat, and how we approach our daily diets has a significant impact on all aspects of health and wellness. Because of the importance of dietary balance, millions of individuals worldwide have begun to take their eating habits more seriously, proactively monitoring and managing what they put into their bodies. Nonetheless, expert nutritionists' guidance and assistance are required to guide health-conscious individuals in the right direction. This Diet and Nutrition: Diet and Nutrition Course provides learners with a thorough introduction to one of the world's most important and fascinating contemporary professions. The Diet and Nutrition: Diet and Nutrition Course curriculum focuses on important areas of nutrition and dietetics of practical value in a working scenario, laying a solid basis for a satisfying lifelong career. Among the core topics covered include how various key nutrients affect human health, the role nutrition plays in building and strengthening the immune system, the connection between dietary choices and disease risk, an overview of detoxification digestion, an introduction to women's health issues, and many more. Courses you will get: Course 01: Level 1 Diet and Nutrition Course 02: Diet and Nutrition (Diploma Level 5) Course 03: Level 2 Award in Nutrition and Health Course 04: Level 1 Certificate in Well-being Course 05: Level 5 Diploma in Nutrition Course 06: Level 5 Nutritional Therapy Course 07: Diploma in Sports Nutrition Course 08: Nutrition Course (Level 3 Certificate) Course 09: Personal Trainer Course 10: Sports First Aid Course 11: Level 2 Certificate in Understanding Nutrition and Health Course 12: Level 2 Award in Improving Personal Exercise, Health and Nutrition [ Note: Free PDF certificate as soon as completing the Diet and Nutrition: Diet and Nutrition Course] iet and Nutrition: Diet and Nutrition Course Online This Diet and Nutrition: Diet and Nutrition Course consists of 15 modules. Assessment Method of Diet and Nutrition: Diet and Nutrition Course After completing Diet and Nutrition: Diet and Nutrition Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Diet and Nutrition: Diet and Nutrition Course After completing the Diet and Nutrition: Diet and Nutrition Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Diet and Nutrition: Diet and Nutrition Course Online This Diet and Nutrition: Diet and Nutrition Course is suitable for anyone who wants to get to the top of the profession and requires no prior knowledge or experience. The Diet and Nutrition: Diet and Nutrition Course is ideal for both newcomers and existing members of the workforce. This Diet and Nutrition: Diet and Nutrition Course is also highly recommended for anyone interested in freelancing or self-employment opportunities all around the world. Requirements Diet and Nutrition: Diet and Nutrition Course Online To enrol in this Diet and Nutrition: Diet and Nutrition Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Diet and Nutrition: Diet and Nutrition Course. Be energetic and self-motivated to complete our Diet and Nutrition: Diet and Nutrition Course. Basic computer Skill is required to complete our Diet and Nutrition: Diet and Nutrition Course. If you want to enrol in our Diet and Nutrition: Diet and Nutrition Course, you must be at least 15 years old. Career path Diet and Nutrition: Diet and Nutrition Course Online Diet and Nutrition: Diet and Nutrition Course is a field with limitless scope for self-employment and freelance job opportunities. Successful candidates with this Diet and Nutrition: Diet and Nutrition Course can pursue a more formal position such as: Sports Nutritionist Health Coach Holistic Nutritionist Public Health Nutritionist

Gain the insights, tools, and frameworks to make impactful decisions that steer your organisation towards success. Elevate your strategic thinking and drive results Course overview Duration: 1 day (6.5 hours) Strategic decision making is messy, complex and full of uncertainty. These are factors which work against the human mind when it comes to making effective decisions. This course provides delegates with insights into the factors influencing strategic decision making. Using psychometric profiles delegates will learn about their own preferences when making decisions, how to influence others and how to create the ideal conditions for successful strategic decision making. Objectives By the end of the course you will be able to: Explain the challenges of VUCA – Volatility, Uncertainty, Complexity & Ambiguous Use models of Strategic Thinking Understand the impact of perception, bias and judgement in decision making Understand personal preferences and approaches to decision making Speed read other people’s approach to decision making Use decision making models for strategic thinking Apply Mindsets, Skillsets and Toolsets for decision making Content The decision lifestyle - personal preferences Understand the human facts that influence decision making Understanding personal preferences and approaches to decision making Understand the impact of Perception, Bias and judgement in decision making Speed reading others’ approach to decision making Frameworks to provide context for decision making Understand the business factors that influence decision making – VUCA The Cynefin Framework – decision making in complex situations Understanding which business context you operate in – simple, complicated, complex or chaotic Models to improve strategic thinking How to understand yourself better How to improve your decision making How to understand others better How to improve other’s decision making Human centred decision making How to put humans at the centre of your decision making The art of Creative Problem Solving Using Design Thinking to reduce human complexity in decision making

Sports Nutrition Diploma is important in maximising the benefits of physical exercise, whether you're a bodybuilder, a professional athlete in training, or working out to enhance your mental and physical health. Making smart nutrition and hydration decisions can result in greater performance, injury avoidance, and faster recovery. But it can be tough to know where to begin with so much contradicting information readily available. That's where a skilled sports nutritionist can help you make better decisions and eventually enhance your performance. Sports nutrition is the study and use of a diet/plan to improve athletic performance. To maximise energy and help in sports recovery, the proper amount of food type (protein, carbs, fats, fibre, etc.), fluids, and nutrients are provided. It is most commonly seen in endurance and strength sports. Athletes require different nutritional levels than non-athletes, hence sports nutrition differs from conventional nutrition. Our Sports Nutrition Diploma course is designed to introduce you to nutrition, as well as the role and importance of nutrition in leading a healthy lifestyle. It will also expand your knowledge so that you are able to build diet plans based on the demands of your clients. The only goal of the Sports Nutrition course is to teach a person about the fundamental as well as advanced mechanisms of nutrition as a whole that will assist an athlete perform at his or her best. This Sports Nutrition Diploma course will teach you about nutrition and its role and importance in leading a healthy lifestyle. It will also expand your knowledge so that you are well prepared to design diet plans based on your clients' needs. The sole purpose of our Sports Nutrition Diploma course is to teach an individual about the fundamental and advanced mechanisms of nutrition as a whole that will help an athlete perform at his or her best. Learning Outcomes By the end of Sports Nutrition Diploma course, you will be able to: Describe the basics of sports nutrition and its classification, including macro and micronutrients especially designed for athletes. Get insight into the digestive system. Explain nutritional requirements according to various age groups and professions. Demonstrate planning healthy eating habits for athletic clients. Understand the framework for energy requirements. Carry out weight control and weight loss management. Explain how to design nutrients plans for specific sports competitions and to replace them afterwards. Why Choose Sports Nutrition Diploma Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ****6 Course Bundle**** Course 01: Sports Nutrition Diploma Course 02: Sports First Aid Course 03: Martial Arts First Aid Course 04: Level 5 Diploma in Nutrition Course Course 05: Childcare and Nutrition Course 06: Level 1 Diet and Nutrition Course ***Other Benefits Include*** Free 6 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Sports Nutrition Diplomacourse] We will discuss all concerns and more in this Sports Nutrition course to help you learn how to properly sustain your way through training. This course will teach you how to improve your nutritional knowledge, enhance your energy levels, and maximise your performance, all while being more knowledgeable about your health and well-being. This course will be more helpful for fitness professionals, athletes, and non-athletes and will cover macronutrients, micronutrients, energy systems, nutritional timing, developing a nutrition plan, and fueling for competition. With this Sports Nutrition Diploma, you will find it much easier to achieve success and monetise your skills. This course is destined for both part-time and full-time students and can be completed at your own pace. Enrol in the Sports Nutrition Diploma to increase your knowledge of sports and nutrition and help athletes, sportspeople, and fitness enthusiasts to achieve their goals. Whether you plan to take this course for personal or professional reasons, it will benefit you at every stage of your life cycle; after all, health is wealth. In short, knowing what foods are good for your body is extremely important for leading a healthy lifestyle. Course Curriculum of *** Sports Nutrition Diploma *** Module 1: A Quick Overview of Sports Nutrition What is Sports-Nutrition? Why Study Sports Nutrition? What are the Basic Nutrients? How does the Body Produce Energy? What are the Dietary Reference Intakes? What are Enriched and Fortified Foods? What are the Factors to Consider When Developing an Individualized Sports Nutrition Plan for Athletes? Module 2: Diet and Nutrition: Dietary Guidelines Current Dietary Patterns in the UK Dietary Reference Values (DRVs) and Food-based Dietary Guidelines Diet Trends and Health Module 3: Nutrition and Athlete Health Introduction The Training Diet Special Issues Competition Eating Sports Foods and Supplements A Rational Approach to Supplement Module 4: Diet Planning Food for Energy CarbohydratesProteinHealthy FatsFruit and VegetablesFluids Exercise Routine How Much Exercise is Enough? Module 5: Healthy Dieting Balanced Diet Health and Fitness Using Basic Food Groups for Planning Balanced Diets Module 6: The Digestive System Introduction Enzymes and Digestion Key Components of the Digestive System Processes in the Digestive System Module 7: Water Water and its Functions The Importance of Water in the Body The Significance of Water to the Diet Module 8: Weight Control and Weight Loss Management Introduction Weight - Control Behavior in Athletes Achieving a Healthy and Competitive Body Weight Energy Restriction Approaches Timing of Food Consumption During Training and Throughout the Day Diet Plan for Weight Loss Consumption of Energy Dense Beverage Protein Intake, Quality, and Timing Module 9: The Role of the Vegetarian/Vegan in Sports Nutrition Introduction Types of Vegetarian Diets Vegetarian Diets and Athletic Performance Disadvantages of the Vegetarian Diets Practical Applications Module 10: Myth and Misinformation Various Myths Relating to Sports Nutrition Module 11: Performance Boosters Introduction Definition of a Dietary Supplement Sports Foods Performance Supplements Disadvantages of Sports Foods and Dietary Supplements -------------------- ***Course 02: Sports First Aid*** Course Curriculum Module 01: An Overview of Sports First Aid Module 02: Preliminary Analysis Module 03: Importance of Life-Saving Priorities Module 04: First Aid for Frequent Injuries Module 05: First Aid for Severe Injuries Module 06: Injuries Caused by the Environment Module 07: Understanding Medical Emergencies Module 08: Points to Remember ----------------- ***Course 03: Martial Arts First Aid Course Curriculum Module 01: An Overview of Martial Airs First Aid Module 02: Primary Assessment Module 03: CPR & Recovery Position Module 04: Dealing with Frequent Injuries Module 05: Dealing with Serious Injuries Module 06: Dealing with Medical Emergencies Module 07: The Way of Preventing Injuries Module 08: Things to Remember ----------------- ***Course 04: Level 5 Diploma in Nutrition Course Course Curriculum Module 1: Introduction to Nutrition Module 2: Diet and Nutrition: Dietary Guidelines Module 3: Nutrition and the Human Body Module 4: Nutrition Important for Metabolism and Blood Function Module 5: Macronutrients in the Diet: Protein Module 6: Macronutrients in the Diet: Lipids Module 7: Nutrition throughout the Life Cycle Module 8: Nutrition and Society: Food Politics and Views --------------- ***Course 05: Childcare and Nutrition Course Curriculum Module 01: Childcare and Nutrition Module 02: Children Growth and Development Module 03: Health and Safety of Children Module 04: Hygiene for Child Caring Module 05: The Use of Macronutrients Module 06: The Use of Micronutrients Module 07: Nutritional Requirements of Child Module 08: Child Nutritional Problem and Physical Development Module 09: Caring for Special Needs Children Module 10: Child Abuse and Neglect Module 11: Nutrition Education and Activities ---------------- ***Course 06: Level 1 Diet and Nutrition Course Course Curriculum Module 01: Introduction to Diet and Nutrition Module 02: Dietary Nutrition Module 03: Food Composition Module 04: Principles of Healthy Eating Assessment Method After completing each module of Sports Nutrition Diploma 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. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for Sports Nutrition Diploma course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? The Sports Nutrition Diploma course is ideal for highly motivated individuals who want to improve their professional skills and train for the job of their dreams! In addition, this Course is also suitable for those who want to gain in-depth knowledge on the subject and stay up to date with the latest information. Requirements There are no specific requirements for Sports Nutrition Diploma course because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path A career in Sports Nutrition Diploma can be challenging, rewarding, and frustrating at times, but it is never boring. Although there are significant challenges in many sectors, such as funding availability and commercial sustainability, this will require managers of high caliber and with a diverse set of specialties, and it provides great opportunity for innovation. Certificates Certificate of completion Digital certificate - Included

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Road to Passive Income course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Road to Passive Income course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Road to Passive Income and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Road to Passive Income course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Road to Passive Income course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Road to Passive Income will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Introduction Introduction 00:04:00 Section 02: What are Recurring Income Streams? What are Recurring Income Streams? 00:05:00 What Is the Recurring Revenue Model? 00:04:00 What Should You Sell to Make the Recurring Revenue Model Work? 00:05:00 The Importance of Recurring Revenue in a Thriving Business 00:03:00 Reasons Fortune 500 Companies Are Moving to Recurring Revenue Models 00:03:00 How Recurring Revenue Increases Business Value 00:06:00 Section 03: What is Residual Income? What is Residual Income? 00:04:00 What Is Residual Income And Why Do You Want It? 00:03:00 What is Residual Income & Why is it Important for Building Wealth? 00:04:00 Reasons Why Passive Income Is Important 00:04:00 How Does Residual Revenue Work? 00:04:00 Why Residual Income is Important for Financial Independence 00:05:00 Section 04: Types of Recurring Income Types of Recurring Income 00:04:00 Hard contracts 00:05:00 Auto renewal subscriptions 00:04:00 Build a Membership Program for Your Business 00:03:00 Become an Affiliate for Other Companies Products 00:03:00 Combine Online Membership and Physical Product Delivery 00:04:00 Section 05: Types of Residual Income Types of Residual Income 00:05:00 Consider Investing 00:04:00 Write a Book or E-Book 00:04:00 Build an Online Course 00:05:00 Create an App 00:04:00 Launch a Podcast 00:02:00 Section 06: Relationship between Recurring, Residual and Passive Income Relationship between Recurring, Residual and Passive Income 00:04:00 How They're Similar and also Different 00:04:00 What is Passive Income and Its Relationship to Passive and Residual Income? 00:04:00 Examples of Passive Income 00:04:00 The Truth about Active Income vs Passive Income 00:03:00 Active Income Becomes Passive Income 00:03:00 Section 07: Building Wealth Strategies Building Wealth Strategies 00:04:00 Effective Wealth Building Strategies Used by Personal Finance Pros 00:04:00 Develop a Wealthy Mindset 00:03:00 Strategies for Building Wealth 00:05:00 Strategies to Build Wealth Fast (That Your Financial Advisor Won't Tell You) 00:04:00 How to Begin to Build Wealth 00:04:00 Section 08: Conclusion Review 00:03:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. 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. Certification After you have successfully completed the course, 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 hardcopy 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 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 Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:04:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:04:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:07:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excel's IF() Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 INDEX() Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:14:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Lopps For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Letting Agent Mini Bundle is designed for jobseekers eager to enter the fast-paced world of lettings, property rentals, and tenant management. With targeted skills in estate agent practices, the construction industry scheme, compliance, negotiation skills, and accounting, this bundle makes you the reliable, hireable professional landlords and agencies need now. Description The lettings industry requires more than charm—it demands precision, negotiation, and compliance. Whether you’re looking to manage residential units, support commercial tenants, or assist in agency offices, the Letting Agent Mini Bundle brings together the top five competencies employers expect: estate agent knowledge, awareness of the construction industry scheme, strict compliance skills, negotiation skills, and accounting proficiency. Estate agents involved in lettings must now understand the basics of construction and repair via the construction industry scheme. Compliance ensures you stay aligned with rental laws and data protocols. Negotiation skills are what close the deal, and accounting helps maintain accurate financial records on behalf of both landlords and tenants. Letting offices are hiring now, and they’re shortlisting fast. With estate agent, construction industry scheme, compliance, negotiation skills, and accounting experience, you’ll go from overlooked to overqualified. FAQ Is this for those already in property? It's great for newcomers and industry professionals alike—especially those transitioning into lettings from other property roles. Why is the construction industry scheme relevant? Letting agents often coordinate repairs and contractor work, so knowledge of the construction industry scheme is critical. Will negotiation skills actually help in lettings? Yes—negotiation skills are essential for agreeing tenancy terms, resolving disputes, and closing rental deals. What type of employers does this appeal to? Estate agencies, letting firms, property developers, and housing associations. Why is compliance such a big deal? The lettings industry is heavily regulated. Compliance protects you—and your employer—from legal missteps. Why enrol now? The lettings market is heating up. Make sure you’re seen—with estate agent, construction industry scheme, compliance, negotiation skills, and accounting competence—before someone else is.

For those determined to rise through the people-management ranks, the People Practice Mini Bundle delivers the perfect springboard. Built for modern workplaces, this bundle weaves together HR, team leader, equality and diversity, disaster management, and problem solving — making you an invaluable asset in any organisation. Whether you’re just entering HR or aiming to refine your problem solving edge, this course positions you as someone ready for the people challenges of tomorrow. Hiring managers aren’t just hiring experience — they’re hiring adaptability, and this is the Mini Bundle to prove it. 🧰 Description Today’s roles aren’t just about skills; they’re about values. This People Practice Mini Bundle meets that demand head-on with its focus on equality and diversity, HR, and team leader readiness — all while adding a high-demand edge through disaster management and problem solving. Employers are actively seeking professionals who can manage people during crises, solve problems under pressure, and lead with empathy. This is the kind of certification that keeps your CV relevant — and your inbox full of interviews. Don't wait until HR trends shift again. It’s not just smart to act now — it’s necessary. ❓ FAQ Is this Mini Bundle suitable for aspiring HR professionals? Absolutely. HR and team leader roles are front-and-centre in this training. Can this help me in public sector or NGO roles? Yes. Equality and diversity, disaster management, and HR are core to these fields. Is this a good starting point for new managers? Yes. If you're aiming to be a team leader, this gives you practical grounding. Do I need experience in HR to benefit? No prior experience required — just ambition and commitment. What makes this different from other HR courses? It combines problem solving, disaster management, and equality and diversity — setting you apart. Is now a good time to enrol? If you want to be job-ready before the next hiring wave — absolutely.