467 Courses delivered Online

Did you know that the human brain processes visual information 60,000 times faster than text? That's why Microsoft PowerPoint is the world's leading presentation software. Microsoft PowerPoint allows you to create visually appealing and engaging presentations that will help you communicate your ideas more effectively. This Microsoft PowerPoint Bundle Course will teach you everything you need to know to create professional-looking and effective presentations. You'll learn how to use Microsoft PowerPoint's features and tools to create informative, engaging, and visually appealing slides. You'll also learn how to deliver your presentations confidently and professionally. Learning Outcomes of Microsoft PowerPoint Bundle: Master the fundamentals of Microsoft PowerPoint Learn how to create visually appealing and informative slides Discover advanced PowerPoint features and techniques Develop your public speaking and presentation skills Boost your confidence and deliver effective presentations in any setting This Microsoft PowerPoint Bundle Consists of the following Premium courses: => Course 01: PowerPoint Diploma => Course 02: MS Word Diploma => Course 03: Advanced Diploma in MS Excel => Course 04: Touch Typing Essentials => Course 05: Document Control => Course 06: GDPR => Course 07: Leadership & Management Diploma => Course 08: Motivation Skills => Course 09: Functional Skills IT => Course 10: Public Speaking and Presentation Skill Course => Course 11: Time Management Key features of this Microsoft PowerPoint bundle: This Microsoft PowerPoint bundle is CPD QS Accredited Learn from anywhere in the world Lifetime access Our Microsoft PowerPoint is entirely online 24/7 Learner support Enroll in the Microsoft PowerPoint Bundle Course today and start creating presentations that will impress your audience! In today's digital world, effective communication is essential for success. Microsoft PowerPoint is one of the most popular and powerful presentation tools available, and it can be used to create engaging and informative presentations for a variety of purposes, from business meetings to educational lectures. This Microsoft PowerPoint Bundle Course provides you with the comprehensive skills and knowledge you need to master Microsoft PowerPoint and use it to create effective presentations that will captivate your audience. This Microsoft PowerPoint Bundle course covers everything from the basics of creating and editing presentations to advanced techniques such as animation, transitions, and multimedia elements. You will also learn how to design effective slides, deliver presentations confidently, and use PowerPoint to create professional-looking documents. Whether you are a beginner or an experienced user, this Microsoft PowerPoint bundle course has something to offer you. Its comprehensive coverage of all aspects of Microsoft PowerPoint is the perfect way to take your presentation skills to the next level. The Curriculum of Microsoft PowerPoint Bundle => Course 01: PowerPoint Diploma Module 01 Customize the User Interface Set PowerPoint 2016 Options Module 02 Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Module 03 Create SmartArt Modify SmartArt Write Math Equations Module 04 Add Audio to a Presentation Add Video to a Presentation Customize Animations and Transitions Module 05 Review a Presentation Store and Share Presentations on the Web Module 06 Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks and Action Buttons Record a Presentation Module 07 Secure a Presentation Broadcast a Slide Show Create a Video or a CD =========>>>>> And 10 More Courses <<<<<========= How will I get my Certificate? After successfully completing the Microsoft PowerPoint course, you can order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) P.S. The delivery charge inside the U.K. is £3.99 and international students have to pay £9.99. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Microsoft PowerPoint Bundle: Students and graduates who want to develop their Microsoft PowerPoint skills and make themselves more employable. Professionals who want to improve their presentation skills and advance their careers. Anyone who wants to learn how to create engaging and informative presentations for any purpose. Requirements Our Microsoft PowerPoint bundle is fully compatible with PCs, Macs, laptops, tablets 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 Microsoft PowerPoint bundle course, it can be studied in your own time at your own pace. Career path Having this Microsoft PowerPoint bundle course will increase the value of your CV and open you up to multiple job sectors: Presentation Designer: £25,000 to £50,000 Trainer: £25,000 to £50,000 Sales Representative: £25,000 to £100,000 Marketing Manager: £40,000 to £80,000 Teacher: £25,000 to £70,000 Public Speaker: £25,000 to £100,000 Certificates Certificate of Completion (PDF) Digital certificate - Included Certificate of Completion (Hard Copy) Hard copy certificate - £10 You will get the Hard Copy certificate for the title course (Microsoft PowerPoint Diploma) absolutely Free! Other hard-copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Gain essential skills in data entry and management with our Certificate course. Learn efficient data entry techniques, organization methods, and database management practices. Prepare yourself for a wide range of data-focused roles in various industries. Enroll now to start your journey towards becoming a proficient data handler and advancing your career prospects.

Want to land interviews faster, impress employers instantly, and climb the ladder quicker? The Microsoft Office Specialist (MOS) Mini Bundle equips you with the digital essentials every office, agency, and department looks for. From MS Word and MS Excel to MS PowerPoint, Google DataStudio, and data entry—this is the digital fluency bundle that moves CVs from inbox to interview. Mastery of MS Word, MS Excel, MS PowerPoint, Google DataStudio, and data entry isn’t optional anymore—it’s expected. This bundle arms you with the digital tools employers trust, from admin to analytics, presentation to planning. Job-ready, cost-effective, and career-focused. Description There’s no such thing as a “basic” office job anymore. Employers demand professionals who can wield MS Word, MS Excel, MS PowerPoint, Google DataStudio, and data entry tools with ease and accuracy. The MOS Mini Bundle prepares you to meet that demand—and outshine the competition. MS Word gives you document dominance. MS Excel turns you into a spreadsheet strategist. MS PowerPoint lets you present like a pro. Google DataStudio empowers you with data visuals, while data entry precision proves you're fast, focused, and detail-oriented. Together, they make your CV impossible to overlook. Every admin, HR, finance, marketing, or analyst role expects MS Word, MS Excel, and MS PowerPoint proficiency. But throw in Google DataStudio and data entry experience? You’re not just qualified—you’re indispensable. Don’t let this opportunity expire while others land the jobs you deserve. Grab the MOS Mini Bundle now, and make yourself the candidate employers hope to find. FAQ Q: What kind of roles is this bundle suited for? A: Administrative Assistant, Office Manager, Data Analyst, Executive Assistant, Marketing Support, and more—any role requiring MS Word, MS Excel, MS PowerPoint, Google DataStudio, or data entry. Q: Is this bundle beginner-friendly? A: Yes. Even if you're starting fresh, this bundle helps you become confident in MS Word, MS Excel, MS PowerPoint, Google DataStudio, and data entry. Q: Why is Google DataStudio included with Microsoft tools? A: It’s a popular cloud-based analytics platform, often used alongside MS Excel and MS PowerPoint in data-driven roles. Q: Will this help in remote and hybrid work? A: Absolutely. MS Word, MS Excel, MS PowerPoint, Google DataStudio, and data entry are essential for digital communication and reporting in any environment. Q: Is it worth the investment? A: Yes—you're gaining professional fluency in five of the most commonly required digital skills for a single, budget-friendly price.

The Microsoft Office Specialist (MOS) is a globally recognised qualification. Having a Microsoft Office Specialist certification on your CV demonstrates that you have gained the necessary expertise to competently use Microsoft applications, giving you a competitive advantage when job hunting as well as in the workplace. It will significantly increase your confidence, skills and employability. It will serve to objectively validate your IT skills and assist in your advancement in your chosen career.

