• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

3218 Accounting & Finance courses delivered Online

Financial Ratio Analysis for Business Decisions

4.7(47)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Financial Ratio Analysis for Business Decisions Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Financial Ratio Analysis for Business Decisions Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Financial Ratio Analysis for Business Decisions bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Financial Ratio Analysis for Business Decisions Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Financial Ratio Analysis for Business Decisions Career Bundle: Course 01: Financial Ratio Analysis for Business Decisions Course 02: Financial Analysis Course 03: Financial Analysis: Finance Reports Course 04: Understanding Financial Statements and Analysis Course 05: Financial Modelling for Decision Making and Business plan Course 06: Financial Modeling Using Excel Course 07: Basic Business Finance Course 08: Certificate in Business Studies Course 09: Business Administration Course 10: Diploma in Business Analysis Course 11: Business Strategy Planning Masterclass Course 12: Business Management and Finance Course Course 13: Business Performance Management Course 14: Branding Your Business Course 15: Business Law Course 16: Business Improvement Course 17: Finance Principles Course 18: Financial Advisor Course 19: Financial Investigator Course 20: Banking and Finance Accounting Statements Financial Analysis Course 21: Statistical Analysis Course 22: Finance: Financial Risk Management Course 23: Finance and Accounting Level 1 & 2 Course 24: Fundamentals of Corporate Finance Course 25: Corporate Finance Course 26: Corporate Finance: Profitability in a Financial Downturn Course 27: Corporate Finance: Working Capital Management Course 28: Cost Control Process and Management Course 29: UK Tax Accounting Course 30: Pension UK With Financial Ratio Analysis for Business Decisions, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Financial Ratio Analysis for Business Decisions today and take the first step towards achieving your goals and dreams. Why buy this Financial Ratio Analysis for Business Decisions? Free CPD Accredited Certificate upon completion of Financial Ratio Analysis for Business Decisions Get a free student ID card with Financial Ratio Analysis for Business Decisions Lifetime access to the Financial Ratio Analysis for Business Decisions course materials Get instant access to this Financial Ratio Analysis for Business Decisions course Learn Financial Ratio Analysis for Business Decisions from anywhere in the world 24/7 tutor support with the Financial Ratio Analysis for Business Decisions course. Start your learning journey straightaway with our Financial Ratio Analysis for Business Decisions Training! Financial Ratio Analysis for Business Decisions premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the Financial Ratio Analysis for Business Decisions is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Financial Ratio Analysis for Business Decisions course. After passing the Financial Ratio Analysis for Business Decisions exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Financial Ratio Analysis for Business Decisions course is ideal for: Students seeking mastery in Financial Ratio Analysis for Business Decisions Professionals seeking to enhance Financial Ratio Analysis for Business Decisions skills Individuals looking for a Financial Ratio Analysis for Business Decisions-related career. Anyone passionate about Financial Ratio Analysis for Business Decisions Requirements This Financial Ratio Analysis for Business Decisions doesn't require prior experience and is suitable for diverse learners. Career path This Financial Ratio Analysis for Business Decisions bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Hard Copy Certificate Hard copy certificate - Included If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate CPD Accredited Digital Certificate Digital certificate - Included

Financial Ratio Analysis for Business Decisions
Delivered Online On Demand
£209

Investment Banking Courses

4.9(27)

By Apex Learning

Working for one of the top investment banks can be challenging, but the financial rewards are worth it. For example, you can earn around £30,000 to £40,000 starting out as a corporate investment banker and £25,000 to £50,000 as an operational investment banker, with rapid salary progression the norm in this industry. Corporate investment bankers assist other businesses and organizations with their financial needs. Like, you might work on mergers and acquisitions, financing, or bonds and shares. You'll need to be adept at negotiating and have strong interpersonal skills, as you'll be offering strategic counsel to your clients and working under pressure. Along with this Investment Banking course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a free student ID card. Courses are included in this Investment Banking Bundle: Course 1: Investment Banking Course 2: Investment Course 3: Capital Budgeting & Investment Decision Rules Course 4: Financial Advisor Course 5: Business Analysis Level 3 Course 6: Stock Market Investing for Beginners Course 7: Budgeting and Forecasting Course 8: Team Management Course 9: Forex Trading and Analysis - Level 2 Course 10: Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 11: Business Law This Investment Banking course is going to prepare you for the following: Understand the fundamentals and more complex concepts of investment banking Identify the methods of financial modelling used in investment banking and how to build financial models Know the fundamentals of financial statement analysis and how to do financial statement analysis Appreciate the fundamentals of mergers and acquisitions, as well as how to evaluate and carry out M&A transactions Acknowledge the fundamentals of the stock and debt capital markets and how to raise money Explain the function of investment banking in the world's financial markets Address the ethical issues surrounding investment banking Realise the regulatory context in which investment banks operate Curriculum of Investment Banking Investment Banking Module 1: Introduction to Investment Banking Module 2: Structure and Side of Module 3: Valuation Methods in Investment Banking Module 4: Leveraged Buyout (LBO) Module 5: Initial Public Offering (IPO) in Investment Banking Module 6: Merger and Acquisition Module 7: Ethics in Investment Banking How will I get my Certificate? After successfully completing the Investment Banking course, you can order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF CertificateFree (Previously, it was £6*11 = £66) Hard Copy CertificateFree (For The Title CoursePreviously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Investment Banking course is suitable for the following: Individuals who are seeking to become proficient in investment banking Finance professionals who want to improve their skills and knowledge in investment banking Business owners who want to learn about raising capital for their business Individuals who are interested in pursuing a career in investment banking Professionals who are looking to improve their investment banking skills for career advancement or to increase their employability Requirements You do not need any prior knowledge or qualification to enrol in this course. Career path Career Path of Investment Banking Training Bank Manager (£24,000 to £55,000) Investment Analyst (£22,000 to £65,000) Stockbroker (£24,000 to £125,000) Financial Adviser (£23,500 to £45,000) Financial Analyst (£23,500 to £45,000) Risk Manager (£30,000 to £50,000) Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Investment Banking) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Investment Banking Courses
Delivered Online On Demand
£39

Financial Administrator

4.8(9)

By Skill Up

Enhance your knowledge of social anxiety and learn how to provide therapy in the best way possible with

Financial Administrator
Delivered Online On Demand4 hours 53 minutes
£13.59

Accounting Level 2 & 4

By Imperial Academy

Level 4 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

Accounting Level 2 & 4
Delivered Online On Demand
£135

Level 2 & 3 Investment: Investment Analyst

By Imperial Academy

Level 3 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 120 CPD Points | Lifetime Access

Level 2 & 3 Investment: Investment Analyst
Delivered Online On Demand
£100

Excel Skills for Financial Modelling

By Capital City Training & Consulting Ltd

Enroll today and gain the Excel modelling skills needed for corporate finance roles, investment analysis, business planning, and data-driven decision making.  2+ Hours of Video 4+ Hours to Complete10+ Interactive Exercises1 Recognised Certificate Course Overview Our comprehensive Excel Financial Modelling program teaches the essential Excel skills needed to build flexible and dynamic financial models. Financial modelling is a vital skill for business analysts, investment bankers, corporate financiers, and other finance professionals. Through step-by-step video lessons and over 30 hands-on exercises, this course will teach you Excel best practices to analyse financial data, forecast business performance, and evaluate strategic decisions. The self-paced online format is ideal for busy professionals looking to expand their financial analysis skillset. With over 7 hours of content, our program covers everything you need to become an expert in using Excel to build financial models.  “I was previously unsure of all the financial jargon and concepts, now I feel I have taken steps towards getting the big picture of finance. I really liked the Excel web integration!” Rachel Crawford Course Highlights Time Value of Money Principles and Calculations Net Present Value and Internal Rate of Return Metrics Calculating Averages and Statistical Measures Understanding and Measuring Financial Risk 16+ Practice Exercises and Applications Certificate Upon Successful Course Completion

Excel Skills for Financial Modelling
Delivered Online On Demand2 hours
£50

Business Finance 101

By Ideas Into Action

Business Finance 101: A Beginner’s Guide to Business Accounting and Finance   Course Description   Course Description Three are three main reasons for business failure – an under-skilled management team; ineffective marketing; and poor financial management. Every manager, or student of management, requires a good grasp of business finance. This course will help.  Business finance concerns the management of the monetary resources of an organisation. There are two aspects to this: Raising the money to invest in the business Managing that investment properly to generate a return   Raising the money is about having an attractive proposition and managing the risk to investors. Managing the investment is about the financial controls and reporting of the business. This course covers the three main financial reports; financial performance indicators; and investment analysis.  This course will give you a good grasp of the key principles and issues in business finance.     Key Learning Participants in this course will learn: The history of business accounting Why businesses fail The two main purposes of business finance and accounting The key principles of business finance and what they mean What debits and credits are The three key financial statements for an organisation What the Balance Sheet tells you What the Income Statement (also called the Profit and Loss Account) tells you What the Cashflow Statement tells you Key financial performance indicators in business Analysing business investments   Curriculum L1 What is business finance? L2 Why businesses fail L3 The Principles of Business Finance Part 1 L4 The Principles of Business Finance Part 2 L5 The Balance Sheet L6 The Income Statement L7 The Cashflow Statement L8 A Business Finance Exercise L9 Financial Performance Indicators L10 Investment Analysis L11 Investment Analysis Exercise L12 Key Learning Points in Business Finance   Pre-Course Requirements None     Additional Resources None     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Business Finance 101
Delivered Online On Demand
£5.57

Microsoft Excel Advanced

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 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

Microsoft Excel Advanced
Delivered OnlineFlexible Dates
£550

Level 3 Advanced Diploma in Accounting and Finance With Complete Career Guide Course

5.0(2)

By Training Express

The Level 3 Advanced Diploma in Accounting and Finance offers a robust understanding of financial principles and practices, designed to equip you with the essential knowledge to succeed in the financial sector. Through this course, you’ll delve into the core aspects of accounting, budgeting, and financial reporting. Whether you’re aiming for a role in corporate finance, accounting, or financial analysis, this diploma will give you a solid foundation in managing financial records and understanding complex financial strategies. With a focus on theory combined with an in-depth look at the key financial practices, this course ensures that you are well-prepared for the demands of a rapidly evolving industry. The qualification covers important topics, such as tax, auditing, financial planning, and accounting software, giving you the tools you need to navigate the ever-changing landscape of finance. If you're looking to build a successful career in finance, this course provides all the building blocks to ensure you’re fully equipped for the future. In addition, with a global demand for finance professionals, this diploma can open doors to various career opportunities within the finance sector. ________________________________________________________________________ Key Features: CPD Certified Level 3 Advanced Diploma in Accounting and Finance With Complete Career Guide 10 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Fundamentals of Financial Accounting Module 01: Introduction to Accounting Module 02: The Role of an Accountant Module 03: Accounting Concepts and Standards Module 04: Double-Entry Bookkeeping Module 05: Balance Sheet Module 06: Income statement Module 07: Financial statements Module 08: Cash Flow Statements Module 09: Understanding Profit and Loss Statement Module 10: Financial Budgeting and Planning Module 11: Auditing Finance & Investment Module 12: Introduction to Finance Module 13: Essential Skill for Financial Advisor Module 14: Financial Planning Module 15: Wealth Management and Guide to Make Personal Financial Statements Module 16: Financial Risk Management and Assessment Module 17: Investment Planning Module 18: Divorce Planning Module 19: Google Analytics for Financial Advisors ________________________________________________________________________ Complete Career Guide for Level 3 Advanced Diploma in Accounting and Finance(A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Accounting and Finance. In addition to mastering the essentials of Accounting and Finance, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in Accounting and Finance. Your dream career starts here! List of career guide courses included in Level 3 Advanced Diploma in Accounting and Finance With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Demonstrate proficiency in fundamental financial accounting principles and practices. Apply double-entry bookkeeping techniques and prepare comprehensive financial statements. Evaluate and interpret financial statements, including balance sheets and cash flow statements. Develop advanced skills in financial budgeting, planning, and risk management. Gain expertise in investment planning, wealth management, and financial advisory. Utilize Google Analytics for informed decision-making in financial advisory. ________________________________________________________________________ Accreditation All of our courses, including the Level 3 Advanced Diploma in Accounting and Finance With Complete Career Guide, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Level 3 Advanced Diploma in Accounting and Finance With Complete Career Guide, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the courses, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring accountants and finance professionals seeking advanced knowledge. Individuals interested in financial planning and wealth management careers. Those aiming to enhance their skills for financial advisory roles. Professionals looking to specialize in investment and risk management. Anyone desiring a comprehensive career guide in accounting and finance. Career path Financial Analyst - £40K to £60K/year. Certified Public Accountant - £45K to £70K/year. Investment Manager - £50K to £80K/year. Financial Advisor - £35K to £60K/year. Audit Manager - £45K to £70K/year. Certificates 10 CPD Accredited e-Certificates Digital certificate - Included 10 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

Level 3 Advanced Diploma in Accounting and Finance With Complete Career Guide Course
Delivered Online On Demand1 hour
£50

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 Macros & VBA - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£750