216 Link courses in Birmingham

Overview A 1-day course on inflation-linked bonds and derivatives, focusing on the UK market in particular. We examine how inflation is defined and quantified, the choice of index (RPI vs. CPI), and the most common cash flow structures for index-linked securities. We look in detail at Index-linked Gilts, distinguishing between the old-style and new-style quotation conventions, and how to calculate the implied breakeven rate. Corporate bond market in the UK, and in particular the role of LPI in driving pension fund activity. Inflation swaps and other derivatives, looking at the mechanics, applications and pricing of inflation swaps and caps/floors. The convexity adjustment for Y-o-Y swaps is derived intuitively. Who the course is for Front-office sales product control research Traders Risk managers Fund managers Project finance and structured finance practitioners Accountants, auditors, consultants 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

Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. A comprehensive training course with up to date material to practice at home and during your class. You will also be provided a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. It is a fundamental programme for professional Accountants. Excel spread sheets are the most powerful tool, extensively used for reporting and analysis. Having advanced skills on excel can excel your career and help you to stand ahead of the competitive job market. Advanced skills on excel is a must for any potential professional accountants. You will receive an attendance certificate once you complete the course successfully. Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Autocomplete, using styles, headers and footers, Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Sumifs Tables and Bordering Look up References (Vlookup, Hlookup,etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis

Course description Sage 50 Accounting / Bookkeeping Training - Fast Track Overview Want to open the door to working in Finance and Accountancy Industry? Starting Sage Line 50 Accounting Fast Track Training course will enhance your career potentials and give you the skills and knowledge you need to get started in Finance and Accountancy Industry. Get a new direction for your career in Accountancy, according to statistics, the average salary for Accountants is £50,000 (Source: Reed), it is the sector where the employability rate is higher than any other sector. With the right skills and practical experience, you would be able to fast track your career in Accountancy and exactly that's where Osborne Training can fill the gap. The intensive programmes include all the skills required to fast track your career in professional Accountancy. Duration 6 Weeks Study Options Classroom Based - Osborne Training offers Daytime or Weekend sessions for Sage 50 Bookkeeping Training Course from London Campus. Online Live - Osborne Training offers online Evening sessions for Sage 50 Bookkeeping Training Classes through the Virtual Learning Campus. Distance Learning - Self Study with Study Material and access to Online study Material through Virtual Learning Campus. Certification You will receive a certificate from Osborne Training once you finish the course. You have an option to get an IAB Certificate subject to passing the exams. What qualification will I gain? You could Gain the following IAB qualifications provided that you book and register for IAB exams and pass the exams successfully: IAB Level 1 Award in Computerised Bookkeeping (QCF) 500/9405/1 IAB Level 2 Award in Computerised Bookkeeping (QCF) 500/9261/3 IAB Level 3 Award in Computerised Bookkeeping (QCF) 500/9407/5 Awarding body International Association of Book-Keepers Sage 50 accounts Course Syllabus Creating a Chart of Accounts to Suit Company Requirements Sole Trader Accounts preparation The Trial Balance preparation Errors in the Trial Balance Disputed Items Use of the Journal Prepare and Process Month End Routine Contra Entries The Government Gateway and VAT Returns Bad Debts and Provision for Doubtful Debts Stock Valuation, Stock Control, Work in Progress and Finished Goods Prepare and Produce Final Accounts Extended Trial Balance Exporting Data including Linking to Other Systems Management Information Reports Making Decisions with Reports Using Sage Prepare and Process Year End Accounts and Archive Data Final Accounts for Partnerships including Appropriation Accounts The Fixed Asset Register and Depreciation Accruals and Prepayments Cash Flow and Forecast Reports Advanced Credit Control

This one-day workshop is designed to help users work with advanced features within Word. It includes hands-on exercises to help make complex documents more manageable. Participants will learn how to share and collaborate on documents and track document changes. This course will help participants: Add document links to files, websites, bookmarks and headings Create and revise footnotes and endnotes Use cross-referencing Insert and mark a document index Use comments within a document Create and edit document templates Set up picture and table captioning Work with tracked changes, including viewing, accepting and rejecting changes Use tables of contents Transfer styles across files using styles organiser Protect and restrict the opening and editing of documents Work with document themes Work with subdocuments Use ribbon buttons and groups 1 Adding document links Adding links to a document Linking to files, websites and email Adding and linking to bookmarks Linking to document headings 2 Captioning and cross-referencing Inserting picture and table captions Creating and updating a table of figures Adding and revising endnotes and footnotes Understanding cross-reference types Creating a cross-reference Marking and inserting a document index 3 Collaborating on documents Inserting and viewing documents Navigating through comments Replying to a comment Printing comments 4 Tracking changes Using tracking changes within a document Choosing how to view document revisions Accepting and rejecting changes 5 Comparing documents Comparing two documents Combining changes into a single document Accepting and rejecting changes 6 Protecting a document Restricting opening or editing of documents Defining regions for editing Restricting document formatting 7 Outline view Collapsing paragraphs with heading styles Managing files with subdocuments Editing and locking subdocuments Sharing subdocuments 8 Document themes Standardise document formatting with themes Using a theme to match corporate branding Transferring themes across files 9 Creating templates Creating and editing document templates Adding font and heading styles to templates Defining file locations for shared templates Copying styles across templates and files 10 Customising the ribbon Customising ribbon buttons Adding new ribbons Adding buttons to ribbon groups

This one-day workshop is designed to enhance your PowerPoint skills to achieve dynamic presentations that work with you, making it easier to deliver a polished, professional presentation. You will learn advanced PowerPoint skills that will save you time and elevate your presentations. This course will help participants: Create custom shows to personalise presentations for individual clients Make the Slide Master work collectively with slide layouts and themes Seamlessly interact with external content using links Work with advanced animations and transitions, and video/audio tools 1 Themes and Masters Add a Design theme to a presentation Make changes to the Slide Master Delete layouts from the slide master Saving a slide master with themes as a template 2 Advanced graphics and diagrams Drawing, duplicating and resizing shapes Grouping, aligning and stacking shapes and graphics Using SmartArt for diagrams and organisation charts 3 Graphs and charts Inserting and formatting a chart Linking an Excel chart to a slide Linking Excel tables to a slide Animating charts 4 Video, Custom animation and Hyperlinks Adding and editing video Animating pictures and drawings Hyperlink to another Slide or Website Compressing and optimising media 5 Presenting Reuse slides Hide slides Rehearsing timings Enabling a presentation to run continuously

As technology continues to develop and increasingly interact with our daily lives, so must our sales techniques to ensure we're leveraging advances in how people do business to our advantage. It is essential for all salespeople to understand how to navigate the various tools at our disposal and grow their skills and confidence to put them into action in order to build a solid business pipeline. We have developed this programme to be practical, fun and interactive, whilst ensuring that participants will learn how to utilise new technology to their advantage, self-generate new business leads and opportunities, gain additional business and referrals from existing contacts, and save time and effort using proven business development skills. This course will help participants: Understand the 'organized persistence' model of sales prospecting Develop skills in using video, online and social media to generate interest Understand how to write effective sales and outreach emails and using online tools Develop techniques for effectively managing telephone appointments Learn ways to use LinkedIn for connecting with customers and prospects Develop networking skills and learn how to source and develop referrals and professional introductions 1 Key principles of smart sales prospecting Set your sales prospecting goals and objectives Elevator pitch, core messages and your value proposition Targeting and segmenting your market 'Organised persistence' using your CRM effectively 2 Setting appointments by telephone - planning and preparation Why calling still works and the best times to call Creating a call prompt sheet: Opening a call and taking control Giving a reason to meet Key questions to ask Overcoming the cold calling blues 3 Setting appointments by telephone - advanced skills Giving a reason to meet and 'selling the appointment' Key questions to ask that will create interest and motivation to meet Voice tone, power words, phrasing, pausing, responding Getting past gatekeepers and getting through 4 Using LinkedIn for research and follow-up Why LinkedIn matters and how to use it Finding new contacts, connecting and Inmailing Short-cuts and advanced skills 5 Email strategies that work Using AIDA and other templates for sales emails Using personalized video emails to create interest Vertical targeting emails, with examples Building awareness with an email chain

Budgeting is more than mere vague oversight. Budgeting should deliver the corporate strategy, add shareholder value and lead to a well-run business - for the benefit of all involved in it. Effective budgeting leads to real control - effective day-to-day operational control and more. This course demonstrates what proper budgeting and operational control can do. This course will help ensure that participants: Appreciate the importance of the budgeting process Take ownership of it Use it as a daily working tool - not an annual exercise - to help run their part of the operation Improve their reporting against budget Ensure their delivery against budget 1 Objectives of budgets The budget process Stages - what is the prime aim of a budget? What is forecasting? ObjectivesPlanningImplementation 2 Budget and cost control focus Choosing objectives Links with corporate strategy Links with resource management Can the accounting systems cope? 3 Traditional budgeting and control Benefits and drawbacks The process Control and feedback Reporting - what can be expected? 4 Advanced budgeting and control Understanding the business process Taking out costs Cost awareness ZBB - as valid as ever 5 Reports Reports for action The purpose of a report Content - deliverables and feedback Culture is so important

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 containsOutlineDetail 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' budgetingZero-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

This is an incredibly practical programme which has been developed to enable participants to improve their memory skills. The session focuses on specific techniques that can be used to improve retention of information. It also introduces the principles of mind-mapping By the end of this programme participants will be able to: Explain how our brain processes and stores information Describe the difference between short-term and long-term memory Use specific techniques to improve retention Explain the principles of mind mapping Be able to use mind maps to plan and order information Each participant, no matter how poor they believe their memory to be, will by the close of the session have learnt techniques that enable them to memorise 53 items in a prescriptive order - a massive boost to their confidence in their memory skills. 1 An introduction to the brain's functions Introductory brain-training How the brain works Left / right brain function Short-term and long-term memory Barriers to a good memory 2 Memory techniques Tips and techniques for improving memory Basic word association Chaining and linking Touchstone techniques Use of mnemonics Memory hooks Remembering names 3 Maximising memory Minimising barriers The importance of sleep and diet Supplements which may affect memory 4 Mind-mapping Purpose and principles Creating a mind map Use of colour to delight the eye and tickle the brain How to use the output from a map

This one-day workshop is intended for participants who have a basic understanding of Outlook but who want to know how to use its advanced features to manage their email communications, calendar events, contact information and other communication tasks. This course will help participants: Gain confidence using Outlook and its advanced features Organise and prioritise email messages Archive messages for safe-keeping Use rules to process received or sent messages automatically Manage scheduled meetings with others Give others permission to view and manage their folders and items Use contacts and commands to find out more about a person or company Prioritise work-flow using tasks and assigning tasks to others 1 Email messages Combining multiple clicks with quick steps Following up flag options Saving multiple attachments Attaching a folder of files Recalling and replacing a message Categorising messages with conditional formatting 2 Message options Adding options to messages Marking a message as private Receiving quick responses with voting buttons Directing replies to specific users Delaying sent messages Inserting links in messages 3 Stay organised with rules Using rules to automate message flow Moving messages with rules Using the rules wizard Setting up rules with conditions Using rules that work whilst you are away 4 Message clean-up Using conversation clean-up Using mailbox clean-up Moving messages to the archive folder Archiving folder properties Auto-archiving properties 5 Managing calendars Creating calendar groups Sharing calendars with permissions Setting up working days and times Managing time zones Categorise appointments with conditional formatting Publishing a calendar 6 Schedule meetings Scheduling a meeting Managing meeting responses Proposing new meeting times Adding attendees to a meeting Viewing multiple appointments 7 Using contacts Merging contacts to letters Merging contacts to labels Mail merging contacts in Word Exporting contacts to Excel 8 Managing tasks Organising your workload with tasks Categorising tasks Assigning tasks to others Sending a task status report Allocating time for tasks Regenerating a new task Viewing your tasks in the calendar 9 Adding message items Adding calendars to messages Adding business cards to messages 10 Email accounts Adding multiple user accounts Adding account permissions