24708 Courses

The human resources management is the department assigned to ensure the welfare of employees including their wages, compensation, and benefits. It is best to implement an efficient payroll management to make sure employees could receive their salary on time. Developing payroll management skills is possible after taking this Level 3 Diploma in HR and Payroll Management. It is designed to help HR managers and staff to learn the different payroll systems and choose the best system perfect for the needs of the department. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion at an additional cost Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat Level 3 Diploma in HR and Payroll Management has been given CPD accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then Level 3 Diploma in HR and Payroll Management is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at any time. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £35,000. The sky really is the limit. Course Curriculum HR and Payroll Management - Updated Version Human Resource Management Introduction to Human Resources 00:16:00 Employee Recruitment and Selection Procedure 00:35:00 Employee Training and Development Process 00:19:00 Performance Appraisal Management 00:19:00 Employee Relations 00:15:00 Ensuring Health and Safety at the Workplace 00:16:00 Motivation and Counselling 00:19:00 Employee Termination 00:15:00 Employer Records and Statistics 00:11:00 Essential UK Employment Law 00:35:00 Payroll Management Module 1: Payroll Basics 00:10:00 Module 2: Company Settings 00:08:00 Module 3: Legislation Settings 00:07:00 Module 4: Pension Scheme Basics 00:06:00 Module 5: Pay Elements 00:14:00 Module 6: The Processing Date 00:07:00 Module 7: Adding Existing Employees 00:08:00 Module 8: Adding New Employees 00:12:00 Module 9: Payroll Processing Basics 00:11:00 Module 10: Entering Payments 00:12:00 Module 11: Pre-Update Reports 00:09:00 Module 12: Updating Records 00:09:00 Module 13: e-Submissions Basics 00:09:00 Module 14: Process Payroll (November) 00:11:00 Module 15: Employee Records and Reports 00:13:00 Module 16: Editing Employee Records 00:07:00 Module 17: Process Payroll (December) 00:12:00 Module 18: Resetting Payments 00:05:00 Module 19: Quick SSP 00:10:00 Module 20: An Employee Leaves 00:13:00 Module 21: Final Payroll Run 00:07:00 Module 22: Reports and Historical Data 00:08:00 Module 23: Year-End Procedures 00:09:00 HR and Payroll Management - Old Version HR & Leadership Leader and HR Management 00:30:00 Commitment and HR Management 01:00:00 Team Management 00:30:00 Build A Mastermind Group 02:00:00 People Recognition in HR Management 00:30:00 Performance, Goals and Management 00:30:00 Think Outside The Box 00:30:00 Be Passionate about Your Work 00:30:00 The Importance Of A Good Team Leader 00:30:00 Human Resource Management Module One - Getting Started 00:30:00 Module Two - Human Resources Today 01:00:00 Module Three - Recruiting and Interviewing 01:00:00 Module Four - Retention and Orientation 01:00:00 Module Five - Following Up With New Employees 01:00:00 Module Six - Workplace Health & Safety 01:00:00 Module Seven - Workplace Bullying, Harassment, and Violence 01:00:00 Module Eight - Workplace Wellness 01:00:00 Module Nine - Providing Feedback to Employees 01:00:00 Module Ten - Disciplining Employees 01:00:00 Module Eleven - Terminating Employees 01:00:00 Module Twelve - Wrapping Up 00:30:00 Managing Payroll What Is Payroll? 00:30:00 Principles Of Payroll Systems 01:00:00 Confidentiality And Security Of Information 00:30:00 Effective Payroll Processing 01:00:00 Increasing Payroll Efficiency 01:00:00 Risk Management in Payroll 00:30:00 Time Management 00:30:00 Personnel Filing 00:30:00 When Workers Leave Employment 01:00:00 Hiring Employees 00:30:00 Paye and Payroll for Employers 01:00:00 Tell HMRC about a New Employee 01:00:00 Net And Gross Pay 00:30:00 Statutory Sick Pay 00:30:00 Minimum Wage for Different types of Work 01:00:00 Mock Exam Mock Exam - Level 3 Diploma in HR and Payroll Management 00:30:00 Final Exam Final Exam - Level 3 Diploma in HR and Payroll Management 00:30:00

