7371 Courses delivered Online

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want Excel is an essential tool for data management and analysis and in this course, you will master everything from the fundamentals to advanced functionalities. You will learn to navigate the interface, create and format spreadsheets and perform calculations with ease and you will unlock the true potential of Excel for business and personal use. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand the basics of Excel Know how to use Excel at an intermediate level Be aware of sum and numerical functions Understand how to manipulate text Know about logical functions Create effective spreadsheets Be confident with lookup functionality and date and time functions Easily use financial functions and sort and filter Progress to using Microsoft Excel at an advanced level Know how to create accurate and clear visual presentations Consolidate and validate data Use pivot table and what-if analysis Understand automation and macros Why Microsoft Excel Training Course right for you? Develop advanced skills in Microsoft Excel training course basic to advanced course, with this course. Learn from scratch or build on prior knowledge, to gain a good understanding of Excel functions. You will learn to accelerate your tasks efficiently using Excel techniques and formulae. The course covers how to create professional reports in no time, with Excel tools for data analysis and creating charts. This course will demystify the functions and tools in easy steps. It will teach you to work smart and save time. It is an excellent addition to your CV and is a valued skill in all businesses. Microsoft Excel Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the Interface 0102 Enter Data & Saving Workbook 0103 Applying Formulas 0104 Changing a Worksheet's Structure 0105 Find, Replace & Spell Check 0106 Applying Fonts, Background Colors, and Borders 0107 Formatting Numbers and Dates 0108 Making the Fieces fit 0109 Inserting Headers & Footers and Repeating Rows 0110 Managing Large Workbooks Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) Ex 0201 Formula Writing (Don't Miss this) Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs Ex 0301 SumIf & SumIfs 0302 Count Functions Ex 0302 Count Functions 0303 AverageIf & AverageIfs Ex 0303 AverageIf & AverageIfs Text Functions - Manipulating Text 0401 Change Case (Upper, Lower,Proper) Ex 0401 Change Case (Upper, Lower, Proper) 0402 Separating Text on Symmetrical Data Ex 0402 Separating Text on Symmetrical Data 0403 Separating Text on Non-Symmetrical Data Ex 0403 Separating Text on Non-Symmetrical Data Logical Functions - Working With Conditions 0501 If Functionality Ex 0501 IF Functionality 0502 If with AND Ex 0502 If with AND 0503 If with OR Ex 0503 If with OR 0504 If with 'AND' & 'OR' / IF with Countif Ex 0504 If with 'AND' & 'OR' / IF with Countif 0505 Nested IF (A Genie with 3 wishes) Ex 0505 Nested IF (A Genie with 3 wishes) Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 Ex 0601 Vlookup (Exact Match) # 1 0602 Type of References (Use of $ sign) 0603 Vlookup (Exact Match) # 2 Ex 0603 Vlookup (Exact Match) # 2 0604 Double Vlookup Ex 0604 Double Vlookup 0605 Vlookup on Duplicate Values Ex 0605 Vlookup on Duplicate Values 0606 Vlookup (Approximate Match) Ex 0606 Vlookup (Approximate Match) 0607 Vlookup with If (Conditional Vlookup) Ex 0607 Vlookup with If (Conditional Vlookup) 0608 Hlookup (Exact Match) Ex 0608 Hlookup (Exact Match) 0609 Hlookup (Approximate Match) Ex 0609 Hlookup (Approximate Match) 0610 Lookup (Don't use this !) Ex 0610 Lookup (Don't use this !) 0611 Vlookup with Match (Create Magical Vlookup) Ex 0611 Vlookup with Match (Create Magical Vlookup) 0612 Match (Gives us Column/Row Index #) Ex 0612 Match (Gives us Column/Row Index #) 0613 Index & Match (Made for Each Other) Ex 0613 (1) Index & Match (Made for Each Other) Ex 0613 (2) Index & Match (Made for Each Other) Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 0702 Now, Today & Autofill 0703 DateValue & TimeValue 0704 Calculate WorkingDays 0705 DatedIf Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 0802 Creating a Loan Table Ex 0802 Creating a Loan Table 0803 Calculate Depriciation Ex 0803 Calculate Depriciation Sort & Filter 0901 Basic Sorting & Shortcut keys Ex 0901 Basic Sorting & Shortcut keys 0902 Sorting Using Custom List Ex 0902 Sorting Using Custom List 0903 Horizontal Sorting Ex 0903 Horizontal Sorting 0904 Basic Filter & Shortcut Keys Ex 0904 Basic Filter & Shortcut Keys 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 0906 Filter Problem # 2 (Pasting Values on Filtered Data) Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 0908 Advanced Filter (Applying Complex Criteria's) Ex 0908 Advanced Filter (Applying Complex Criteria's) Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 1002 Format Axis 1003 Plot Values on Secondary Axis 1004 Life of Pie (Charts) 1005 How to Show Axis Title 1006 How to Show Data Label 1007 Show data with chart in Data Table 1008 Column Chart 1009 Bar Chart 1010 Line Chart 1 1011 Line Chart 2 1012 Area Chart 1013 Pie Chart 1014 Pie of Pie or Bar of Pie 1015 Line Chart with Log Scale 1016 Bubble Chart 1017 Selecting Chart Elements 1018 Use of Format Dialog box 1019 Modifying Chart & Plot Area 1020 Modifying Data Series 1021 How to handle Missing Data 1022 Modifying 3-D Charts 1023 Creating Combination of upto 5 Different Charts 1025 Creating Picture Charts Data Consolidation - Multiple WorkBooks WorkSheets Consolidate Data using Excel Inbuilt Function Ex Consolidate Data using Excel Inbuilt Function Data Validation 1201 Applying Data Validation Ex 1201 Applying Data Validation 1202 Dependent Dropdown List Ex1202 Dependent Dropdown List Using Data Validation with Vlookup & Match Other Data Validation Examples Protection of Worksheet Workbook 1301 Worksheet Level Protection Ex 1301 Worksheet Level Protection 1302 Cell Level Protection Ex 1302 Cell Level Protection 1303 Hiding Formulas from Formula Bar Ex 1303 Hiding Formulas from Formula Bar 1304 Protecting Workbook Structure Ex 1304 Protecting Workbook Structure 1305 Workbook Level Protection Ex 1305 Workbook Level Protection Pivot Table & Techniques 1401 Understanding pivot Table 1402 Using Pivot Table in Real Scenario Ex 1402 Using Pivot Table in Real Scenario 1403 Grouping in Pivot Table Ex 1403 Grouping in Pivot Table 1404 Using Slicers (A Visually attractive Filter) Ex 1404 Using Slicers (A Visually attractive Filter) What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) Ex 1501 Goal Seek (A Reverse Approach) 1502 One Way Data Table 1503 Two Way Data Table 1504 Scenario Manager 1505 Solver Add-In Automation in Excel - Macros 1601 Record your first Macro 1602 Record Another Macro 1603 Assigning macro to a Shape, Button, Picture etc 1604 Editing or Deleting a Macro 1605 Security Settings of a Macro Who should take this course? Absolute beginners to Microsoft Excel People who wish to use Microsoft Excel more confidently People who wish to refresh their existing skills in Microsoft Excel Entry Requirements There are no academic entry requirements for this Microsoft Excel training course basic to advanced course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Microsoft Excel training course basic to advanced course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Sage 50 Computerised Accounting / Bookkeeping Training - Fast Track Overview: If you're looking to gain competency in the world's most popular bookkeeping software, the Sage 50 Computerised Accounting course will teach everything you need to know, while helping you gain a recognised qualification. This course is designed to provide individuals from beginner to advanced knowledge of bookkeeping and Sage 50 accounts. It is intended for individuals who aim to improve career prospects and to be able to better financial management and control of the business. This course covers Level 1-3 of Sage 50 Bookkeeping/Accounting Training. Every business, no matter how large or small, is required by law to 'keep books'. Therefore, Bookkeepers play a vital role within organisations; ensuring records of individual financial transactions are accurate, orderly, up to date and comprehensive. If you are organised and methodical, like working through documents and enjoy seeing a set of figures add up properly, then bookkeeping is the career for you. You will receive a CPD Completion certificate from Osborne Training once you finish the course. Then, you have an option to attain a Certificate from SAGE(UK) subject to passing the exams. Level 1 Working with Sage 50 Accounts Program Basics. Creating Account names, Numbers & Bank Payments Financials Bank Reconciliations Generating Customers Invoices Monitoring Customer Activity Generating Product Invoices & Credit Notes Compiling & Sending Customer Statements Creating Customer Receipts & Purchase Invoices Supplier Payments Managing Recurring Entries Generating Reports & Information The Active Set-Up Wizard VAT Changes. Level 2 An overview of the Sage program Entering opening balances, preparing and printing a trial balance Creating customer records Creating supplier records Setting up opening assets, liabilities and capital balances, Producing routine reports Checking data, Entering supplier invoices Posting error corrections, amending records Invoicing, generating customer letters, entering new products, checking communication history Banking and payments, producing statements, petty cash Audit trails, correcting basic entry errors, reconciling debtors and creditors Creating sales credit notes, Processing purchase credit notes Preparing journals Verifying Audit Trail Purchase orders, processing sales orders Processing Trial Balance Creating Backups Restoring data Writing-off bad debts Level 3 Creating a Chart of Accounts to Suit Company Requirements Sole Trader Accounts preparation The Trial Balance preparation Errors in the Trial Balance Disputed Items Use of the Journal Prepare and Process Month End Routine Contra Entries The Government Gateway and VAT Returns Bad Debts and Provision for Doubtful Debts Prepare and Produce Final Accounts Management Information Reports Making Decisions with Reports Using Sage The Fixed Asset Register and Depreciation Accruals and Prepayments Cash Flow and Forecast Reports Advanced Credit Control

The course 'Microsoft Excel' covers the latest features of Microsoft Excel 2019, introducing learners to CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN, Map Chart, Funnel Chart, and other enhancements. It also covers fundamental Excel skills, data analysis, visualization, pivot tables, workbook management, and automation using VBA. Learning Outcomes: Familiarize with the new features in Microsoft Excel 2019, including CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and more. Gain proficiency in basic Excel tasks like navigating the user interface, entering data, and using Excel commands. Perform calculations, create formulas, and use functions to analyze and manipulate data effectively. Format worksheets, apply conditional formatting, and utilize templates to present data professionally. Understand data visualization using charts, sparklines, and mapping techniques in Excel. Work with PivotTables and PivotCharts for in-depth data analysis and presentation. Learn advanced Excel features such as data validation, scenarios, and Goal Seek. Automate workbook functionality using macros and Visual Basic for Applications (VBA). Collaborate on workbooks, protect data, and apply security measures in Excel. Create and work with Excel templates to streamline repetitive tasks and optimize workflow. Why buy this Microsoft Excel? Unlimited access to the course for forever PDF 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 Microsoft Excel you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Microsoft Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Microsoft Excel 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Excel is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Excel Templates Excel Templates 00:00:00 Mock Exam Mock Exam - Microsoft Excel 00:20:00 Final Exam Final Exam - Microsoft Excel 00:20:00

Overview of Virtual Interviewing for HR Join our Virtual Interviewing for HR 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 Virtual Interviewing for HR course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Virtual Interviewing for HR 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! This Virtual Interviewing for HR Course will help you to learn: 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 Virtual Interviewing for HR. 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 Certificate of Completion – Digital / PDF Certificate After completing the Virtual Interviewing for HR course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Virtual Interviewing for HR 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 You don’t need any educational qualification or experience to enrol in the Virtual Interviewing for HR 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 Virtual Interviewing for HR 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 Module 01: Introduction Jenn Flaa Bio 00:01:00 Welcome Seeker 00:01:00 Before We Begin 00:01:00 Bad RECRUITER Example Before for Recruiter 00:02:00 Module 02: Behave Professionally on Video Your Own Goal Seeker 00:01:00 Where Do I Look 00:02:00 How to Convey Confidence 00:02:00 How to Convey Power 00:02:00 First Impression Recruiter 00:01:00 What to Wear - Ladies 00:02:00 What to Wear - Men 00:01:00 Should I Wear Makeup? 00:02:00 Do Men Wear Makeup? 00:02:00 Your Hair on Video 00:01:00 What's Behind You 00:01:00 Good Background 00:01:00 How to Sit Confidently on Video 00:02:00 What To Do With Hands 00:01:00 Glare in Your Glasses 00:01:00 Practice Tips Recruiter 00:02:00 Before Interview Recruiter Explained 00:01:00 Lab 2 Recruiter 00:01:00 Module 03: During the Interview Why Video Interviews Are Popular 00:01:00 When to Schedule the Interview 00:01:00 What to Expect 00:02:00 Distractions 00:02:00 Pulling Focus Away from You 00:01:00 How in Person & Video Interviews Differ 00:03:00 How to Start & End Your Video Interview 00:01:00 Ending the Interview 00:01:00 Managing Time 00:01:00 #1 Pitfall 00:03:00 Module 04: Handling Video Fear and Nerves Fear of Being Seen & Revealing Yourself 00:01:00 Un-Nerving Yourself 00:02:00 Grounding Meditation 00:09:00 Module 05: Things of Recruiter #1 Things You Must Do 00:03:00 How to Critique A Candidate on Video 00:05:00 Visual Bias 00:04:00 How to Deal With Bad Video and Distraction 00:03:00 Manipulating with Video 00:01:00 Lab 5 Visual Bias 00:03:00 Module 06: Your Setup and Equipment Do I Need to Buy Equipment for This Interview? 00:01:00 Equipment Experiment - Easy, Affordable Setup 00:06:00 Upgraded Camera & Mic 00:04:00 What's On My Desk During Video Interviews? 00:01:00 Jenn's Office Setup with Ambient Light for Video Interviews 00:01:00 Jenn's Office Setup with Full Lighting and White Backdrop 00:01:00 Module 07: Your Introduction Video Should I Use a Script? 00:02:00 #1 Way to Bore Your Viewer 00:01:00 Video Check List Animated 00:01:00 Module 08: Bonus Tips Before The Video Interview 00:01:00 What If You Have an Accent? 00:01:00 What What Recruiter 00:01:00 4 Tips 00:02:00 4 Things to Avoid 00:01:00 Preparing for Your Video Interview 00:01:00 Your Eyes Communicate Too 00:04:00 Water 00:01:00 What if I Have a BAD Interviewer? 00:01:00 Video Foul 00:02:00 After' Example 00:02:00 Module 09: Wrap Up Jenn's Last Thoughts 00:01:00 Last Labs 00:03:00 The 10% To Remember 00:01:00

Health and Safety: Health and Safety at Work Online Unlock the Power of Health and Safety: Health and Safety at Work Course: Enrol Now! Every year, workplace accidents and injuries cost businesses millions of dollars and thousands of hours. They also have a significant and often lifelong impact on workers. Introducing a safety culture into your organisation, where safety is valued as an integral part of business operations, saves time and money and builds a committed, loyal, and healthy workforce. Our Health and Safety at Work: Health and Safety at Work course will lay the foundation for you to start building a safety culture. The Health and Safety at Work: Health and Safety at Work course covers a broad introduction to workplace health and safety, along with the value of establishing a safe working culture. Students will also learn to ensure their respective businesses and workplaces comply with all relevant laws and legislation. The Health and Safety: Health and Safety at Work provides lessons, modules, and quizzes to gain knowledge, and at the end, a Professional Certificate that assists in career development in professional life. Main Course: Level 5 Health and Safety at Work Courses are included with the Health and Safety at Work: Health and Safety at Work Course Course 01: Workplace First Aid Training Course 02: Working at Height Training Course Course 03: Level 2 Health and Safety in the Workplace Training [Note: Free PDF certificate as soon as completing the Health and Safety at Work: Health and Safety at Work course] Health and Safety: Health and Safety at Work Online This Level 5 Health and Safety at Work course consists of 12 modules. Course Curriculum of Level 5 Health and Safety at Work course Module 01: Foundations of Health and Safety at Work Module 02: Managing Health and Safety Module 03: Organising for Health and Safety Module 04: Health and Safety Culture Module 05: Health and Safety Policy Module 06: Risk Assessment Module 07: Workplace Hazards and Risk Control Module 08: Accidents and Emergencies Module 09: Vehicle Hazards and Risk Control Module 10: Fire Prevention and Protection Module 11: Electrical Safety Module 12: Managing the Safety Function Assessment Method of Health and Safety: Health and Safety at Work After completing Health and Safety: Health and Safety at Work Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Health and Safety: Health and Safety at Work After completing the Health and Safety: Health and Safety at Work course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Health and Safety: Health and Safety at Work Online This Health and Safety: Health and Safety at Work could be extremely beneficial to employees at all levels. From entry-level recruits to supervisors, managers, and business owners. Requirements Health and Safety: Health and Safety at Work Online To enroll in this Health and Safety: Health and Safety at Work Course, students must fulfill the following requirements: Good Command over English language is mandatory to enrol in our Health and Safety: Health and Safety at Work Course. Be energetic and self-motivated to complete our Health and Safety: Health and Safety at Work Course. Basic computer Skill is required to complete our Health and Safety: Health and Safety at Work Course. If you want to enrol in our Health and Safety: Health and Safety at Work Course, you must be at least 15 years old.

