50593 Courses delivered Online

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

Use the features in project to report effectively on your plans. Course overview Duration: 4 hours Our Project – Reporting course is aimed at experienced users of Project who need to create reports in their project plans. It looks at using the different types of report in Project, exporting data to other packages, building new reports and sharing reports between projects. Experience of using Project to create and resource plans is required. Objectives  By the end of the course you will be able to: Print and PDF data from your project Use timelines Setup filters and groups Import and export data Create and share dashboard reports Content Printing and reporting Setup and Printing Creating PDFs Visual reports Using the Timeline Filtering and grouping Applying filters Applying grouping Creating your own filters and groups Importing and exporting data Importing data into Project Exporting data Creating and saving data maps Dashboard reports Using dashboard reports Creating dashboard reports Adding widgets Customising data shown

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.

This short course introduces staff to a range of hazardous substances, the risks and controls available, and what to expect from a control of substances hazardous to health (COSHH) assessment. It prepares them to contribute to the safer use of hazardous substances in their workplaces. 1 Definition and types Defining what constitutes a substance hazardous to health in the workplace Outlining the various types of hazardous substances 2 Health effects Exploring the health effects caused by exposure to hazardous substances Routes of entry - exploring how substances can enter the body and methods of prevention 3 Data COSSH register Data sheets Risk assessments Control options 4 Responsibilities An overview of the responsibilities imposed by the Control of Substances Hazardous to Health Regulations 2002

This comprehensive one-day programme has been designed to provide participants with an overview of basic supply chain principles and concepts and to identify potential opportunities for reducing costs, minimising risks and adding value across the supply chain. This could include reducing inventory, procurement, transport and storage costs. Fundamentally, the object of the programme is to empower participants to be able to collaborate with all key stakeholders across the supply chain. This course will help participants: Appreciate the importance of the supply chain as a source of competitive advantage Understand the tools and techniques available to improve supply chain performance Analyse and mitigate risks across the supply chain Identify opportunities for improvements in their respective supply chains Demonstrate competence in the pro-active management of the supply chain

This course looks at the key processes in supply chains and how they interact; the most common supply chain terms and how they are utilised to describe supply chain activities. It will cover the definitions of transport modes and how to select the most appropriate one; the role of logistics partners in the extended supply chain and the definition and use of Incoterms. PARTICIPANTS WILL LEARN HOW TO: Explain the term “Supply Chain” Define main activities in Transport & Freight Management Describe the key principles of Warehousing Interpret INCOTERMS COURSE TOPICS INCLUDE: Freight terminology & global trade terminology Warehouse, logistics and transport operations Transport modes Parties involved in international shipments INCOTERMS Freight calculations

ACCA Qualification is designed to provide the accounting knowledge, skills and professional values which will deliver finance professionals who are capable of building successful careers across all sectors, whether they are working in the public or private sectors, practicing in accounting firms, or pursuing a career in business. The ACCA Qualification is your route to professional status. Making a decision to study ACCA courses at Osborne Training will be one of the biggest decision you would make for your career. Assessment is by external examination. You must pass all the exams to be ACCA qualified. Once you finish all exams successfully, you will be awarded with ACCA certificate. Paper F1 Accountant in Business Paper F2 Management Accounting Paper F3 Financial Accounting (INT) Paper F4 Corporate and Business Law (UK) Paper F5 Performance Management Paper F6 Taxation (UK) Paper F7 Financial Reporting (INT) Paper F8 Audit and Assurance (INT) Paper F9 Financial Management

Your grumpiest customers can become your biggest advocates if you solve their problems quickly, effectively and permanently. We supply the top tips for dealing with tricky customers so your teams can create positive outcomes from every interaction with some simple techniques that make a difference to relationships straight away. Bespoke courses include: Customer needs and expectations Communication styles and how to influence them Assertiveness The 4 psychological fears Dealing with difficult customer behaviour The power of your behaviour Five steps to customer problem solving

Understanding cultural differences in the global sales environment is critical to your salespeople’s success. Developing their intercultural communication skills and knowledge of the sales and negotiation techniques of different cultures and nationalities, will help them to ensure relationships are as effective and rewarding as possible. Bespoke courses include: The impact of language and cultural differences on the sales environment Communication techniques in international sales Effective sales questions A global mindset Culture and its impact on sales Delivering on different cultural expectations Perceptions of time across cultures and the impact on sales cycles and timelines

This intensive course equips senior management with the knowledge and skills to develop a logistics strategy that will consistently support business objectives. PARTICIPANTS WILL LEARN HOW TO: Understand the concept of integrated logistics. Critically analyse and evaluate logistics operations. Apply solutions to problems in line with global best practices. Devise and operate effective performance measures. Learn how to create performance improvement plans. Understand how to support inbound and outbound logistic activities. COURSE TOPICS INCLUDE: Mission, strategy and policies for logistics Costs of non-performance and poor performance Logistics planning Land, air and marine transport services Materials storage, preservation and handling Waste management services HSSE policies Sustainable logistics and transport Risk management in logistics Management controls Performance measurement Sustainability