3816 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

CPD accredited Level 3 Effective Auditing & Inspection course. Delivered online (Zoom) by a live tutor. Exam and Certificate fee included in the price.

This 2 hour session will combine knowledge as well as practical interactive scenarios to work through to assist delegates in evaluating themselves to identify areas they might need to improve on.  The course will cover: * The purpose of the role (reminder) * How the role has evolved * What lessons can be gained so far * How do you create a culture of compliance * What good systems, policies and procedures look like * Easy tips on what, where and how you should be looking TARGET AUDIENCE This online course is suitable for those new to the COFA role, those supporting the COFA and for those that would like a refresher of the role and their responsibilities. RESOURCES An information pack including the course slides, scenarios and suggested answers will be provided to all delegates, which may be useful for ongoing reference. Please note a recording of the course will not be made available. SPEAKER SARAH CHARLTON, CONSULTANT, DG LEGAL [https://dglegal.co.uk/the-team/sarah-charlton/] Sarah has a BSc (Hons) in Applied Accounting and is a Fellow member of the Association of Chartered and Certified Accountants. Her career spans over 35 years working within the legal sector, fulfilling roles from COFA through to CEO. During her career she has worked with a number of legal regulators, professional bodies and government organisations. Sarah has been a member of the Institute of Legal Finance and Management throughout her career, qualifying as a Fellow member in 2005. Sarah also served as chairperson between 2010-2012 and continues to serve as an Executive Council Member.

Move from Beginner to Professional Level in Financial Modelling and Analysis with this detailed Advanced Financial Modeler Certificate Course.

A payment plan is available, please contact us for more details. WSET Level 3 in Wines Award is an advanced level qualification for professionals working in the wine industry and for wine enthusiasts. If you are looking to delve deeper into the world of wines, this qualification provides a detailed understanding of grape growing and wine making. Upon completion you will be able to assess wines accurately, and use your understanding to confidently explain wine style and quality.  What the course covers * Wine Tasting: Taste, describe and analyse wines using the WSET Systematic Approach to Tasting * Food and Wine Matching: A guide to the key considerations when matching food and wine successfully * Labelling: Learn how to decode and understand labels * Wine Production: Learn about the production factors influencing the style, quality and price of wine from vineyard to bottling * Light Wines: Learn about the styles of wines produced in the key wine regions and districts of the world: France, Italy, Spain, Portugal, Austria, Germany, Greece, South Africa, Australia, New Zealand, North and South America, England and Wales * Sparkling Wines: Learn about the methods of production and the main styles of sparkling wines from the key wine producing countries: France, Spain, Italy, Germany, New World - Australia, California, New Zealand, South Africa * Fortified Wines: Learn about the methods of production/main styles of fortified wines from the key wine countries: Spain, Portugal, France, Australia Examination: The examination is in two parts and takes place in the afternoon session of the final day of the course. The WSET Exam fee is included in the course cost. * Theory paper: a combined theory paper consisting of a 50 question multiple-choice section and a four question short answer written section. 2 hours. * Tasting: a blind tasting of two wines. A mark of 55% required in all sections to pass. 1 hour. The qualification has full accreditation from the UK Government’s Qualifications & Curriculum Authority as a Level 3 Vocational Qualification. To view the full course specification, including examples of exam questions, please click HERE.  [https://www.wsetglobal.com/media/11731/wset_l3wines_specification_en_highres_may2022_issue2.pdf] Recommended Private Study: 56 hours additional private study is recommended for this course. It is strongly recommended the majority of the private study is done in preparation for each session. Private study is essential to ensure that you are ready and prepared for the exam. Entry requirements: Although not essential, we do recommend you have completed the WSET Level 2 Award in Wines before enrolling on the course. The syllabus assumes that candidates already possess a good basic understanding of simple wine making techniques, key grape varieties and viticultural patterns. The fee of £825 includes * All WSET course materials including; 'Accounting For Style And Quality' course manual (comprehensive 250 page textbook), Study Guide and Full SAT Tasting Card * All wine tasting samples (60 to 70 wines) * The use of professional ISO tasting glasses * 6 days of professional WSET tuition by a WSET Certified tutor * Teaching of the WSET Level 3 Systematic Approach to Tasting Wine [https://www.localwineschool.com/files/pdf/wset_l3_wines_sat_en_jun-2016.pdf] (SAT) ® which will enable you to analyse wines objectively and consistently in preparation for the tasting exam * Two fully marked mock tasting exams and weekly written exam technique sessions to ensure you are fully prepared for the exam * Comprehensive student support by WSET certified educator outside of class time should you have any questions before, during and after the course * Registration with WSET and all examination fees * Internationally-recognised certificate and pin badge upon successful completion * VAT at 20%  (VAT receipt can be provided on request) Special Educational Needs Please make us aware if you have a condition that may mean you qualify for additional help during the exam such as dyslexia. Funding Funding for this course is available:  DEVELOP is the educational programme of The Drinks Trust, the drinks and hospitality industry charity. DEVELOP offers fully funded training and skills courses, delivered by industry-leading providers for people already working, or with an ambition to work, in the drinks and hospitality industry. Manchester Wine SChool has partnered with The Drinks Trust to bring courses free of charge to eligible students. All of the WSET courses are available for funding with DEVELOP. To learn more please visit the Drinks Trust website HERE [https://www.drinkstrust.org.uk/get-help/develop/our-courses/wset-level-3-in-wines] Criteria of eligibility for DEVELOP funding: must be 18 or over, eligible to work in the UK, have a National Insurance Number, and be earning less than £26k/pa

ICA ADVANCED CERTIFICATE IN MANAGING FRAUD This intermediate-level course is aimed at those already working within fraud risk management who wish to enhance their knowledge and skills as well as those who are new to the discipline. It provides a comprehensive understanding of fraud threats, how to formulate an effective strategy to prevent these threats and how to manage the response when they occur. You will learn how to implement key fraud management strategies at your firm to manage the risk to your business. The course also explores international fraud management best practice and anti-fraud frameworks. There are many benefits of studying with ICA: * Flexible learning solutions that are suited to you * Our learner-centric approach means that you will gain relevant practical and academic skills and knowledge that can be used in your current role * Improve your career options by undertaking a globally recognised qualification that hiring managers look for as part of their hiring criteria * Many students have stated that they have received a promotion and/or pay rise as a direct result of gaining their qualification * The qualifications ensure that you are enabled to develop strategies to help manage and prevent risk within your firm, thus making you an invaluable asset within the current climate Students who successfully complete this course will be awarded the ICA Advanced Certificate in Managing Fraud and will be able to use the designation- Adv.Cert(Fraud) This qualification is awarded in association with Alliance Manchester Business School, the University of Manchester. What will you learn? * International context * Global anti-fraud frameworks * Understanding risks * The 'Fraudster' * Formulating an effective counter-fraud strategy * Managing the response to fraud * The future of fraud How will you be assessed? * Assessed by a one-hour, question-based exam and one research-based assignment

This course will enable candidates to understand how to improve their handling techniques to avoid injury so it is particularly suited for those starting a new job, returning to work or who need specific manual handling training.

This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector.

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.