Recruitment: Recruitment Course Online Do you want to start a career in recruitment or enhance your recruitment skills? Then this Recruitment: Recruitment Course will assist you in moving one step closer to your professional goals by developing your recruitment: recruitment skills and knowledge for a rewarding career. Learn the skills you'll need to advance your recruitment: recruitment career. Equip yourself with the necessary knowledge and skills to become a confident recruitment: recruitment consultant and advance your career. This Recruitment: Recruitment Course is designed to assist you in achieving your career goals. This Recruitment: Recruitment Course will teach you the theory of effective recruitment: recruitment practice and will provide you with the necessary skills, confidence, and competence to help you succeed in the recruitment: recruitment industry. You'll gain a solid understanding of the core competencies needed to propel a successful recruitment: recruitment career. Why choose this Recruitment: Recruitment Course from the School of Health Care? Self-paced Recruitment: Recruitment Course, access available from anywhere in the world. High-quality study materials that are easy to understand. Recruitment: Recruitment Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Recruitment: Recruitment Course Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Recruitment: Recruitment Course. Main Course: Recruitment Consultant Diploma Free Courses included with Recruitment: Recruitment Course Course 01: HR Management Course Course 02: Workplace First Aid Training Course 03: HR and Payroll Management Course Special Offers of this Recruitment: Recruitment Course: This Recruitment: Recruitment Course includes a FREE PDF Certificate. Lifetime access to this Recruitment: Recruitment Course Instant access to this Recruitment: Recruitment Course 24/7 Support Available to this Recruitment: Recruitment Course [ Note: Free PDF certificate as soon as completing Recruitment: Recruitment Course] Recruitment: Recruitment Course Online This Recruitment: Recruitment Course consists of 13 modules. Course Curriculum of Recruitment: Recruitment Course Module 01: Introduction to Recruitment Module 02: Recruitment Industry: At a Glance Module 03: Recruitment: Legal Procedures in The UK Module 04: Sales & Marketing Strategies for Recruiters Module 05: Recruitment and Selection Module 06: Relevant Key Performance Indicators Module 07: Attracting Candidates for Recruitment Module 08: Managing Candidates Module 09: Interview Processes for the Candidate Module 10: Obtaining Client Module 11: Client Strategy Module 12: Managing Clients Module 13: How to Start and Run a Recruiting Service Effectively Assessment Method of Recruitment: Recruitment Course After completing Recruitment: Recruitment Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Recruitment: Recruitment Course After completing the Recruitment: Recruitment Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Recruitment: Recruitment Course Online This Recruitment: Recruitment Course is ideal for people who want to start a new career in human resources or recruitment: recruitment, as well as those who want to improve their skills and advance their career in HR management. Requirements Recruitment: Recruitment Course Online To enrol in this Recruitment: Recruitment Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Recruitment: Recruitment Course. Be energetic and self-motivated to complete our Recruitment: Recruitment Course. Basic computer Skill is required to complete our Recruitment: Recruitment Course. If you want to enrol in our Recruitment: Recruitment Course, you must be at least 15 years old. Career path Recruitment: Recruitment Course Online This Recruitment: Recruitment Course is a valuable qualification to have and would be useful for any profession or career in any industry, such as: HR Manager, Recruitment Consultant, HR Administrator, HR Assistant.

