Learning Objectives Introduction , Getting Started with Excel , Creating Workbooks and Using Templates , Entering Data , Excel Formula Basics , Adjusting a Worksheet , Formatting and Aligning Data , Using Cell Styles and Themes , Inserting Objects and Graphics , Proofing a Workbook , Printing an Excel File , Managing Worksheets , Navigating and Viewing Excel Files , Conclusion Pre-Requisites Basic Computer Skills Description Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. Section 01 Lesson 01: What is Excel 00:03:00 Lesson 02: Opening Excel 00:04:00 Lesson 03: Navigating the Excel User Interface-v2 00:06:00 Lesson 04: Navigating the Excel User Interface 00:04:00 Lesson 05: Using the Excel Ribbon 00:07:00 Lesson 06: Understanding Excel Worksheet Components 00:07:00 Lesson 07: Using the Backstage View 00:06:00 Section 02 Lesson 01: Creating a New Workbook 00:06:00 Lesson 02: Saving an Excel Workbook 00:05:00 Lesson 03: Using the Accessibility Checker 00:04:00 Lesson 04: Using the Accessibility Checker-v3 00:04:00 Section 03 Lesson 01: Navigating a Worksheet by Mouse or Keyboard 00:05:00 Lesson 02: Understanding Excel Data Types 00:04:00 Lesson 03: Using the Inking Tools 00:05:00 Lesson 04: Using the Inking Tools-v3 00:03:00 Lesson 05: Working with Cell and Range Addressing 00:05:00 Lesson 06: Using Various Data Selection Techniques 00:05:00 Lesson 07: Working with Common Excel Commands 00:06:00 Lesson 08: Using Flash Fill and Autofill 00:06:00 Section 04 Lesson 01: What are Formulas and Functions 00:05:00 Lesson 02: Understanding the Components of a Formula 00:05:00 Lesson 03: Understanding Calculation Hierarchy and the Order of Operations 00:03:00 Lesson 04: Creating Basic Formulas 00:05:00 Lesson 05: Working with Basic Functions and AutoSum 00:06:00 Lesson 06: Using Cell References 00:05:00 Lesson 07: Using the Quick Analysis Tool 00:03:00 Section 05 Lesson 01: Modifying Columns and Rows 00:06:00 Lesson 02: Hiding and Unhiding Columns and Rows 00:06:00 Section 06 Lesson 01: Formatting and Aligning Data 00:07:00 Lesson 02: Merging Data 00:07:00 Lesson 03: Wrapping Text and Adjusting Orientation 00:06:00 Lesson 04: Formatting Numbers 00:05:00 Lesson 05: Using the Format Painter 00:04:00 Section 07 Lesson 01: Using Cell Styles 00:06:00 Lesson 02: Applying Themes 00:05:00 Section 08 Lesson 01: Inserting and Formatting Images and Shapes 00:08:00 Lesson 02: Inserting and Formatting SmartArt 00:05:00 Lesson 03: Working with Icons 00:04:00 Lesson 04: Inserting Hyperlinks 00:06:00 Lesson 05: Inserting Symbols and Equations 00:05:00 Lesson 06: Inserting WordArt and Text Boxes 00:05:00 Lesson 07: Inserting 3-D Models 00:04:00 Lesson 08: Arranging Objects 00:06:00 Section 09 Lesson 01: Using Find and Replace 00:05:00 Lesson 02: Using Go To and Go To Special 00:03:00 Lesson 03: Using the Spell Checker 00:05:00 Lesson 04: Using the Thesaurus and Translation Features 00:05:00 Lesson 05: Using the resolve Feature-v3 00:02:00 Section 10 Lesson 01: Printing and Previewing Excel Files 00:06:00 Lesson 02: Creating Custom Margins and Scaling 00:05:00 Lesson 03: Adding Headers and Footers 00:04:00 Lesson 04: Formatting a Page with the Page Layout Tab 00:06:00 Lesson 05: Printing Titles and Specific Worksheet Areas 00:03:00 Lesson 06: Exporting to PDF-v3 00:02:00 Lesson 07: Exporting to PDF and XPS 00:04:00 Section 11 Lesson 01: Renaming and Coloring Worksheet Tabs 00:03:00 Lesson 02: Adding, Deleting and Navigating Worksheets 00:03:00 Lesson 03: Hiding and Unhiding Worksheets 00:03:00 Section 12 Lesson 01: Viewing Workbooks 00:03:00 Lesson 02: Using Zoom Tools 00:03:00 Lesson 03: Configuring Sheet Options 00:05:00 Lesson 04: Using the Freeze Panes and Split Commands 00:04:00 Lesson 05: Adjusting Worksheet Properties 00:04:00 Lesson 06: Viewing Workbook Statistics-v3 00:02:00 Course Recap Recap 00:02:00 Final Exam Final Exam - Excel 365 Beginner 00:20:00
Take charge of your leadership journey with the Advanced Diploma in Strategic People Management Mini Bundle — crafted to amplify your career within people-driven industries. Combining HR, operations management, team leader skills, equality and diversity, and crisis management, this bundle is perfect for professionals who want to lead teams with resilience, responsibility, and relevance. HR and equality and diversity are now deal-breakers in any workplace. With rising demands for inclusivity and strong crisis management, this bundle empowers you with the confidence and competencies recruiters desperately need. 🧰 Description This isn’t just another management course — it’s your gateway into HR, operations management, and team leader roles that reward smart, people-first strategy. From boardroom to frontline, businesses are investing in those who can navigate crisis management with empathy, enforce equality and diversity, and streamline departments through real operations management know-how. As you’d expect, the competition is heating up. Those without team leader or HR credentials are falling behind. This Mini Bundle is your opportunity to skip the waiting line and prove you’re ready for strategic leadership — on your terms. Enroll now, or stay stuck while others advance. ❓ FAQ Who is this Mini Bundle for? Future leaders aiming for HR, team leader, or operations management roles with a strong grasp of equality and diversity. Is this bundle applicable in both private and public sectors? Yes. Crisis management and HR practices are essential across all sectors. Can this help me stand out for promotion? Definitely. Having team leader and equality and diversity on your CV signals maturity and leadership potential. Does it support remote or hybrid work environments? Yes. Operations management and HR skills apply directly to modern team structures. Is the demand high for these skills right now? Absolutely. Especially in fields that value leadership resilience and crisis management readiness. Why is this bundle a smart investment? Because you're gaining full-spectrum leadership credibility across HR, equality and diversity, and beyond — affordably.
Description: The 70-414 - Implementing an Advanced Server Infrastructure (MCSE) course will prepare you for the Exam 70-414: Implementing an Advanced Server Infrastructure. The course covers the advanced topics that IT professionals encounter in the enterprise environment. For passing the exam, you should have a thorough understanding of a fundamental server infra¬structure including monitoring, virtualisation, and high availability. There are four main objective areas on the 70-414 Exam which are discussed in the course thoroughly: Manage and maintain a server infrastructure Plan and implement a highly available enterprise infrastructure Plan and implement a server virtualisation infrastructure Design and implement identity and access solutions In the course, you will learn how to create the virtual infrastructure, plan and deploy virtual machines and implement solutions for the virtual administration. You will also learn about monitoring, high availability, updates, PKI, BCP and IDA. In short, the course will prepare you for the exam. 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? 70-414 - Implementing an Advanced Server Infrastructure (MCSE) training course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our 70-414 - Implementing an Advanced Server Infrastructure (MCSE) course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Creating the Virtualization Infrastructure Introducing Microsoft System Center 2012 Components FREE 00:23:00 Using System Center for Virtualization 00:18:00 Using the VMM Management Console 00:08:00 Planning a VMM Deployment 00:14:00 Creating the Virtualization Host 00:13:00 Configuring Host Groups 00:04:00 Working with Libraries 00:10:00 Storage Infrastructure 00:22:00 Configuring a Storage Infrastructure for Virtualization 00:04:00 Confituring Storage in VMM 00:06:00 Network Infrastructure for Virtualization 00:22:00 Configuring Virtual Networking 00:06:00 Configuring Virtual Networks in VMM 00:06:00 Planning and Deploying Virtual Machines Considerations for Virtual Machine Setup 00:34:00 Planning Virtual Machine Deployment with VMM 00:13:00 How to Deploy a Virtual Machine 00:23:00 Monitoring Monitoring in Windows Server 2012 00:20:00 Enabling and Viewing Resource Metering Data C3TAD1 00:07:00 Introduction to Operations Manager 00:18:00 Management Packs 00:23:00 Notifications and Reporting 00:08:00 Integration with VMM 00:12:00 Solution for the Virtualization Administration System Center 2012 Administration 00:34:00 Delegated Administration 00:03:00 Automation with System Center 2012 00:10:00 VMM Private Clouds 00:06:00 High Availability Storage Spaces 00:48:00 RAID 00:08:00 NLB 00:22:00 The Infrastructure for Failover Clustering 00:21:00 Defining Failover Clustering 00:25:00 Integrating Failover Clustering with Server Virtualization 00:26:00 Multisite Planning a Multisite Failover Cluster 00:13:00 PKI The Certificate Authority 00:30:00 Certificate Templates 00:22:00 Overview of Certificate Services 00:11:00 CRL 00:13:00 Key Archival 00:07:00 Updates WSUS Deployment 00:25:00 WSUS 00:05:00 Using Configuration Manager 2012 00:17:00 Updating Virtualization 00:10:00 BCP BCP 00:25:00 Backups 00:13:00 Windows Backup Utility 00:07:00 Recovery 00:14:00 Backup and Recovery of VMs 00:09:00 IDA Planning and Implementing an AD FS Server Infrastructure 00:13:00 Planning and Implementing AD FS Claims Providers and Relying Parties 00:06:00 Planning and Implementing AD FS Claims and Claim Rules 00:07:00 Planning and Implementing an AD RMS Cluster 00:18:00 Installing an AD RMS Cluster 00:12:00 Planning and Implementing AD RMS Templates and Policies 00:06:00 Planning and Implementing External Access to AD RMS Services 00:07:00 Planning and Implementing AD RMS Integration with DAC 00:05:00 Mock Exam Mock Exam- 70-414 - Implementing an Advanced Server Infrastructure (MCSE) 00:20:00 Final Exam Final Exam- 70-414 - Implementing an Advanced Server Infrastructure (MCSE) 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Step into the leadership spotlight with the Advanced Diploma in Strategic People Management: 20-in-1 Premium Online Courses Bundle. Designed to elevate professionals into people-first managers, this bundle is perfect for HR specialists, project leads, operations supervisors, and anyone steering teams through complexity and change. With 20 key qualifications in one strategic package, it’s your opportunity to move from managing tasks to managing impact. Description Today’s employers expect more from leadership: emotional intelligence, change readiness, and crisis competence. This bundle signals all of that—and more. Ideal for roles in HR, organisational development, corporate leadership, or internal consultancy, these credentials demonstrate that you’re not just a manager—you’re a people strategist. From Lean Six Sigma to counselling, crisis management to negotiation, this collection adds real substance to your leadership profile. Whether you’re climbing into management or building credibility for a new career pivot, the value here is unmatched. In a hiring climate that favours those who can guide, influence, and organise people effectively—this bundle is your shortcut to relevance. Don’t miss the window. Offers like this don’t stay live for long. FAQ What career paths can this support? HR, operations management, learning and development, team leadership, and business consultancy. Is this only for HR professionals? Not at all. It’s perfect for anyone managing teams or building toward leadership roles. How long will I have access? Full, unlimited access begins immediately upon enrolment. Do I get proof of completion? Yes—each course comes with a certificate to support your CV or LinkedIn profile. Is this offer recurring? No. This is a promotional bundle with limited availability.
Launch or elevate your career in regulatory support, compliance, and risk mitigation with this all-in-one AML Administrator bundle. Covering key administrative, legal, and financial competencies, this 20-course collection equips you with the credentials modern institutions look for when hiring AML support professionals. Description From banking and law to fintech and government sectors, the demand for trained AML (Anti-Money Laundering) administrators is on the rise. But these roles require more than just theory—they demand operational awareness, legal sensitivity, and software fluency. This bundle brings together 20 career-relevant certifications across compliance, finance, HR, and law. If you're aiming to enter or grow within risk management, regulatory operations, or legal administration, this package places you miles ahead of the competition. Hiring cycles move fast. Don’t wait until you’re left behind—secure the training that says you’re ready to take responsibility today. FAQ What kinds of roles does this bundle support? AML administrator, compliance support, financial admin, KYC assistant, paralegal, risk operations analyst. Are these certifications useful across industries? Yes. They're ideal for roles in banking, legal firms, insurance, consultancy, and government departments. Do I need prior experience in compliance or finance? Not at all. This bundle is designed for both beginners and administrative professionals upskilling into AML. Is each course certified? Yes. All 20 courses include a certificate of completion for your CV and job applications. How long do I have access? You get lifetime access to all content. Learn anytime. Why should I enrol now? Compliance hiring is peaking, and employers want candidates who are already qualified. Delay less, qualify faster.
Energy management is evolving—and the professionals being hired are the ones trained across technical, safety, and environmental dimensions. The Energy Manager Training 20-in-1 Bundle is your shortcut to becoming one of them. Description The energy industry doesn’t just want specialists—it needs cross-trained professionals who understand systems, safety, sustainability, and smart energy flow. This comprehensive 20-in-1 bundle includes topics aligned with energy efficiency, HVAC systems, environmental management, and electrical safety—making it ideal for those eyeing careers in utilities, infrastructure, renewables, or facilities management. Whether you’re starting out or aiming for advancement, this bundle is structured to meet the hiring needs of technical energy roles, giving you a standout résumé for positions in energy operations, engineering support, logistics, or compliance. Jobs in energy are growing—and getting more competitive. This bundle offers the kind of multidisciplinary foundation that many professionals wish they had started sooner. FAQ Q: What industries does this bundle align with? A: Energy, utilities, HVAC services, mechanical engineering, renewables, and environmental compliance. Q: Who is it suitable for? A: Energy coordinators, HVAC technicians, aspiring engineers, sustainability officers, and operations assistants. Q: Will it help me qualify for energy-related jobs? A: Yes—employers prefer candidates who understand both systems and safety protocols. Q: Can I take this without prior experience? A: Absolutely. It suits beginners, career changers, and working professionals alike. Q: How long will this deal be available? A: For a short period only—bundles with this much value rarely last long. Q: Does it include compliance-focused topics? A: Yes. It covers RIDDOR, PUWER, and electrical safety, which are essential for energy professionals.
Unlock your career in payroll, finance, and data-driven administration with this comprehensive 20-in-1 Payroll Analyst bundle. Designed to help you stand out in accounting, HR, or financial operations roles, this bundle proves you’re prepared, capable, and hiring-ready. Description Payroll professionals are no longer just data processors—they're problem solvers, analysts, and compliance champions. Employers across sectors—from SMEs to large corporations—seek payroll analysts who are fluent in reporting, legislation, and software tools. That’s exactly the profile this bundle supports. With credentials in VAT, payroll systems, financial analysis, and key legal areas, you’ll show potential employers that you’re not just trainable—you’re already trained. It's a value-packed alternative to expensive accounting courses and a smart route to job-readiness in finance. The best part? It’s self-paced, affordable, and yours for life. Jobs may come and go—but this qualification toolkit stays with you. FAQ What roles can this help me land? Payroll analyst, payroll assistant, finance admin, data reporting officer, accounting support. Is this bundle suited for finance beginners? Yes, it’s built for beginners and career changers looking to enter payroll or finance operations. Will I receive proof of completion? Yes, each course includes a certificate you can use for applications and professional profiles. Is accounting software covered? Yes—key platforms like Xero, Sage, and Excel are included. What makes this a smart investment? 20 courses, one bundle, lifetime access—less than the cost of one-day payroll training. Should I wait before enrolling? Not if you want to be job-ready before the next hiring cycle. The earlier you start, the sooner you stand out.
The Facilities Manager Training Mini Bundle is built for those managing people, parts, or places—sometimes all three before lunch. With modules in Logistics and Transportation, Operations Management, Supply Chain Management, Problem Solving, and Telephone Etiquette, this bundle provides solid knowledge for those who quietly keep everything running. Whether you’re navigating supplier delays or trying to make someone understand the word “urgent” over the phone, these lessons cover the pillars of effective facilities management. The Facilities Manager Training Mini Bundle is for the doers, the fixers, and the ones who solve it before it makes the group chat. Learning Outcomes: Understand logistics and transportation in workplace environments. Learn the foundations of operations and business flow. Explore supply chain structure and delivery strategies. Apply logical thinking to solve typical workplace issues. Develop telephone etiquette for professional communication. Improve time management in problem-heavy scenarios. Who is this Course For: Facilities coordinators dealing with multiple daily tasks. Office managers handling logistics and daily operations. Admin staff supporting supply or delivery systems. Professionals dealing with inbound and outbound calls. New hires in facilities or office resource roles. Supervisors overseeing internal systems and movement. Problem solvers working across departments regularly. Anyone who fixes things before others notice. Career Path: Facilities Manager – £38,000/year Logistics Supervisor – £34,000/year Office Administrator – £28,500/year Supply Chain Assistant – £29,000/year Operations Coordinator – £32,000/year Reception Manager – £27,000/year
Overview In the design of a bridge to the flight path of an aeroplane, mathematical principles are at play. Now, consider the power and promise held by those who master its intricacies. Welcome to our Math Fundamentals course. Math Fundamentals aligns with this pressing global requirement, laying the bedrock for understanding core concepts that shape academia and real-world applications. Initiating with a comprehensive introduction, this course dives deep into integers, exponents, fractions, and decimals and culminates in applied mathematics subjects like profit and loss, discount, and taxation. With mathematical fluency increasingly becoming a non-negotiable asset, immersing oneself in Math Fundamentals stands not just as an educational prerequisite but as a vital life skill. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Math Fundamentals. It is available to all students, of all academic backgrounds. Requirements Our Math Fundamentals is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 14 sections • 67 lectures • 07:39:00 total length •Introduction: 00:02:00 •Number system: 00:09:00 •Integers and ordering of integers: 00:07:00 •Addition and Subtractions of Integers: 00:10:00 •Operations on Integers: 00:06:00 •Multiplication and Division of Integers: 00:07:00 •Powers of Integers (Exponents): 00:04:00 •Complete knowledge about factors and multiples: 00:07:00 •Divisibility tests for 2,3,4,5,6: 00:07:00 •Divisibility rules 7,8,9,10,11: 00:11:00 •Prime Factorization: 00:13:00 •Highest common factor HCF: 00:13:00 •Word problems based on HCF: 00:12:00 •Least common multiple LCM: 00:16:00 •Relation between lcm and HCF: 00:04:00 •Classification of Fractions: 00:04:00 •Convert mixed to improper and improper to mixed fractions: 00:03:00 •Equivalent Fractions: 00:04:00 •Comparing Fractions after converting to like fractions: 00:09:00 •Reducing a fraction to lowest term: 00:04:00 •Addition and subtraction OF fractions: 00:08:00 •Multiplication and division of fractions: 00:11:00 •Word problems on fractions: 00:16:00 •Bodmas and rules to remove brackets: 00:03:00 •simplify expressions using BODMAS rules: 00:05:00 •simplify expressions involving fractions using BODMAS: 00:07:00 •Decimal numbers in relation to fractions: 00:08:00 •Like and unlike Decimals: 00:05:00 •Ordering of Decimal numbers: 00:10:00 •Addition and subtraction of Decimal: 00:07:00 •Multiplication of Decimal: 00:03:00 •Division of Decimal: 00:08:00 •Rational number: 00:02:00 •Representation of Rational Numbers on Number line: 00:05:00 •Determining which fraction is terminating or non-terminating: 00:07:00 •shortcut method of writing decimal expansion of fraction to decimal: 00:08:00 •Rounding to whole number: 00:06:00 •Rounding to required number of decimals (1 d.p. ): 00:05:00 •Rounding to significant digits: 00:07:00 •Practice question on three methods of approximation: 00:05:00 •Estimation: 00:05:00 •Scientific Notation: 00:07:00 •Operation on numbers when they are in scientific notation: 00:06:00 •Percentage to fraction and fraction to percentage: 00:06:00 •Percentage of a quantity and conversation to decimal: 00:06:00 •Expressing one quantity as percentage of another quantity: 00:06:00 •Finding increase decrease percent: 00:05:00 •Uses of Percentages-Word Problems: 00:09:00 •Ratio- How to express as simple ratio: 00:09:00 •How to compare Ratios: 00:04:00 •Word problems on finding ratios: 00:07:00 •To divide a given quantity into a given Ratio: 00:11:00 •Proportion: 00:04:00 •Practice problems on Proportion: 00:06:00 •Continued proportion: 00:06:00 •Direct Variation (or proportion): 00:04:00 •Problems based on Direct proportion: 00:10:00 •Inverse Variation (or proportion): 00:10:00 •Multiple Ratios: 00:10:00 •Basics - Profit and Loss: 00:04:00 •More practice problems on Profit _ Loss: 00:06:00 •Selling price formula and Problems: 00:04:00 •Cost price formula and Problems: 00:03:00 •Higher problems on Profit and Loss: 00:08:00 •Basics - Discount: 00:05:00 •Practice problems on Discount: 00:04:00 •Tax: 00:06:00