- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
An M.D.D coach will come to you Six friends group discussion 2 hours snacks and drinks / a bottle of wine/champagne A discussion about dating problems q and a dating tips This package is great for a group of friends that would like some tips and a fun evening at home Price on application https://relationshipsmdd.com/product/group-package/
Alcohol consumption (In-House)
By The In House Training Company
Who says what's right for you? How aware are you of how much you actually drink each week? Is it more than you want it to be? Does it take the edge off your performance? Or do you just think it's time to change? This session will challenge the way you think about drink. It's not about what someone else thinks you ought to drink - it's about your own attitude to it. Take away a completely fresh way of thinking about drinking. Get some insights into 'how come' you drink what you do. Find out what you can easily do to drink less. During the session you will have the opportunity to take a fresh look at: Your drinking habits - casual/social drinking, habitual drinking, binge drinking 'How come I do this'? How we think about habits 'How could I change my drinking'?
Microsoft Excel Macros & VBA - In-company
By Microsoft Office Training
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 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. 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. Certificates Certificates Certificate of completion Digital certificate - Included
Microsoft Excel Advanced - In-company
By Microsoft Office Training
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
Online Options
Show all 45ONLINE - WSET Level 2 Award in Wines - Evenings
By Manchester Wine School
The WSET Level 2 Award in Wines has full accreditation from OfQual as a Level 2 Vocational Qualification. Through a combination of tasting and theory you will explore the factors that impact the style and quality of wine and learn how to describe wines with confidence. Course Schedule: The 8 x 2-hour online sessions on - What the course covers Wine tasting: You will learn how to taste and describe wines using the WSET Systematic Approach to Tasting (SAT) Food and wine pairing: You will learn the principles of food and wine pairing Wine service and storage: You will learn the correct way to store and serve wine and how to recognise common faults found in wine Labelling: You will learn how to decode and understand wine labels Factors influencing the style of wine: You will explore how environmental factors, grape-growing, vineyard and maturation options influence the style and quality of the wines made all over the world Grape varieties: You'll learn about the styles of wines produced by the key international red and white grape varieties (Chardonnay, Pinot Grigio, Sauvignon Blanc, Riesling, Cabernet Sauvignon, Pinot Noir, Merlot and Syrah/Shiraz) as well as the styles of wines made with 22 regionally important grape varieties grown in 70 wine regions (GI's) around the world Sparkling and Fortified wines: You will be taught how grape varieties and winemaking processes influence the style of wines in these two key wine categories. No prior wine knowledge is required however the course builds upon the WSET Level 1 Award in Wines course. It is not essential to complete Level 1 to join the Level 2 course but if you are a complete begineer you may wish to consider this option. We recommend you read the course specification document HERE for full details of the content, structure and assesment criteria. Any questions please get in touch. Course delivery The Level 2 Award in Wines online course covers the same syllabus as the classroom course and is delivered in LIVE interactive online lessons by one of our certified wine educators This course includes 16 hours online tuition in 8 x 2hr sessions and we recommend a minimum of 12 hours additional study Your tutor will give you a guided tasting of 12 wines on this course (for details of how to order the wines see below) You will receive access to practice multiple-choice revision questions specific to this course - FREE OF CHARGE Please note a reliable broadband connection is essential for the completion of this online course as are basic computer skills. Examination To obtain the WSET Level 2 Award in Wines Qualification, you will need to successfully pass the exam. The exam is made up of 50 multiple-choice questions to be completed in 1 hour. A mark of 55% is required to pass the exam. The exam is taken online via a Remote Invigilation service giving you the flexibility to take the exam at a time and date of your choice. More details will be sent upon registration. Please ensure you read the information HERE if you wish to take the exam online. Whats included All WSET course materials posted to you at no extra charge including: Looking Behind the Label course manual, Study Guide, specification and SAT Tasting Card LIVE virtual interactive sessions taught by a Local Wine School WSET Certified Tutor Exclusive access to practice multiple choice questions provided FREE OF CHARGE WSET exam fee Remote Invigilation service Internationally recognised WSET qualification, certificate and pin for those who pass the exam VAT at 20% (VAT receipt can be provided on request) Course Wines It is recommended that at least 12 wines are tasted as part of this course, although this is optional and the cost of wines is not included in the course fee above. Our wine experts have specially selected wines for this course designed to demonstrate specific learning outcomes. We have negotiated a discounted price only available to our online students. Details of how to order your case of wines will be provided when you book your place. The cost is approx £150 including VAT and delivery. Wine preservation advice is give so that after each tasting exercise you can reseal and return to the wines over the coming days. Special Educational Needs Please make the school aware if you have a condition which may mean that you will qualify for additional help during the exam such as dyslexia. Important dates Registration deadline: please book at least 5 days before the start of the course, to allow time to send materials and order the tasting wines.
WSET Level 2 Award in Wine Online - 8 Evenings
By Thames Valley Local Wine School
This beginner to intermediate level qualification course provides a structured exploration of the world of wine and is suitable for both wine industry professionals and wine enthusiasts. Individuals on this course will gain knowledge of the principal and regionally important grape varieties of the world and the styles of wine they produce. Through a combination of tasting and theory, candidates will explore the factors that impact style and quality and learn how to describe wines with confidence.
Description Wine Consultant Diploma Irrespective of whether you wish to become a certified wine consultant or simply wish to learn which wine is to be served when at parties thrown at your house; our Wine Consultant Diploma is the best method to adopt. Learning the different varieties of wine available, the numerous rules to be followed when tasting and serving and understanding how to appreciate wine can seem like an insurmountable task. Knowing the proper wine to choose for any situation can help you well in life. If you wish to make your dinner party a flawless success or impress someone on the first date or even suggest a good wine to go with your customer's meal, knowledge of wine appreciation is vital. Do not shrink away from any situation where the topic of wine comes up. Educate yourself with the knowledge needed to either impress friends or foray into a new fun-filled and exciting career. When you enrol with our Wine Consultant diploma course online, your education is completely in your control. You can complete your coursework from the comfort of your home. Do you wish to learn more about wine? Enrol with our online Wine Consultant Diploma now. What you will learn 1. Types of wine 2. Relishing the taste buds 3. Grape varieties 4. Wine names and label lingo 5. Navigating a wine shop 6. Confronting a restaurant wine list 7. Opening a wine bottle 8. Champagne and other sparklers Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.
ONLINE - WSET Level 1 Award in Wines - Evenings
By Manchester Wine School
The WSET Level 1 Award in Wines is the ideal starting point for anybody new to wine or those beginning a career in wine or hospitality. It lays the foundation for understanding wine, giving you confidence for food and wine pairing and an introduction to different wine styles. What the course covers: The basic skills and product knowledge required for the service and retail of wine The main types and styles of wine Common wine grapes and their characteristics How to make food and wine pairings How to store and serve wine How to taste and describe wine using the WSET Level 1 Systematic Approach to Tasting Wine®(SAT) The WSET Level 1 Award in Wines has full accreditation from OfQual as part of the UK Government’s Qualifications & Credits Framework as a Level 1 Vocational Qualification. We recommend you read the course specification document before you sign up for the course. Course delivery The Level 1 Award in Wines online course covers the same syllabus as the classroom course and is delivered in LIVE virtual lessons by one of our certified wine educators The course includes 6 hours online tuition in 3 x 2 hour sessions Your tutor will provide a guided tasting of 6 wines with you on this course (for details of how to order the wines for your course see below) You will receive access to practice multiple-choice revision questions specific to this course You will be sent details of how to join your LIVE sessions when you book Please note a reliable broadband connection is essential for the completion of this online course as is basic computer skills. Examination To obtain the WSET Level 1 Award in Wines Qualification, you will need to successfully pass the exam. The exam is made up of 30 multiple-choice questions to be completed in 45 minutes. You must answer at least 70% correctly to pass the exam. The exam is taken online via a Remote Invigilation service. We will arrange a suitable time/date for you to take your exam when you are ready to do so. Please ensure you read the information HERE if you wish to take the exam online. The course fee includes: Course study guide, posted to you at no extra charge LIVE virtual, interactive sessions taught by a Local Wine School WSET Certified Tutor Exclusive access to practice multiple choice questions Registration with WSET and all examination fees Remote Invigilation service *Please note there are some minimum system requirement (contact us for more information) Internationally recognised WSET qualification certificate and pin for those who pass the exam VAT at 20% (VAT receipt can be provided on request). Course Wines: It is recommended that 6 wines are tasted as part of this course, although this is optional and not essential to complete the course. Please note that the cost of wines is not included in the course fee above. Our wine experts have specially selected wines for this course aligned to demonstrate specific learning outcomes. They have even negotiated a specially discounted price only available to our online students. The price of the 6 bottle case around £75.95 including delivery. Details of how to order your case of wines will be provided when you book your place. Special Educational Needs Please make the school aware if you have a condition that may mean that you will qualify for additional help during the exam such as dyslexia. Important dates Registration deadline: please book at least 5 days before the start of the course, to allow time to send materials and order the tasting wines.
Waiter and Concierge - QLS Diploma Level 3 & 4
By Imperial Academy
Level 3 & 4 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access
French Cooking Training course is structured into ten detailed modules, each focusing on a specific aspect of French cooking. Starting with an introduction to the fundamental concepts, you will then explore various domains, including French breakfasts, sauces, appetisers, soups, main dishes, desserts, cheese and wine, advanced cooking techniques, baking, and fish recipes.
Embark on a culinary journey like no other with our 'French Cooking Delights: Mastering the Art of French Cuisine' course. Delve into the heart of French gastronomy and let your passion for cooking flourish. Whether you're an aspiring chef or simply a food enthusiast, this course is your gateway to unlocking the secrets of French culinary excellence. Our meticulously crafted curriculum, spanning ten modules, covers everything from the basics of French cooking to advanced techniques, ensuring you become a maestro in the kitchen. Unveil the magic of French breakfasts, craft classic French sauces with finesse, and master the art of preparing delectable appetizers and soups. Elevate your culinary repertoire with exquisite French main dishes and sumptuous desserts. Delight in the world of French cheese and wine pairing, and challenge your skills with advanced cooking methods. Dive into the art of French baking, and explore a variety of fish recipes that will leave your taste buds longing for more. Learning Outcomes Master the foundational principles of French cooking. Create a delightful French breakfast spread. Craft classic French sauces to perfection. Prepare an array of appetizers, soups, and main dishes. Develop expertise in French desserts, cheese, wine, and advanced cooking techniques. Why buy this French Cooking Delights: Mastering the Art of French Cuisine? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the French Cooking Delights: Mastering the Art of French Cuisine there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this French Cooking Delights: Mastering the Art of French Cuisine for? Aspiring chefs and culinary enthusiasts. Home cooks eager to elevate their skills. Food bloggers and writers seeking culinary knowledge. Professionals in the food and hospitality industry. Anyone with a passion for French cuisine.. Prerequisites This French Cooking Delights: Mastering the Art of French Cuisine does not require you to have any prior qualifications or experience. You can just enrol and start learning.This French Cooking Delights: Mastering the Art of French Cuisine was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Sous Chef: £25,000 - £35,000 per annum Pastry Chef: £22,000 - £30,000 per annum Food Critic: £25,000 - £45,000 per annum Restaurant Manager: £25,000 - £40,000 per annum Catering and Event Coordinator: £20,000 - £30,000 per annum Food Writer and Blogger: £18,000 - £35,000 per annum Course Curriculum Module 01: Introduction to French Cooking Introduction to French Cooking 00:09:00 Module 02: French Breakfast French Breakfast 00:18:00 Module 03: Classic French Sauces Classic French Sauces 00:12:00 Module 04: French Appetisers and Soups French Appetisers and Soups 00:12:00 Module 05: French Main Dishes French Main Dishes 00:14:00 Module 06: French Desserts French Desserts 00:14:00 Module 07: French Cheese and Wine French Cheese and Wine 00:06:00 Module 08: Advanced French Cooking Advanced French Cooking 00:10:00 Module 09: French Baking French Baking 00:14:00 Module 10: Various Fish Recipes Various Fish Recipes 00:10:00
No-Code Machine Learning Using Amazon AWS SageMaker Canvas
By Packt
This AWS SageMaker Canvas course will help you become a machine learning expert and will enhance your skills by offering you comprehensive knowledge and the required hands-on experience on this newly launched cloud-based ML tool, by solving real-time industry-based projects, without needing any complex coding expertise.
Fine Chocolate Tasting Discovery Experience - Group Tastings In Person
By Kathryn Laverack
Chocolate is the new wine! Learn to how to taste and identify fine chocolate with Chocolate Educator and International Chocolate Judge Kathryn Laverack. Book a tasting experience for your team or friends and family.