Looking to get hired in facilities, logistics, or admin-heavy industries? The Facilities Management Mini Bundle is packed with high-utility career tools—logistics and transportation, operations management, supply chain management, proofreading, and MS Excel—to make your CV hard to ignore and easy to shortlist. If logistics and transportation, operations management, supply chain management, proofreading, and MS Excel are on your CV, you’re not just a candidate—you’re the candidate. This bundle is your ticket to becoming the go-to person in any large operation. Description Facilities and operations don’t run themselves—they run on professionals skilled in logistics and transportation, operations management, supply chain management, proofreading, and MS Excel. The Facilities Management Mini Bundle arms you with job-relevant capabilities that employers trust for making smart, efficient hiring decisions. With logistics and transportation, you’re ready for movement and delivery management. Operations management makes you process-aware. Supply chain management proves your global coordination value. Proofreading shows your attention to detail, while MS Excel speaks volumes about your data fluency. Hiring managers are tired of single-skill candidates. They want multi-skilled applicants who bring logistics and transportation experience, understand operations management and supply chain management, can proofread accurately, and navigate MS Excel with confidence. This bundle lets you step into that exact profile. Don’t wait for job openings to pass you by. Equip yourself now—and become the organised, hireable professional every company needs. FAQ Q: What roles does this bundle prepare me for? A: Logistics Coordinator, Facilities Assistant, Supply Chain Analyst, Office Administrator, Operations Officer, or Excel Technician. Q: Why is proofreading included? A: Documentation errors can ruin logistics, operations, and supply chain management—proofreading ensures accuracy at every level. Q: Do I need Excel skills in logistics? A: Absolutely. MS Excel is a core tool used across logistics and transportation, operations management, and supply chain management functions. Q: Is this good for both small and large employers? A: Yes. These five skills are essential in any operation—whether a warehouse startup or a corporate distribution centre. Q: Can this help me get promoted? A: Definitely. Proficiency in logistics and transportation, supply chain management, MS Excel, and operations management is a strong case for promotion.

Looking to land that coveted office support role or transition into remote admin work? The Secretary Mini Bundle positions you at the top of the shortlist for employers across industries. Featuring job-ready qualifications in administrative assistant duties, virtual assistant capabilities, MS Excel expertise, HR fundamentals, and telephone etiquette mastery—this bundle was crafted to get you hired, fast. Employers want administrative assistant and virtual assistant professionals who are fluent in MS Excel, aware of HR protocols, and polished in telephone etiquette. Don’t wait for the job market to pass you by—own it with this career-accelerating bundle. Description Today’s offices, agencies, and virtual teams are built on people who can manage admin chaos with calm, clarity, and confidence. That’s where the Secretary Mini Bundle comes in—arming you with the most relevant and requested skills in administrative assistant roles, virtual assistant work, MS Excel data fluency, HR compliance, and telephone etiquette professionalism. Whether it’s managing appointments, spreadsheets, HR communications, or client calls, this bundle reflects the hybrid, fast-paced nature of modern office environments. You’ll be seen as the professional who brings administrative assistant organisation, virtual assistant flexibility, MS Excel efficiency, HR awareness, and excellent telephone etiquette to every task. Want to stand out to hiring managers in legal firms, healthcare offices, real estate agencies, and corporate departments? These employers are all on the hunt for candidates with administrative assistant, virtual assistant, MS Excel, HR, and telephone etiquette credentials. This bundle gives you all five, in one career-boosting package. Time-sensitive roles like these fill quickly. Get qualified, get noticed, and get hired—before someone else does. FAQ Q: Who will benefit most from this bundle? A: Anyone aiming to work as an administrative assistant, virtual assistant, office support worker, HR clerk, or executive receptionist. Q: Why is telephone etiquette so important? A: Strong telephone etiquette sets a professional tone—critical for both administrative assistant and virtual assistant positions. Q: Can this help me get remote work? A: Absolutely. Virtual assistant roles rely heavily on MS Excel, HR awareness, and telephone etiquette. Q: Is this suitable for career changers? A: Yes. If you're transitioning into admin, HR, or virtual roles, this bundle covers key job-relevant skills. Q: What industries will recognise this training? A: Finance, healthcare, education, corporate offices, and SMEs all value administrative assistant, virtual assistant, MS Excel, HR, and telephone etiquette skills.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Ever dreamed of becoming the backbone of a successful organisation? Administrative professionals are crucial to 98% of UK businesses, with over 2.5 million employed across various industries. If you're looking for a rewarding and versatile career path, this PA, Office Skills & Administration bundle is your perfect starting point. Our meticulously crafted bundle aims to teach you about Admin, Secretarial & PA, and Office Administration & Skills, ensuring you are equipped with the highest level of administrative knowledge. Additionally, specialised courses in Hospitality Management for Receptionists, Effective Minute-Taking, and Meeting Management will refine your skills in specific, crucial areas of corporate administration. These courses share essential theoretical knowledge providing you with a robust skillset that meets the demands of modern businesses. This Executive PA, Office Skills & Administration Bundle Contains 5 of Our Premium Courses for One Discounted Price: Course 01: Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Course 02: Advanced Diploma in Office Administration & Skills at QLS Level 7 Course 03: Hospitality Management for Receptionist Course 04: Effective Minute-Taking Training Course 05: Meeting Management Learning Outcomes of PA, Office Skills & Administration Confidently handle scheduling, filing, correspondence, and more. Organise and manage effective meetings that achieve goals. Provide exceptional support to executives and teams. Understand and navigate compliance regulations in your field. Capture key information accurately and concisely. Build strong relationships and collaborate effectively. Advance your career by mastering the art of administration with our comprehensive training bundle. Whether you aim to climb the corporate ladder, enhance your current job performance, or secure a prestigious new position, our courses offer the expertise you need. Don't miss the opportunity to stand out in the job market. Enrol today and transform your professional future! Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! *** Course Curriculum *** Course 01: Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Module 01: Personal Assistant Module 02: Admin Support Module 03: Administrative Management Module 04: Organisational Skills Module 05: Telephone Etiquette Module 06: Business Writing Module 07: Time Management Module 08: Body Language And Effective Communication Module 09: Meeting Management Module 10: Excel Basics Module 11: PowerPoint Basic Course 02: Advanced Diploma in Office Administration & Skills at QLS Level 7 Module 01: Introduction to Office Administration Module 02: Skills of an Effective Administrator Module 03: Business Etiquette Module 04: Business Telephone Skills Module 05: Representing Your Boss and Company Module 06: Mail Services and Shipping Module 07: Travel Arrangements Module 08: Organising Meetings and Conferences Module 09: Time Management Module 10: Record Keeping and Filing Systems Module 11: Business Writing Skills Module 12: Organisational Skills Module 13: Communication Skills Module 14: Customer Service Module 15: Effective Planning and Scheduling Module 16: Invoicing Petty Cash Course 03: Office Admin and Receptionist Skills Module 01: Introduction To Reception And Receptionist Module 02: Business Telephone Skills Module 03: Representing Your Boss And Company Module 04: Mail Services And Shipping Module 05: Travel Arrangements Module 06: Organising Meeting And Conferences Module 07: Time Management Module 08: Record Keeping And Filing Systems Module 09: Business Writing Skills Module 10 :Organisational Skills Module 11: Communication Skills Module 12: Customer Service Module 13: Effective Planning And Scheduling Module 14: Invoicing/Petty Cash Module 15: Business Environment Module 16: Advanced MS Excel =========>>>>> And 2 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*5 = £65) CPD Hard Copy Certificate: Free (For The Title Course: Previously it was £29.99) CPD 240 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring Executive PAs Office Administrators Receptionists Secretarial Staff Career Changers Office Managers Note: This PA, Office Skills & Administration Bundle is not a regulated course. To qualify, you may choose any of the following: Level 1 Certificate in Business Administration Level 2 Certificate - Business Administration Level 2 Certificate in Principles of Business Administration (RQF) Level 2 Certificate in Principles of Business Administration (VRQ) Level 2 Certificate in Principles of Business and Administration (RQF) Level 3 Certificate in Principles of Business (RQF) Administration BTEC Business Level 2 Diploma in Business Administration Level 4 Diploma in Business Administration Level 6 Diploma in Business Administration Level 2 Diploma in Business Administration (RQF) Requirements You will not need any prior background or expertise to enrol on this PA, Office Skills & Administration Diploma Course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Executive Personal Assistant - £35,000 Office Manager - £30,000 Senior Administrator - £28,000 Receptionist Team Leader - £25,000 Meeting and Events Coordinator - £24,000 Administrative Assistant - £22,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Hard copy certificate - £129 Please note that International students have to pay an additional £10 as a shipment fee.

