537 Courses in Coventry

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

The IMI PAC course in Light Vehicle Brake Fitting is 3 days in duration and is aimed at fitters who want to improve their knowledge and skills A minimum of 3 months practical experience is required as this is not an introductory course. An alternative course is available for those with no previous experience, contact us for more details Successful candidates will receive an IMI Professional Achievement Certificate in Light Vehicle Brake Fitting.  Course Details: Classroom based theory session Workshop practice session Examination and assessment Course Fees £399.00 + VAT per candidate *Please contact us for group rates  Course Content Theoretical Health & Safety Brake types (disc brake & drum brakes) Hydraulic operating systems Brake arrangements Brake valves Brake fluid Servo assistance Introduction to ABS and EPB Practical Brake pad and disc removal and re-fitting Brake drum and shoe removal and re-fitting Manufacturing a brake pipe Bleeding a hydraulic system IMI assessment and test A multi-choice theory question paper Five practical assessments, observed by an IMI approved assessor. What’s included Fully qualified and experienced trainers Course booklet Examinations Fees and Certification One year IMI membership To find out more, please use the live chat function, visit our contact page or call us on 024 76325880

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 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. 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. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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

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

Effective cross-cultural management and leadership demand an understanding of the complexities of culture from structural, political, social and psychological perspectives An intensive 3-day training course from one of the leading providers of cross- cultural leadership and management training. Designed for individuals wishing to develop and their skills in managing and leading in a cross-cultural environment. Introduction Created specifically for the cross‐cultural workplace setting and utilising a blend of interactive role play, DVD presentations and case‐study based discussion, the course provides comprehensive skills training for anyone who must manage or lead a cross‐cultural team or employees. Trainer The trainer is Tony Buon, the Managing Partner of Buon Consultancy. He is a qualified workplace psychologist with over 30 years experience . Tony has worked in over 40 countries. He is a Certified Employee Assistance Professional (CEAP) and Associate Lecturer at the Aberdeen Business School. He holds degrees in Psychology, Behavioural Sciences and Work‐ place Education and trains throughout the UK, Europe, The Middle East & Asia. Tony has worked with some of the world’s leading companies over the past 30 years including; Diageo, Dolphin Energy, DuPont, Gulf Offshore, Halliburton, Hewlett‐Packard, ICI, ING Group, Kuwait Petroleum, Lend Lease, McDonalds, National Australia Bank, PetroChina, Pfizer, Qatar Petroleum, Royal Bank of Scotland, Shell, 3M, Coca Cola and Microsoft. He was also the senior consultant to the Sydney 2000 Olympic Games. Tony has also been interviewed in publications as diverse as Rolling Stone and the Reader’s Digest. He has appeared on CNN, BBC, Trans‐World Sport and many international television and radio stations. The Course The world of business has no borders. Nationalisation, globalisation and the growth of multi‐national corporations introduces challenges which managers and leaders must address. Effective cross‐cultural management and leadership demand an understanding of the complexities of culture from structural, political, social and psychological perspectives. The aims of the course are to explore the meaning and psychology of culture; to understand the impact of culture on management and leadership; to identify the areas in which cultural differences present a challenge in managing and leading employees in a multicultural environment; and finally to become more self ‐aware in cultural understanding, individual biases and assumptions and to understand the implications these have on our work. A vital course for any manager or leader work‐ ing in a multi‐cultural environment Covers the managerial, social and psychological aspects of culture Develop your cross‐cultural leadership & management skills in a fun and informative environment Discover best‐practice in diversity management and cross‐cultural communication Appreciate current business issues related to managing and leading in a cross‐cultural environment Comments from previous participants: “ ...one of the best courses I have ever attended!”“ I can’t believe how much I learnt. As an experienced expat, I thought I knew it all, this course truly expanded my people management skills”“ “...the trainer was excellent and the individual feedback and advice fantastic”“ This course will make me a better HR Manager, I have new skills I can use every day in dealing with all staff globally”   This course can be conducted on-site at your location for groups of up to 15 participants The Objectives By the end of the course, the delegates will be able to: Illustrate examples of stereotypes and stereotyping Formulate a business case for cultural diversity in their workplace List Hofstede’s five value dimensions Explain in his/her own words the meaning of each of the five value dimensions Evaluate the risks involved in international assignments The Delegates All supervisors, middle managers , department heads and senior managers Human resource personnel including HR Business Partners All staff interested in developing cross‐cultural skills The Benefits Appreciate the importance and meaning of culture Learn about the psychology of culture Develop your cross‐cultural leadership & management skills Discover how to manage and lead diverse employees in a multi‐cultural environment Appreciate current issues in international business related to managing people The Course Day 1: The Meaning and Psychology of Culture Our world today ‐ the importance of demographics Dimensions of culture Hofstede’s five value dimensions Workplace and organisational culture Stereotypes and stereotyping Cross‐cultural communication Body‐language and culture Day 2: Managing and Leading Diverse Employees Developing a global mindset Culture and strategy Managing in multi‐national companies Multi‐cultural teams and teamwork International assignments and global career development Culture shock and global working Culture and decision‐making

The IMI Motorcycle Tyre Fitting course is 3 days in duration for and is aimed at Fast Fit Technicians and Specialist Tyre Fitters involved with working on Motorcycle Tyres. Candidates must have a minimum of 3 months practical motorcycle tyre fitting experience.  Successful candidates will receive an IMI Quality Approved Award in Motorcycle Tyre Fitting recognised throughout the industry. A basic tyre fitting course can be provided for those with little or no experience. Course Details: One day classroom based theory session One day workshop practice session One day examination and assessment Course Fees £396.00 + VAT per candidate Please contact us for group rates Course Content Theoretical Health & Safety Motorcycle Tyre construction identification Motorcycle Wheel rim identification MotorcycleTyre sidewall markings Construction & Use regulations Limits of wear and serviceability Fault identification methods Tyre and inner tube repairs Practical Tyre fault identification and reporting Safe wheel removal and replacement Safe wheel balancing Safe removal and replacement of tyres Safe tyre and inner tube repairs to BSAU159g IMI assessment and test A multi-choice theory question paper Four practical assessments, observed by an IMI approved assessor. What’s included Fully qualified and experienced trainers Course booklet Examinations Fees and Certification One year IMI membership To find out more, please use the live chat function, visit our contact page or call us on 024 76325880

The NVQ Level 3 is designed to provide both new entrants and those seeking progression in their career, with the opportunity to develop the necessary skills to carry out job roles and responsibilities associated with the installation and maintenance of Electrotechnical systems. The EWR is for electricians who have been working in the industry for at least 5 years but have not formally completed an industry apprenticeship or Level 3 NVQ qualification. Successful completion of the NVQ and AM2 assessment will satisfy the entry criteria for JIB accredited Gold Card status. Bear in mind that the C&G 2391-50 and 18th Edition courses are pre-requisites to the Experienced Worker route. In case you don’t hold them, we can help you with a Pre-Experienced Worker Route package.

This Level 3 Course is a full 3 day first aid at work course which is designed to help higher risk organisations. We can come nationwide or you can come to us.

We deliver Workplace PAT Testing Courses across most of the UK to assist businesses with Compliance. We also work with Bridges into Work and ReACT in association with Careers Wales and the Welsh Government to offer work based skills which some Candidates could be eligible for Government funding.

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