Masterclasses? Refreshers? Introductions? It depends what you're looking for and where you want to pitch them, but here are six tried-and-tested highly focused sessions that organisations can take individually or as a series, to help develop their teams' project management capabilities one topic at a time. Objectives for each individual session are set out below, as part of the session outlines. Taken together, as a series, however, these modules are an ideal opportunity to develop your team's levels of project management capability maturity, whether that's by introducing them to the basic principles, refreshing them on best practice, or giving them the opportunity to really drill down into a specific area of challenge in your particular operating environment. Session outlines 1 Stakeholder management Session objectives This session will help participants: Understand why stakeholders matter to projects Be able to identify and engage stakeholders Be able to categorise stakeholders by their significance 1 Key principles What does 'stakeholder' mean - in theory? What does this mean in practice? Why stakeholders matter Consequences of missing stakeholders The stakeholder management process:IdentifyAssessPlanEngage 2 Identifying stakeholders Rapid listing CPIG analysis PESTLE analysis Drawing on the knowledge and experience of others Other ways to identify stakeholders 3 Assessing stakeholders Which stakeholders are significant? Stakeholder radar Power-interest maps Power-attitude maps 4 Planning The adoption curve Dealing with obstacles Who should engage which stakeholder? How should the project's organisation be structured? How will communication happen? 5 Engaging Seven principles of stakeholder engagement 2 Requirements and prioritisation Session objectives This session will help participants: Understand how clarity of requirements contributes to project success Use different techniques for prioritising requirements Agree requirements with stakeholders Manage changes to requirements 1 Understanding and managing stakeholder needs and expectations What are 'requirements'? What is 'requirements management'? Sources of requirements - and the role of stakeholders Are stakeholders sufficiently expert to specify their needs? Do they understand the detail of what they want, or do they need help to tease that out? What do stakeholders want to achieve? Working within constraints Prioritising requirements - three techniques 2 MoSCoW prioritisation 'Must have', should have', 'could have, 'won't have this time' When to use MoSCoW 3 The Kano Model Customer satisfaction - 'attractive' and 'must-be' qualities When to use Kano 4 Value-based prioritisation Understanding risk v value Using risk v value to prioritise features and schedules 5 Agreeing requirements Perfect v 'good enough' Establishing acceptance criteria Requirements traceability Agreeing project scope 6 Changing requirements Why requirements change Why change control matters Impact on projects A formal change control process Paying for change - managing change for different types of project 3 Estimating Session objectives This session will help participants: Understand the different purposes estimates satisfy Be able to use different estimating techniques Understand how to achieve different levels of accuracy 1 Key principles What's an estimate? Informed guesswork What needs to be estimated? Costs, resources, effort, duration Tolerances Precision v accuracy 2 Estimating through the lifecycle Start Plan Do 3 Early estimates Comparative ('analogous') estimating Parametric estimating Using multiple estimating techniques 4 Bottom-up estimating Bottom-up ('analytical') estimating Pros Cons 5 Three-point estimating Three-point ('PERT': Programme Evaluation and Review Technique) estimating Uncertainty and the range of estimates Calculating a weighted average Three-point with bottom-up 4 Scheduling Session objectives This session will help participants: Understand how to create a viable schedule Be able to use different forms of schedule Understand the concept of the critical path 1 Key principles The planning horizon Rolling wave planning Release planning 2 Viable scheduling Creating a viable schedule Define the scope Sequence the work Identify the risks and build in mitigations Identify the resources Estimate the effort and durations Check resource availability Refine until a workable schedule is produced 3 Critical path analysis The critical path Network diagrams Sequence logic Practical application:Network diagram with estimated durationsThe 'forward pass'The 'backward pass'Calculating total floatIdentifying the critical pathCalculating free float Gantt charts 5 Risk and issue management Session objectives This session will help participants: Understand the difference between risks and issues Be able to identify and assess risks Understand ways of mitigating risks Manage issues 1 Key principles Understanding risk Threats and opportunities The risk management processPreparation - proactive risk managementThe process - identify, assess, plan, implementStakeholder communication Roles and responsibilities Risk management strategy The risk register Risk appetite 2 Risk identification Brainstorming Interviews Assumption analysis Checklists 3 Risk assessment and prioritisation Probability, impact and proximity Triggers Qualitative risk assessment Qualitative impact assessment Qualitative probability assessment Probability / impact grid Bubble charts Risk tolerance 4 Planning countermeasures To mitigate or not to mitigate? Categories of risk response Avoid and exploit Reduce and enhance Transfer Share Accept Contingency Secondary risks 5 Issue management What is an issue? Tolerances Issues and tolerances The PRINCE2 view of issues Ownership of issues An issue management process Issue register 6 Budgeting and cost control Session objectives This session will help participants: Understand what to include in a budget - and why Choose - and use - the appropriate estimating technique Align the budget with the schedule Understand how to monitor spend and control costs Trouble-shoot effectively to get projects back within budget Session format Flexible. The session can be tailored to the participants' average level of project management maturity - a 60-minute session (delivered virtually) is an effective introduction. A 90-minute session allows for more in-depth treatment. A half-day session (face-to-face or virtual) gives time for a more challenging workshop, particularly to discuss specific cost control issues with any of the participants' current projects. 1 Where is the money coming from? Can we pay from revenue? Do we need to borrow? How long will the project take to pay back? The lifecycle of the budget Through-life costs Stakeholder involvement 2 Estimating costs Reminder: the relationship between estimates Reminder: possible estimating techniques What do we need to estimate?PeopleEquipmentMaterialsFacilities and operating costsWork package estimateEstimated project costs Estimating agile projects 3 Aligning budget and schedule Scheduling and financial periods Spreading the budget 4 Reserves and agreeing the budget Contingency reserve Management reserve Agreeing the budget 5 Cost control Planned spend over time Actual spend over time Work completed over time Evaluating different scenarios: delivery v spend 6 Trouble-shooting Why are we where we are? What has caused the project to spend at the rate it is? Why is it delivering at the rate it is? What are the root causes? What can we do about it?

