1138 Courses in Bristol

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 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. Tailored training courses: In, in company training, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel 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

This very practical workshop has a simple objective: to help you prepare, design and deliver memorable and high-quality presentations. This programme will help you: Use a proven, structured tool-kit when designing and developing presentations Benefit from short cuts and best practice when designing and using Powerpoint presentations Select the right information, examples, exercises and activities - and use them well Prepare and structure a presentation or session appropriate to the audience, and to best achieve your objectives Maintain audience or group interest Develop and practise presentation skills to improve your voice tone, speech power and body language Use practical methods to control nerves and anxiety - develop higher levels of confidence and credibility Command a room, hold attention and create a high impact 1 Introduction Personal objectives Key messages and learning objectives of the workshop 2 Presentation skills What does good look like? Exercise: Characteristics of high/low impact presentations Presenting yourself as a 'winner' The energy / attitude model Exercise: Being a winner 3 Preparation skills - eight steps to preparing a great presentation, plus Powerpoint tips •The magic circle• How to 'assume the role' when presenting• The eight steps• Step 1 - develop your objectives- The five questions that you must answer before preparing your presentation- Defining your objectives and outcomes- Creating a first draft- Step 1 exercise• Step 2 - analyse your audience- Doing your homework: audience, event, venue- Developing a pre-event check-list- Methods and means for researching your audience- Step 2 exercise• Steps 3 and 4 - structure the main body of your presentation and state the main ideas- Ways to structure your presentation for maximum impact- Balancing and managing content and topics- Organising your information: 6 options and methods- Your 'one main point' and creating a 30-second summary- Steps 3 and 4 exercises• Step 5 - decide on supporting information, using the toolkit- Making your case convincing: ways to support your claims- Selecting and using relevant and interesting examples- Quotes, case studies and printed material- Presenting statistics, tables and graphs- Ways of maintaining visual interest- Transitions and links, creating a 'golden thread'- Step 5 exercise: Creating compelling stories and anecdotes4• Step 6 - create an effective 'opening'- Claiming the stage and creating a good first impression- The three most powerful ways of opening a presentation- The five elements of a strong opening- Step 6 exercise: Participants work individually to prepare an opening, focusing onpersonal introduction, and then deliver to the group, with structured feedback• Step 7 - develop transitions- Step 7 exercise / examples• Step 8 - create an effective close- Signalling and sign-posting; the importance of, and how to do it effectively- Five ways to close a presentation successfully- Step 8 exercise / examples• Presentation design and Powerpoint- An interactive review of participants' own real-life past presentations and advanced tipsand techniques on using Powerpoint effectively 4 Facilitation skills The three main types of group activity - triads, teams and main group How to select the right activity, define the objectives, set it up and run the debrief Using energisers - with examples Exercise: Dealing with 'difficult' behaviours Exercise: Working in triads, design and deliver 5 Tips and tricks: presentation and facilitation 10 reasons why facilitation fails Five golden rules for success Defining the session goals and the facilitation plan Open and closed questions - why and when to use Using a 'car park' to manage unresolved issues Using AV aids - tips and tricks Exercises: Including participants working in pairs to prepare a short section form of one of their own presentations 6 Putting it all together Summary of key learning points Action plan

FourSquare Training specialise in private, corporate Microsoft PowerPoint courses delivered at your premises and tailored to your needs.

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

This one-day Suicide First Aid training course gives learners the knowledge and tools to understand that suicide is one of the most preventable deaths and some basic skills can help someone with thoughts of suicide stay safe from their thoughts and stay alive.

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.

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.

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

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.

Overview This is particularly important for PPP projects where long-term commitments are made now based on bankability, value for money and risk allocation. During the course, participants will gain knowledge and skills on the frameworks, tools, and methodologies necessary to build quantitative models for financial decision-making in order to improve the financial viability and bankability of PPP projects. Participants will master modelling frameworks on capital budgeting, risk measurement, regression analysis and Monte Carlo Simulation among others.