• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1205 Courses in Bristol

Microsoft Access Advanced - In-company / Bespoke

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Microsoft Access Advanced - In-company / Bespoke
Delivered in London or UK Wide or OnlineFlexible Dates
£550

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Excel Macros & VBA - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£750

Level 3 Award in skills for a Workplace Health Champion

4.5(2)

By Active Lancashire

Workplace Health Champions promote healthy lifestyles and wellbeing at work by inspiring others to take a more active role in their health. Course Description This course will provide you with the knowledge and skills required to become a health champion in the workplace. Workplace Health Champions promote healthy lifestyles and wellbeing at work by inspiring others to take a more active role in their health. They can be a source of information on all aspects of health and wellbeing, signpost people to services, and support others to make positive behavioural changes. Who is the course for? Champions are individuals who are dedicated to supporting, advocating for, and implementing initiatives, and who help to overcome resistance that may occur at various levels within the workplace. Why not become a champion in supporting others.

Level 3 Award in skills for a Workplace Health Champion
Delivered in Leyland or UK Wide or OnlineFlexible Dates
£245

HG Diploma – Part 2

By Human Givens College

These two weeks of intensive training consolidate and expand upon what you’ve learnt in Part 1 of the Human Givens Diploma Length: 2 x 5 days (9.00am – 6.30pm) Tutors: Dr Gareth Hughes, Jo Baker Suitable for: See below Location: Our Part 2 courses are held in Bristol Qualification: HG.Dip. / HG.Dip.P. (Trainee) I can’t speak highly enough of Part 2. It had all the elements to make it challenging, stretching, stimulating and, above all, thoroughly practicalPSYCHOTHERAPIST Part 2 of the 3-part Human Givens Diploma course consists of ten days of highly-focused and enjoyable work, plus home study and skills practice. The two separate weeks are held approximately a month apart and include the observation of therapy sessions carried out by HG tutors with real patients. The profound teaching style and practical approach is highly stimulating and generates much extra-curricular thought and discussion. During the two weeks you will have plenty of opportunity to expand upon and consolidate the knowledge and skills you have obtained on the shorter courses that make up Part 1 of the Diploma. There are many practical group and one-to-one exercises during which you will learn how to subtly combine what you’ve learnt into powerful therapy sessions that will enable your clients to move on in their lives, and a 2-hour written examination. The psychological knowledge and psychotherapeutic skills gained on the course are also highly relevant and easily transferable to other fields such as parenting, education, business coaching and back-to-work programmes. Course Dates Part 2 courses are held in Bristol. 2024Course No. HG96 Week 1: 29th January – 2nd February 2024 – 4 places available Week 2: 4th – 8th March 2024 Course No. HG97 Week 1: 20th – 24th May 2024 Week 2: 24th – 28th June 2024 Course No. HG98 Week 1: 14th – 18th October 2024 Week 2: 18th – 22nd November 2024 VENUE: Engineers’ House, Clifton Down, Bristol, BS8 3NB Who is this course for? The HG Diploma is primarily designed for anyone already working in mental health, education or social services, but because all aspects of the course are presented in clear, jargon-free language anyone interested in the subjects covered, or wishing to embark on a career in counselling or psychotherapy for the first time, can benefit from attending. Before attending the first Part 2 week, you need to have completed all 16 x Part 1 required courses, have read the required items on the Reading List and studied the Diploma Manual in depth. NB If you started working towards the HG Diploma before January 2019, you may well have completed some of our previous free-choice Part 1 courses, don’t worry these will still count towards your Part 1 – please call the office to discuss. Meet your tutors Dr Gareth Hughes Gareth is an HG psychotherapist, researcher, nationally recognised expert on university mental health and wellbeing and a Principal Fellow of the Higher Education Academy. Read more Jo Baker For many years Jo worked as a therapist within the Psychological Wellbeing department at the University of Derby, where she dealt with an extensive and varied caseload… Read more

HG Diploma – Part 2
Delivered In-PersonFlexible Dates
£3,984

Private Banking & Wealth Management

5.0(10)

By GBA Corporate

Overview This Private Banking & Wealth Management training course is designed to give you the skills to acquire, protect/preserve, enjoy and pass on wealth. As a result, it is specifically designed for those working in the industry as well as those with an interest in investments and markets.

Private Banking & Wealth Management
Delivered in Internationally or OnlineFlexible Dates
£1,718 to £3,779

PUBLIC RELATIONS AND PROTOCOL MANAGEMENT

5.0(10)

By GBA Corporate

Overview The training objective is to build on existing knowledge of Strategic Public Relations, Apply the tactical skills required for working in Strategic Public Relations, Capitalise on developments in technology, Manage the key aspects of protocol, Learn tips, tools and techniques to arrange business travel, Meet the expectation of those involved in protocol and travel arrangements.

PUBLIC RELATIONS AND PROTOCOL MANAGEMENT
Delivered in Internationally or OnlineFlexible Dates
£1,718 to £3,779

Global Upstream Oil & Gas Operations

5.0(10)

By GBA Corporate

Overview To achieve maximum effectiveness, managers and professionals must continually expand their business knowledge and sharpen their skills. This program is designed to achieve this goal in a time-efficient manner. Integration of Downstream Refining and Petrochemicals to achieve greater efficiencies is yet another critical factor in this business which will be covered in this course

Global Upstream Oil & Gas Operations
Delivered in Internationally or OnlineFlexible Dates
£1,718 to £3,779

Microsoft Project Blue Belt 2016: In-House Training

By IIL Europe Ltd

Microsoft Project Blue Belt® 2016: In-House Training This course introduces Project Server 2016 features that expedite scheduling projects and simplify managing tasks within an enterprise environment. Learn different aspects of Project Server and their benefits to varying roles in the enterprise, and gain hands-on experience and insights on best practices from SMEs around the world. This course introduces Project Server 2016 features that expedite scheduling projects and simplify managing tasks within an enterprise environment. Learn different aspects of Project Server and their benefits to varying roles in the enterprise, and gain hands-on experience and insights on best practices from SMEs around the world. Users in Project online will get the same benefits of this program. What you Will Learn You'll learn how to: Describe the Enterprise Project Management (EPM) environment Apply the basic project management principles of, initiating, planning, executing, monitoring and controlling, and closing your project schedules Discuss new features Explain PWA views project sites Meet deadlines and budget restrictions Keep the workloads of your resources within their available limits Explain tracking methods and manage task assignments Update the schedule Differentiate between updating tasks and timesheets Use standard reports, custom views, and visual reports for your projects Recognize the potential of the Business Intelligence features Getting Started with Microsoft® Project Server 2016 Describing the EPM context Discovering Project Web App Differentiating the users of PWA Working with Project Professional and PWA Initiating Projects New projects with Project Professional, SharePoint lists, Enterprise Projects Importing schedules and managing project owner and permissions Customize the ribbon with enterprise commands Planning Projects - Scope and Schedule Management Scheduling in PWA Using the Deliverables feature Developing components of the risk management plan and issues tracking Linking planning documents Planning Projects - Staffing Management Plan Building a project team Managing resource availability Reviewing the assignment cycle Managing resource engagements Resolving resource overallocation Executing, Monitoring and Controlling Baselines Working with timesheets Reporting administrative time Tracking methods (% work, actual work, single entry mode) Assignment progress and updates in PWA Task progress and updates in Project Professional and PWA Monitor and Control Projects - Measuring Performance and Reporting Progress Reviewing performance metrics and progress reports Using the preloaded reports at the Business Intelligence Center Considerations for defining custom reports Closing Projects Reviewing the closing processes and closing tasks to updates Supporting the closing process

Microsoft Project Blue Belt 2016: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£1,495

Microsoft Powerpoint Introduction - In-company (now with live online classes)

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Getting Started with PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Powerpoint Introduction - In-company (now with live online classes)
Delivered in London or UK Wide or OnlineFlexible Dates
£550

Analysing and Designing Business system

5.0(10)

By GBA Corporate

Overview In this course, you will explore several key issues that you need to understand about the specific area. This Virtual Online course is specially designed by GBA to provide you the skills and knowledge.

Analysing and Designing Business system
Delivered in Internationally or OnlineFlexible Dates
£1,718 to £3,626