2546 Courses in Birmingham delivered Live Online

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 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 classrom, one to one, tailored and bespoke courses. Tailored 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. 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

Introduction to Wound Care via ZoomJoin us via Zoom for this informative and interactive course designed for nurses, healthcare professionals, and healthcare assistants who are new to wound management in the primary care setting. This course will empower you with the knowledge and skills to confidently manage wound care for both adults and children, ensuring the highest standards of patient care in your practice.Day OneLearning Objectives:1. Develop a comprehensive understanding of wound care in the primary care setting.2. Explore the anatomy and physiology related to wound healing.3. Learn how to assess wounds, including the various stages of wound healing.4. Understand wound infections and their management.5. Familiarize yourself with wound closure techniques such as sutures, Steri-strips, and clips.6. Gain knowledge about emollients, barrier creams, and steroids.7. Discover commonly used dressings for wound care.8. Create an action plan, evaluate your learning, and access resources for further study.Day TwoLearning Objectives:1. Review the topics covered on Day One and explore wound care formularies and pathways.2. Differentiate between leg ulcers of arterial and venous origin.3. Understand exudate management in wound care.4. Learn about the theory behind compression therapy for wound management.5. Engage in case studies to apply your knowledge.6. Explore competencies that can be achieved in practice.7. Create an action plan for your next steps, evaluate your learning, and access additional resources.Learning Outcomes for Both Days:By the end of this 2-day Introduction to Wound Care course, participants will:1. Develop a solid understanding of the physiology of wound healing, including chronic venous and arterial insufficiency.2. Acquire knowledge about topical medications and emollients commonly used in wound care.3. Familiarize themselves with a range of dressings frequently employed in wound management.4. Recognize the importance of regular wound review and supervised self-management plans.5. Engage in discussions about relevant practice problems and work toward effective solutions.6. Understand the significance of ongoing professional development in wound care practice.

This is a one to one course running over five weeks, providing two hours a week of tuition on a flexible basis. The course is aimed at those keen to discover more about the practical aspect of interior design. Whether you are about to embark on a project of your own, are keen to learn more about your individual style, or are just looking to gain more confidence, this course will give you the knowledge and tools to confidently create stylish interiors.

This intensive 9 weeks Virtual Airline Cabin Crew course will give you all the information and tools you will need to become successful job candidate. 98% Employment rate after completion of the course. Virtual Airline Cabin Crew which is also known as Air Hostess, Flight Attendant and Stewardess course – Join your lesson from wherever you are.  This intensive 9 weeks Virtual Airline Cabin Crew course will give you all the information and tools you will need to become successful job candidate.   98% Employment rate after completion of the course. How will you learn? Apart of our traditional class-based tuition, we also offer Virtual Learning courses. On our Virtual (live stream via Zoom) lessons, we provide the same quality of tuition as in the classroom. You only need a laptop, PC or tablet with either built in (or external) camera and microphone. The virtual platform is very interactive with a sense of real classroom at the Academy. You will study from the comfort of your own home and communicate with your tutor and classmates via video chat (by using your phone or computer camera) and you will receive outstanding tuition, qualification, and certification. We provide A-Z guidance starting from before and after the course. Your tutor will guide you through the online course to graduation which you will be welcome to attend. What a joy it would be to meet your tutor and classmates in real life!! You will have: According to the timetable- 1 lessons per week for 9 consecutive weeks. Exams and final exam based on which the certificate will be issued. On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment.  What is Flight Attendant? Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees. A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an aircrew team , who operate a commercial, business or even military aircraft while travelling domestically or internationally.  Flight Attendant benefits: Getting paid for travelling the world Lifestyle Flexible Work Schedules Meeting Interesting People Free Food & Accommodation Excellent Compensation The uniforms Working Environment How to become successful Flight Attendant job candidate?Our Aviation Team understands each candidate who wish to become Airline Cabin Crew or start a career in Aviation. Airline companies look for individuals who share their values and can act as ambassadors for the company’s brand. Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous. Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course, your application will stand out and you can get an offer from the first round.  Student – Cabin Crew Flying Support Group As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation and recruitment, we constantly upgrading our course and going extra nautical mile to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners.  Why London Waterloo Academy? Top Airline Cabin Crew course provider in London 98% Employment rate after completion of the course Individual support on the journey from the course to a job placement With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview. We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge. Our graduates are now flying with Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviación, Air France,Titan, Norwegian B737 Short Haul and many more. We will enhance your CV Guidance through the job application process (free of charge) Gain an insight into the airline selection process and final one-to-one interview The vast global experience of our instructors This course has been developed in accordance with EASA PART-CC Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way, we give you all the tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories. Course Entry Requirements: English Language at B2 (CEFR) level or above. There are no other special requirements for this Airline Cabin Crew course. We will teach you from scratch and support after the course when applying for the job. This course has been developed for all candidates, independent of their background, wishing to start a new career.  Dates (choose one for your course): 15 May 2024 – 10 July 2024, Wednesday classes 18 September 2024 – 6 November 2024, Wednesday classes 14 November 2024 – 9 January 2025, Thursday classes Course duration – 9 weeks Classes – once a week Lesson Time – 10am to 5pm – London time Course fee – £529 (we offer flexible payment plan and accept weekly instalments) Registration fee – £300 (includes: examination, Airline Cabin Crew certificate in Current Airline Training Standards and Equipment)

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

A four-hour workshop on how to accelerate the learning and development of your Neurodiverse colleagues.

During this 2 day course, you will develop a learning-based action plan to use in your workplace ensuring that you can put the learning into action.

During this 2 day course, you will develop a learning-based action plan to use in your workplace ensuring that you can put the learning into action.

During this 2 day course, you will develop a learning-based action plan to use in your workplace ensuring that you can put the learning into action.

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 classroom, one to one, tailored and bespoke courses. Tailored 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. 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. 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