3565 Courses delivered On Demand

Step into the captivating world of Functional Skills Maths Level 2, a course that transcends mere numbers. It's not just about equations; it's about empowering you to conquer challenges and infuse confidence into your every step. Imagine a world where percentages aren't daunting but doors opening to financial empowerment.    Functional Skills Maths Level 2 equips learners with essential mathematical competencies. This course addresses real-world challenges, empowering individuals to navigate daily life, business, and further education with confidence. Proficiency in BODMAS, decimals, ratios, and more provides tangible benefits, fostering problem-solving and decision-making skills. Students gain a competitive edge in personal and professional spheres, improving their prospects and contributing to a numerically literate society.   By mastering concepts like percentages and unitary methods, learners enhance their financial acumen, crucial for managing personal finances or pursuing business ventures. This course is a gateway to unlocking opportunities, and fostering a deeper understanding of mathematical applications in diverse contexts. The practical skills acquired are invaluable for achieving academic success, career advancement, and overall personal development.   Learning Outcomes Apply rules of BODMAS for accurate mathematical simplification. Demonstrate proficiency in working with integers and directed numbers. Master calculations involving decimals, percentages, and scientific notation. Analyse and solve problems related to profit, loss, discount, and tax. Utilise unitary methods in practical applications and problem-solving scenarios. Understand and apply concepts of ratio, proportion, and fractions effectively. Successfully estimate and approximate numerical values in real-world situations. Comprehend the principles of factors, multiples, and their mathematical relationships. Apply mathematical skills to solve mock and final exam questions effectively.   Who is this Award in Functional Skills Maths at QLS Level 2 Course For? Individuals seeking practical math skills for daily life. Students aiming for academic success and confidence in mathematics. Professionals looking to enhance their financial literacy. Entrepreneurs and business enthusiasts want sound mathematical foundations. Anyone wanting to improve problem-solving abilities through practical math.   Why Choose This Award in Functional Skills Maths at QLS Level 2 Course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success.   Career Path Administrative roles: Administrative Assistant (£18,000 - £25,000 per year) Retail positions: Retail Manager (£20,000 - £45,000 per year) Finance sector: Junior Accountant (£20,000 - £30,000 per year) Business ownership: Small Business Owner (Earnings vary widely) Further studies: Access to higher-level math courses for specialised careers.   Prerequisites This Functional Skills Maths - Level 2 is open to all, irrespective of prior qualifications. Enrolling is simple, and the course, created by experts, functions seamlessly on PCs, Macs, tablets, and smartphones. With accessibility from any location with a reliable internet connection, this course provides convenient learning options.   Certification After finishing the course content, you'll encounter a written assignment test. Upon successful completion, you can acquire a PDF certificate for a fee of £4.99. If you prefer a physical copy, you can order an original hard copy for an extra £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £75 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Integers ( Directed Numbers) Lecture 1 Introduction 00:02:00 Lecture 2 Multiplying any digit number by 11, 22, and 33 00:09:00 Lecture 3 Integers and ordering of integers 00:06:00 Lecture 4 Addition and Subtractions of Integers 00:07:00 Lecture 5 Operations on Integers 00:04:00 Lecture 6 Multiplication and Division of Integers 00:04:00 Lecture 7 Powers of Integers (Exponents) 00:04:00 Factors and Multiples Lecture 8 Complete knowledge about factors and multiples 00:06:00 Lecture 9 Divisibility tests for 2,3,4,5,6 00:07:00 Lecture 10 Divisibility rules 7,8,9,10,11 00:06:00 Lecture 11 Prime Factorization 00:06:00 Lecture 12 Highest Common Factor HCF 00:10:00 Lecture 13 Least Common Multiple LCM 00:16:00 Lecture 14 Relation between LCM and HCF 00:04:00 Fractions Lecture 15 Classification of Fractions 00:04:00 Lecture 16 Convert mixed to improper and improper to mixed fractions 00:03:00 Lecture 17 Equivalent Fractions 00:04:00 Lecture 18 Comparing Fractions after converting to like fractions 00:09:00 Lecture 19 Reducing a fraction to lowest term 00:04:00 Lecture 20 Addition and subtraction OF fractions 00:08:00 Lecture 21 Multiplication and division of fractions 00:11:00 Lecture 22 Word problems on fractions 00:16:00 Simplification Rule : BODMAS Lecture 23 BODMAS and rules to remove brackets 00:03:00 Lecture 24 Simplify expressions using BODMAS rules 00:05:00 Lecture 25 Simplify expressions involving fractions using BODMAS 00:07:00 Decimal numbers Lecture 26 Decimal numbers in relation to fractions 00:08:00 Lecture 27 Like and unlike Decimals 00:05:00 Lecture 28 Ordering of Decimal numbers 00:10:00 Lecture 29 Addition and subtraction of Decimal 00:07:00 Lecture 30 Multiplication of Decimal 00:03:00 Lecture 31 Division of Decimal 00:05:00 Rational Numbers Lecture 32 Rational number 00:02:00 Lecture 33 Representation of Rational Numbers on Number line 00:04:00 Lecture 34 Determining which fraction is terminating or non terminating 00:05:00 Lecture 35 shortcut method of writing decimal expansion of fraction to decimal 00:08:00 Approximation Lecture 36 Rounding to whole number 00:06:00 Lecture 37 Rounding to required number of decimals (1 d.p. ) 00:05:00 Lecture 38 rounding to significant digits 00:07:00 Lecture 39 Practice question on three methods of approximation 1 00:05:00 Estimation and Scientific Notation or Standard form Lecture 40 Estimation 00:05:00 Lecture 41 Scientific Notation 00:07:00 Lecture 42 Operation on numbers when they are in scientific notation 00:06:00 Percentage Lecture 43 Percentage to fraction and fraction to percentage 00:06:00 Lecture 44 Percentage of a quantity and conversation to decimal 00:06:00 Lecture 45 Expressing one quantity as percentage of another quantity 00:06:00 Lecture 46 Finding increase decrease percent 00:05:00 Lecture 47 Uses of percentages-Word Problems 00:09:00 Ratio and Proportion Lecture 48 Ratio- How to express as simple ratio 00:09:00 Lecture 49 How to compare Ratios 00:04:00 Lecture 50 Word problems on finding ratios 00:07:00 Lecture 51 To divide a given quantity into a given Ratio 00:11:00 Lecture 52 Proportion 00:04:00 Lecture 53 Practice problems on Proportion 00:06:00 Lecture 54 Continued proportion 00:06:00 Unitary Method and its Applications Lecture 55 Direct Variation ( or proportion) 00:04:00 Lecture 56 Problems based on Direct proportion 00:10:00 Lecture 57 Inverse Variation ( or proportion) 00:10:00 Lecture 58 Multiple Ratios 00:10:00 Profit , Loss, discount and Tax Lecture 59 Basics - Profit and Loss 00:04:00 Lecture 60 More practice problems on Profit & Loss 00:06:00 Lecture 61 Selling price formula and Problems 00:04:00 Lecture 62 Cost price formula and Problems 00:03:00 Lecture 63 Higher problems on Profit and Loss 00:08:00 Lecture 64 Basics - Discount.mp4 00:05:00 Lecture 65 Practice problems on Discount 00:04:00 Lecture 66 Tax 00:06:00 Mock Exam Mock Exam - Award in Functional Skills Maths at QLS Level 2 00:20:00 Final Exam Final Exam - Award in Functional Skills Maths at QLS Level 2 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Course Overview Gain an excellent understanding of power electronics and power systems by taking this Power Electronics for Electrical Engineering course.  The Power Electronics for Electrical Engineering course will provide a thorough overview of power electronics fundamentals and their importance. Here, you will learn about the power electronics components and understand the working principle of rectifier circuits. Furthermore, you will learn about the design and implementation of AC and DC choppers and explore the fundamentals of inverters in power electronics. Learning Outcomes Identify the primary purpose of power electronics Understand how power electronics work Know about rectifiers and their operations Determine how AC and DC choppers work Gain insights into the inverter fundamentals and types Who is this course for? Anyone interested in improving their knowledge of electrical circuit analysis can take this Power Electronics for Electrical Engineering course. 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 Power Electronics for Electrical Engineering course offers useful skills to possess and would be beneficial for any relevant profession or career such as: Electronics: Apprentice Electrician Electronics: Industrial Electricians Electronics: Commercial Electrician Electronics: Residential Electrician Electronics: Maintenance Electrician Auto Electrician Unit 1- Introduction to Power Electronics Components Module 1- Introduction to Power Electronics 00:13:00 Module 2- Uncontrolled Switches 00:17:00 Module 3- What is the Benefit of Diode 00:06:00 Module 4- Semi-Controlled Switches Part 1 00:09:00 Module 5- Semi-Controlled Switches Part 2 00:14:00 Module 6- Semi-Controlled Switches Part 3 00:05:00 Module 7- What is the Benefit of Thyristor 00:05:00 Module 8- Fully Controlled Switches Part 1 00:17:00 Module 9- Fully Controlled Switches Part 2 00:10:00 Module 10- Fully Controlled Switches Part 3 00:12:00 Unit 2- Fundamentals of Rectifier Circuits Module 1- Overview on Rectifiers 00:02:00 Module 2- Rectifier Definition 00:01:00 Module 3- Half Wave Uncontrolled Rectifier with R Load 00:21:00 Module 4- Example on Half Wave Uncontrolled Rectifier with R Load Part 1 00:06:00 Module 5- Example on Half Wave Uncontrolled Rectifier with R Load Part 2 00:07:00 Module 6- Half Wave Uncontrolled Rectifier with RL Load 00:10:00 Module 7- Derivation of the Discontinuous Current in R-L Load 00:08:00 Module 8- Freewheeling Diode (Commutation Diode) 00:03:00 Module 9- Half Wave R-L Load with FWD 00:09:00 Module 10- Difference Between Continuous and Discontinuous Mode in RL Load 00:07:00 Module 11- Half Wave RL Load with FWD Continuous Mode 00:06:00 Module 12- Example on Half Wave Rectifier with FWD 00:07:00 Module 13- Bridge Full Wave Uncontrolled Rectifier Part 1 00:07:00 Module 14- Bridge Full Wave Uncontrolled Rectifier Part 2 00:05:00 Module 15- Quick Revision on Bridge Full Wave Uncontrolled Rectifier 00:06:00 Module 16- Firing Angle 00:02:00 Module 17- Half Wave Controlled Rectifier R Load 00:05:00 Module 18- Half Wave Controlled Rectifier R-L Load 00:04:00 Module 19- Half Controlled R-L Load with FWD 00:06:00 Module 20- Example 1 00:07:00 Module 21- Example 2 00:08:00 Module 22- Example 3 00:13:00 Module 23- Example 4 00:09:00 Module 24- Example 5 00:05:00 Module 25- Fully Controlled Bridge Rectifier Part 1 00:06:00 Module 26- Fully Controlled Bridge Rectifier Part 2 00:06:00 Module 27- Quick Revision on Bridge Full Wave Controlled Rectifier 00:02:00 Module 28- Example 6 00:08:00 Module 29- Half Controlled Bridge Rectifier 00:08:00 Module 30- Half Controlled Bridge Rectifier with FWD 00:05:00 Module 31- Example 7 00:06:00 Module 32- Example 8 00:07:00 Module 33- Performance Parameters 00:04:00 Module 34- Power Factor 00:04:00 Unit 3- Fundamentals of AC Choppers Module 1- Introduction to AC Choppers 00:02:00 Module 2- Definition of AC Choppers 00:05:00 Module 3- Switching Techniques in AC Choppers 00:06:00 Module 4- Applications on AC Choppers 00:03:00 Module 5- Types of AC Choppers 00:02:00 Module 6- AC Chopper with R Load 00:14:00 Module 7- Example 1 on AC Chopper with R Load 00:06:00 Module 8- Example 2 on AC Chopper with R Load 00:04:00 Module 9- AC Chopper with L Load Part 1 00:13:00 Module 10- AC Chopper with L Load Part 2 00:06:00 Module 11- Example on AC Chopper with L Load 00:08:00 Module 12- AC Chopper with RL Series Load 00:20:00 Module 13- Example on AC Chopper with RL Series Load 00:07:00 Module 14- AC Chopper with RL Parallel Load 00:25:00 Module 15- Example on AC Chopper with RL Parallel Load 00:06:00 Module 16- AC Chopper with Pure Capacitive Load 00:14:00 Module 17- Example on AC Chopper with Pure Capacitive Load 00:04:00 Module 18- AC Chopper Loaded by Heavy Rectifier 00:06:00 Module 19- AC Chopper Loaded by an AC Motor with Sinusoidal Back Emf 00:12:00 Module 20- Example on AC Chopper Loaded by an AC Motor with Sinusoidal Back Emf 00:08:00 Module 21- Integral Cycle Control 00:11:00 Module 22- Example on Integral Cycle Control 00:04:00 Unit 4- Fundamentals of DC Choppers Module 1- Introduction to DC Choppers 00:02:00 Module 2- Definition and Application of DC Choppers 00:05:00 Module 3- Step down DC Chopper with R Load 00:12:00 Module 4- Example on Step Down DC Chopper with R Load 00:08:00 Module 5- Generation of Duty Cycle 00:09:00 Module 6- Switching Techniques 00:03:00 Module 7- Step Down DC Chopper with RLE Load Part 1 00:19:00 Module 8- Step Down DC Chopper with RLE Load Part 2 00:15:00 Module 9- Example 1 on Step Down DC Chopper with RLE Load 00:13:00 Module 10- Example 2 on Step Down DC Chopper with RLE Load 00:02:00 Module 11- Step Up DC Chopper with R or RL Load 00:09:00 Module 12- Step Up DC Chopper with RE Load 00:15:00 Module 13- Example on Step Up DC Chopper with RE Load 00:20:00 Module 14- Buck Regulator Part 1 00:16:00 Module 15- Buck Regulator Part 2 00:17:00 Module 16- Example on Buck Regulator 00:03:00 Module 17- Boost Regulator 00:23:00 Module 18- Example on Boost Regulator 00:06:00 Module 19- Buck Boost Converter 00:17:00 Module 20- Example on Buck-Boost Converter 00:05:00 Unit 5- Fundamentals of Inverters Module 1- Introduction to Inverters 00:02:00 Module 2- Definition of Inverters 00:04:00 Module 3- Importance and Applications of Inverters 00:08:00 Module 4- Single Phase Half Bridge R-Load 00:15:00 Module 5- Single Phase Half Bridge RL- Load 00:08:00 Module 6- Performance Parameters of an Inverter 00:05:00 Module 7- Example on Single Phase Half Bridge 00:10:00 Module 8- Single Phase Bridge Inverter R- Load 00:06:00 Module 9- Single Phase Bridge Inverter RL- Load 00:07:00 Module 10- Example on Single Phase Bridge Inverter 00:06:00 Module 11- Three Phase Inverters and Obtaining the Line Voltages 00:15:00 Module 12- Three Phase Inverters and Obtaining The Phase Voltages 00:17:00 Module 13- Example on Three Phase Inverters 00:16:00 Module 14- Single Pulse Width Modulation 00:13:00 Module 15- Multiple Pulse Width Modulation 00:13:00 Module 16- Example on Multiple Pulse Width Modulation 00:04:00 Module 17- Sinusoidal Pulse Width Modulation 00:16:00 Module 18- Industrial Inverter 00:03:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Are you ready to embark on an enlightening journey of wisdom with the Typist bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Typist - Immediate start. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 1: Touch Typing Essentials Course 2: Document Control Course 3: Ultimate Transcription and Captioning Course Course 4: Microsoft Office Bundle Course 5: Virtual Assistant Course 6: Minute Taking Course Course 7: Diploma in Effective Writing Skills Course 8: Proofreading & Copyediting Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Typist - Immediate start bundle illuminate your path to wisdom. The Typist - Immediate start bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Typist - Immediate start package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Typist bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Typist - Immediate start community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Typist bundle. Establish robust bases across each course nestled within the Typist bundle. Decipher intricate concepts through the articulate content of the Typist bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Typist bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Typist bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Typist bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Typist bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Typist bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Typist journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Typist bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Typist bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Ultimate UK Payroll Training | Master Accounting, Tax, Finance, Xero, and Learn UK Employment Law, AML | Tutor Support | Lifetime Access

Sharpen your culinary leadership skills with our Kitchen Management course. Master safety, sanitation, menu creation, and strategic financial planning to excel as a kitchen manager. Dive into this all-encompassing guide to managing a high-functioning kitchen.

Description: Windows Server 2016 is a server operating system that is designed to handle corporate networking, Internet/intranet hosting, databases, enterprise-scale messaging and similar functions more efficiently. Developed by Microsoft, it is a part of the Windows NT family of operating systems. With the proper knowledge of Windows Server 2016, you can able to handle your office environment proficiently. The Windows Server 2016 Complete Video Training course is for you if you want to master the features and functions of Windows Server 2016. Apart from this, the bundled video course will help you to prepare for the various exam of Microsoft Windows Server 2016 MCSA certification. The course is divided into four sections where each section helps you with a specific exam and the practical use of Windows Server. The 70-740 Exam section teaches you the methods of installing Windows Server in Host and Compute Environments along with the other features such as storage. On the other hand, the 70-741 series teaches you how to do networking with Windows server including implementing Domain Name system, etc. Next, you will learn about the functionality of Windows Server in the 70-742 section that focuses on the Web Application proxy implementations, Microsoft Azure AD and Directory Synchronization, etc. Finally, in the 70-744 part, you will know how to secure your Windows server. In short, the Windows Server 2016 Complete Video Training course helps you to understand all the necessary information skills if you want to use Windows Server 2016. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Windows Server 2016 Complete Video Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Windows Server 2016 Complete Video Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Installing Windows Servers in Host and Computer Environments Determining Windows Server 2016 Installation FREE 00:54:00 Installing Windows Server 2016 Core and Nano Editions 01:35:00 Managing Windows Installations with Windows PowerShell 00:01:00 Create, Manage, and Maintain Windows Images to Deploy 00:33:00 Implementing Local and Enterprise Storage Solutions Managing Disks and Volumes in Windows Server 2016 01:00:00 Implementing and Managing Storage Spaces 00:45:00 Configuring Data Deduplication 00:39:00 Understanding Various Types of Storage 00:15:00 Fibre Channel, iSCSI, and Fibre Channel over Ethernet 00:18:00 Understanding iSNS, DCB, and MPIO 00:09:00 Configuring File and Folder Sharing in Windows Server 2016 00:21:00 Implementing Hyper-V Virtualization Installing Hyper-V Virtualization 00:26:00 Configuring Storage and Networking on Hyper-V Hosts 00:38:00 Configuring and Managing Virtual Machines 00:34:00 Implementing Windows Containers Understanding Windows Server and Hyper-V Containers 00:17:00 Deploying Windows Server and Hyper-V Containers 00:08:00 Using Docker to Install, Configure, and Manage Containers 00:12:00 Implementing High Availability Overview of High Availability and Disaster Recovery 00:55:00 Implementing Network Load Balancing 00:25:00 Planning and Configuring Failover Clustering 01:10:00 Maintaining a Failover Cluster 00:15:00 Troubleshooting Failover Clustering 00:11:00 Integrating Failover Clustering and Hyper-V 00:23:00 Configuring Site Availability 00:12:00 Maintaining and Monitoring Server Environments Windows Server Update Services 00:33:00 Windows PowerShell Desired State Configuration (DSC) 00:10:00 Windows Server 2016 Monitoring Tools 00:43:00 Plan and Implement IPv4 and IPv6 Networks Plan and Implement IP Addressing Schemes for IPv4 Networks FREE 01:31:00 Configuring IPv4 Hosts 00:18:00 Managing and Troubleshooting IPv4 Connectivity 00:35:00 Implementing IPv6 for Network Hosts 00:20:00 Implementing IPv6 Transitioning and Coexistence 00:16:00 Installing and Configuring DHCP Overview of the DHCP Server Role 00:16:00 Managing and Troubleshooting DHCP 00:48:00 Installing and Configuring DNS Implementing DNS Servers 00:27:00 Creating and Configuring DNS Zones 00:52:00 Understanding Active Directory Integration 00:23:00 Configuring Advanced DNS Settings 00:41:00 Implementing and Managing IP Address Management Overview of IPAM 00:15:00 IPAM Deployment 00:49:00 Implementing Remote Access Remote Access Overview 00:27:00 Implementing the Web Application Proxy 00:08:00 Planning and Implementing VPNs 00:31:00 Overview of DirectAccess 00:21:00 Implementing DirectAccess 00:27:00 Installing and Configuring Branch Office Networking Configuring Networking for Branch Offices 00:39:00 Implementing Distributed File Systems 00:44:00 Implementing BranchCache 00:19:00 Implementing Advanced Networking Features Implementing Networking Features for High Performance 00:23:00 Implementing Hyper-V Advanced Networking Features 00:13:00 Introduction to Software-Defined Networking 00:10:00 Overview of Network Virtualization 00:06:00 Installing and Configuring Domain Controllers Overview of Active Directory Domain Services FREE 01:00:00 Overview of Domain Controllers 00:30:00 Deploying Domain Controllers 1 01:00:00 Managing Active Directory Objects Overview of AD DS Object Management 00:23:00 Managing User Accounts 01:07:00 Managing Groups 01:06:00 Managing Computer Accounts 00:20:00 Managing Organizational Units 00:41:00 Securing Active Directory Domain Services Securing Domain Controllers 00:33:00 Implementing Account Security 00:48:00 Auditing AD DS 00:26:00 Configuring Managed Service Accounts 00:14:00 Working with Complex AD DS Infrastructures Overview of Advanced AD DS Deployments 00:20:00 Deploying a Distributed AD DS Environment 00:45:00 Overview of AD DS Replication 00:12:00 Configuring AD DS Sites 00:38:00 Implementing Group Policy Overview of Group Policy 00:39:00 Creating and Configuring GPOs 00:56:00 Monitoring and Troubleshooting Group Policy 00:18:00 Security Management Using Group Policy 00:54:00 Managing User Environments 00:22:00 Understanding Microsoft Azure AD and Directory Synchronization Planning Directory Synchronization 00:24:00 Implementing Azure AD Connect 00:12:00 Managing Identities with Directory Synchronization 00:14:00 Monitoring and Recovering AD DS Monitoring AD DS 00:27:00 Database Management 00:07:00 Backup and Recovery in AD DS 00:21:00 Implementing Active Directory Certificate Services Overview of Public Key Infrastructure and AD CS 00:17:00 Deploying Certificate Authority Hierarchy 00:19:00 Administering Certificate Authorities 00:13:00 Deploying and Managing Certificates 00:26:00 Managing Revocation and Distribution 00:07:00 Configuring Certificate Recovery 00:08:00 Implementing Active Directory Federation Services (AD FS) Overview of AD FS 00:17:00 Planning and Deploying AD FS 00:35:00 Overview of Web Application Proxy 00:08:00 Implementing Active Directory Rights Management Services Overview of AD RMS 00:14:00 Deploying AD RMS 00:14:00 Protecting Content with AD RMS 00:09:00 Introduction to Attacks, Breaches, and Detection Understanding Types of Attacks FREE 00:33:00 Detecting Security Breaches 00:06:00 Using Sysinternals Tools 00:30:00 Protecting Users and Workstations User Rights and Privileges 01:28:00 Working with Computer and Service Accounts 00:19:00 Protecting User Credentials 00:20:00 Using Privileged Access Workstations 00:12:00 Managing Administrative Access Understanding and Deploying JEA 00:32:00 Using Enhanced Security Administrative Environments (ESAE) Forests 00:12:00 Using Microsoft Identity Manager 00:08:00 Using JIT Administration and PAM 00:16:00 Configuring Anti-Malware and Patch Management Configuring and Managing Windows Defender 00:18:00 Restricting Software 00:28:00 Using Device Guard 00:12:00 Patch Management with WSUS 00:29:00 Auditing and Advanced Threat Analytics Configuring Auditing for Windows Server 2016 00:21:00 Advanced Auditing and Management 00:42:00 Deploying and Configuring ATA 00:15:00 Deploying and Configuring Operations Management Suite 00:07:00 Securing the Infrastructure Secure the Virtualization Infrastructure 00:15:00 Deploying Security Baselines 00:20:00 Deploying Nano Server 00:08:00 Configuring Data Protection Planning and Implementing File Encryption 00:29:00 Planning and Implementing BitLocker 00:32:00 Advanced File Server Management Using File Server Resource Manager 00:58:00 Implementing Classification and File Management Tasks 00:16:00 Working with Dynamic Access Control 00:39:00 Securing the Network Infrastructure Using the Windows Firewall with Advanced Security 00:33:00 Datacenter Firewall 00:08:00 Utilizing IP Security 00:29:00 Configuring Advanced DNS Settings 00:42:00 Monitoring Network Traffic 00:09:00 Securing SMB Traffic 00:07:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

The life of Office Administration and all you need to know Do you have an interest in working at the office as an admin? Think about it, if you have right organizing and leadership skills, you can have a successful career as an office admin where the pay is also really high. So what do you need to do to be a good office administrator? This course will give you the guide you need. The administrative office is the department assigned to craft and ensure that the rules and procedures are well implemented in a business or organization. This would help in the operations and functions of each department work well. Every office needs an efficient administrator who can ensure that everything behind the scenes of a successful company is running efficiently. Without one, things quickly start to fall apart. As an Office Administrator you'll be expected to turn your hand to jobs such as sorting out the post, answering the phones, ordering office stationery supplies, greeting clients, typing, filing, managing diaries.The course is meant for prospective office administrator so get on board and become the administrator that you dream of becoming. Course Highlights Administrative Skills Training Bundle is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Administrative Skills Training Bundle into several modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Administrative Skills Training Bundle Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Administrative Skills Training Bundle is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Administrative Skills Training Bundle is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Administrative Management Module One - Getting Started FREE 01:00:00 Module Two - Why Your Office Needs Administrative Procedures FREE 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 01:00:00 Admin Support Module One - Getting Started FREE 00:30:00 Module Two - Getting Organized (I) FREE 01:00:00 Module Three - Getting Organized (II) 01:00:00 Module Four - Managing Time 01:00:00 Module Five - Getting It All Done On Time 01:00:00 Module Six - Special Tasks 01:00:00 Module Seven - Verbal Communication Skills 01:00:00 Module Eight - Non-Verbal Communication Skills 01:00:00 Module Nine - Empowering Yourself 01:00:00 Module Ten - The Team of Two 01:00:00 Module Eleven - Taking Care of Yourself 01:00:00 Module Twelve - Wrapping Up 00:30:00 Personal Assistant Module One - Getting Started FREE 00:30:00 Module Two - Working with Your Manager FREE 01:00:00 Module Three - Administrative Soft Skills 01:00:00 Module Four - Effective Time Management 01:00:00 Module Five - Meeting Management 01:00:00 Module Six - Tools of the Trade (I) 01:00:00 Module Seven - Tools of the Trade (II) 01:00:00 Module Eight - Being an Effective Gatekeeper 01:00:00 Module Nine - Organizational Skills 01:00:00 Module Ten - Confidentiality Guidelines 01:00:00 Module Eleven - Special Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Executive Secretarial and PA Course - Activities 00:00:00 Business Writing Module One - Getting Started FREE 00:30:00 Module Two - Working with Words FREE 01:00:00 Module Three - Constructing Sentences 01:00:00 Module Four - Creating Paragraphs 01:00:00 Module Five - Writing Meeting Agendas 01:00:00 Module Six - Writing E-mails 01:00:00 Module Seven - Writing Business Letters 01:00:00 Module Eight - Writing Proposals 01:00:00 Module Nine - Writing Reports 01:00:00 Module Ten - Other Types of Documents 01:00:00 Module Eleven - Proofreading and Finishing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Customer Service Introduction To Customer Service FREE 00:15:00 The Power of Positive Thinking in Customer Service FREE 00:30:00 Types of Difficult Customers and How to Help them 01:00:00 How to Deal with Difficult Customers 00:30:00 Conclusion 00:15:00 Time Management Where Do You Spend Your Time FREE 01:00:00 Managing Tasks FREE 01:00:00 Planning 01:00:00 Goals 01:00:00 Tips From The Gurus 01:00:00 Wrapping Up 00:15:00 Organisational Skills Module One - Getting Started FREE 00:30:00 Module Two - Remove the Clutter FREE 01:00:00 Module Three - Prioritize 01:00:00 Module Four - Scheduling Your Time 01:00:00 Module Five - To Do Lists 01:00:00 Module Six - Paper and Paperless Storage 01:00:00 Module Seven - Organization in Your Work Area 01:00:00 Module Eight - Tools to Fight Procrastination 01:00:00 Module Nine - Organizing Your Inbox 01:00:00 Module Ten - Avoid the Causes of Disorganization 01:00:00 Module Eleven - Discipline is the Key to Stay Organized 01:00:00 Module Twelve - Wrapping Up 00:30:00 Administrative Skills Developing Diploma- Activities 00:00:00 Self Esteem & Confidence Building Module One - Getting Started FREE 01:00:00 Module Two - What Does Self-Confidence Mean To You FREE 01:00:00 Module Three - Obstacles to Our Goals 01:00:00 Module Four - Communication Skills 01:00:00 Module Five - The Importance of Goal Setting 01:00:00 Module Six - Feeling the Part 01:00:00 Module Seven - Looking the Part 01:00:00 Module Eight - Sounding the Part 01:00:00 Module Nine - Powerful Presentations 00:30:00 Module Ten - Coping Techniques 01:00:00 Module Eleven - Dealing with Difficult Behavior 00:30:00 Module Twelve - Wrapping Up 00:15:00 Microsoft Word Module One - Getting Started FREE 00:30:00 Module Two - Opening Word FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft PowerPoint Module One - Getting Started FREE 00:30:00 Module Two - Opening PowerPoint FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Mock Exam Mock Exam - Administrative Skills Training Bundle 00:30:00 Final Exam Final Exam - Administrative Skills Training Bundle 00:30:00

