910 Basic courses in London

Your puppy training journey can begin before you even bring your puppy home. By ensuring you have the basics covered such as puppy crate training and puppy toilet training, you can start your journey off with your puppy in the best possible way.    Focusing on you and your puppy outside of a group class setting, in a 1-2-1 puppy training session, can be really useful for you and your puppy. We can focus on specific goals you may have, from teaching a puppy a new game such as retrievals or flirt pole, to training for specific situations such good puppy manners when guests come to our house. 1-2-1 puppy training sessions are typically 1 hour. Training can be carried out in your home/ garden or out at an agreed location, such as a local park, if suitable for you and your puppy goals. I am also happy for you to travel to me to train your dog at an agreed location. 1-2-1 puppy training prices: 1 hour = £60, including follow up report. Pre-arrival session= £30 (half hour) (Longer sessions can be arranged by agreement, priced on an individual basis.) Above prices are based on Dog Training being in and around Bishop's Stortford (IE Sawbridgeworth, Much Hadham, Little Hallingbury, Harlow, Puckeridge, Standon, Manudon), I am happy to travel, subject to agreed travel costs.

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

Code the Hangman Game in a few hours, in our Taster Java Hangman Code course Basics made simple! Learn plenty in one day and apply techniques to a game by coding The Hangman Game. Get to know what is Java coding. Will you enjoy a coding career? Or for coders, simply fast-track crossing over to Java.

Powerful 1-hour Python workshop course understand Python Basics. Practical. Instructor-led. Online. Learn to code a Password Validator in 1 hour. 

Total SAGE Training (Sage 50 Accounts + Sage Payroll Training) Want to open the door to working in Finance and Accountancy Industry? Starting our Total Sage Training courses will enhance your career potentials and give you the skills and knowledge you need to get started in Finance and Accountancy Industry. Total Sage Training courses are combined with Sage 50 Accounts and Sage Payroll Training. You will receive a CPD Completion Certificate from Osborne Training once you finish the course. You also have an Option to attain Certificate from SAGE(UK) subject to passing the exams. What qualification will I gain for Sage Training Courses? CERTIFICATION FROM SAGE (UK) As Osborne Training is a Sage (UK) Approved training provider, you could gain the following qualifications provided that you book and register for exams and pass the exams successfully: Sage 50c Computerised Accounting Course (Level 1) Sage 50c Computerised Accounting Course (Level 2) Sage 50c Computerised Accounting Course (Level 3) Sage 50c Computerised Payroll Course (Level 1) Sage 50c Computerised Payroll Course (Level 2) Sage 50c Computerised Payroll Course (Level 3) 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

Sage Line 50 Accounting / Bookkeeping Training - Fast Track 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 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. What qualification will I gain? You have the choice to gain certification from one of the following awarding bodies. CERTIFICATION FROM SAGE (UK) As Osborne Training is a Sage (UK) Approved training provider, you could gain the following qualifications provided that you book and register for exams and pass the exams successfully: Sage 50c Computerised Accounting Course (Level 1) Sage 50c Computerised Accounting Course (Level 2) Sage 50c Computerised Accounting Course (Level 3) 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

Nowadays not only do we rely on our commercial and sales staff to hit that bottom line but we expect our engineers and project teams to play their part too - not only through their engineering and management skills but by behaving in a commercially minded way in their dealings with their counterparts in customer or supplier organisations. This means understanding, amongst other things, the issues surrounding the commencement of work ahead of contract, having a clear contract baseline, recognising the broader implications of contract change, the need for timeliness and the consequences of failing to meet the contracted timetable. This practical one-day programme has been designed specifically to give engineers, project staff and others just that understanding. The course is designed principally to provide engineers and project staff with an appreciation of contractual obligations, liabilities, rights and remedies so that they understand the implications of their actions. It is also suitable for business development staff who are negotiating contracts on behalf of the business. The main focus of the day is on creating an awareness of when a situation may have commercial implications that would harm an organisation's business interests if not recognised and handled appropriately and how taking a positive but more commercial approach to those situations can lead to a more positive outcome for the business. As well as providing an understanding of the commercial imperatives the day also focuses on specific areas affecting engineers and project staff, such as the recognition and management of change, the risks when working outside the contract and managing delays in contracts. The course identifies the different remedies that may apply according to the reasons for the delay and provides some thoughts on pushing back should such situations arise. On completion of this programme the participants will: appreciate the need for contractual controls and will have a better understanding of their relevance and how they can be applied, particularly the issues of starting work ahead of contract, implementing changes and inadvertently creating a binding contract by their behaviour; have gained an understanding of the terminology and procedural issues pertaining to contracting within a programme; and be more commercially aware and better equipped for their roles. 1 Basic contract law - bidding and contract formation Purpose of a contract Contract formation - the key elements required to create a legally binding agreement Completeness and enforceability Express and implied terms Conditions v warranties The use of, and issues arising from, standard forms of sale and purchase Use of 'subject to contract' Letters of intent Authority to commit 2 Change management Recognising changes to a contracted requirement Pricing change Implementation and management of change 3 Key contracting terms and conditions By the end of this module participants will be able to identify the key principles associated with: Pricing Getting paid and retaining payment Cashflow Delivery and acceptance Programme delaysExamining some reasons for non-performance...Customer failureContractor's failureNo fault delays ... and the consequences of non-performance: Damages claimsLiquidated damagesForce majeureContinued performance Waiver clauses and recent case law Use of best/reasonable endeavours Contract termination 4 Warranties, indemnities and liability Express and implied warranties Limiting liability 5 Protection of information Forms of intellectual property Background/foreground intellectual property Marking intellectual property Intellectual property rights Copyright Software Confidentiality agreements Internet

