- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
Cost reduction (In-House)
By The In House Training Company
Businesses that don't control their costs don't stay in business. How well are you doing? Is everyone in your organisation sufficiently aware of costs, managing them effectively and maximising opportunities to reduce them? If there is scope for improvement, this course will help get you back on track. It will demonstrate that cost reduction is so much more than cost control and cost cutting. True cost management is about being aware of costs, seeking to reduce them through good design and efficient operating practices whilst taking continuing action on overspending. This course will develop the participants' skills in: Being aware of costs at all times Seeking cost reduction from the start (including life-cycle costing) Appraising projects / production to identify and take out risk Understanding real budgeting Using techniques such as ZBB and ABC where appropriate Ensuring cost reports lead to action Managing a cost reduction process that delivers Benefits to the organisation will include: Identification of cost reduction and business improvement opportunities Better reporting and ownership of costs Greater awareness and control of everyday costs 1 Introduction - the cost management process The risks of poor cost control Capital and revenue costs The importance of cost awareness The importance of cost reduction Cost management - the key aspects How to build a cost management and control process checklist for your areas of responsibility 2 Cost removal - taking out costs Cost awareness Costs of poor design / poor processes Value engineering Removing redundant costs 3 The need for commercial, technical and financial appraisals Understand the problems before cash is committed and costs incurred Making the effort to identify commercial and technical risk The time value of money - DCF techniques for long term projects Cost models for production processes and projects Costing models - project appraisals The use of spreadsheets to identify sensitivity and risk How to focus on risk management 4 Budgeting - proper budgeting challenges costs The philosophy of the business - are costs an issue? The importance of having the right culture The need for detailed business objectives Budgetary control measures Designing budget reports - for action 5 Zero-based budgeting (ZBB) - the principles Much more than starting with a clean sheet of paper What ZBB can achieve The concept of decision packages - to challenge business methods and costs Only necessary costs should be incurred A review of an operating budget - demonstrating what ZBB challenges and the costs it may lead to being taken out 6 Awareness of overheads and other costs Definitions of cost - direct and indirect Dealing with overheads - what is meant by allocation, absorption or apportionment? The apparent and real problems with overheads Different ways of dealing with overheads Review of overhead allocation methods and accounting and reporting issues 7 Overheads and product costing Activity-based costing (ABC) - the principles Where and how the ABC approach may be helpful Know the 'true' cost of a product or a project Should you be in business? Will you stay in business? Identifying weaknesses in a traditional overhead allocation How ABC will help improve product or service costing Identifying which products and activities should be developed and which abandoned 8 Cost reduction culture The need for cost reports What measures can be used to identify over-spends as early as possible Cost control performance measures and ratios 9 Design of cost control reports Reports should lead to action and deliver Selecting cost control measures which can be acted upon Practice in designing action reports 10 Course summary - developing your own cost action plan Group and individual action plans will be prepared with a view to participants identifying their cost risks areas and the techniques which can be immediately applied to improve costing and reduce costs
In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Powerful Functions in Microsoft Excel course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Powerful Functions in Microsoft Excel course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Powerful Functions in Microsoft Excel and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Powerful Functions in Microsoft Excel course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Powerful Functions in Microsoft Excel course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. 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 £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Powerful Functions in Microsoft Excel will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Powerful Functions in Microsoft Excel Introduction 00:03:00 Basic Functions 00:12:00 Date Functions 00:09:00 Random Numbers 00:09:00 IFS so many IFS 00:11:00 Text Functions 00:13:00 Logical Functions 00:09:00 Creating a Drop-Down List 00:05:00 VLOOKUP and XLOOKUP 00:09:00 Pivot Tables 00:08:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
Description: This Microsoft Excel 2016 PowerPivot takes a look at the free PowerPivot add-in for Microsoft Excel 2016. It is a program for all users of PowerPivot to get a good grasp of how its features are set and how it works. It covers interface features, techniques for manipulating PowerPivot data. You will learn how to create PowerPivot reports, the structure of DAX functions, and ways to distribute PowerPivot data. So, if you are interested to develop your skills and knowledge, you shouldn't be late to join this course. Learning Outcomes: Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time dependent data Saving data in different formats and protecting reports Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Excel 2016 PowerPivot is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Excel 2016 PowerPivot is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Microsoft Excel 2016 PowerPivot Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 PowerPivot 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2016 PowerPivot 00:20:00 Final Exam Final Exam- Microsoft Excel 2016 PowerPivot 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00
Overview 2 day applied course in modelling Basel IRB parameters and generating IRB Pillar 1 credit risk capital requirement for a mixed retail and corporate loan book Who the course is for Credit risk management, model validators and quants Loan officers / loan portfolio management ALM staff Bank investors – equity and credit investors Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now
48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! This Diploma in Health Coaching at QLS Level 4 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! Are you looking to improve your current abilities or make a career move? If yes, our unique Health Coaching at QLS Level 4 course might help you get there! It is an expertly designed course which ensures you learn everything about the topic thoroughly. Expand your expertise with high-quality training from the Health Coaching at QLS Level 4 course. Due to Health Coaching at QLS Level 4's massive demand in the competitive market, you can use our comprehensive course as a weapon to strengthen your knowledge and boost your career development. Learn Health Coaching at QLS Level 4 from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career. The Health Coaching at QLS Level 4 course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Health Coaching at QLS Level 4 course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this Health Coaching at QLS Level 4 course. This Health Coaching at QLS Level 4 training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer This Health Coaching at QLS Level 4 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Health Coaching at QLS Level 4 course: Introduction Defining Your coaching offer Managing Yourself The Coaching Process Client Coach Relationship Marketing & Selling Finances Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Health Coaching at QLS Level 4 exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Health Coaching at QLS Level 4 course is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements Health Coaching at QLS Level 4 No prior background or expertise is required. Career path The Health Coaching at QLS Level 4 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Certificates CPDQS Accredited Certificate Digital certificate - Included Diploma in Health Coaching at QLS Level 4 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Health Coaching at QLS Level 4, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme and also you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost.
48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! This Diploma in Residential Property Sales at QLS Level 4 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! Are you looking to improve your current abilities or make a career move? If yes, our unique Residential Property Sales at QLS Level 4 course might help you get there! It is an expertly designed course which ensures you learn everything about the topic thoroughly. Expand your expertise with high-quality training from the Residential Property Sales at QLS Level 4 course. Due to Residential Property Sales at QLS Level 4's massive demand in the competitive market, you can use our comprehensive course as a weapon to strengthen your knowledge and boost your career development. Learn Residential Property Sales at QLS Level 4 from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career. The Residential Property Sales at QLS Level 4 course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Residential Property Sales at QLS Level 4 course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this Residential Property Sales at QLS Level 4 course. This Residential Property Sales at QLS Level 4 training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer This Residential Property Sales at QLS Level 4 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Residential Property Sales at QLS Level 4 course: Module 01: Introduction to Residential Property Sales Module 02: Valuation of Real Estate Module 03: Law Relating to Residential Property Sales Module 04: Residential Agency Module 05: Finances Involved in Buying and Selling Property Module 06: Property Appraisal and Basic Building Construction and Defects Module 07: Records and Systems Module 08: UK Tax on Property Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Residential Property Sales at QLS Level 4 exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Residential Property Sales at QLS Level 4 course is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements Residential Property Sales at QLS Level 4 No prior background or expertise is required. Career path The Residential Property Sales at QLS Level 4 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Certificates CPDQS Accredited Certificate Digital certificate - Included Diploma in Residential Property Sales at QLS Level 4 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Residential Property Sales at QLS Level 4, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme andalso you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost.
48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! This Diploma in Mortgage Adviser at QLS Level 4 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! Are you looking to improve your current abilities or make a career move? If yes, our unique Mortgage Adviser at QLS Level 4 course might help you get there! It is an expertly designed course which ensures you learn everything about the topic thoroughly. Expand your expertise with high-quality training from the Mortgage Adviser at QLS Level 4 course. Due to Mortgage Adviser at QLS Level 4's massive demand in the competitive market, you can use our comprehensive course as a weapon to strengthen your knowledge and boost your career development. Learn Mortgage Adviser at QLS Level 4 from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career. The Mortgage Adviser at QLS Level 4 course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Mortgage Adviser at QLS Level 4 course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this Mortgage Adviser at QLS Level 4 course. This Mortgage Adviser at QLS Level 4 training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer This Mortgage Adviser at QLS Level 4 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Mortgage Adviser at QLS Level 4 course: Module 01: Introduction to Mortgage and Mortgage Adviser Module 02: Basics of Mortgage Purchase Module 03: Understanding the Buyer's Perspective Module 04: Mortgage Finances Module 05: Being a Successful Mortgage Advisor Module 06: Mortgage Regulation and Law: UK Module 07: The Mortgage Conduct of Business (MCOB) Part 01 Module 08: The Mortgage Conduct of Business (MCOB), Part 02 Module 09: UK Mortgage Market and Borrowers Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Mortgage Adviser at QLS Level 4 exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Mortgage Adviser at QLS Level 4 course is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements Mortgage Adviser at QLS Level 4 No prior background or expertise is required. Career path The Mortgage Adviser at QLS Level 4 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Certificates CPDQS Accredited Certificate Digital certificate - Included Diploma in Mortgage Adviser at QLS Level 4 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Mortgage Adviser at QLS Level 4, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme andalso you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost.
Project appraisal and risk management (In-House)
By The In House Training Company
Where should management effort be directed? In controlling costs and ensuring proper engineering in live projects? - yes, of course, but true cost control comes by understanding, eliminating and minimising risk prior to a business committing any funds. This course studies the stages required for practical financial and business appraisals of projects and capital expenditure. This course has two primary objectives: To impart the knowledge and skills required to ensure as risk-free as possible expenditure of that scarce resource, cash - the investors', governments' or shareholders' money must not be squandered To improve the quality of the appraisal process in the widest sense - demonstrating how the process of project and capital expenditure appraisal can be used to dramatically improve cost control and deliver as risk-free as possible expenditure As a result of the course, participants will be able to: Understand the economics of appraisal Be in control of their projects from the start Understand the economics of their projects - and devise the most appropriate mode Carry out sensitivity analysis and identify risk Improve their methods of appraisal and approach Focus on the risk areas and take out risk and control costs before they over-run The benefits of attending this course will be demonstrable from day one. Thorough appraisals and risk assessment follow through to success in project management and detailed cost control and project management. 1 Introduction Why appraise? Taking risk out of investment The short- and long-term results of not appraising business expenditure 2 Developing an appraisal process The process - overall and stage-by-stage objectives Understand business and technical risks Manage resources and time Do you invest enough time and effort at this stage? Take out the risks - control costs before you are committed to contracts and action Checklists 3 Appraisal arithmetic Review of the arithmetic of appraisalThe time value of moneyThe effects of different interest or required ratesThe effects of inflation (or deflation) in prices and costs Understanding the economics of appraisal is essential 4 Appraisal measures Meaning and use of appraisal measures Identifying the most appropriate measures for your particular business Payback Discounted cash flow measures - NPV and IRR Other measures - FW, AW, Profitability Index The meaning of the measures and their application in practice 5 Cost benefit analysis The effect on decision-making of more intangible benefits Cost benefit analysis Ensuring costs are genuine Measuring intangible benefits Environmental issues Consideration of intangible benefits in the appraisal decision-making process 6 Developing appropriate models Developing models - examples of spreadsheet models and measures for many different situations Modelling investment opportunities - summarising outcomes Sensitivity analysis - identifying, quantifying and taking out risk 7 Developing an appraisal process The process - managing risk from the outset Using the process in risk management, negotiating and project management Take out risk by thoroughly knowing your project - developing your own process