The HR Management Diploma and UK Employment Law course provides an essential foundation in understanding the complexities of managing human resources in the modern workplace. This course delves into the key areas of HR management, including recruitment, employee relations, performance management, and compensation, while offering a deep dive into the specifics of UK employment law. Whether you're new to HR or looking to expand your knowledge, this course will help you navigate the ever-changing landscape of employee management and legal frameworks in the UK. In addition to core HR practices, the course offers a detailed exploration of UK Employment Law, covering topics such as employee rights, contracts, dismissal procedures, and health and safety regulations. By the end of the course, you will gain a clear understanding of how to manage HR operations effectively while ensuring your practices align with the law. Designed for those eager to build a career in human resources or enhance their existing expertise, this course equips you with the tools needed to manage people and policies with confidence. ________________________________________________________________________ Key Features: CPD Certified HR Management Diploma and UK Employment Law With Complete Career Guide 10 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Module 01: Introduction to Human Resource Module 02: Employee Recruitment and Selection Procedure Module 03: Employee Training and Development Process Module 04: Performance Appraisal Management Module 05: Employee Relations Module 06: Motivation and Counselling Module 07: Ensuring Health and safety at the Workplace Module 08: Employee Termination Module 09: Employer Record and Statistics Module 10: Essential UK Employment Law ________________________________________________________________________ Complete Career Guide for HR Management Diploma and UK Employment Law (A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the HR Management. In addition to mastering the essentials of HR Management, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in HR Management. Your dream career starts here! List of career guide courses included in HR Management Diploma and UK Employment Law With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Understand the fundamentals of Human Resource Management. Apply effective recruitment and selection procedures in organisations. Implement employee training and development processes for workforce enhancement. Evaluate and manage performance appraisal effectively. Develop skills in employee relations, motivation, and counselling. Ensure workplace health and safety and handle employee termination proficiently. ________________________________________________________________________ Accreditation All of our courses, including the HR Management Diploma and UK Employment Law With Complete Career Guide course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your HR Management Diploma and UK Employment Law With Complete Career Guide, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the HR Management Diploma and UK Employment Law With Complete Career Guide courses, there will be an online assessment, which you will need to pass to complete the HR Management Diploma and UK Employment Law With Complete Career Guide course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This HR Management Diploma and UK Employment Law With Complete Career Guide Course can be taken by anyone who wants to understand more about the topic. With the aid of this course, you will be able to grasp the fundamental knowledge and ideas. Additionally, this HR Management Diploma and UK Employment Law With Complete Career Guide Course is ideal for: Individuals aspiring to enter the field of HR management. Professionals seeking a comprehensive UK employment law understanding. HR personnel aiming to enhance their knowledge and skills. Managers responsible for employee relations and performance. Anyone interested in maintaining workplace health and safety standards. Requirements Learners do not require any prior qualifications to enrol on this HR Management Diploma and UK Employment Law With Complete Career Guide Course. You just need to have an interest in HR Management Diploma and UK Employment Law With Complete Career Guide Course. Career path After completing this HR Management Diploma and UK Employment Law With Complete Career Guide Course you will have a variety of careers to choose from. HR Manager - £30K to 50K/year. Recruitment Specialist - £25K to 40K/year. Training and Development Coordinator - £28K to 45K/year. Employee Relations Advisor - £27K to 42K/year. Health and Safety Officer - £26K to 40K/year. Certificates 10 CPD Accredited e-Certificates Digital certificate - Included 10 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

Discover the key to success in the food service industry with our comprehensive Kitchen Porter Training course. Acquire essential skills in dishwashing, kitchen maintenance, safety, and HACCP principles. Join us for hands-on learning in a dynamic culinary environment. Elevate your career and become an indispensable asset in the commercial kitchen. Enroll now for a transformative culinary journey!

Uncover Excel 2019's potential through our comprehensive Microsoft Excel course. It empowers you to master features, calculations, data analysis, and automation. Whether you're new to spreadsheets or aiming for data expertise, this course is tailored for you. Our Microsoft Excel course simplifies Excel's complexities, making it beginner-friendly. It equips you with skills vital in today's data-driven landscape. Beyond personal growth, this Microsoft Excel course boosts career prospects. Excel proficiency is valuable in a competitive job market, opening doors to diverse opportunities. Our course is a transformative journey into Excel 2019, unlocking potential, enhancing skills, and advancing careers. Whether you're a novice or aspiring data pro, it's your key to Excel's power and your potential. Learning Outcomes of our Microsoft Excel course: Master Microsoft Excel 2019's latest features. Perform complex calculations with ease. Create visually appealing and well-formatted worksheets. Analyze and visualize data effectively using charts and PivotTables. Automate workbook tasks with Excel VBA. Why buy this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7? Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Who is this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 for? Individuals new to Microsoft Excel looking to build a strong foundation. Students and job seekers aiming to enhance their employability. Business professionals wanting to improve data management and analysis skills. Entrepreneurs seeking to streamline their business processes. Anyone interested in harnessing the power of Excel for personal or professional growth. Prerequisites This Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £40,000 per year Financial Analyst: £30,000 - £50,000 per year Business Intelligence Analyst: £30,000 - £55,000 per year Operations Manager: £35,000 - £70,000 per year Project Manager: £40,000 - £70,000 per year Excel VBA Developer: £35,000 - £60,000 per year Certification After studying the course materials of the Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Excel Templates Excel Templates 00:00:00 Resources Resources - Microsoft Excel - Beginner Course - Cpd Accredited 00:00:00 Mock Exam Mock Exam - Microsoft Excel Complete Course 2019 00:20:00 Final Exam Final Exam - Microsoft Excel Complete Course 2019 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00