927 Courses in London

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

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

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 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 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 and Business Intelligence. 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

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. Tailored in company 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

Personal Tax Return and Self Assessment training Course Most self-employed people and directors of companies have to do submit a Tax Return every year. If you are a self-employed person you may learn how to do tax return yourself. As a result, you can save money by not having to pay an external agent. Don't forget You can also save more money as you will know more about how to apply for a tax rebate. According to statistics, more than 60% of taxpayers not sure how to do tax return correctly and lose money for not knowing how to apply for a tax rebate correctly. If you want to offer tax services to the general public, then skills in this sector can dramatically improve your job prospect or business prospect. How to do a tax return Firstly, you need to be registered with HMRC to process your tax return. You should get a UTR (Unique Tax Reference) no, which is your personal identification no for tax purpose. Once you have details for all incomes and expenditure, you can submit them electronically to HMRC. The deadline for submitting a personal tax return is 31 January for the previous tax year. Apply for a Tax Rebate It is possible that you could be eligible for a tax rebate. The most possible scenarios are When you pay more tax than required Submitting an incorrect tax return Claiming special Tax relief There could be many more reasons why should you get a tax refund. It is vital to know the scenarios under which you should apply for a tax rebate. Identify the type(s) of returns that may be completed Understand the duties and responsibilities of a bookkeeper / tax agent when completing self-assessment tax returns Calculating the taxes on profits for Self Employed & on income for Employed individuals Understanding differences between Drawings & Dividends Introduction to UTR and NI Classes Understanding Tax Return submission procedures to HMRC (using 2 individual Scenarios) Analysing Class 2 & Class 4 NIC Analysing Personal Allowance Analysing Income from Self Employments Employment benefits Analysis Analysis of Car & Fuel benefits Analysis on savings and investment income and tax implications on them. Introduction to Capital Gains Tax analysis Introduction to Inheritance Tax Analysis Understanding the procedure for payment and administration of both tax and National Insurance Contributions

A step-by-step guide for Dragon users.

If you want to improve your or your team ability to resolve and reduce conflicts, feel free to check out my Training course focusing on conflict resolution.

Every relationship has its ups and downs, but sometimes these become too difficult for a couple to manage on their own… Accredited CPD Certificate: 6 hours Length: 1 day (9.15am–4.00pm GMT) Probably the best couples therapy training course I have ever attended. Very full, hugely informative contentWELLBEING OFFICER, SOLENT MIND Live training delivered online – Attend Jennifer Broadley’s online training masterclass live online on Tuesday 21st May 24 via Zoom. The content covered is the same as her attended workshop with a few modifications to some of the exercises, and you will have plenty of opportunities to ask questions. All you need is a quiet place to watch, a computer or tablet and a strong internet signal, the rest is easy – simply book your place as normal, and we will email you details of how to join the Zoom workshop. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. Why take this course Relationship issues are one of the most common causes of emotional distress – and often the reason people seek help. A solid understanding of why difficulties arise, and what can be done about them, is extremely useful therefore for all caring professionals, not just those working with couples. Drawing on pioneering research, Jennifer Broadley’s one-day couples counselling course gives you this important knowledge, along with a range of strategies and proven tips for working effectively and ethically with more than one client. She shares the practical guidelines and skills she has acquired over many years of successfully helping couples using the human givens approach to build and maintain supportive and mutually rewarding relationships. Presented without psychobabble, and making good use of insightful case histories, Jennifer demystifies an area of counselling that many find daunting or fear is complicated. The day covers: the most effective ways to help and build rapport with couples in conflicted relationships; the sex differences in processing emotions; non-blame talking styles; the long-term impact of parenting; past conditioning, including psychological traumas, that can give clues about why difficulties arose; and what we can learn from the way successful couples facilitate mutual needs satisfaction. Well worth attending – and the money. I'm going back refreshed and well resourced, with lots of new skills and strategies to try.PSYCHOTHERAPIST What will you learn Essential skills for building and maintaining rapport with two emotionally-aroused people Ways to encourage both partners to engage in solving their difficulties How to teach non-blaming communication skills and explain the differences in male and female behaviour to clients What to do if one or even both parties are having an affair How to deal with issues specific to couple counselling, such as confidentiality The key points you need to bear in mind when working with more than one client at a time How to structure effective therapy sessions and goal setting with two people Effective ways to help each partner begin to cooperate in helping the other get their emotional needs met The key ingredients for a healthy and mutually rewarding relationship An insight into the many common relationship problems – and how to help clients overcome them (illustrated with case histories) Tips and techniques for staying objective and empathetic, whilst calming your clients’ high emotional arousal How to recognise and interrupt disruptive behaviour patterns How to use Solution Focused Questioning to initiate change How to manage setbacks and keep the partners motivated How to tell when the relationship isn’t the problem – and what to do about it How to use Guided Imagery with two people Information regarding the latest research into effective couples therapy How early life experiences can influence our relationships, and what to do about this now Creative ways to develop effective interventions, including using tasks and metaphor Asperger’s syndrome – how to work with couples if one or both show Asperger traits, a common cause of relationship problems Considering the wider picture, including other family members Course notes, Accredited CPD Certificate and more… Course Programme The ‘Couples therapy – a practical masterclass’ counselling course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am What predicts relationship stability and fulfilment? 11.00am Comfort break and discussion 11.30am Building empathy, how to use RIGAAR™ 1.00pm Lunch break 1.45pm Structuring therapeutic interventions, establishing goals, and moving forward 2.45pm Comfort break and discussion 3.00pm Valuing the bigger context 4.00pm Day ends Who is this course suitable for? Anyone considering working therapeutically with couples Psychotherapists and counsellors already working with couples who would like additional insights, tools and strategies to use Anyone involved in mental health or whose work involves dealing with couples or families, including: social workers, psychologists, teachers, GPs and health visitors Anyone who is interested in learning solution focused, brief therapy interventions, working from the human givens approach, to facilitate a rapid process of change for couples in distress Anyone wanting to overcome their own insecurity in a relationship or to learn more about the myriad dynamics that come into play in relationships will benefit from the information given on this course. Please Note This course is not a substitute for therapy.

Overcome social awkwardness and social anxiety the fast, fun and easier way. DO YOU find yourself drying up or going blank when under pressure, or get tongue-tied when someone makes a smart remark? One of the reasons that you dry up or get tongue-tied – is because you are programmed to go into your head and try to think of something to say. Most of us have become left-brain dominant because of the way we’ve been educated and we don’t know how to activate our powerful and more creative right-brain. This is why the "I Don't Know what to Say" Improvisation Course is so effective at overcoming social difficulties. It gives you access to your spontaneous right-brain, and in fact, enables you to operate from both right and left-brain together. It is probably one of the fastest and most effective ways of building verbal confidence as well as liberating you on all sorts of levels.

If you want to improve your or your team ability to have the best approach to personal development, feel free to check out my Training course focusing on continuous improvement.