Duration 5 Days 30 CPD hours This course is intended for This class is designed for persons who are new to the z/OS platforms but have a technical background in information technology. It is intended for those who require an in-depth understanding of z/OS. Overview Describe the system initialization process of the z/OS operating systemsState the differences between an address space, data space, and hyperspaceDescribe the process of translating a virtual address to a real addressExplain the difference between paging and swappingDefine a z/OS taskDescribe dispatching, interrupt processing, supervisor calls, cross memory services, and serializationDescribe the purpose of the Job Entry Subsystem (JES)Illustrate the flow of a job through the z/OS environmentDescribe the allocation process for data sets in the z/OS environmentsIllustrate how an I/O request is processed in a z/OS environmentDescribe how workload management is accomplished in a z/OS environmentExplain the z/OS recovery processes and list available Problem Determination ToolsDescribe z/OS storage management conceptsDescribe the UNIX System Services functions provided in the z/OS environmentsExplain the network topologies and protocol support provided in z/OSDescribe system security and network security for a z/OS environmentCreate a high-level plan for the installation and configuration of a z/OS environment This classroom course introduces the base elements, optional features, and servers that are provided in z/OS. It focuses on the system service facilities that are provided by the z/OS Base Control Program (BCP). Day 1 Unit 1: z/OS overview Including welcome and course overview Unit 2: Storage management Day 2 Unit 3: Managing work Unit 4: Input/output processing Day 3 Unit 4: Input/output processing (continued) Unit 5: Data management Unit 6: Job management Day 4 Unit 7: IPL and system initialization Unit 8: Termination and recovery analysis Unit 9: Installing and configuring Day 5 Unit 10: Communicating Unit 11: Security in z/OS Including end-of-course summary Additional course details: Nexus Humans ES15 IBM z/OS Facilities training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the ES15 IBM z/OS Facilities course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Microsoft 365. Overview In this course, you will optimize an Access database. You will: Provide input validation features to promote the entry of quality data into a database. Organize a database for efficiency and performance, and to maintain data integrity. Improve the usability of Access tables. Create advanced queries to join and summarize data. Use advanced formatting and controls to improve form presentation. Use advanced formatting and calculated fields to improve reports. Your training and experience using Microsoft© Access© has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access.Microsoft© Access© for Office 365?: Part 1 : Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.Microsoft© Access© for Office 365?: Part 2 (this course): Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.Microsoft© Access© for Office 365?: Part 3 : Focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. Lesson 1: Promoting Quality Data Input Topic A: Restrict Data Input Through Field Validation Topic B: Restrict Data Input Through Forms and Record Validation Lesson 2: Improving Efficiency and Data Integrity Topic A: Data Normalization Topic B: Associate Unrelated Tables Topic C: Enforce Referential Integrity Lesson 3: Improving Table Usability Topic A: Create Lookups Within a Table Topic B: Work with Subdatasheets Lesson 4: Creating Advanced Queries Topic A: Create Query Joins Topic B: Create Subqueries Topic C: Summarize Data Lesson 5: Improving Form Presentation Topic A: Apply Conditional Formatting Topic B: Create Tab Pages with Subforms and Other Controls Lesson 6: Creating Advanced Reports Topic A: Apply Advanced Formatting to a Report Topic B: Add a Calculated Field to a Report Topic C: Control Pagination and Print Quality Topic D: Add a Chart to a Report

