60273 Courses

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - USING VBA TO SOLVE BUSINESS PROBLEMS * Topic A: Use Macros to Automate Tasks in Excel * Topic B: Identify Components of Macro-Enabled Workbooks * Topic C: Configure the Excel VBA Environment 2 - AUTOMATING REPETITIVE TASKS * Topic A: Use the Macro Recorder to Create a VBA Macro * Topic B: Record a Macro with Relative Addressing * Topic C: Delete Macros and Modules * Topic D: Identify Strategies for Using the Macro Recorder 3 - GETTING HELP ON VBA * Topic A: Use VBA Help * Topic B: Use the Object Browser to Discover Objects You Can Use in VBA * Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - CREATING CUSTOM WORKSHEET FUNCTIONS * Topic A: Create a Custom Function * Topic B: Make Decisions in Code * Topic C: Work with Variables * Topic D: Perform Repetitive Tasks 5 - IMPROVING YOUR VBA CODE * Topic A: Debug VBA Errors * Topic B: Deal with Errors * Topic C: Improve Macro Performance 6 - CONTROLLING HOW AND WHEN MACROS RUN * Topic A: Prompt the User for Information * Topic B: Configure Macros to Run Automatically 7 - DEVELOPING CUSTOM FORMS * Topic A: Display a Custom Dialog Box * Topic B: Program Form Events 8 - USING VBA TO WORK WITH FILES * Topic A: Use VBA to Get File and Directory Structure * Topic B: Use VBA to Read Text Files * Topic C: Use VBA to Write Text Files 9 - USING VBA TO CLEAN AND TRANSFORM DATA * Topic A: Automate Power Query * Topic B: Transform Data Using VBA and Workbook Functions * Topic C: Use Regular Expressions * Topic D: Manage Errors in Data 10 - EXTENDING THE PROGRAMMING ENVIRONMENT BEYOND THE WORKBOOK * Topic A: Run Other Programs and Commands * Topic B: Share Your VBA Projects

LOOKING FOR: ADULT FICTION, NON-FICTION Sian Ellis-Martin joined Blake Friedmann in 2018 and is building a list of fiction and non-fiction at the agency.  With regards to fiction, Sian is looking for commercial, upmarket and accessible literary novels. She always wants to be completely absorbed by the world of the novel, to jump into the character’s life and be swept into the narrative as if she’s been there all along. She’s drawn in by compelling characters and relationships, and loves stories with a mystery or question at the heart of them. She’s open to these ideas being explored in a variety of ways, but at the moment, she’d particularly like to find an epic love story, a fun, queer rom-com with an unusual setting or pitch, and/or a sweeping family saga. She leans more towards contemporary settings but does enjoy a historical backdrop too. In non-fiction, she’s looking for narrative non-fiction, history from different perspectives and books that make complicated ideas around things like politics and literature more accessible. Her favourite type of non-fiction book is the one that makes you interested in something or someone you’d never thought you would be. She’d also love to find cookery and food books too, particularly cuisines that are less visible in the book world, or budget cooking. She’s not currently taking on YA, children’s, fantasy or science fiction projects. Sian would like you to submit a covering letter, 1 - 2 page synopsis and the first three chapters (or 5,000 words) of your manuscript in a single word document.  (In addition to the paid sessions, Sian is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk [agent121@iaminprint.co.uk] to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline 20and note that I Am In Print take no responsibility for the advice received during your agent meeting. Please prepare to submit your manuscript immediately you book as the submission deadline is now: Monday 8 July 2024

During this 12 week course you will have the opportunity to work on your own project ideas to explore your different media choices.

Duration 3 Days 18 CPD hours This course is intended for This course is designed for anyone who needs an understanding of IT Service Management to help deliver better value to customers. It is appropriate for all IT staff and management, as well as customers who work closely with IT to support business requirements. This course is also designed for students who are seeking the ITIL© 4 Foundation certification and who want to prepare for ITIL© 4 Foundation exam. Overview By the completion of this course, you will have a deep understanding of the 7 Guiding Principles, 4 Dimensions of Service Management, 34 ITIL© Practices, and the new Service Value Chain that incorporate the core of ITIL© version 4. ITIL© is the world?s leading best practice framework for implementing IT Service Management. ITIL version 4 introduces IT Service Management through the lens of a Service Value System (SVS), which provides a holistic end-to-end view of how to successfully contribute to business value, and also how to leverage concepts from models such as Lean IT, Agile, DevOps and Organizational Change Management. This foundational course immerses you in the guiding principles, dimensions, and practices of ITIL© 4. This course will earn you 21 PDUs. This class includes an exam voucher. 1 - ITIL 4 OVERVIEW * Introduction to ITIL * Key Concepts of ITIL 2 - THE ITIL FRAMEWORK * The Four Dimensions of Service Management * The ITIL Service Value System 3 - THE ITIL GUIDING PRINCIPLES * Focus on Value * Start Where You Are * Progress Iteratively with Feedback * Collaborate and Promote Visibility * Think and Work Holistically * Keep It Simple and Practical * Optimize and Automate 4 - THE ITIL SERVICE VALUE SYSTEM (SVS) * Governance * The Service Value Chain * Continual Improvement 5 - KEY ITIL PRACTICES * Continual Improvement * Service Level Management * Change Control * Incident Management * Service Request Management * Service Desk * Problem Management 6 - OTHER ITIL PRACTICES * General Management Practices * Service Management Practices * Technical Management Practices

Do you need a CSCS Card? Well you have come to the right place because here at GEM you can take your CITB Health, Safety & Environment Test at one of our CITB Test Centres across Yorkshire. You can also attend our 1 day Health and Safety Awareness and take your CITB Health, Safety & Environment Test, all on the same day, at the same venue!

Rally Navigation Training Webinar on Maps and Route Plotting, cover common techniques and lots of hints and tips.

Beginners 7 Week Quilting Course

Empowering women towards a path of heightened clarity, confidence, and unwavering belief in their vision and desired direction.

Tiny Toes Ballet offers enjoyable and inclusive dance classes for toddlers and kids in Newport, designed to nurture confidence and support development for boys and girls aged 6 months to 7 years. Through our ballet and dance programs, your child will experience the joy of dancing while developing essential skills like coordination, balance, and rhythm. Our classes also foster creativity, imagination, and self-confidence. Join us this term at Tiny Toes Ballet as we embark on summer sporting adventure in our children's ballet classes.

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 [https://www.localwineschool.com/manchester/events/professional-courses/wset-courses/wset-course-level-1-online/] 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 [https://www.wsetglobal.com/media/11718/wset_l2wines_specification_en_jun2022_issue11.pdf] for full details of the content, structure and assesment criteria. Any questions please get in touch [https://www.localwineschool.com/manchester/contact/]. 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 [https://www.youtube.com/watch?v=DarWJz6dUbU] 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 [https://www.wsetglobal.com/wset-remote-invigilation-essential-guidance/?dm_i=5G5C,KRHB,4A50QU,2G285,1] 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.