80 Spreadsheet courses in Nottingham delivered Live Online

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

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 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 click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar