34 Abs courses in Leicester

Our *NEW* Mini First Aid Baby Proofing class is our second class, designed for parents and carers of babies and children over 3 months. It can be taken after our 2 hour Baby and Child First Aid class, or in isolation for those parents who are starting their weaning journey, or have a baby on the move!

The 2-hour Baby & Child First Aid class covers CPR, Choking, Bumps, Burns, Breaks, Bleeding, Febrile Seizures and Meningitis & Sepsis Awareness and will give everyone who attends the peace of mind they deserve.

We invite adults, children, complete beginners, and advanced pianists alike to join us at our studio on Baker Street for the finest and most comprehensive piano lessons London has to offer, thanks to a wonderful team of piano instructors. Please contact us for in-person or online lesson availability.

With this 2 hour workshop, you will learn to make your own lampshade. You can choose from our wide range of over 1400+ fabrics to make a lampshade. You can match this to your home decor if you so wish.

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

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: * Create tables * Use functions * Manage rows and columns * Write formulas * Manage sheets * Use content formats * Handle larger tables * Create reports and charts 1 CREATING A TABLE * Creating an Excel table from scratch * Wrapping text in cells * Speeding up data entry using AutoFill * Sorting columns 2 INSERTING FUNCTION * Inserting function calculators * Using AutoSum to sum numbers * Statistical calculations AVERAGE, MAX and MIN 3 TABLE ROWS AND COLUMNS * Inserting and deleting rows and columns * Adjusting multiple column widths and row heights * Hiding and unhiding rows and columns 4 FORMULA WRITING * The basics of formula writing * Understanding mathematical symbols * Using multiple mathematical symbols in a formula * When to use brackets * Troubleshooting calculation errors 5 MANAGING SHEETS * Inserting, renaming, moving and deleting sheets * Copying a worksheet to another file * Copying a table to another sheet 6 MANAGING CONTENT FORMATS * Applying data formats * Managing number formats * Controlling formats with the Format Painter 7 MANAGING LARGER TABLES * Applying freeze panes to lock tables when scrolling * Sorting on multiple columns * Using filters to extract table information 8 CREATING AND MODIFYING CHARTS * Creating a pie chart * Creating a column chart * Inserting chart titles and data labels * Controlling chart formatting * Changing chart types 9 PRINTING * Previewing and printing tables and charts * Modifying page orientation * Adjusting print margins * Printing a selection 10 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 11 PIVOT TABLES * Create a pivot table report * Insert a pivot chart into a report

No-one in business will succeed if they are not financially literate - and no business will succeed without financially-literate people. This is the ideal programme for managers and others who don't have a financial qualification or background but who nonetheless need a greater understanding of the financial management disciplines essential to your organisation. This course will give the participants a sound understanding of financial reports, measures and techniques to make them even more effective in their roles. It will enable participants to: * Overcome the barrier of the accountants' strange language * Deal confidently with financial colleagues * Improve their understanding of your organisation's finance function * Radically improve their planning and budgeting skills * Be much more aware of the impact of their decisions on the profitability of your organisation * Enhance their role in the organisation * Boost their confidence and career development 1 REVIEW OF THE PRINCIPAL FINANCIAL STATEMENTS * What each statement contains * Outline * Detail * Not just what the statements contain but what they mean * Balance sheets and P&L accounts (income statements) * Cash flow statements * Detailed terminology and interpretation * Types of fixed asset - tangible, etc. * Working capital, equity, gearing 2 THE 'RULES' - ACCOUNTING STANDARDS, CONCEPTS AND CONVENTIONS * Fundamental or 'bedrock' accounting concepts * Detailed accounting concepts and conventions * What depreciation means * The importance of stock, inventory and work in progress values * Accounting policies that most affect reporting and results * The importance of accounting standards and IFRS 3 WHERE THE FIGURES COME FROM * Accounting records * Assets / liabilities, Income / expenditure * General / nominal ledgers * Need for internal controls * 'Sarbox' and related issues 4 MANAGING THE BUDGET PROCESS * Have clear objectives, remit, responsibilities and time schedule * The business plan * Links with corporate strategy * The budget cycle * Links with company culture * Budgeting methods * 'New' budgeting * Zero-based budgets * Reviewing budgets * Responding to the figures * The need for appropriate accounting and reporting systems 5 WHAT ARE COSTS? HOW TO ACCOUNT FOR THEM * Cost definitions * Full / absorption costing * Overheads - overhead allocation or absorption * Activity based costing * Marginal costing / break-even - use in planning 6 WHO DOES WHAT? A REVIEW OF WHAT DIFFERENT TYPES OF ACCOUNTANT DO * Financial accounting * Management accounting * Treasury function * Activities and terms 7 HOW THE STATEMENTS CAN BE INTERPRETED * What published accounts contain * Analytical review (ratio analysis) * Return on capital employed, margins and profitability * Making assets work - asset turnover * Fixed assets, debtor, stock turnover * Responding to figures * EBIT, EBITEDIA, eps and other analysts' measure 8 OTHER KEY ISSUES * Creative accounting * Accounting for groups * Intangible assets - brand names * Company valuations * Fixed assets / leased assets / off-balance sheet finance

Most organisations and businesses are trying to navigate the best way back to a functional working framework. But two things need to happen - 1. The working practices need to be efficient, sustainable and compatible for meeting the demands and needs of the organisation; it’s clients, it’s workforce and it’s Leaders 2. The culture needs to be welcoming, authentic and supportive otherwise there will be disenfranchisement and potentially a churn of staff and loss of talent What has been proven to be a very successful approach to mitigate the dangers of demotivated team members and poor efficiency levels is a bespoke ‘Ushering the Team Back to the Workplace’ workshop. -------------------------------------------------------------------------------- PROGRAMME OUTLINE Below is a template of an actual Programme that has been delivered very successfully for clients such as the NHS; Claranet; Jotun Paints & Workspace. This, however, can be modified to suit any group or size. It will be designed to reflect the Organisation’s preferred Hybrid working framework and communication systems. The options of having the innovative Real Play technique to help handle delicate conversations is especially effective. The biggest gain is to reconnect the relationships via the activities and exercises, which would be selected carefully. Key commitments and buy-in is always the priority outcomes - which this programme will help deliver in just 1 day. The objectives include: * Making the transition back to working as a collaborative team * Enhancing the Leadership skills of the team * Reviewing/establishing the Hybrid working protocols * Galvanising the Team spirit * Maintain inclusivity among full-time; part-time and Region based team members * Energising and motivational * Fun! EXERCISE – ROUND THE BEND The team are to follow the instructions delivered as they walk (and jump) through the route – always keeping a safe distance apart. The instructions become more complicated as they progress. DEBRIEFING POINTS: * Dealing with Change * Attention to Detail * Adapting approach * Optimising results EXERCISE - NUMBER CRUNCH (3 x Cohorts of 12/13) The team must be effectively led and motivated to work as one unified group to reach their objective of visiting each numbered location within a very tight deadline. DEBRIEFING POINTS: * Support and co-ordination * Strategy and planning * Adapting approach * Optimising results TUTORIAL – TEAM DYNAMICS * Tuckman model * Phases of Development towards Maturity EXERCISE - JUGGLING (3 x Cohorts of 12/13) The group(s) will be invited to optimise the number of ‘clients’ (juggling balls) they can manage at one time. This involves devising a sequence between the group to achieve maximum results without making any mistakes. We introduce different balls which represent different degrees of complexity, challenging the group’s preparation and approach to a variety ‘customers’ needs. DEBRIEFING POINTS: * Ensuring effective communication * Clarifying the approach for dealing with the unexpected * Setting expectations and reviewing delivery * Treating every colleague with care and respect TUTORIAL - EMAIL ETIQUETTE * The primary standards – best practices * ABSURD model * Preparation and planning * Top Tips WORLD CAFE The team are split into 5-6 sub-groups – each with a specific review focus:- * What recommendations do you have to engage the team back into the Workplace? * How do we ensure the framework is efficient? * What are the best ways to optimise team working strategically when most/all team members are in the office? * What potential barriers are there? * How do we accommodate for the Regional team members? * What are the benefits to bringing the team back to the workplace? Each session has 2 – 3 rounds with each table’s ‘host’ sharing feedback for applying to the Team Action Plan – or Charter. DEBRIEFING POINTS: * Each Syndicate’s recommendations and capture the key actions they generate 'REAL PLAY' We offer an innovative solution to bring real Leadership/team scenarios to life. We use actors who improvise scenarios which have been specified by the group. * The group is split the group into 2 sub-groups, one with the Actor, the other with the Trainer. * Each group has a brief and has to instruct their Trainer/Actor on how to approach the scenario supplied. * The Actor and Trainer perform the role play(s) as instructed by their respective teams; however, during the action they can be paused for further recommendations or direction. * The outcome is the responsibility of the team(s) – not the performers Assign 24 x ‘Directors’ (4 for each Player – Phil & Julia – for each Real Play. POTENTIAL REAL PLAY SCENARIOS: * Engaging with a team member as to how the new working plans will be applied. * Overcoming concerns to the new working practices/framework * Addressing issues where a team member feels excluded from the teamworking practices/culture Debrief the Programme Individual Action Plans Team Priorities for application into the workplace

It is essential that those charged with responsibility for credit control and debt recovery have a full appreciation of the relevant law: no-one can negotiate effectively to recover a debt if they don't understand the ultimate sanctions they can apply. This programme is designed to give them a practical, up-to-date understanding of the law as it applies to your particular organisation. This course will help ensure that participants: * Understand the relevant laws * Know how and when to invoke legal processes * Avoid legal pitfalls in debt collection negotiations Specific, practical learning points include: * Definition of 'harassment' * How to set up an in-house collection identity * Whether cheques in 'full and final settlement' are binding * The best steps to trace a 'gone away'... and many, many more. 1 DATA PROTECTION AND DEBT RECOVERY There are a whole range of things which can be checked on members of the public and which are not affected by the restraints of the Data Protection Act. These will be explained in simple, clear terms so that staff can use this information immediately. 2 COUNTY COURT SUING The expert trainer will show how to sue for money owed, obtain judgment and commence enforcement action without leaving your desk. This module is aimed at showing how to make the Courts work for you instead of the other way around! 3 ENFORCEMENT OF JUDGMENTS There are many people who have a County Court Judgment (CCJ) against their debtor but who still remain unpaid. This session explains each of the enforcement methods and how to use them to best effect. Enforcement methods covered include: * Warrant of Execution * Using the sheriff (now known as High Court Enforcement Officers) * Attachment of earnings * Third Party Debt Orders * Charging Orders (over property and goods) * Winding-up companies and making individuals bankrupt 4 OFFICE OF FAIR TRADING RULES ON DEBT RECOVERY Surprisingly few people are aware of the Office of Fair Trading rules on debt recovery and many of those that do know think they don't apply to them - but they do. Make sure you know what you need to! 5 NEW METHODS TO TRACE ELUSIVE, ABSENTEE AND 'GONE AWAY' DEBTORS Why write the money off when you can trace the debtor and collect the money you are owed? 6 CREDIT CHECKING OF NEW AND EXISTING CUSTOMERS It makes sense to credit check would-be, new and existing customers to evaluate the likelihood of payment delays or perhaps not being paid at all. This session shows a range of credit checking steps, many of which can be done completely free of charge, including a sample credit application / account opening form. 7 LATE PAYMENT OF COMMERCIAL DEBTS REGULATIONS Do your staff understand this legislation and how to use it to make people pay quicker than ever before? The trainer shows how. 8 THE ENTERPRISE ACT The Enterprise Act made some startling changes to corporate and personal insolvency. What are the implications for credit control and debt recovery within your organisation?

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