54263 Courses

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. This course will help participants: Plan and create a database Sort and filter records Use field data types Work with tables Create and manage a query Create and work with forms, and use the form wizard View, create and print reports 1 Access introduced Planning a database Creating a blank database Opening an existing database Security warnings The navigation pane Previewing database components Closing an Access database 2 Tables introduced Viewing and navigating table data Navigating using keyboard shortcuts Editing table data Adding records to tables Selecting and deleting records Finding and replacing data Filtering tables Summing table data 3 Queries introduced Opening a query in datasheet view Opening a query in design view Adding fields to a query Sorting query results Modifying datasheet view Saving and closing queries 4 Forms introduced Working with form data Sorting records Filtering records Working in design and layout views Changing object attributes 5 Reports introduced Opening and viewing reports Viewing a report in design view Previewing and printing report data Creating reports with auto report Creating reports with the report wizard Changing field attributes 6 Creating a new database Creating database tables Creating table fields Selecting field data types 7 Table relationships Introducing relationships Establishing table relationships The one-to-many relationship type Establishing referential integrity 8 Creating queries Streamline query criteria using wildcards Creating summary queries Creating queries based on criteria Running date queries Formatting field properties Building queries from multiple tables Summing in queries 9 Creating forms Creating a new form Inserting form fields Working with the property sheet The command button wizard The command button wizard Programming without typing Creating forms with embedded sub forms Creating forms with the sub form wizard Creating forms with the form wizard 10 Creating reports What are report bands? Managing report controls Basing reports on multiple tables Basing reports on queries Sorting and grouping records

Sage 50 Computerised Accounting / Bookkeeping Training - Fast Track Overview: If you're looking to gain competency in the world's most popular bookkeeping software, the Sage 50 Computerised Accounting course will teach everything you need to know, while helping you gain a recognised qualification. This course is designed to provide individuals from beginner to advanced knowledge of bookkeeping and Sage 50 accounts. It is intended for individuals who aim to improve career prospects and to be able to better financial management and control of the business. This course covers Level 1-3 of Sage 50 Bookkeeping/Accounting Training. Every business, no matter how large or small, is required by law to 'keep books'. Therefore, Bookkeepers play a vital role within organisations; ensuring records of individual financial transactions are accurate, orderly, up to date and comprehensive. If you are organised and methodical, like working through documents and enjoy seeing a set of figures add up properly, then bookkeeping is the career for you. You will receive a CPD Completion certificate from Osborne Training once you finish the course. Then, you have an option to attain a Certificate from SAGE(UK) subject to passing the exams. Level 1 Working with Sage 50 Accounts Program Basics. Creating Account names, Numbers & Bank Payments Financials Bank Reconciliations Generating Customers Invoices Monitoring Customer Activity Generating Product Invoices & Credit Notes Compiling & Sending Customer Statements Creating Customer Receipts & Purchase Invoices Supplier Payments Managing Recurring Entries Generating Reports & Information The Active Set-Up Wizard VAT Changes. Level 2 An overview of the Sage program Entering opening balances, preparing and printing a trial balance Creating customer records Creating supplier records Setting up opening assets, liabilities and capital balances, Producing routine reports Checking data, Entering supplier invoices Posting error corrections, amending records Invoicing, generating customer letters, entering new products, checking communication history Banking and payments, producing statements, petty cash Audit trails, correcting basic entry errors, reconciling debtors and creditors Creating sales credit notes, Processing purchase credit notes Preparing journals Verifying Audit Trail Purchase orders, processing sales orders Processing Trial Balance Creating Backups Restoring data Writing-off bad debts Level 3 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 Prepare and Produce Final Accounts Management Information Reports Making Decisions with Reports Using Sage The Fixed Asset Register and Depreciation Accruals and Prepayments Cash Flow and Forecast Reports Advanced Credit Control

The IMI Roadside Safety programme is a blended learning course consisting of an online learning package followed by a face to face training and assessment session. The course is aimed at Truck and Light Vehicle Tyre Technicians involved with working on the roadside and whilst not essential, we advise that candidates should have completed a recognised course in Heavy or Light Vehicle Tyre Fitting and possess good communication skills. Successful candidates will receive the IMI Quality Approved Award in Roadside Safety as well as the NTDA REACT Licence to Work on the Roadside. Course Details:  Online training program to be worked through at the candidates own pace. Up to one day training and assessment session. Course Content Theoretical Identification of essential service vehicle equipment Personal Protective Equipment to be used at the roadside The main requirements of PAS43 and the REACT licence Pre-breakdown planning and dynamic risk assessment Attending a breakdown and making the area safe Clearing up and leaving the scene safely Practical Service vehicle inspection and equipment condition reporting Simulated attendance a motorway breakdown for the purposes of making the scene safe (please note, there is no wheel removal or tyre fitting activities included in this course or test. (Please view the High Performance Car Tyre or Truck Tyre Fitting courses for this) IMI assessment and test A multi-choice theory question paper Two practical assessments, observed by an IMI approved assessor covering a service vehicle and equipment inspection and attending a simulated motorway breakdown. It is required that each candidate supply their own fully equipped service vehicle for this assessment What’s included Fully qualified and experienced trainers Online training program Examinations, Certification and REACT licence fees To find out more, please use the live chat function, visit our contact page or call us on 024 76325880

A question of trust. Leadership implies followership. And that means trust. Because who's going to follow a leader they don't trust? This programme takes a values-driven approach to leadership. It gets current and aspiring leaders to hold up the mirror to themselves and to see their reflections as leaders of people. It asks them whether what they see justifies their view of themselves as leaders. It helps them understand just what it takes to be an effective leader. And it does so in a highly practical, constructive manner. It helps the course participants to truly understand the core skills of effective leadership. It focuses on the difference between leadership and management, defining what high performing teams do and how they do it. It helps people to see their teams from different perspectives, allowing them to adapt their styles to maximise team outputs. And it explores concepts such as emotional intelligence, authentic leadership and the RAIV approach (relationships-achievement-independence-vocation) to help explore underlying values and use them to drive effective leadership. Because what worth do our values have unless we put them into practice? The course will help you:• Appreciate the key skills a leader needs to be effective• Understand what the organisation expects of you as a leader• Recognise your leadership style and the impact it has on others• Consider your role models - who inspires you?• See leadership from the 'followers' perspective - how do you like to be led?• Discover what holds you back - limiting beliefs• Examine your core values -do they support your ambition?• Explore the concept of Emotional Intelligence - how do we manage ourselves?• Discover how to lead through change• Explore the concept of 'Authentic Leadership' - consider how it can work for you• Practice some of the skills essential to motivating and influencing for success• Use the RAIV approach to generating enthusiasm and commitment• Plan how best to 'walk the leadership talk' - in your role, in your organisation Above all, this course will help you put theory into practice, values into actions, in a mature, considered, effective way. Day 1 1 Welcome and introduction Participants are welcomed to the programme and invited to share their personal objectives and people challenges Participants given an action plan template to complete throughout the workshop Participants required to bring an inspirational quote to share with the group 2 What is leadership? The concept of 'leadership' The role of a leader Skills assessment for all participants# Leadership v Management Assess your team effectiveness 3 Your leadership style Leadership questionnaire You and your role models Push v Pull styles of leadership Empowerment v Control Team goals and role profiling Day 2 1 You, the leader Your core values Your communication style Situational leadership The Emotional Bank Account Buy Me Today 2 Are you Emotionally Intelligent? (EI) What is emotional intelligence? Self-assessment exercise Manage your emotions Nine strategies for promoting EI 3 Leading through change Identify the major changes affecting you / your team Types of change The roles of resistance How safe are you to talk to? Forcefield Analysis Day 3 1 Authentic Leadership (AL) What is AL? Managing perceptions is managing their truth A leadership challenge 2 Motivating and influencing for success What motivates you? Motivational theory Leading by example Influencing skills required Influencing styles The influence challenge! 3 Creating enthusiasm and commitment The RAIV approach (relationships-achievement-independence-vocation) Building self-worth What drives your team? Your leadership legacy Your commitment to leadership

The aim of this programme is to help attendees create better quality technical documents in an organised and efficient manner. It will give those new to the topic an appreciation of how to approach the task professionally whilst those with more experience will be able to refresh and refine their skills. The programme comprises three complementary one-day modules: The programme presents a structured methodology for creating technical documents and provides a range of practical techniques that help delegates put principles into practice. Although not essential, it is strongly advised that delegates for modules 2 and 3 have already attended module 1, or another equivalent course. Note: the content of each module as shown here is purely indicative and can be adapted to suit your particular requirements. This course will: Explain the qualities and benefits of well written technical documents Present a structured approach for producing technical documents Review the essential skills of effective technical writing Demonstrate practical methods to help create better documents Provide tools and techniques for specification and report writing Review how technical documents should be issued and controlled Note: the content of each module as shown here is purely indicative and can be adapted to suit your particular requirements. Module 1: Essential skills for technical writers 1 Introduction to the programme Aims and objectives of the module Introductions and interests of participants 2 Creating effective technical documents What is technical writing? how does it differ from other writing? Key qualities of an effective technical document Communication essentials and the challenges faced by technical writers The lessons of experience: how the best writers write The five key steps : prepare - organise - write - edit - release (POWER) 3 Preparing to write Defining the document aims and objectives; choosing the title Understanding technical readers and their needs Getting organised; planning and managing the process Integrating technical and commercial elements The role of intellectual property rights (IPR), eg, copyright 4 Organising the content The vital role of structure in technical documents Deciding what to include and how to organise the information Categorising information: introductory, key and supporting Tools and techniques for scoping and structuring the document Creating and using document templates - pro's and con's 5 Writing the document Avoiding 'blinding them with science': the qualities of clear writing Problem words and words that confuse; building and using a glossary Using sentence structure and punctuation to best effect Understanding the impact of style, format and appearance Avoiding common causes of ambiguity; being concise and ensuring clarity Using diagrams and other graphics; avoiding potential pitfalls 6 Editing and releasing the document Why editing is difficult; developing a personal editing strategy Some useful editing tools and techniques Key requirements for document issue and control Module 2: Creating better specifications 1 Introduction Aims and objectives of the day Introductions and interests of participants The 'POWER' writing process for specifications 2 Creating better specifications The role and characteristics of an effective specification Specifications and contracts; the legal role of specifications Deciding how to specify; understanding functional and design requirements Developing the specification design; applying the principles of BS 7373 Getting organised: the key stages in compiling an effective specification 3 Preparing to write a specification Defining the scope of the specification; deciding what to include and what not Scoping techniques: scope maps, check lists, structured brainstorming The why/what/how pyramid; establishing and understanding requirements Clarifying priorities; separating needs and desires: the MoSCoW method Useful quantitative techniques: cost benefit analysis, QFD, Pareto analysis Dealing with requirements that are difficult to quantify 4 Organising the content The role of structure in specifications Typical contents and layout for a specification What goes where: introductory, key and supporting sections Creating and using model forms: the sections and sub sections Detailed contents of each sub-section Exercise: applying the tools and techniques 5 Writing the specification Identifying and understanding the specification reader Key words: will, shall, must; building and using a glossary Writing performance targets that are clear and unambiguous Choosing and using graphics Exercise: writing a specification 6 Editing and releasing the document Key editing issues for specifications Issue and control of specifications Module 3: Writing better reports 1 Introduction Aims and objectives of the day Introductions and interests of participants The 'POWER' technical writing process for technical reports 2 Creating better reports What is a technical report? types and formats of report The role and characteristics of an effective technical report Understanding technical report readers and their needs The commercial role and impact of technical reports Getting organised: the key stages in compiling a technical report 3 Preparing to write reports Agreeing the terms of reference; defining aims and objectives Being clear about constraints; defining what is not to be included Legal aspects and intellectual property rights (IPR) for reports Preparing the ground; gathering information and reference documents Keeping track of information: note making, cataloguing and cross referencing Tools and techniques for developing a valid and convincing argument 4 Organising the content The role of structure reviewed; some typical report structures Who needs what: identifying the varied needs of the readership What goes where: introductory, key and supporting sections Creating and using model forms: the sections and sub sections Detailed contents of each sub-section Exercise: applying the tools and techniques 5 Writing the report Planning the storyline: the report as a journey in understanding Recognising assumptions about the reader; what they do and don't know Converting complex concepts into understandable statements Presenting technical data and its analysis; the role of graphics Presenting the case simply whilst maintaining technical integrity Exercise: writing a technical report 6 Editing and releasing the report Key editing issues for technical reports Issue and control of technical reports

In a world focused on digital media, 24-hour news channels and social channels, it’s really important to communicate with your audience – there are lots of opportunities to do this if you are interviewed by journalists. There’s the chance to deliver expert comments or take part in in-depth features or give a quote about your business or organisation. The media wants to stay relevant and engaged with its audience and you can play a part in that and talk to your audience. In our Broadcast Media Training Courses, we will teach you the best ways to share your story, how to answer those difficult questions and present yourself with confidence and style. This means you will capitalise on every opportunity. Our broadcast media and media interview training courses include: Crisis Media Training Benefits  There are many reasons why businesses and organisations suddenly find themselves trending on social media or being talked about in the broadcast media. When something goes wrong, your every move is watched and then commented on online, putting you and your teams under even more pressure. So if the worst should happen and you find yourself or your company or business suddenly in the public eye, you need to be prepared. We’ll help you learn how to manage your response ensuring clarity and confidence. It’s vital you don’t leave a vacuum for others to fill so let us help you respond effectively. Why would I ever need Crisis Training? Brand reputation is the most important asset we have in the digital media age. Audiences want to engage with organisations which have credibility and authenticity. A crisis – not always of your making – can quickly undermine that if it’s handled badly. Communication is at the heart of crisis media training and we can show you how to deal with a wide range of situations, address concerns and criticism and ensure your message reaches audiences under the most pressured circumstances. Who needs to attend the training? Crisis Media Training isn’t just for the most senior CEO’s or Managing Directors. In order to support the authenticity of your response it’s important the people on the ground can talk to the public. And in the age of social media, if you’re talking to the public, you’re talking to the media. So the people dealing with the crisis are the people who should know how to communicate in a crisis. There are times when the top bosses must talk as they are accountable and are happy to demonstrate that level of responsibility. But the media will also ask to talk to the people handling the problem and we can show them how. How do I book Crisis Media Training? We can help you create the perfect training to stress test your messaging and make sure you’re ready to deliver your message if you find yourselves unexpectedly in the news. We’ll help you deal with challenging questions and diffuse the most tense of interviews. But our main criteria is that we design the training you want so we’ll work with you to create the perfect course. All you have to do is give one of our friendly team a ring on 0754 533 4269 or email us.

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

Equality is everyone’s right and everyone’s responsibility’. This training promotes the requirements of the Equality and Diversity Act. This session will strengthen understanding of Equality & Diversity.

Explore the key features of Falls Awareness including common causes of falls in care & work environment including risk assessing for slips, trips and falls and being aware issues arising from medications and illnesses that can increase risk of falls.

Power BI is a powerful data visualisation program that allows businesses to monitor data, analyse trends, and make decisions. This course is designed to provide a solid understanding of the reporting side of Power BI, the dashboards, where administrators, and end users can interact with dynamic visuals that communicates information. This course focuses entirely on the creation and design of visualisations in dashboards, including a range of chart types, engaging maps, and different types of tables. Designing dashboards with KPI's (key performance indicators), heatmaps, flowcharts, sparklines, and compare multiple variables with trendlines. This one-day programme focuses entirely on creating dashboards, by using the many visualisation tools available in Power BI. You will learn to build dynamic, user-friendly interfaces in both Power BI Desktop and Power BI Service. 1 Introduction Power BI ecosystem Things to keep in mind Selecting dashboard colours Importing visuals into Power BI Data sources for your analysis Joining tables in Power BI 2 Working with data Utilising a report theme Table visuals Matrix visuals Drilling into hierarchies Applying static filters Group numbers with lists Group numbers with bins 3 Creating visuals Heatmaps in Power BI Visualising time-intelligence trends Ranking categorical totals Comparing proportions View trends with sparklines 4 Comparing variables Insert key performance indicators (KPI) Visualising trendlines as KPI Forecasting with trendlines Visualising flows with Sankey diagrams Creating a scatter plot 5 Mapping options Map visuals Using a filled map Mapping with latitude and longitude Mapping with ArcGIS or ESRI 6 Creating dashboards High-level dashboard Migration analysis dashboard Adding slicers for filtering Promote interaction with nudge prompts Searching the dashboard with a slicer Creating dynamic labels Highlighting key points on the dashboard Customised visualisation tooltips Syncing slicers across pages 7 Sharing dashboards Setting up and formatting phone views Exporting data Creating PDF files Uploading to the cloud Share dashboards in SharePoint online