Our comprehensive program is meticulously crafted to equip you with the essential skills and knowledge required to thrive in your chosen field. Developed by seasoned professionals with years of industry experience, this course is ideal for those seeking to kickstart their careers or enhance their existing skill set. Featuring an engaging audio-visual presentation and easily digestible modules, our program facilitates a self-paced learning experience. Our dedicated online support team is available on weekdays to provide assistance throughout your journey. Key Learning Outcomes: Grasp the fundamentals and their practical applications. Cultivate the necessary skills for success in your field. Apply newfound knowledge to real-world scenarios. Develop effective solutions for relevant topics. Elevate your employability and career prospects.   Designed to give you a competitive edge in the job market, this course offers lifetime access to materials and the flexibility to learn at your own pace, from the comfort of your home. Why Choose Us? Learn at your own pace with 24/7 online access to course materials. Benefit from full tutor support available Monday through Friday. Acquire essential skills in the convenience of your home through informative video modules. Enjoy 24/7 assistance and advice via email and live chat. Study on your preferred device - computer, tablet, or mobile. Gain a thorough understanding of the course content. Improve professional skills and earning potential upon completion. Access lifetime course materials and expert guidance. Enjoy the convenience of online learning with flexible schedules. Why Enroll in This Course? Our program provides a comprehensive introduction to the subject matter, laying a solid foundation for further study. It empowers students to acquire knowledge and skills applicable to both their professional and personal lives. Assessment: The course incorporates quizzes to evaluate your understanding and retention of the material. These quizzes pinpoint areas for further practice, allowing you to review course materials as needed. Successfully passing the final quiz qualifies you for a certificate of achievement. Career Path: Our course is meticulously designed to equip you for success in your chosen field. Upon completion, you'll have the qualifications to pursue diverse career opportunities across various industries. Course Content Diploma of Paralegal (Legal Secretary)

Microsoft office is used for documentation, writing, and many other activities. It brings a new dimension to this technology-based competitive world. It has vivid functions and much more use. If you want to learn all its advanced functions, look at our Microsoft Office 2016 Advanced course. This course introduces to the function of ribbon that incorporates many tabs such as Insert, design, animation, slides, show, review, and home. It also guides you step by step how to insert a picture, change design lay order, add a hyperlink, watch video from youtube, create CV, cash memo, payment sleep, many more things. Overall the course teaches you all the efficient use of Microsoft Office to be expert in it. Who is this Course for? Microsoft Office 2016 Advanced is 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. 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Microsoft Word 2016 Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities - Microsoft Word 2016 Advanced 00:00:00 Microsoft Excel 2016 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Microsoft PowerPoint 2016 Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Microsoft Outlook 2016 Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Manage Advanced Calendar Options 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Configure E-mail Message Security Settings 00:30:00 Activities - Microsoft Outlook 2016 Advanced 00:00:00 Microsoft Access 2016 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Mock Exam Mock Exam - Microsoft Office 2016 Advanced 00:20:00 Final Exam Final Exam - Microsoft Office 2016 Advanced 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Learn essential vaccine principles, types, safety protocols, and communication strategies with our Vaccination Training course. Perfect for healthcare professionals and public health practitioners, this comprehensive course equips you to effectively manage vaccination tasks and address public health challenges, including pandemics.

Master English grammar with a focus on spelling and punctuation. This course helps you refine your writing skills, ensuring clear and error-free communication.

Ensure your classroom is a safe haven. Learn vital strategies in child safeguarding and protection, tailored specifically for teachers to protect every student.

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. 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 Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel 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 Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel 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 The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum 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:03: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:03: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.mp4 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 Little Slice of Pie Charts 00:05: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:06: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.mp4 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 Excels 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 The 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:13: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 Loop 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 00:00:00

Discover the holistic world of Bach Flower Remedies with our comprehensive course. Learn to prepare, preserve, and integrate these natural remedies for emotional balance and well-being across various age groups and emotional states.

PowerPoint for Business in 60 Minutes   Course Description   Copyright Ross Maynard 2021   Course Description Welcome to PowerPoint for Business in 60 Minutes.   Microsoft PowerPoint has been around for nearly 35 years, and I am sure you are familiar with it, and have experienced many PowerPoint presentations – some good; many extremely tedious! Creating a business presentation in PowerPoint presents a number of challenges and there is a danger of “death by PowerPoint”. I recently attended a meeting which was supposed to be a planning discussion but which the person leading the meeting insisted on introducing with a PowerPoint presentation of 60 slides – mostly bullet points! We were hardly in the mood for action planning after that assault on our senses.  PowerPoint is good for presenting business results or for a training course, but you need to plan your slideshow carefully to avoid bullet-point boredom and to keep your audience engaged and interested. And that is the purpose of this course – to teach you PowerPoint techniques which you may not be familiar with, and which will help you improve the impact of your business presentations.   Less is more in a slide show so it is important to use techniques and effects which will help engage your audience and draw their attention to the points that matter.  In “PowerPoint for Business in 60 Minutes”, I cover six key topics that will help you produce more impactful business presentations: The best slide transitions and animations for business presentations The morph transition to make the narration of an agenda, or similar list, or a team photograph extremely slick and professional The Zoom effect to create a summary slide with hyperlinks to zoom into the section that you or your audience choose How to animate charts to highlight the key points you want to bring out How to embed Excel tables with slicers into PowerPoint, and why PowerPoint is not developed enough to make this useful for a business presentation How to turn your PowerPoint presentation into a video. This is the technique I am most often asked how to do.   This is not a full “PowerPoint from scratch” course: it assumes familiarity of Microsoft’s ubiquitous programme. Instead, the course takes only 1 hour of your time to focus on key techniques that can help you improve the impact of the presentations you create.   I hope you enjoy the course.     Key Learning Points  On completion of the course, delegates will be able to: Identify the most useful slide transitions and animations for business presentations Use the morph transition to draw the audience’s attention Create a “zoom” summary slide to jump to user-selected sections of slides Animate charts to highlight key points Embed a Microsoft Excel table in a PowerPoint slide Create a video with commentary of their PowerPoint presentation     Curriculum Lesson 1: Transitions and Animations Lesson 2: The Morph Transition Lesson 3: Zoom Lesson 4: Animating Charts Lesson 5: Excel Tables and Slicers in PowerPoint (or Not!) Lesson 6: Making a PowerPoint Video     Pre-Course Requirements There are no pre-course requirements     Additional Resources None     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What slide effect allows you to give the illusion of moving around a larger “page”? The Wipe transition. The Dissolve transition. The Push transition. The Fly-In animation   What does “Zoom” in PowerPoint allow you to do? Zoom creates the illusion of “zooming in” on a particular part of a slide Zoom creates a summary slide with hyperlinks to the individual slides or sections contained in the summary Zoom creates a smooth object animation from one slide to another to animate, for example, an agenda or timeline Zoom is used to highlight areas of a chart or graphic to draw the audience’s attention   What is the main problem with embedding a Microsoft Excel table with slicers into PowerPoint? The slicers do not work, and the table cannot be manipulated, in presentation mode in PowerPoint The table cannot be opened or manipulated in PowerPoint slide view Microsoft Excel and PowerPoint are incompatible with each other The file size created is too large for most business PCs to handle   When seeking to create an MP4 video file from a PowerPoint presentation, why is it advisable to record the commentary separately? PowerPoint’s built-in recording facility is unreliable and frequently crashes It’s much quicker to record the audio separately and then insert it into PowerPoint and save as a video file Separate video editing software needs to be used to improve the video’s look and sound where the audio is recorded directly in PowerPoint It removes the stress of commentating “live” on the presentation while recording it, and allows any mistakes and errors to be cut out  

Advance your food safety skills with our Food Hygiene and Safety Level 3 course. Learn to manage food safety systems, control contamination, and comply with regulations. Ideal for catering managers, supervisors, and food safety professionals.