402 Spreadsheet courses

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

AAT Level 3 Advanced Diploma in Accounting AAT Level 3 is an Advanced or Intermediate level of AAT qualification in accounting. This course gives successful students the skills and knowledge to work competently in finance, accountancy, or bookkeeping role. Moreover, the students also have the opportunity to progress their studies with AAT Level 4 Diploma in Accounting and acquire full membership of the AAT. You will be awarded AAT Level 3 Advanced Diploma in Accounting certificate from Association of Accounting Technicians (AAT), once you have passed all the advanced-level qualification exams and skill tests. The Level 3 Diploma in Accounting covers the following areas: Advanced Bookkeeping Final Accounts Preparation Indirect Tax Management Accounting: Costing Ethics for Accountants Spreadsheets for Accounting

AAT Level 3 - Prepare Final Accounts for Sole Traders & Partnerships: AAT Level 3 is an Advanced or Intermediate level of AAT qualification in accounting. This course gives successful students the skills and knowledge to work competently in finance, accountancy, or bookkeeping role. Moreover, the students also have the opportunity to progress their studies with the AAT Level 4 Diploma in Accounting and acquire full membership of the AAT. You will be awarded an AAT Level 3 Advanced Diploma in Accounting certificate from the association of Accounting Technicians(AAT), once you have passed all the advanced-level qualification exams and skill tests. The Level 3 Diploma in Accounting covers the following areas: Advanced Bookkeeping Final Accounts Preparation Indirect Tax Management Accounting: Costing Ethics for Accountants Spreadsheets for Accounting

AAT Level 3 - Cost and Revenues Overview: AAT Level 3 is an advanced or Intermediate level of AAT qualification in accounting. This course gives successful students the skills and knowledge to work competently in finance, accountancy, or bookkeeping role. Moreover, the students also have the opportunity to progress their studies with the AAT Level 4 Diploma in Accounting and acquire full membership of the AAT. You will be awarded an AAT Level 3 Advanced Diploma in Accounting certificate from the association of Accounting Technicians(AAT), once you have passed all the advanced-level qualification exams and skill tests. The Level 3 Diploma in Accounting covers the following areas: Advanced Bookkeeping Final Accounts Preparation Indirect Tax Management Accounting: Costing Ethics for Accountants Spreadsheets for Accounting

AAT Accounting Training Course Fast Track: AAT Level 2 & 3 are the Beginner and Intermediate levels of AAT qualification in Accounting. These two levels are a part of three mandatory qualification levels required to be an AAT Certified Accountant.  AAT Level 2 course covers the foundational areas and is suited for people with limited or no accounts knowledge. It is the first step for aspirants intending to build a successful career in accounting. The course by taking you through basic accounting principles will enable you to work in an entry-level role in the accounting or finance department.  AAT Level 3 is an intermediate or advanced level of AAT accounting qualification. By the end of this course, you'll be competent enough to work in finance, accountancy, or bookkeeping role. Why Take This Course? Build a remarkable reputation: Complete all the three AAT Levels to earn the highly regarded 'MAAT' status. A bright future: With an opportunity to progress to chartered accountancy. Increase your salary: Up-skill yourself and increase your earning potential. Work overseas: AAT qualifications are recognised internationally, giving you the freedom to work abroad. The AAT Level 2 Foundation Certificate in Accounting covers the following areas: Bookkeeping Transactions Bookkeeping Controls Elements of Cost Work Effectively in Finance Using Accounting Software (i.e SAGE) The Level 3 Diploma in Accounting covers the following areas: Advanced Bookkeeping Final Accounts Preparation Indirect Tax Management Accounting: Costing Ethics for Accountants Spreadsheets for Accounting

AAT Level 3 is an Advanced or Intermediate level of AAT qualification in accounting. This course gives successful students the skills and knowledge to work competently in finance, accountancy, or bookkeeping role. Moreover, the students also have the opportunity to progress their studies with the AAT Level 4 Diploma in Accounting and acquire full membership of the AAT. Duration You can expect this qualification to take 1-1.5 year to complete for most students. Tutors Tutors are highly qualified with extensive knowledge of accountancy. Study Options Online Live - Live Interactive Online Classes are offered through the State of The Art Virtual Learning Campus. Classes are recorded to catch up later. In-Campus - Study at our London campus for AAT level 3. Daytime, weekend and evening courses for AAT available. AAT Distance Learning- Self-Study at home at your own pace with Study Material and access to Online study Material through Virtual Learning Campus (VLC). AAT Qualification Once you finish AAT qualification and pass all exams successfully, you will be awarded globally recognised AAT Certificate in Accounting from AAT. AAT Level 3 Course Syllabus Advanced Bookkeeping Final Accounts Preparation Indirect Tax Management Accounting: Costing Ethics for Accountants Spreadsheets for Accounting

Ideal for those already using Excel but who really want to get to grips with formulas and functions. Course overview Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages. It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong.  This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. Objectives By the end of the course you will be able to: Construct Formulas Use a range of common Functions Work with absolute and relative references in formulas Create percentage calculations Use named ranges in formulas Use the XLOOKUP command Create formulas with date and use date functions Use formulas in conditional formatting Use a range of Count functions Use the formula auditing tools Content Formulas vs Functions Constructing formulas Using functions Common Excel functions Using the function wizard vs the formula bar Formulas in tables Absolute vs relative references in formulas Using absolute references in formulas Using partial absolute referencing Range Naming Naming ranges Using range names in formulas Single and multi-cell ranges Working with percentages Creating formulas with percentages Percentage breakdowns Percentage increases Formatting as a percentage Using Lookups Using XLOOKUP to insert information from other spreadsheets Calculating with dates Calculating with dates Using date functions Using formulas in conditional formatting Using conditional formulas Using functions in conditional formatting Count functions COUNT COUNTA COUNTBLANK Formula auditing Using the auditing facility Tracing how formulas are made up Tracing precedents and dependants Evaluating formulas Error checking Showing formulas on a sheet

This 3 Days programme will equip you to use, price, manage and evaluate interest rate and cross-currency derivatives. The course starts with the building blocks of money markets and futures, through yield curve building to interest-rate and cross-currency swaps, and applications. The approach is hands-on and learning is enhanced through many practical exercises covering hedging, valuation, and risk management. This course also includes sections on XVA, documentation and settlement. The programme includes extensive practical exercises using Excel spreadsheets for valuation and risk-management, which participants can take away for immediate implementation.

Overview Interest Rate Options are an essential part of the derivatives marketplace. This 3-Day programme will equip you to use, price, manage and evaluate interest rate options and related instruments. The course starts with a detailed review of option theory, from a practitioner’s viewpoint. Then we cover the key products in the rates world (caps/floors, swaptions, Bermudans) and their applications, plus the related products (such as CMS) that contain significant ’hidden’ optionality. We finish with a detailed look at the volatility surface in rates, and how we model vol dynamics (including a detailed examination of SABR). The programme includes extensive practical exercises using Excel spreadsheets for valuation and risk-management, which participants can take away for immediate implementation Who the course is for This course is designed for anyone who wishes to be able to price, use, market, manage or evaluate interest rate derivatives. Interest-rate sales / traders / structurers / quants IT Bank Treasury ALM Central Bank and Government Treasury Funding managers Insurance Investment managers Fixed Income portfolio managers 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

Improove your excel skills with Time Training Center’s advanced excel course in Abdu Dhabi. Our advanced Training can help you master the latest functions and tools in MS Excel.Acquire multiple skills, such as calculating, evaluating, organising, and coordinating data through spreadsheets. Enroll now! Call us: 97126713828 Mail : info@timetraining.ae Learn more:https://www.timetraining.ae/course/advanced-excel-course-in-abu-dhabi Address: Office 203, ADCP Tower - B,Behind City Seasons, Electra Street, Abu Dhabi United Arab Emirates