3398 Courses in Belfast delivered Online

Overview This comprehensive course on Microsoft Excel - 25 Must-Know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel - 25 Must-Know Formulas and Functions comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel - 25 Must-Know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel - 25 Must-Know Formulas and Functions is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 2 lectures • 01:12:00 total length •Must-Know Formulas and Functions: 01:12:00 •Resource - Microsoft Excel - 25 Must-Know Formulas and Functions: 00:00:00

Overview This comprehensive course on Microsoft Excel: Master Power Query in 120 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Master Power Query in 120 Minutes! comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Master Power Query in 120 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 25 lectures • 02:25:00 total length •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Excel Power Query - Query Editor Ribbon: 00:09:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Transform Data - Split Text Fields in Excel Power Query: 00:10:00 •Transform Data - Group By in Excel Power Query: 00:03:00 •Transform Data - Unpivoting Columns in Excel Power Query: 00:05:00 •Transform Data - Pivoting Columns in Excel Power Query: 00:02:00 •Transform Data - Split Columns into Other Columns in Excel Power Query: 00:04:00 •Transform Data - Filtering Rows in Excel Power Query: 00:05:00 •Transform Data - Sorting Columns in Excel Power Query: 00:02:00 •Transform Data - Transform and Add Columns in Excel Power Query: 00:07:00 •From Folder - Import From Folder in Excel Power Query: 00:07:00 •From Folder - Doing Auto Cleanup in Excel Power Query: 00:13:00 •From Folder - Extract Data from Forms in Excel Power Query: 00:13:00 •From Workbook - Extract Multiple Criteria in Excel Power Query: 00:05:00 •From Workbook - Extract Multiple Worksheets in Excel Power Query: 00:04:00 •Joins - Intro to Joins: 00:04:00 •Joins - Merging: 00:08:00 •Joins - Full Outer Join: 00:06:00 •Joins - Right Anti Join: 00:09:00 •Power Query - Convert Reports into Pivot Tables: 00:05:00 •Modulo: 00:06:00

In today's competitive business world firms are under unprecedented pressure to deliver value to their shareholders and other key stakeholders. Senior executives in all parts of the organisation are finding that they need some degree of financial know how to cope with the responsibility placed on them as business managers and key decision-makers; monitoring and improving business performance, investing in capital projects, mergers and acquisitions: all require some degree of financial knowledge. The key financial skills are not as difficult to learn as many people believe and in the hands of an experienced senior executive they can provide a formidable competitive advantage. After completing this course delegates will be able to: Understand fundamental business finance concepts; understand, analyse and interpret financial statements: Profit Statement, Balance Sheet and Cashflow Statement Understand the vital difference between profit and cashflow; identify the key components of working capital and how they can be managed to generate strong cashflow Evaluate pricing decisions based on an understanding of the nature of business costs and their impact on gross margin and break-even sales; managing pricing, discounts and costs to generate strong business profits; understand how lean manufacturing methods improve profit Use powerful analytical tools to measure and improve the performance of their own company and assess the effectiveness of their competitors Apply and interpret techniques for assessing and comparing investment opportunities in capital projects, business acquisitions and other ventures; understand and apply common methods of business valuation Understand the role of business finance in formulating and implementing competitive business strategy; the role of budgeting as part of the planning process and the various approaches to budgeting and performance measurement 1 Basic principles Delivering value to key stakeholders Accounting concepts, GAAP, IFRS and common terms Understanding and using the balance sheet Understanding and using the profit statement Recognising the vital difference between profit and cashflow Understanding and using the cashflow statement What financial statements can and cannot tell us 2 Managing and improving cashflow Sources of finance and their advantages and disadvantages What is working capital and why is it so important? Managing stocks, debtors and creditors Understanding how working capital drives business growth Understanding and avoiding the over-trading trap Unlocking the funds tied up in fixed assets: asset backed loans and leasing 3 Managing and improving profit Understanding how profits generate cashflow The fundamental nature of costs: fixed and variable business costs Understanding gross margin and break-even How common pricing methods affect gross margin and profit Effective strategies to improve gross margin Using value chain analysis to reduce costs Lean manufacturing methodsUnderstanding Just-in-time, 6 Sigma and Kaizen methods Improving profitEffective and defective strategies 4 Measuring and managing business performance Measures of financial performance and strength Investor behaviour: the risk and reward relationship Return on investment (ROI): the ultimate measure of business performance How profit margin and net asset turnover drive return on net assets Why some companies are more profitable that others Understanding competitive advantage: cost and differentiation advantage Why great companies failWhat happened to Kodak? Using a 'Pyramid of Ratios' to improve business performance Using Critical Success Factors to develop Key Performance Indicators 5 Budgeting and forecasting methods Using budgets to support strategy Objectives and methods for effective budgets Using budgets to monitor and manage business performance Alternative approaches to budgeting Developing and implementing Balanced Scorecards Beyond Budgeting Forecasting methods and techniques Identifying key business drivers Using rolling forecasts and 'what-if' models to aid decision-making

Are you ready to embark on an enlightening journey of wisdom with the Financial Wellness & Cashflow Management bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Financial Wellness & Cashflow Management. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: Financial Wellness: Managing Personal Cash Flow Course 2: Financial Advisor Course 3: Understanding Financial Statements and Analysis Course 4: Introduction to Accounting Course 5: Making Budget & Forecast Course 6: Pension UK Course 7: Tax Accounting Course 8: Introduction to VAT Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Financial Wellness & Cashflow Management bundle illuminate your path to wisdom. The Financial Wellness & Cashflow Management bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Financial Wellness & Cashflow Management package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Financial Wellness & Cashflow Management bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Financial Wellness & Cashflow Management community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Financial Wellness & Cashflow Management Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Financial Wellness & Cashflow Management bundle. Establish robust bases across each course nestled within the Financial Wellness & Cashflow Management bundle. Decipher intricate concepts through the articulate content of the Financial Wellness & Cashflow Management bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Financial Wellness & Cashflow Management bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Financial Wellness & Cashflow Management bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Financial Wellness & Cashflow Management bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Financial Wellness & Cashflow Management bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Financial Wellness & Cashflow Management bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Financial Wellness & Cashflow Management journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Financial Wellness & Cashflow Management Bundle. Career path Armed with the Financial Wellness & Cashflow Management bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Financial Wellness & Cashflow Management bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Are you ready to embark on an enlightening journey of wisdom with the Investment Advisor bundle and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Investment Advisor. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 1: Investment Course 2: Financial Investigator Course 3: Financial Advisor Course 4: Investment Banking: Venture Capital Fundraising for Startups Course 5: Capital Budgeting & Investment Decision Rules Course 6: Stock Market Investment: Plan for Retirement Course 7: Anti-Money Laundering (AML) and Financial Crime Course 8: Tax Accounting Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Investment Advisor bundle illuminate your path to wisdom. The Investment Advisor bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Investment Advisor package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Investment Advisor bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further join the Investment Advisor community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding of the designated areas of study with the Investment Advisor bundle. Establish robust bases across each course nestled within the Investment Advisor bundle. Decipher intricate concepts through the articulate content of the Investment Advisor bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Investment Advisor bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Investment Advisor bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Investment Advisor bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Investment Advisor bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Investment Advisor bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Investment Advisor journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this course. Career path Armed with the Investment Advisor bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Investment Advisor bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Overview The objective of this course is to equip professionals with comprehensive knowledge and practical skills in WEB 3 technologies and crypto assets. Participants will gain a deep understanding of the underlying principles of blockchain, the operational mechanics of cryptocurrencies, the potential impact of these technologies on the banking sector and the latest trends. Who the course is for Consultants Analysts Managers C-Level executives People in need of knowledge to develop a blockchain strategy People working with blockchain projects Regulators Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Our Aim is Your Satisfaction! Offer Ends Soon; Hurry Up!! Internal audits are necessary to sustain operational effectiveness, financial stability, and asset protection. It offers unbiased confirmation that an organisation's risk assessment, management, and internal control procedures are effective. Our Internal Audit Skills course will give you an in-depth understanding of internal auditing. An internal auditor evaluates the effectiveness of a company's risk management. They employ a systematic approach to determine how well internal procedures are performing and whether there is room for improvement in risk and business operations. Some of their responsibilities include assessing the financial risk to the firm, protecting assets, obtaining and interpreting data, assuring the authenticity of financial reports, reviewing the effectiveness of business processes, and ensuring the organisation abides by rules and laws. This course will help you in learning internal audit skills. The duties and responsibilities of an auditor are discussed in this Internal Audit Skills course. You will comprehend the significance of auditing as a form of assurance. You will be taught the fundamentals of conducting internal audits and technology-based internal audits. You will gain a deep understanding of internal control and control risks in auditing. Audit outcomes, interviews, and UK internal audit requirements are also covered. So, don't wait any longer. Sign up for this Internal Audit Skills course now! Learning Outcomes: Get acquainted with the significance of auditing as a form of assurance. Discover the roles and responsibilities of an auditor. Acquire a thorough knowledge of internal auditing procedures. Become well-versed in technology-based internal audits. Heighten your understanding of internal control and control risks in auditing. Learn about audit interviews. Explore how to report audit outcomes. Obtain a deep insight into the UK internal audit standards. Why Prefer This Internal Audit Skills Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another certificate accredited by CPD QS after completing the Internal Audit Skills course Get a free student ID card! (£10 postal charges 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 course: Internal Audit Skills Module 01: Auditing as a Form of Assurance Module 02: Internal Audit Procedures Module 03: Technology-based Internal Audit Module 04: Internal Control and Control Risk Module 05: Audit Interviews Module 06: Reporting Audit Outcome Module 07: UK Internal Audit Standards Module 08: Career as an Auditor Assessment Process After completing an online course module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Diploma in Internal Audit Skills at QLS Level 5exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. Show off Your New Skills with a Certificate of Completion Endorsed Certificate of Achievement from the Quality Licence Scheme After successfully completing the Diploma in Internal Audit Skills at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 119 GBP inside the UK 129 GBP (including postal fees) for International Delivery Certificate Accredited by CPD QS Upon finishing the Internal Audit Skills course, you need to order to receive a Certificate Accredited by CPD QS that is accepted all over the UK and also internationally. The pricing schemes are: 10 GBP for Digital Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery) CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Are you the right candidate for this course? Anyone interested in learning more about Internal Audit Skills is advised to take this course. This course will help you understand the topic thoroughly and enable you to understand the basic concepts. Enrollment in this Internal Audit Skills course is open to everybody. You can access the course materials from anywhere in the world; there are no restrictions. You should enrol in this course if you: Wish to gain a better understanding of Internal Audit Skills. Already working in this field and want to learn more about Internal Audit Skills. Is a student pursuing a relevant field of study? looking for a job in the Internal Audit Skills industry. Requirements The Internal Audit Skills program does not require any prior knowledge; everyone may participate! This course is open to anyone interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This course allows you to study at your speed and grow a quality skillset. Career path Internal Auditor Internal Audit Manager Risk and Internal Auditor In the UK, internal auditors have the potential to earn an average salary of £45,350 annually.

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Audit Management course might help you get there! Expand your expertise with high-quality training - study the Audit Management course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Audit Management online training course. The Audit Management 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 Audit Management 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 course. This Audit Management 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 Us? Opportunity to earn a certificate accredited by CPD QS. Get a free student ID card! (£10 postal charges 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**** ***Audit Management*** Module 01: Auditing As A Form Of Assurance Module 02: Internal Audit Procedures Module 03: Introduction To Money Laundering Module 04: Proceeds Of Crime Act 2002 Module 05: Development Of Anti-Money Laundering Regulation Module 06: Responsibility Of The Money Laundering Reporting Officer Module 07: Risk-Based Approach Module 08: Customer Due Diligence Module 09: Suspicious Conduct And Transactions Module 10: Internal Control And Control Risk Module 11: UK Internal Audit Standards Module 12: Career As An Auditor Assessment Process Once you have completed all the modules in the Audit Management course, you can assess your skills and knowledge with an optional assignment. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Audit Management course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD QS Accredited Certificate Digital certificate - £10 CPD QS Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Learning Objectives Introduction , Designing Tables for Better Data Entry , Sharing Data with Other Applications , Working with Action Queries , Advanced Query Techniques , Automating Processes with Macros , Advanced Form Techniques , Advanced Report Techniques , Conclusion   Pre-Requisites Access 365 Beginner or equivalent experience.   Description This course is designed to teach students intermediate level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 365 Advanced course.   Module 1: Design Tables for Better Data Entry Reviewing Table Design Principles 00:11:00 Setting Field Size, Formats, and Captions 00:11:00 Setting Default Values and Required Fields 00:05:00 Restricting Data Entry-Validation Rules 00:07:00 Restricting Data Entry-Input Masks 00:09:00 Module 2: Share Data with Other Apps Exporting Tables and Queries to Excel 00:05:00 Exporting Data to a SharePoint List 00:02:00 Importing Data from Excel 00:06:00 Importing Data from a SharePoint List 00:02:00 Linking External Data Sources 00:05:00 Using Word Merge 00:06:00 Module 3: Work with Action Queries What are Action Queries 00:04:00 Creating an Update Query 00:06:00 Creating an Append Query 00:04:00 Creating a Delete Query 00:04:00 Creating a Make Table Query 00:04:00 Changing Start Number of an Auto Number Field 00:04:00 Module 4: Advanced Query Techniques Modifying Query Joins 00:06:00 Using Self Joins to Combine Data 00:06:00 Creating Find Unmatched and Find Duplicate Queries 00:09:00 Creating Parameter Queries 00:05:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:06:00 Summarizing Query Data with Totals 00:04:00 Creating Crosstab Queries 00:06:00 Module 5: Automate Processes with Macros Understanding Macro Basics 00:14:00 Creating Macros to Open Forms by Record 00:09:00 Validating Data Entry with Macros 00:10:00 Creating a Macro to Automate Data Entry 00:08:00 Advanced Data Entry Using Macros and DLOOKUP 00:11:00 Module 6: Advanced Form Techniques Using Conditional Formatting 00:04:00 Working with the New Label Name Property 00:03:00 Organizing Form Fields with Tab Controls 00:09:00 Creating an Option Group Control 00:06:00 Creating a Combo Box Control 00:04:00 Configuring a Combo Box Control to Show Search Results 00:04:00 Using a Subform to Show Data From a Related Table 00:06:00 Module 7: Advanced Report Techniques Inserting a Chart on a Report 00:07:00 Showing Data in Columns 00:07:00 Inserting a Subreport 00:05:00 Configuring Reports with Parameter Queries 00:03:00 Sending Reports 00:03:00 Resource Resource - Access 365 Intermediate 00:00:00 Final Exam Final Exam - Access 365 Intermediate 00:20:00

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