Unlock your potential in the property sector with the Real Estate Development Mini Bundle—designed for those looking to build a strong, hireable skillset in property finance and management. By focusing on essential skills like Finance, MS Excel, Business Analysis, Proofreading, and Business Law, this bundle provides everything you need to stand out in the competitive world of real estate development. Description Success in real estate development depends on a deep understanding of Finance and the ability to analyze business opportunities critically. The Finance skills gained here will make you a valuable asset for companies needing experts who can manage budgets, assess investment viability, and optimize project funding. No modern real estate professional can overlook MS Excel. From financial modeling to data analysis, MS Excel proficiency is a must-have. Employers actively seek candidates skilled in MS Excel to streamline reporting and support data-driven decision-making. Adding depth to your profile, Business Analysis enhances your capability to evaluate market trends, client needs, and project feasibility. Strong Business Analysis skills empower you to identify risks and opportunities, making you indispensable in real estate project teams. The importance of clear communication and error-free documents can’t be overstated, so Proofreading is an invaluable addition. With impeccable Proofreading, you ensure contracts, proposals, and reports reflect professionalism and accuracy, a vital skill for client-facing roles. Finally, understanding Business Law is fundamental in real estate development. Whether it’s contracts, property rights, or regulatory compliance, Business Law knowledge sets you apart as a knowledgeable and reliable professional. Combining Finance, MS Excel, Business Analysis, Proofreading, and Business Law prepares you to confidently enter and thrive in real estate development roles. FAQ Q: Who should consider this bundle? A: Aspiring real estate developers, project managers, financial analysts, and professionals seeking expertise in Finance, MS Excel, Business Analysis, Proofreading, and Business Law. Q: Can this bundle help me in property investment? A: Yes, the combined skills in Finance, MS Excel, Business Analysis, and Business Law give you a significant edge. Q: Do I need prior experience? A: No, this bundle supports beginners and professionals looking to sharpen their real estate development skills.

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

Unlock your potential in the recruitment and HR industry with the Employee Recruitment Mini Bundle—an essential stepping stone for anyone serious about mastering the hiring process, understanding legal frameworks, and communicating with precision. This bundle was strategically built to make you hireable, promotable, and ready for roles in HR, staffing, administration, and corporate compliance. In a rapidly evolving job market, companies are hunting for professionals who understand employment law, MS Excel, proofreading, business law, and psychology inside and out. Don't wait—while others are still figuring out their next move, you could be building skills that employers trust and value. Description The Employee Recruitment Mini Bundle is tailor-made for anyone looking to break into or grow within the recruitment and HR ecosystem. Whether you're aiming to work with staffing agencies, large corporations, or HR consultancies, mastery over employment law, MS Excel, proofreading, business law, and psychology is your ticket in. From organizing recruitment pipelines with MS Excel to ensuring communication accuracy through proofreading, every skill in this bundle is designed for real-world relevance. Deepen your awareness of employment law and business law—two of the most in-demand domains in modern HR settings—and gain insights into psychology to better evaluate and manage talent. There’s no time to hesitate. These industries evolve fast, and roles are competitive. Whether you're just starting out or already in the field, learning employment law, MS Excel, proofreading, business law, and psychology together will give you a hiring advantage many others lack. No filler. No fluff. Just the crucial skills you need, at a fraction of the price you'd expect for this level of career impact. Get job-ready faster, smarter, and stronger than the competition. FAQ Who should enroll in the Employee Recruitment Mini Bundle? Anyone looking to join or advance in HR, recruitment, or administrative roles where employment law, MS Excel, proofreading, business law, and psychology are must-haves. How will this help me get hired? Mastering employment law, MS Excel, proofreading, business law, and psychology shows recruiters you're ready to take on real responsibilities from day one. It's one of the fastest ways to stand out in a crowded job market. Is this bundle suitable for beginners? Absolutely. Whether you're new or refreshing your knowledge, the Employee Recruitment Mini Bundle builds foundational and practical fluency in employment law, MS Excel, proofreading, business law, and psychology.