4895 Courses delivered Live Online

Ensure you can fully utilize this powerful tool to create a range of flowcharts and diagrams. Course overview Duration: 1 day (6.5 hours)  Microsoft Visio is a powerful tool designed to simplify complex information through the creation of simple, professional-looking diagrams. While Visio is capable of producing almost any type of drawing this training concentrates on flowcharts, swim lane process diagrams and organisation charts. You will also discover the real power of Visio by adding essential data to the content of your diagrams and producing reports in Excel using this data. This course is designed for either new users of Visio or those who have dabbled and can create basic diagrams. Our course will give you the skills and knowledge you need to navigate your way around this powerful program and produce different types of diagram. Objectives  By the end of the course you will be able to: Create and amend flowcharts Create cross functional (Swim Lane) process flows Produce organisation charts by importing data Add essential data to shapes Export diagram data reports to Excel Present, publish and print Visio diagrams Content Visio essentials Finding your way around Visio Using the ribbon and Quick Access toolbar Keyboard shortcuts Shapes and stencils explained What Visio can do for you Creating basic flowcharts Working with shapes Adding and deleting shapes Joining, aligning and sizing shapes Using Auto-Connect Labelling shapes and connectors Editing and improvinC flowcharts Amending shape and connector labels Using colours to emphasise Changing line styles Moving and copying objects Grouping diagram elements Quick ways of working Cross functional flowcharts Creating Cross-Functional Flowcharts Manipulating functional bands Creating off-page references within diagrams and hyperlinks to other documentation Organising charts and shape data Using the wizard to create an organisation Chart Importing existing Data into to create an organisation chart Modifying an organisation chart Shape Data Adding shape data to a shape Creating shape data sets Diagram reports Exporting data to a report in Excel Exporting to HTML Creating and customizing reports Presenting, publishing and printing Using Page Setup Print previewing Embedding backgrounds Adding headers and footers Converting your final documentation to PDF Saving as HTML Visio with PowerPoint

If you are a Mental Health First Aider or MHFA Champion you have skills for life that support you and the people around you. We believe that mental health should be treated equally to physical health - and just like physical first aid, Mental Health First Aid training should be kept up to date. The four-hour MHFA Refresher course will empower you to: Keep your awareness of mental health supports current Update your knowledge of mental health and what influences it Practice applying the Mental Health First Aid action plan Outline About mental health Stress and factors that influence mental health Mental health continuum and stigma Frame of reference and non-judgement Reintroducing ALGEE Warning signs of mental ill-health Depression and anxiety Suicide and first aid for suicidal crisis Psychosis and first aid for severe psychotic episodes Practising our MHFA sills Self-care, wellbeing and recovery

If you're looking for a short, sharp high-impact intervention that will help motivate and inspire your sales team then a 'bite-sized' session could be just what you're looking for. We have a range of sessions that can be delivered on an 'off-the-shelf' basis, or they can be tailored to your specific requirements or, of course, we can develop something specifically for you on an entirely bespoke basis. And the length of the session is entirely up to you - 45-minutes, an hour, a half-day - whatever you prefer. Sessions can be run for small groups as part of your regular team meetings or they can be delivered for larger audiences, conference-style - the choice is yours. The session outlines below are just to give you an idea of the possibilities. If one of them whets your appetite please just give us a call on 01582 463463 to talk through what we can do for you - we're here to help!

This course will provide the key to successful inventory management, by combining practical inventory control techniques with sound procurement practice, to produce a solid foundation to enable your supply chain to meet customer expectations at the lowest possible cost. PARTICIPANTS WILL LEARN HOW TO: • Understand the role of inventory in an effective supply chain. • Understand categories of stock and how to tailor stockholdings. • Learn how to utilize key concepts, variables and metrics that allow for effective management of inventory. • Understand how product demand and product lifecycle are connected to inventory management. COURSE TOPICS INCLUDE: • Demand Characteristics and the Product Life Cycle • Push and pull systems • Demand forecasting • Categorisation of stock • ABC Analysis • Economic order quantity and minimum order quantity • Safety stock and stock cover • Materials requirements planning (MRP) • Stock replenishment systems • The cost of managing stock

This foundational course will help all managers better understand what a procurement function does, including the processes, tools and techniques it employs to reach its goals and how it measures its business performance. PARTICIPANTS WILL LEARN HOW TO: Explain the contribution of procurement to the overall business objectives. Explain the added value that can be obtained by a business when it manages its procurement activities efficiently and effectively. Understand the complex activity of procurement and the challenges it presents for risk management. Develop good quality procurement practices that will manage the expectations of all stakeholders Identify methods by which a procurement function can be measured and performance monitored. Perform contract management activities. Understand ways in which improvements might be identified and implemented. COURSE TOPICS INCLUDE: Procurement and business objectives Stakeholder Management Commercial Specifications Whole Life Costing Targeted procurement Procurement planning Supplier Appraisal and selection RFQ & ITT & Evaluation Contract Management

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

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

The core principles gained from this course will help delegates have a better understanding of how to manage the relationships between sales and marketing stakeholders on the demand side and the manufacturing and other operational stakeholders on the supply side. PARTICIPANTS WILL LEARN HOW TO: • Take a different perspective on traditional data such as sales history and forecasts, as well as time-phased inventory projections and production capacity. • Recognise how their forecasts impact manufacturing schedules and inventory levels. • Assess whether they are producing enough products to meet sales demand. • Recognise how production is tied to finance and see the financial impact of production decisions, so appropriate adjustments may be then undertaken. COURSE TOPICS INCLUDE: What is S&OP? – Introduction – Definition and benefits S&OP processes – What information is required? – The stages of the S&OP process (including inputs & outputs) The integration of S&OP into a business – Critical success factors for an effective implementation – Typical roles and responsibility matrix

This foundational course will help all managers to better understand what a supply chain is and how their roles impact and interact with, their end-to-end supply chain process. PARTICIPANTS WILL LEARN HOW TO: • Understand the role of the supply chain within the wider business context • Become aware of the fundamental trade-offs in the supply chain (e.g. supply chain cost vs service level, efficiency vs flexibility etc.) • Understand the importance of supply chain planning and be able to identify its key components • Develop awareness of the key challenges in modern inventory management and distribution; become familiar with tested practices that allow responding to these challenges • Understand the meaning of essential supply chain terminology • Understand how supply chain performance affects company financial results COURSE TOPICS INCLUDE: • What is supply chain management? Why is it important? • The importance of cost versus service • Purchasing and procurement • Manufacturing processes • Demand management • Warehouse and inventory management • Logistics and transport • Risk management

Learn how to use OneNote to create, organize and populate electronic notebooks. Course overview Duration: 4 hours OneNote is a digital notebook and can be a great way to easily take notes. Whether for meetings, on training courses or to help with to do lists. It works very much like it’s paper copy equivalent but, of course, with lots of enhanced features. Its integration with Outlook and the other office applications means you can easily take notes and link them to documents meeting details and then email them out. You can even add audio and video notes as reminders. Objectives  By the end of the course you will be able to: Create and manage notebooks Add contents Tag and prioritise content Create notes from other applications Create To Do Lists and integrate into Outlook Content Using OneNote Creating notebooks Creating sections and pages Formatting pages Using page templates Creating page templates Reordering sections and pages Deleting sections and pages Creating OneNote content Adding text Bullet lists Adding tables Adding images Adding drawings Adding links Adding audio and video notes Tagging Tagging Creating custom tags Creating to-do lists Searching and filtering for tags Notes Creating quick notes Filtering them in OneNote notebooks Linked notes Outlook integration Linking to tasks in Outlook Flagging notes for follow up Inserting Outlook meeting content Taking minutes Emailing OneNote pages Send emails to OneNote