2544 Courses in Nottingham 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 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

Duration 2 Days 12 CPD hours This course is intended for Delegates should be PC literate, i.e., familiar with PC'S/Laptops and have used a mouse and keyboard; be able to launch and close programs; navigate to information stored on the computer; manage files and folders and be comfortable using Microsoft Office applications such as MS Excel, MS Word etc. Overview The purpose of this course is to provide delegates with the practical skills to build and manage project schedules. It is designed to provide techniques and tips that will help users of the software apply it as a powerful tool to develop competent and unambiguous schedules - while avoiding some of the traps associated with the incorrect application of scheduling features. Techniques learned will also facilitate communicating deliverables and milestones to project stakeholders. This course covers management practices and methodologies and an in-depth knowledge of MS Project functionality. Delegates will be able to create and manage project schedules during the course and reinforce attained skills through practical applications. Project Management Overview Concepts of project management and scheduling The project lifecycle and phases Fundamental importance of defining ? and agreeing ? project scope Developing a Work Breakdown Structure (WBS) to define project scope 4 steps to create a schedule based on the WBS Understanding task dependencies Understanding the concept of the project baseline Developing a Project Schedule Setting the ?Scheduling Mode? Creating Tasks, Recurring Tasks (e.g. progress or review meetings) and Milestones Defining task Dependencies Applying Lag and Lead Time Working with the Critical Path Managing Tasks in the schedule Add Notes and attach project documents to tasks Setting and removing task Constraints and Deadlines Applying the ?Task Path? feature to view dependencies Working with Resources Creating a Resource Pool Working with Resource Calendars Creating Team/Group Calendars Understanding Effort Driven and Non-Effort Driven scheduling Assigning Resources to tasks Working with Project Costs Managing Project Information Applying Field, Tables and Views Applying Filters and Groups Creating custom Fields, Tables and Views (Drop-down menus, Traffic Light reports, Flag Fields) Using the ?Organiser? feature for customised elements Communicating Project Information Applying formats to Views and Tables Using the ?Copy Picture? command Create and Print Project Reports Exporting to Excel Managing Resources Finding Resource Overallocations Resolving Overallocations (reassigning, splitting tasks, utilising float, changing work contours) Applying Resource Levelling features Tracking Progress Setting the Project Baseline Applying the Tracking Gantt and Tracking Table Using the ?Mark on Track? and ?Update Tasks? features Working with Dashboards and Burndown Reports Programme Management Methods to consolidate multiple Project Files Resource sharing - setting up a Master Resource Pool Creating and managing Master Project Files

Duration 1 Days 6 CPD hours This course is intended for The audience for this course includes software developers and data scientists who need to use large language models for generative AI. Some programming experience is recommended, but the course will be valuable to anyone seeking to understand how the Azure OpenAI service can be used to implement generative AI solutions. Note Generative AI is a fast-evolving field of artificial intelligence, and the Azure OpenAI service is subject to frequent changes. The course materials are maintained to reflect the latest version of the service at the time of writing. Azure OpenAI Service provides access to OpenAI's powerful large language models such as GPT; the model behind the popular ChatGPT service. These models enable various natural language processing (NLP) solutions to understand, converse, and generate content. Users can access the service through REST APIs, SDKs, and Azure OpenAI Studio. In this course, you'll learn how to provision Azure OpenAI service, deploy models, and use them in generative AI applications. Prerequisites Familiarity with Azure and the Azure portal. Experience programming with C# or Python. 1 - Get started with Azure OpenAI Service Access Azure OpenAI Service Use Azure OpenAI Studio Explore types of generative AI models Deploy generative AI models Use prompts to get completions from models Test models in Azure OpenAI Studio's playgrounds 2 - Build natural language solutions with Azure OpenAI Service Integrate Azure OpenAI into your app Use Azure OpenAI REST API Use Azure OpenAI SDK 3 - Apply prompt engineering with Azure OpenAI Service Understand prompt engineering Write more effective prompts Provide context to improve accuracy 4 - Generate code with Azure OpenAI Service Construct code from natural language Complete code and assist the development process Fix bugs and improve your code 5 - Generate images with Azure OpenAI Service What is DALL-E? Explore DALL-E in Azure OpenAI Studio Use the Azure OpenAI REST API to consume DALL-E models 6 - Use your own data with Azure OpenAI Service Understand how to use your own data Add your own data source Chat with your model using your own data Additional course details: Nexus Humans AI-050T00: Develop Generative AI Solutions with Azure OpenAI Service training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the AI-050T00: Develop Generative AI Solutions with Azure OpenAI Service course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Supercharge your skills and career and learn in-demand knowledge needed to build business intelligence dashboards. This beginner to intermediate level course will introduce you to all the Power BI technologies i.e. Power Query, DAX, Data Modelling (Power Pivot), M, types of visualizations, etc.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for customer service professionals with any level of experience who want to expand their knowledge, improve their skill set, and increase the understanding of customer benefits. Overview In this course, you will explore the background and techniques of customer interactions. You will: ?Describe the benefits of customer service, identify internal customers, identify the benefits to you of giving good customer service, and identify how you can help your company to excel. ?Identify the major trends in customer service today and the combination of criteria required for customer satisfaction. ?Identify the benefits of bringing respect, emotional support, and a personal touch to customer interactions, and apply the personal touch to customer interactions. ?Identify the six categories of face-to-face communication, the critical success factors in face-to-face communication, and the benefits of actively listening to your customers. ?Identify remote customer service communication channels and apply remote customer service best practices. ?Identify guidelines for handling unreasonable customers, explore ways to handle angry customers, and identify guidelines for handling unhelpful colleagues. ?Take action to increase the loyalty of the customers you serve. You will also identify guidelines for dealing with moments of truth, identify the benefits of customer complaints, identify the steps in the service recovery process, and analyze the moments of truth in a real-life situation. As a customer service representative, you are expected to handle customer interactions in the best way possible. The expectations of both your company and your customers hinge on your ability to provide the right service in the right way. In this course, you will explore the background and techniques of customer interactions. Providing quality customer care ensures that every single contact with your company is a positive experience. Customers can range from external consumers to internal employees in other departments. Knowing how to provide the same level of service to all customers will enrich your time spent at work by establishing positive business relationships. Recognizing crucial points throughout customer interactions increases your ability to solve problems and offer affirmative solutions. Applying this knowledge to trends in service and consumer desires allows you to contribute to the company?s bottom line and make a customer?s life a little easier. 1 - Understanding Customer Service Describe Customer Service Benefits Recognize the Importance of Internal Customer Service Identify How Customer Service Benefits You Excel with Customer Service 2 - Identifying How Customers Define the Success of Your Company Recognize Trends in Customer Service Identify Criteria for Customer Satisfaction 3 - Increasing Customer Satisfaction Identify Characteristics of the Personal Touch Create Lasting Positive Impressions on Your Customers 4 - Providing Face-to-Face Customer Service Identify Categories of Face-to-Face Contact Understand the Critical Success Factors in Face-to-Face Customer Service Identify the Characteristics of Active Listening 5 - Providing Remote Customer Service Identify Remote Customer Service Communication Channels Apply Remote Customer Service Best Practices 6 - Engaging Difficult Customers Serve Difficult Customers Manage Angry Customers Deal with Difficult or Unhelpful Colleagues 7 - Increasing Customer Loyalty Optimize Moments of Truth Recognize the Value of Customer Complaints Identify the Stages of the Service Recovery Process

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

The course will increase participants knowledge relating to how drugs work, potential risks and hazards associated with medicines, and provide an overview of the legal and professional aspects of medicines management.

The main subject areas of the course are: Legislation and guidance for asbestos practitioners. The properties of asbestos and health effects of exposure to asbestos fibres. The types of asbestos and its uses in buildings. The types of asbestos surveys. The asbestos register, risk assessment and management plan. Asbestos remediation. The role of asbestos analysts and laboratory procedures.

SEO Description: Elevate the standard of health and safety in your care home with our comprehensive 3-hour CPD Care Home Legionella Management Course. Specifically crafted for care home professionals, this online course empowers facility managers, maintenance teams, and health and safety officers with essential skills and knowledge to manage legionella risks effectively. Aligned with HSE ACOP L8 guidelines, the course offers in-depth learning about prevention, assessment, and control of legionella in care environments. Gain a CPD Certificate upon completion, showcasing your commitment to upholding the highest standards in care home safety. Join our expert-led live sessions for a practical and engaging learning experience, ensuring your care home remains a safe and compliant haven for residents and staff.

Resilience is the ability to take the challenges and changes of life in your stride and say yes to the opportunities that excite you.