1885 Audit courses in Cardiff delivered On Demand

Highlights of the Food Safety Diploma Course Type: Online Learning Duration: 2 Hours 2 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about food safety Understand the core competencies and principles of food safety Explore the various areas of food safety Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert catering manager Food Safety Diploma Master the skills you need to propel your career forward in food safety. This course will equip you with the essential knowledge and skillset that will make you a confident catering manager and take your career to the next level. This comprehensive food safety level 3 course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this food safety level 3 course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective food safety practice and equip you with the essential skills, confidence and competence to assist you in the food safety industry. You'll gain a solid understanding of the core competencies required to drive a successful career in food safety. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for catering manager or for people who are aspiring to specialise in food safety. Enrol in this food safety level 3 course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive food safety level 3 course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this food safety can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This online food safety course diploma has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This food safety level 3 course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This online food safety diploma course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Check out our Achieving Food Hygiene Rating Level 5 Training Online to further enhance your knowledge and skills in the food industry. Invest in your professional development and ensure the safety and satisfaction of your customers. Enrol now and start your journey towards success! Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Prologue: The importance of food Prologue: The importance of food safety 00:02:00 Introduction Introduction 00:03:00 Prerequisites Pest Control 00:12:00 Structure and equipment 00:07:00 Cleaning and disinfection 00:06:00 Flow Diagrams Flow Diagrams 00:02:00 Hazard Analysis and Critical Control Points: and introduction INTRODUCTION TO HACCP 00:04:00 Principle 1: Identity Hazards and Controls Physical, allergenic and chemical contamination 00:06:00 Microbiological contamination 00:04:00 Microbiological multiplication 00:08:00 Microbiological survival 00:03:00 Principle 2: Identity Critical Control Points Identify Critical Control Points 00:03:00 Establish critical limits Establish critical limits 00:04:00 Principle 4: Implement monitoring of CCP's Principle 4: Implement monitoring of CCP's 00:02:00 Principle 5: Establish corrective actions Principle 5: Establish corrective actions 00:02:00 Principle 6: Verification An introduction to verification. 00:01:00 Verification: Monitoring complaints (food poisoning). 00:07:00 Verification: Internal Audits 00:09:00 Principle 7: Documentation Principle 7: Documentation 00:02:00 The Supervisors Role in Food Safety The Supervisors Role in Food Safety 00:01:00 Food Safety Law Food Safety Law 00:07:00 Course summary and revision Course summary and revision 00:17:00 Thank you and GoodBye A thank you from me 00:01:00 Bonus Lecture Bonus Lecture 00:02:00 Assessment Assessment - Food Safety Diploma 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Want to learn how to become the star of your corporate organisation? Do you want to learn the secrets behind the promotions at workplaces? Are you aiming excel at your workplace? Are you looking for the reasons of how to become the employee of the month? If yes is your answer, then enrol now and benefit from the course. Description: The corporate world is a place wherein an individual needs to carve out one's approach to get to the higher echelon of the firm's ladder. It is the workplace where the employees face a level of competition to seek praises in the form of promotions or increment. Through this course you will learn about the level of competition that you will have to face as an employee and how will you deal with it to cope up at your workplace. You will also go through the effects of generational differences in management styles and how a generation can become a source of competition. In this course you will learn the necessary skills, knowledge and information of how to become successful in corporate world. Who is the course for? Individuals who are looking for promotion. People who are looking jobs. Individuals who are willing to increase their value at their workplaces. 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 hardcopy 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 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: Become a corporate rockstar course is a useful qualification to possess and would be beneficial for the following careers: Supervisors. Managers. Team leaders. Executives. Staff members. Becomeing a Corporate Rockstar INTRODUCTION 00:30:00 Creating A Positive Competitive Workplace Culture 01:30:00 Analyzing The Time and Energy Tradeoff in high Performance 01:30:00 Using Benchmarking In Setting Performance Targets 01:00:00 How To Show Off Your Strength 00:30:00 Keep Learning And Sharing 01:00:00 CONCLUSION 00:15:00 Corporate Skills You Have To Have A Different Product 00:30:00 Pick A Name 00:30:00 Get People Involved 00:30:00 Catchy Marketing 00:30:00 Be Confident 00:30:00 Review Yourself 00:30:00 Business Management: Corporate Behaviour Module One - Getting Started 00:15:00 Module Two - The Science of Behavior 00:30:00 Module Three - Benefits for Corporate Behavior 01:00:00 Module Four - Most Common Categories of Corporate Behavior 01:00:00 Module Five - Managerial Structure 00:30:00 Module Six - Company Values and Ethics 01:00:00 Module Seven - Employee Accountability 00:30:00 Module Eight - Workplace Incidents 01:00:00 Module Nine - Designing and Implementing 01:00:00 Module Ten - Corporate Team Behavior 01:00:00 Module Eleven - Auditing Corporate Behavior 01:00:00 Module Twelve - Wrapping Up 01:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course overview If you wish to get into Ketosis for a healthy lifestyle, take the proper steps with this Keto Lifestyle Guide Masterclass course and swiftly transition to the Keto diet. The Keto diet is gaining popularity as a way to shed pounds. Many people find that following the keto diet makes it more manageable to lose weight. This Keto Lifestyle Guide Masterclass program will explain the science behind Keto and its importance to the body. You will discover the excellent health benefits of the Keto diet and recognize the adverse effects of a high-sugar diet.  Next, you will identify the crucial aspects of a healthy metabolism. You will learn about the tremendous benefits of a low carb, healthy fat diet. You will also explore how to plan your keto meals and counting macros to ensure you're eating the right amount of nutrients. Enroll now and get started on your path to a healthy and better life.  Learning Outcomes Explore the benefits of the keto diet Identify the importance of intermittent fasting in Keto diet Determine the health benefits of Keto Learn how to boost your metabolism Deepen your understanding of keto meal planning and counting macros Understand the transition process Who Is This Course For?  Anyone interested in transitioning into a keto diet for a healthy lifestyle can take this Keto Lifestyle Guide Masterclass course. The skills gained from this training will provide excellent opportunities for career advancement.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £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 and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Keto Lifestyle Guide Masterclass course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Ketogenic Diet Coach Clinical Dietician Nutritionist Nutritional Therapist Food Safety Auditor Nutrition Educator Ketogenic Diet Plan Author Introduction Course introduction 00:01:00 Content Overview 00:04:00 About the Author About the Author 00:02:00 Gut Issues 00:02:00 Sugar/Carb addiction 00:02:00 Our Journey 00:08:00 My Interest in Diets 00:01:00 Preferred Sources 00:02:00 Introduction to keto Definition and History 00:01:00 The Science behind Keto 00:03:00 Intermittent fasting 00:06:00 What you are not told about high sugar diets 00:03:00 Health benefits of Keto 00:14:00 Calories and Metabolism 00:03:00 Lifestyle Mindset 00:04:00 Adaptation and Precautions 00:12:00 Getting Started Intermittent Fasting 00:03:00 The Low-carb, Healthy-fat Diet 00:05:00 Not All Fats are Created Equal 00:07:00 Keto Meal Planning & Counting Macros 00:07:00 The Transitioning-process Keto-flu 00:07:00 Diet Supplementation 00:08:00 Staying the Course Foods to Eat on Your Keto-diet 00:13:00 Keto/Carb-cycling 00:04:00 Practical tips 00:06:00 Bonus Section Bonus Lecture: Easy & Healthy Keto-friendly Meals 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

🎧 Unleash Your Audio Creativity with Adobe Audition CC - Audio for Everyone! 🎶   Are you passionate about creating captivating audio content but struggle with the technicalities? Whether you're a budding podcaster, an aspiring musician, a content creator, or a filmmaker looking to master the art of audio, our comprehensive online course, 'Adobe Audition CC - Audio for Everyone,' is your ticket to unlocking limitless potential in the world of sound!   🔊 What You'll Learn: Master Adobe Audition CC: From the fundamentals to advanced techniques, navigate the software with ease and confidence. Audio Editing Excellence: Learn the art of editing, mixing, and polishing audio to professional standards. Effectively Remove Imperfections: Say goodbye to background noise, clicks, and unwanted sounds with precise editing tools. Create Stunning Soundscapes: Craft immersive audio experiences, layering effects, music, and vocals seamlessly. Podcasting & Voiceovers: Elevate your podcasts and voiceovers with pro-level editing and enhancements. Musical Magic: Explore music production techniques, from recording to mastering your tracks.   🌟 Why Choose Our Course? Expert Guidance: Led by industry experts with years of experience in audio production. Practical Learning: Hands-on exercises and real-life examples to reinforce your skills. Flexible Learning: Study at your pace, from anywhere, with lifetime access to course materials. Supportive Community: Connect with fellow learners, share insights, and grow together.   🚀 Take your passion for audio to the next level! Join 'Adobe Audition CC - Audio for Everyone' and turn your creative visions into sonorous realities. No prior experience required-just a passion for sound! Course Curriculum

Highlights of the Food Safety Level 3 Course Course Type: Self-paced online course Duration: 2 Hours 2 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Understand the importance of maintaining food safety Gain knowledge about the prerequisites to maintain the premises Identify the critical control points and perform a hazard analysis Know how to implement the monitoring of CCP's Identify and control various hazards and contamination Demonstrate various food safety principles and laws Understand the supervisor's duties in ensuring food safety Explore the various areas of food safety. Know how to apply the skills in a real-life context. Food Safety Level 3  This Level 3 Food Safety and Hygiene course will help you acquire knowledge and skills about advanced food safety techniques and procedures to excel in your role as a supervisor. You will receive instruction from expert instructors with practical expertise who impart the most current knowledge and best practices. Comply with food safety legislation Effective pest control and equipment maintenance Proper cleaning and disinfection techniques HACCP and verification procedures Control food contamination and hazards Establish critical limits and corrective actions Supervisor's role and duties This Food Safety Level 3 course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. This Food Safety Level 3 course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. Who is this Course for? Supervisors and managers who are in charge of planning, managing, or monitoring the health and safety processes in the food industry can take this course. This Level 3 Food Safety and Hygiene course is also open to anyone who works in an environment where food is prepared, cooked, or handled Chefs, kitchen assistants, teachers, care workers, baristas or nursery staff can also take this course to enhance their skills and knowledge of level 3 food safety This course is also open to business owners in the food sector who want to implement food safety procedures within their business This course will also aid beginners who have little to no prior expertise in food safety to increase their chances of getting recruited. This course is open to also everyone, regardless of profession, who wants to gain knowledge about food safety practices. Entry Requirements This Level 3 Food Safety and Hygiene for Supervisors course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone and a reliable internet connection. Assessment This Level 3 Food Safety Course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure.  Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment, the pass mark is 60%. Advance Your Career This Food Safety Level 3 UK Course will provide you with significant opportunities to enter the relevant job market and select your desired career path. Additionally, by showcasing these skills on your resume, you will be able to develop your career, face more competitors in your chosen sector, and increase your level of competition. If you are looking for Food Safety in Catering, enrol into our affordable and highly informative course, which will open your door towards a wide range of opportunities within your chosen sector.  Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Prologue: The importance of food Prologue: The importance of food safety 00:02:00 Introduction Introduction 00:03:00 Prerequisites Pest Control 00:12:00 Structure and equipment 00:07:00 Cleaning and disinfection 00:06:00 Flow Diagrams Flow Diagrams 00:02:00 Hazard Analysis and Critical Control Points: and introduction INTRODUCTION TO HACCP 00:04:00 Principle 1: Identity Hazards and Controls Physical, allergenic and chemical contamination 00:06:00 Microbiological contamination 00:04:00 Microbiological multiplication 00:08:00 Microbiological survival 00:03:00 Principle 2: Identity Critical Control Points Identify Critical Control Points 00:03:00 Establish critical limits Establish critical limits 00:04:00 Principle 4: Implement monitoring of CCP's Principle 4: Implement monitoring of CCP's 00:02:00 Principle 5: Establish corrective actions Principle 5: Establish corrective actions 00:02:00 Principle 6: Verification An introduction to verification. 00:01:00 Verification: Monitoring complaints (food poisoning). 00:07:00 Verification: Internal Audits 00:09:00 Principle 7: Documentation Principle 7: Documentation 00:02:00 The Supervisors Role in Food Safety The Supervisors Role in Food Safety 00:01:00 Food Safety Law Food Safety Law 00:07:00 Course summary and revision Course summary and revision 00:17:00 Thank you and GoodBye A thank you from me 00:01:00 Bonus Lecture Bonus Lecture 00:02:00 Assessment Assessment - Food Safety Level 3 00:10:00 Obtain Your Certificate of Achievement Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

The Accounting and Analysis Manual is an indispensable resource for finance professionals, auditors, and business managers navigating the complexities of financial reporting and analysis. What is inside the manual? Presentation of Financial Statements This section is foundational, providing readers with a comprehensive understanding of how financial statements are structured and presented, which is crucial for both reporting and analysis. Balance Sheet Issues: Assets and Liabilities A deep dive into the intricacies of assets and liabilities, including current and non-current classifications, debt, leases, and more. This part is essential for understanding a company's financial health and operational sustainability. Income Statement Issues Focusing on revenue recognition and the implications of employee share options, this section is key for understanding how a company's operations translate into financial performance. Understanding Cash Flow Statements With emphasis on free cash flow, this section highlights the importance of cash management and its impact on a company's valuation and investment attractiveness. Accounting and Analysis for M&A This comprehensive segment covers the end-to-end process and considerations for M&A activities, including the consolidation process, acquisition accounting, and the treatment of goodwill.  Accounting and Analysis Cover the fundamentals of accounting frameworks, reporting elements, and the mechanics of preparing financial statements, including detailed discussions on assets, liabilities, income statements, and cash flow statements.

Are you a hypnotherapist looking to enhance your skills and better serve your clients who are neurodiverse? Take my masterclass on tailoring trance inductions for neeurodiverse individuals and discover the art of crafting personalised hypnotic inductions that resonate with the unique needs of each client.

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

Explore the AWS Platform with the expert guidance of a cloud and security instructor

Digital forensics is becoming very important in cyber security to detect and backtrack Black Hat criminals. It is essential to remove hackers' malicious backdoors/malware and trace them back to avoid possible future incidents.