Duration 5 Days 30 CPD hours This course is intended for This course is geared toward Windows system administrators, network administrators, and other system administrators who are interested in supplementing current skills or backstopping other team members, in addition to Linux system administrators who are responsible for these tasks: Configuring, installing, upgrading, and maintaining Linux systems using established standards and procedures Providing operational support Managing systems for monitoring system performance and availability Writing and deploying scripts for task automation and system administration Successful completion of Red Hat System Administration I (RH124) is recommended. Experienced Linux administrators seeking to accelerate their path toward becoming a Red Hat Certified System Administrator should start with the RHCSA Rapid Track course (RH199). Overview You should be able to demonstrate these skills: - Install Red Hat Enterprise Linux using Kickstart - Manage file systems and logical volumes - Manage scheduled jobs - Access network file systems - Manage SELinux - Control firewalls - Perform troubleshooting tasks Red Hat System Administration II (RH134) is designed as the second part of the Red Hat© Certified System Administrator (RHCSA©) training track for IT professionals who have taken Red Hat System Administration I (RH124). The course goes deeper into core Linux© system administration skills, including storage configuration, security feature management, task control, and installation and deployment of Red Hat© Enterprise Linux. Prerequisites Successful completion of Red Hat System Administration I (RH124) is recommended. 1 - Automate installation with Kickstart Automate the installation of Red Hat Enterprise Linux systems with Kickstart. 2 - Use regular expressions with grep Write regular expressions that, when partnered with grep, will allow you to quickly isolate or locate content within text files. 3 - Create and Edit text files with vim Introduce the vim text editor, with which you can open, edit, and save text files. 4 - Schedule future Linux tasks Schedule tasks to automatically execute in the future. 5 - Manage priority of Linux processes Influence the relative priorities at which Linux processes run. 6 - Control access to files with access control lists (ACL) Manage file security using POSIX access control lists. 7 - Manage SELinux security Manage the Security Enhanced Linux (SELinux) behavior of a system to keep it secure in case of a network service compromise. 8 - Connect to network-defined users and groups Configure systems to use central identity management services. 9 - Add disks, partitions, and file systems to a Linux system Manage simple partitions and file systems. 10 - Manage logical volume management (LVM) storage Manage logical volumes from the command line. 11 - Access networked attached storage with network file system (NFS) Access (secure) NFS shares. 12 - Access networked storage with SMB Use autofs and the command line to mount and unmount SMB file systems. 13 - Control and troubleshoot the Red Hat Enterprise Linux boot process 14 - Limit network communication with firewall Configure a basic firewall. 15 - Comprehensive review Practice and demonstrate knowledge and skills learned in this course.