Master food hygiene and safety with this CPD-accredited course. Learn regulations, risk management, and best practices for food handling.
Employee Assistance Programme Training
Dive into the realm of effective management with our course, 'Essentials of Becoming a Manager and Managing Teams'. Navigate the challenges of stepping into a managerial role in 'New Manager Mastery'. Discover the art of selecting the perfect candidate for your team in 'A Masterclass in Hiring For Your Teams' and foster an environment that promotes continuous growth with 'Creating a Culture of Learning in Your Organisation'. Equip yourself with top-tier interview techniques, manage stress, lead with conviction, conduct impactful meetings, and delve into the intricacies of advanced team management. Learning Outcomes Understand the transition intricacies and best practices of becoming a new manager. Master the strategies to effectively hire and onboard team members. Establish and nurture a growth-oriented learning culture within the organisation. Acquire techniques to proficiently manage stress, ensuring personal and team well-being. Lead meetings effectively and gain insights into advanced aspects of team leadership. Why buy this Essentials of Becoming a Manager and Managing Teams course? Unlimited access to the course for forever 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 Certification After studying the course materials of the Essentials of Becoming a Manager and Managing Teams there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Essentials of Becoming a Manager and Managing Teams course for? Aspiring managers looking to transition into leadership roles seamlessly. Team leaders seeking to refine their hiring and team-building strategies. Organisational heads aiming to instil a robust learning culture. Professionals wanting to enhance their interview conduction skills. Individuals eager to develop leadership attributes and manage workplace stress. Prerequisites This Essentials of Becoming a Manager and Managing Teams does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Essentials of Becoming a Manager and Managing Teams 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 Manager: £30,000 - £45,000 Team Leader: £25,000 - £35,000 HR Specialist: £28,000 - £40,000 Training and Development Officer: £27,000 - £37,000 Stress Management Consultant: £35,000 - £50,000 Meetings Coordinator: £22,000 - £30,000 Course Curriculum Section 01: New Manager Mastery What to Expect & About Me 00:02:00 Well Done! 00:02:00 It's a Different Job 00:03:00 You're Scared? Good! 00:02:00 The Manager Mindset 00:03:00 Set Expectations 00:04:00 Get Learning Leadership! 00:03:00 What is Culture? 00:02:00 Culture of Fairness 00:08:00 People Are Crazy 00:02:00 Mastering One To One Meetings 00:05:00 Manager to Coach 00:07:00 Me? A Psychologist? 00:02:00 Emotional Intelligence 00:05:00 Mastering Performance Evaluations 00:07:00 Welcoming New Starters 00:07:00 How to Hire a Diverse Workforce 00:06:00 Get the Basics Right Every Time 00:02:00 Conclusion 00:02:00 Section 02: A Masterclass In Hiring For Your Teams Introduction 00:02:00 The Importance of the Interview Process 00:03:00 What's Wrong With The Interview Process 00:07:00 Human Vs. Algorithm 1 00:02:00 Unconscious Interviewer Biases 00:03:00 Be Data Driven 00:03:00 Let's See You In Action 00:02:00 Keep it Relevant 00:02:00 Seriously Avoid These Topics 00:03:00 Benefits of a Diverse Workforce 00:03:00 How to Hire a Diverse Workforce 00:06:00 Hunger and Desire Over Skills 00:03:00 Culture Addition, Not Culture Fit 00:03:00 Compliment, Backup or Add To The Team 00:05:00 Hiring The Right Rank 00:04:00 What Are Your Location Restrictions 00:01:00 The Risk Of Delivering Less 00:02:00 The Risk Of Burnout 00:02:00 The Risk Of Losing The Headcount 00:02:00 Confirm The Job Is What They Think It Is 00:02:00 Sell Yourself, The Team & The Company 00:03:00 Don't Be A Jerk 00:02:00 It's Not About Making You Look Good 00:02:00 Managing Recruitment Agencies 00:04:00 Communications With The Candidate 00:03:00 Be Ready 00:03:00 Assign A Buddy 00:02:00 You Got It Wrong! 00:02:00 Conclusion 00:03:00 Section 03: Creating a Culture Of Learning In Your Organization What To Expect From The Course 00:02:00 Why Even Bother? 00:07:00 What Learning Used To Be Like 00:02:00 Individual Learner 00:01:00 Everyone Says They Are A Self-Learner 00:10:00 Online Communities 00:02:00 Embedding Learning Into Daily Life 00:03:00 Teach It To Learn It 00:02:00 Learning New Vs Becoming Expert 00:01:00 Listen Faster 00:01:00 Tom's Approach 00:02:00 The Paid Training Course Is History 00:03:00 Develop The Right Mental Habits 00:06:00 Make It Easier On Yourself 00:02:00 Manager Responsibilities 00:01:00 Are You Really A Centre Of Excellence? 00:02:00 Learning As Part Of Performance Evaluation 00:02:00 Don't Worry If People Leave 00:01:00 The Benefits Of A Skilled User Base 00:02:00 Push It, Push It, Push It 00:01:00 The Golden Hour 00:09:00 Internal Mobility 00:03:00 Team Secondment 00:02:00 Make People Good Enough To Quit 00:03:00 Lunch & Learns 00:02:00 Personalised Learning Plans 00:02:00 Use It Or Lose It 00:02:00 Certifiably Great 00:02:00 Get A Learning Buddy 00:02:00 Senior Leaders Responsibilities 00:01:00 Walk It From The Top 00:02:00 Learning Wherever, Whenever 00:02:00 Show Us The Data 00:02:00 Create Learning Champions 00:02:00 Gamification 00:02:00 Sell, Sell, Sell 00:03:00 Don't Block The Useful Sites 00:03:00 Create A Varied Library Of Resources 00:02:00 Encourage Conferences And Seminars 00:04:00 The Feedback Loop 00:02:00 Learning Is Expensive 00:03:00 Learning Takes Time 00:02:00 Concluding Remarks 00:04:00 Section 04: Job Interview Practicals: Complete Interview Skills Training Interview Masterclass - Maximize Your Chances of Success 00:03:00 Get Yourself Game Ready! 00:08:00 Final Prep Tips! 1-2 Days Before Interview 00:03:00 It's Interview Day! How to ACE the interview! 00:07:00 Positive Personality Traits Interviewers Are Desperate For 00:07:00 How to Engage & Impress in Conversation 00:05:00 The Art of Asking Questions 00:08:00 How to Answer Questions Using Skill & Psychological Tricks 00:10:00 After Interview - Still More You Can Do 00:05:00 Staying Professional 00:02:00 That Wasn't What You Expected!! 00:03:00 Waiting For The Answer 00:02:00 Let's Review The Tips - So Much To Consider 00:04:00 Section 05: Beating Burnout - Practical & Complete Stress Management Introduction to Overcoming Burnout 00:03:00 The Problem of Burnout in Modern Workplaces 00:06:00 Symptoms of Burnout - Do You Have It? 00:03:00 How Individuals Can Fight Back Against Burnout 00:12:00 How Leaders Can Create A Burnout Free Culture 00:10:00 Let's Review The Advice - What's Important? 00:03:00 Section 06: Practical Leadership: Complete Guide To Great Leadership Characteristics of Great Leaders - Introduction 00:02:00 Honesty, Coaching & The Mission 00:08:00 Empathy, Togetherness & Feedback 00:06:00 Change, Authenticity & Enablement 00:05:00 Perspective, Empowerment & Emotional Intelligence 00:05:00 My Favourite Tips & Bonus! 00:05:00 Section 07: Mastering Meetings - A Complete Practical Guide To Meetings What to Expect 00:04:00 What & Why? 00:03:00 The Cost of Meetings 00:02:00 Red Amber & Green Meetings 00:06:00 Do You Need A Meeting? 00:04:00 Timing Considerations 00:07:00 Contents of the Invite 00:03:00 Scheduling Etiquette 00:07:00 Considerations for Externals 00:05:00 The Meeting as an Opportunity 00:02:00 Chairing Meetings 00:01:00 Your Agenda 00:08:00 Kicking Off 00:06:00 During The Meeting 00:08:00 After Meeting Minutes 00:06:00 Considerations 00:06:00 Concluding Remarks 00:02:00 Section 08: Advanced People Management - What They Don't Tell You About Team Leading! What To Expect & About Me 00:02:00 Management Vs. Coaching 00:07:00 What Is Culture? 00:02:00 Culture of Fairness 00:08:00 How To Be A Great Listener 00:05:00 Mastering Performance Evaluations 00:07:00 Welcoming New Starters 00:07:00 Stupid Things NOT To Say To Your Team 00:07:00 Your Team Made A Mistake 00:06:00 Mastering Crucial Conversations 00:05:00 When to Fire Someone 00:06:00
24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! [Updated: February 2024] Start a career in the lucrative project management industry. Enrol in this thorough Project Management for Project Managers course to acquire the essential abilities and methods used in project management around the world. Courses are included in this Project Management for Project Managers: Course No 01: Project Management for Project Managers Course No 02: Agile Project Management Course No 03: Lean Process and Six Sigma Course No 04: Strategic Business Management Course No 05: Financial Management In this Online Training, you will be introduced to the practical knowledge and techniques that you need to be a successful project manager. The training provides all the necessary information and skills for Project managers, such as how to build the team, how to lead the team, communication, etc. You will also learn the basics of Project Management, Change Management, Stakeholder Management, Managing Budgets and schedules, etc. With This Project Management for Project Managers Diploma, You Will Learn: Acquire deeper insights into the fundamentals Familiarise yourself with the PMBOK framework & PMI Expose yourself to the dimensions of global project management Understand the difference between product and project Management life cycles Develop a solid understanding of Project Management, HR, conflict & stress management Proficiency in quality, performance, change & many other sorts of management Detailed grasp of business resilience & crisis management Agility in procurement, purchasing & risk management and much more... After completing this course, you can progress towards- Project management institute (pmi) PMI Project Management Professional (PMP) PMI certified associate in project management (capm) Project Management Professional (PMP) Agile Project Management **This offer ends soon** Student Testimonials - What Our Students Say! ''The Level 7 Advanced Diploma in Project Management for Project Managers is a game-changer. It's the most comprehensive and practical course I've ever taken, and it's helped me take my project management skills to the next level. Recommended'' Reviewed by C.Well ''This course covers all aspects of project management, from the fundamentals to the advanced. It is ideal for aspiring and experienced project managers who want to learn the latest techniques and best practices. Thanks, Reed'' Reviewed by Abbie ''I loved the course, and I learnt a lot. It has equipped me with a wealth of knowledge I'll need to hit the ground running as a project manager here in the UK. Also, thank you for your prompt response to my inquiry.'' Reviewed by GRACE ANYEBE So enrol now today to Advance your career! Course Curriculum Module 01: Introduction to Project Management In this module of Project Manager Training, the following topics will be discussed: Project and Project Management Relationships among Portfolios, Programs and Projects Linking Organisational Governance and Project Governance Project Success and Benefits Management Duties and Responsibilities Knowledge, Skills and Abilities Summary Assessment Module 02: Project Life Cycle In this module of Project Manager Training, the following topics will be discussed: Project Life Project Life and Product Life Cycle Completion of Phase Project Design Creating Project Plan How Many Projects Integrating Consecutive Project Triple Constraint Summary Assessment Module 03: Project Scope Management In this module of Project Manager Training, the following topics will be discussed: Key Concepts Plan Scope Management Collect Requirements Define Scope Summary Assessment Module 04: Project Time and Cost Management In this module of Project Manager Training, the following topics will be discussed: Defining the Project Activities The Inputs to Activity Definition Creating Network Diagram Estimating Activity Duration Summary Assessment Module 05: Project Quality Management In this module of Project Manager Training, the following topics will be discussed: Implementing Quality Project Management Determining the Quality Policy Reviewing Summary Assessment Module 06: Effective Planning & Estimating In this module of Project Manager Training, the following topics will be discussed: Introduction to Project Planning Planning Process Summary Assessment Module 07: Human Resource Management In this module of Project Manager Training, the following topics will be discussed: Preparing for Organisational Planning Identifying the Project Interfaces Summary Assessment Module 08: Organising Meetings In this module of Project Manager Training, the following topics will be discussed: Anatomy of a Meeting Types of Corporate Meetings Scheduling Meetings Meeting Agendas Summary Assessment Module 09: Managing Resources (Please, avoid case study) In this module of Project Manager Training, the following topics will be discussed: Resource Management Benefits of Resource Management Summary Assessment Module 10: Change Management In this module of Project Manager Training, the following topics will be discussed: What is Change? Change Cycle The Pace of Change Summary Assessment Module 11: Crisis Management In this module of Project Manager Training, the following topics will be discussed: What is Crisis Management? Crisis Management Team Creating Team Technique Assessment Module 12: Conflict Management In this module of Project Manager Training, the following topics will be discussed: Conflict Benefits of Confrontation Preventing Problems Getting Focused The Three 'F' Assessment Module 13: Stress Management In this module of Project Manager Training, the following topics will be discussed: Understanding Stress Reasons for Stress Less Stress Strategies to Manage Stress Assessment Module 14: Communication Management In this module of Project Manager Training, the following topics will be discussed: Communications Management Processes Communication Planning Input to communication planning Communication technology Summary Assessment Module 15: Procurement Management In this module of Project Manager Training, the following topics will be discussed: Trends and Emerging Practices Plan Procurement Management Inputs Tools and techniques Outputs Outputs Summary Assessment Module 16: Risk Management In this module of Project Manager Training, the following topics will be discussed: Risk Identification Risk Quantification Assessment Module 17: International Project Management In this module of Project Manager Training, the following topics will be discussed: Global Projects Global Projects Knowledge Areas Global Project Leadership Assessment CPD 250 CPD hours / points Accredited by CPD Quality Standards Module 01: Introduction of Project Management 17:34 1: Introduction Video Preview 01:02 2: Introduction to Project Management Preview 13:32 3: Quiz 03:00 Module 02: PMBOK and PMI 08:35 4: PMBOK and PMI 07:35 5: Quiz 01:00 Module 03: Global Project Management 25:13 6: Global Project Management 23:13 7: Quiz 02:00 Module 04: Project Management Life Cycle 18:33 8: Project Life Cycle 16:33 9: Quiz 02:00 Module 05: Project Management & Time Management 26:53 10: Time Management 24:53 11: Quiz 02:00 Module 06: Project Management & Quality Management 15:03 12: Quality Management 13:03 13: Quiz 02:00 Module 07: Effective Planning & Scheduling for Project Management 35:19 14: Effective Planning & Scheduling 33:19 15: Quiz 02:00 Module 08: Human Resource Management 16:25 16: Human Resource Management 14:25 17: Quiz 02:00 Module 09: Performance Management 12:55 18: Performance Management 11:55 19: Quiz 01:00 Module 10: Talent Management 11:03 20: Talent Management 10:03 21: Quiz 01:00 Module 11: Organising Meeting and Conferences 18:24 22: Organising Meeting and Conferences 17:24 23: Quiz 01:00 Module 12: Managing Resources 12:52 24: Managing Resources 10:52 25: Quiz 02:00 Module 13: Change Management 16:19 26: Change Management 15:19 27: Quiz 01:00 Module 14: Business Resilience and Crisis Management 10:45 28: Business Resilience and Crisis Management 09:45 29: Quiz 01:00 Module 15: Conflict Management 08:47 30: Conflict Management 07:47 31: Quiz 01:00 Module 16: Stress Management 10:09 32: Stress Management 09:09 33: Quiz 01:00 Module 17: Communication Skills 18:21 34: Communication Skills 16:21 35: Quiz 02:00 Module 18: Procurement & Purchasing Management 13:55 36: Procurement & Purchasing Management 12:55 37: Quiz 01:00 Module 19: Risk Management 14:08 38: Risk Management 12:08 39: Quiz 01:00 40: Final Words 01:00 Assessment (Optional) 03:00 41: Assignment On - Advanced Diploma in Project Management at QLS Level 7 03:00 Order Your Certificate 02:00 42: Order Your CPD Certificate 01:00 43: Order Your QLS Endorsed Certificate 01:00 Recommendations 01:00 44: Take your career to the next level with HF Online! 01:00 Free Course No 01: Agile Project 46:59 45: Module 01: Key Concepts (I) 05:13 46: Module 02: Key Concepts (II) 04:07 47: Module 03: Initiation (I) 04:32 48: Module 04: Initiation (II) 04:17 49: Module 05: Planning (I) 05:02 50: Module 06: Planning (II) 06:39 51: Module 07: Planning Tools 04:47 52: Module 08: Executing the Project 03:57 53: Module 09: Maintaining and Controlling the Project 03:53 54: Module 10: Closing Out 04:32 Free Course No 02: Diploma in Six Sigma & Lean Process 44:46 55: Module 01: Understanding Lean 09:59 56: Module 02: Liker's Toyota Way 07:36 57: Module 03: The TPS House 05:08 58: Module 04: The Five Principles of Lean Business 02:58 59: Module 05: The First Improvement Concept (Value) 02:41 60: Module 06: The Second Improvement Concept (Waste) 02:20 61: Module 07: The Third Improvement Concept (Variation) 02:42 62: Module 08: The Fourth Improvement Concept (Complexity) 02:43 63: Module 09: The Fifth Improvement Concept (Continuous Improvement) 03:29 64: Module 10: The Improvement Toolkit 05:10 Free Course No 03: Strategic Business Management 2:35:05 65: Module 01: Introduction to Strategic Management Business 17:34 66: Module 02: Corporate Governance 14:23 67: Module 03: Industry Analysis 13:47 68: Module 04: Strategy Formulation 19:57 69: Module 05: Strategy Implementation 17:43 70: Module 06: Evaluation and Control 15:21 71: Module 07: Building a Brand 15:05 72: Module 08: Generating Success from the Customer Relationship 14:07 73: Module 09: Social Responsibility and Ethics in Strategic Management 15:41 74: Module 10: Getting Ready for Business Improvement 11:27 Free Course No 04: Financial Management 1:31:32 75: Module 01: Introduction to Financial Management 05:54 76: Module 02: Fundamentals of Budgeting 11:27 77: Module 03: The Balance Sheet 07:50 78: Module 04: The Income Statement 05:48 79: Module 05: The Cash Flow Statement 07:46 80: Module 06: Statement of Stockholders' Equity 05:48 81: Module 07: Analysing and Interpreting Financial Statements 22:11 82: Module 08: Inter-Relationship Between all the Financial Statements 07:59 83: Module 09: International Aspects of Financial Management 16:49 Who is this course for? This Project Manager Training course is ideally suited to any individual working in a standard. Particularly, this course is perfect for: New members of the project team Level 7 Diploma Project Management Level 6 Certificate in Project Management Project finance Project Management Insititute (PMI) NB: Please note that this Project Management course does not provide any professional qualifications. To get professional qualifications, please check: Project Management Insititute (PMI) Courses PMI Project Management Professional Courses PMI Certified Associate in Project Management Courses APM Project Management Qualification (PMQ) Level 7 Diploma - Project Management pmi project management professional Requirements Project Manager Training Our Project Management for Project Managers is open for everybody Career path Project Manager Training Project Coordinator Project Manager Senior Project Manager Project Director Program Manager Portfolio Manager Chief Project Officer (CPO) Project Assistant Project co-ordinator Project management support Project Analyst Certificates CPD Accredited Digital Certificate Digital certificate - Included Method of Assessment MCQ Based Passing Marks 60% Instant Assessment and Feedback Assessment Process You must complete the assignment questions given at the end of the and score a minimum of 60% to pass the exam and achieve the Quality Licence Scheme endorsed certificates. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing theexam, you will be able to request a certificate with additional cost that the Quality Licence Scheme has endorsed. Student ID Digital certificate - Included Get a Free Student ID card! (£10 postal charge will be applicable for international delivery) CPD Accredited Hard Copy Certificate Hard copy certificate - £29 Upon finishing the course, you need to order to receive a Certificate Accredited by CPDQS that is accepted all over the UK and also internationally. The pricing schemes are: Free (Shipping Fee Excluded) 29 GBP for Printed Hardcopy Certificate outside the UK (International Delivery) Advanced Diploma at QLS Level 7 Hard copy certificate - £139 Show off Your New Skills with a Certificate of Completion After successfully completing the course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 139 GBP inside the UK 149 GBP (including postal fees) for International Delivery
Microsoft Office skills are in high demand across industries, and proficiency in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Office 365 opens up numerous career opportunities. In the UK, administrative roles, data analysis positions, office management, project coordination, and marketing support roles are just a few examples of job prospects. With average salaries ranging from £20,000 to £45,000 per year, individuals with comprehensive Microsoft Office skills can secure stable employment and contribute to the success of various organisations. Enrol in the Ultimate Microsoft Office Skills Training course today and equip yourself with the knowledge and expertise needed to thrive in the ever-evolving workplace. You Will Learn Following Things: Develop a solid foundation in Microsoft Office applications, including Word, Excel, PowerPoint, and Office 365. Acquire essential skills to efficiently navigate and manipulate data in Microsoft Excel, such as organising, sorting, filtering, and writing formulas. Gain proficiency in creating professional presentations in Microsoft PowerPoint, utilising features like multimedia, transitions, animations, and smart graphics. Master the art of document creation and formatting in Microsoft Word, including tables, styles, page layouts, envelopes, labels, and mail merges. Understand advanced features like pivot tables, charts, and data analysis tools in Microsoft Excel, enabling effective data visualisation and decision-making. This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This course is designed for individuals who want to enhance their Microsoft Office skills for personal or skilled purposes. Whether you are a student, an experienced entrepreneur, or anyone who regularly works with Microsoft Word, Excel, PowerPoint, and Office 365, this Microsoft Office skills course will provide you with a solid foundation and advanced techniques to maximise your productivity and efficiency. No prior experience is required, making it suitable for beginners and intermediate users looking to expand their knowledge and capabilities in the Microsoft Office suite. On the other hand, anyone who wants to establish their career as: like MS Office User Microsoft Office 2019 User Touch Typing Worker Audio Typist Can take this Ultimate Microsoft Office Skills Training (Word, Excel, PowerPoint, and 365) course. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career path Administrative Assistant - £20K to £30K/year Data Analyst - £25K to £45K/year Office Manager - £25K to £40K/year Project Coordinator - £25K to £35K/year Marketing Assistant - £20K to £30K/year Course Curriculum Section 01: Getting Started Introduction 00:03:00 Getting started on Windows, macOS, and Linux 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: Excel 2021: Basics Excel Overview 00:05:00 Start Excel Spreadsheet 00:04:00 Enter Text and Numbers 00:07:00 Relative References 00:04:00 Working with ranges 00:07:00 Save and Save as Actions 00:08:00 File Extensions, Share, Export, and Publish files 00:06:00 Section 03: Excel 2021: Rows, Columns, and Cells Adding Rows and Columns 00:03:00 Modifying Rows and Column lengths 00:05:00 Section 04: Excel 2021: Data Handling Copy, Cut, and Paste 00:07:00 Copying Formulas 00:03:00 Section 05: Excel 2021: Page Setting Up and Print Page setup options 00:06:00 Fit to print on One Page 00:03:00 Print Workbooks 00:03:00 Section 06: Excel 2021: Sorting and Filtering Sorting Data Ascending Order 00:04:00 Sorting Data Descending Order 00:02:00 Filter Data 00:04:00 Section 07: Excel 2021: Writing Formulas Creating Basic Formulas 00:06:00 Datetime Formulas 00:06:00 Mathematical formulas phase1 00:20:00 Mathematical formulas phase2 00:12:00 Section 08: Excel 2021: Advanced Formulas VLOOKUP formula 00:12:00 HLOOKUP formula 00:04:00 Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 XLOOKUP 00:08:00 Handling #NA and Approximates match in XLOOKUP 00:11:00 Section 10: Excel 2021: Data and Tools Split Text into columns 00:07:00 Flash Fill 00:07:00 Data Validation 00:07:00 Remove Duplicates 00:08:00 Import Data from Text files 00:06:00 Import Data from .CSV files 00:03:00 Section 11: Excel 2021: Formatting data and tables Formatting Font 00:04:00 Formatting Alignment 00:06:00 Formatting Numbers 00:05:00 Formatting Date 00:03:00 Formatting Tables 00:05:00 Section 12: Excel 2021: Pivot Tables Pivot Tables 00:07:00 Pivot Charts 00:02:00 Section 13: Excel 2021: Charts Excel Charts - Categories 00:03:00 Elements of a chart 00:04:00 Creating Charts 00:02:00 Column or Bar charts 00:04:00 Formatting charts 00:04:00 Line Charts 00:02:00 Pie and Doughnut charts 00:04:00 Section 14: PowerPoint 2021: Course Introduction Overview 00:04:00 Start PowerPoint Presentation 00:05:00 Screen setting and Views 00:05:00 Section 15: PowerPoint 2021: Basics Presentation Tips and Guidelines 00:06:00 Creating a New Presentation 00:04:00 Working with Slides 00:04:00 Save a Presentation 00:04:00 Print Slides 00:03:00 Section 16: PowerPoint 2021: Text and Bullet Options Formatting Text 00:05:00 Slide Text Alignments 00:03:00 Multi-Column Text Alignments 00:02:00 Adding Bullets and Numbered List Items 00:03:00 Section 17: PowerPoint 2021: Adding Graphic Assets Insert Shapes 00:03:00 Insert Icons 00:03:00 Insert Graphics 00:04:00 Add 3D Models 00:03:00 Insert Pictures 00:03:00 Section 18: PowerPoint 2021: Picture Formatting Picture Options 00:04:00 Picture Cropping 00:03:00 Applying Built-in Picture Styles 00:04:00 Section 19: PowerPoint 2021: SmartArt Graphics Add SmartArt Graphic 00:03:00 Modifying SmartArt 00:03:00 Creating a Target Chart using SmartArt 00:03:00 Section 20: PowerPoint 2021: Working with Tables Create a Table on Slide 00:04:00 Formatting Tables 00:02:00 Inserting Tables 00:02:00 Table Layouts 00:01:00 Section 21: PowerPoint 2021: Working with Charts Add a Chart 00:02:00 Formatting Charts 00:02:00 Insert Chart from Microsoft Excel 00:03:00 Section 22: PowerPoint 2021: Adding Multimedia Adding Video to a Presentation 00:03:00 Adding Audio to a Presentation 00:02:00 Screen Recording and Adding 00:02:00 Section 23: PowerPoint 2021: Working with Transition Applying Transitions to Presentation 00:04:00 Section 24: PowerPoint 2021: Animation Object Animation 00:03:00 Effect Options 00:02:00 Advanced Animation 00:02:00 Triggers to control animation 00:02:00 Section 25: PowerPoint 2021: Slideshow Effects Onscreen Presentation 00:02:00 Hiding Slides 00:02:00 Changing Order of Slides 00:02:00 Copying Slides 00:02:00 Section 26: Word 2021: Introduction Overview of MS Word 00:04:00 Start MS Word 2021 00:05:00 Section 27: Word 2021: Basics Create a new blank document 00:04:00 Creating a paragraph text 00:05:00 Non-printing characters 00:03:00 Save a document 00:03:00 Open a document 00:01:00 Find and replace 00:04:00 Section 28: Word 2021: Word Formatting AutoCorrect options 00:03:00 Formatting text 00:04:00 Copy cut and paste 00:04:00 Character formatting 00:02:00 Format painter 00:04:00 Work with numbers 00:02:00 Add bullets 00:03:00 Outline creation 00:04:00 Section 29: Word 2021: Tables Creating a table 00:03:00 Adding rows and columns to a table 00:02:00 Formatting table data 00:02:00 Borders and shading 00:02:00 Sorting in a table 00:04:00 Draw a table 00:04:00 Convert text to table 00:03:00 Convert table to text 00:02:00 Insert a spreadsheet 00:02:00 Quick tables - readily available formats 00:02:00 Section 30: Word 2021: Styles Working with styles 00:02:00 Creating styles 00:02:00 Clear formatting 00:01:00 Section 31: Word 2021: Page Layout Margins 00:02:00 Orientation 00:01:00 Page size setting 00:01:00 Adding columns 00:03:00 Page break - section break 00:02:00 Adding watermark 00:03:00 Headers and footers 00:03:00 Section 32: Word 2021: Envelops and Lables Create envelops 00:02:00 Creating labels 00:02:00 Section 33: Word 2021: Mail Merges Creating a mail merge document 00:03:00 Section 34: Word 2021: Review and Printing Thesaurus and spell check 00:01:00 Word count 00:01:00 Speech - read aloud 00:01:00 Language - translate 00:01:00 Tracking 00:01:00
Gain essential healthcare skills with this CPD-accredited Care Certificate course. Master 15 key standards & boost your career in health & social care.
Master project leadership, risk management & strategy with this CPD-accredited Level 7 course. Gain globally recognised project management skills.
Gain life-saving skills with this CPD-accredited First Aid Course. Learn CPR, AED use, injury management, and emergency response for any situation.
Enhance your training & mentoring skills with this CPD-accredited, QLS-endorsed course. Gain expertise & career growth with flexible learning.
Boost your career with this CPD-accredited Microsoft Office course. Master Word, Excel, PowerPoint, and Access to enhance productivity and efficiency.