In today's competitive business world firms are under unprecedented pressure to deliver value to their shareholders and other key stakeholders. Senior executives in all parts of the organisation are finding that they need some degree of financial know how to cope with the responsibility placed on them as business managers and key decision-makers; monitoring and improving business performance, investing in capital projects, mergers and acquisitions: all require some degree of financial knowledge. The key financial skills are not as difficult to learn as many people believe and in the hands of an experienced senior executive they can provide a formidable competitive advantage. After completing this course delegates will be able to: Understand fundamental business finance concepts; understand, analyse and interpret financial statements: Profit Statement, Balance Sheet and Cashflow Statement Understand the vital difference between profit and cashflow; identify the key components of working capital and how they can be managed to generate strong cashflow Evaluate pricing decisions based on an understanding of the nature of business costs and their impact on gross margin and break-even sales; managing pricing, discounts and costs to generate strong business profits; understand how lean manufacturing methods improve profit Use powerful analytical tools to measure and improve the performance of their own company and assess the effectiveness of their competitors Apply and interpret techniques for assessing and comparing investment opportunities in capital projects, business acquisitions and other ventures; understand and apply common methods of business valuation Understand the role of business finance in formulating and implementing competitive business strategy; the role of budgeting as part of the planning process and the various approaches to budgeting and performance measurement 1 Basic principles Delivering value to key stakeholders Accounting concepts, GAAP, IFRS and common terms Understanding and using the balance sheet Understanding and using the profit statement Recognising the vital difference between profit and cashflow Understanding and using the cashflow statement What financial statements can and cannot tell us 2 Managing and improving cashflow Sources of finance and their advantages and disadvantages What is working capital and why is it so important? Managing stocks, debtors and creditors Understanding how working capital drives business growth Understanding and avoiding the over-trading trap Unlocking the funds tied up in fixed assets: asset backed loans and leasing 3 Managing and improving profit Understanding how profits generate cashflow The fundamental nature of costs: fixed and variable business costs Understanding gross margin and break-even How common pricing methods affect gross margin and profit Effective strategies to improve gross margin Using value chain analysis to reduce costs Lean manufacturing methodsUnderstanding Just-in-time, 6 Sigma and Kaizen methods Improving profitEffective and defective strategies 4 Measuring and managing business performance Measures of financial performance and strength Investor behaviour: the risk and reward relationship Return on investment (ROI): the ultimate measure of business performance How profit margin and net asset turnover drive return on net assets Why some companies are more profitable that others Understanding competitive advantage: cost and differentiation advantage Why great companies failWhat happened to Kodak? Using a 'Pyramid of Ratios' to improve business performance Using Critical Success Factors to develop Key Performance Indicators 5 Budgeting and forecasting methods Using budgets to support strategy Objectives and methods for effective budgets Using budgets to monitor and manage business performance Alternative approaches to budgeting Developing and implementing Balanced Scorecards Beyond Budgeting Forecasting methods and techniques Identifying key business drivers Using rolling forecasts and 'what-if' models to aid decision-making

At some point in your life you will have attended a training course or workshop, but what happens when you are asked to deliver one? Some people relish the opportunity while others are challenged by it. Whatever you feel about training others, it is a skill that is admired and can be studied and learned. With the trainer you will be learning the techniques, skills and understanding you need and you will have the chance to deliver a short training session to others, receive feedback and having the confidence to deliver it for real in your job. The training will comprise one day followed by a half day when all those able to attend will deliver and have feedback on a 20 minute training activity. To be able to create and maintain an environment conducive to learning and engagement To understand basic learning theory and practice and the difference between training, facilitating and learning To understand how adults learn and how to apply it as a trainer To be able to plan and deliver a training activity using the appropriate set of skills and behaviours To be able to review and evaluate learning and identify how outcomes are met To manage the learning process and the participant engagement in the training environment To be able to present effectively and appropriately to a variety of audiences To deliver and receive feedback on a short delivered training activity with peers To review and evaluate learning and have an action plan to take back and put into practice DAY ONE (full-day) 1 Welcome, housekeeping, how the day will be run Introductions (and making the most of them) Warm up - breaking the ice followed by review and feedback Creating an environment conducive to learning and engagement; managing expectations well as a trainer Group task with feedback and review in plenary 2 What is training and how do adults learn? Trainer input: David Kolb's Learning Cycle Group tasks 3 How to plan a session and what to include - trainer input Starting at the end and working backwards Linking outcomes to purposeful activities Practice task and planning time for day two using a template 4 The skills and behaviours of a brilliant trainer Modelling skills and behaviours Creative task and discussion 5 Mini reviewing task De-brief - using reviewing in training 6 How to manage the process Trainer input followed by practice Paying conscious attention to language (verbal and non verbal), feelings and responses in the room and managing yourself as a trainer 7 The trainer's toolkit #1 Key tools, materials and templates Choosing different tools and approaches with different audiences Know your audience 8 The trainer's toolkit #2 Key tools, materials and templates continued Addressing trainer good practice 9 Review, evaluation and action planning activities Why and what should we be evaluating and why it's important Action planning task Group review task DAY TWO (half-day) The day will comprise a series of 30 minute timed sessions where each delegate will present and deliver a training activity with the group. The training activity will be prepared and planned in advance and will take 20 minutes (+ or - 2 minutes) to deliver in real time. This will be followed by review and feedback from the trainer and peers to complete the total of 30 minutes as a time slot. Reiteration of the task and discussion can take place with the trainer if needed, and there is time included in Day One to support the training planning.

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups