601 Finance courses in Devizes delivered Live Online

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data

This course is designed to enable learners to increase their understanding of risk assessment and risk management in Health and Social Care settings.

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will understand the programming environment of Visual Basic for applications and know how to create custom procedures and functions that can expand their ability to use Excel more effectively. This course is intended for the experienced Excel users that want to gain knowledge of visual basic for applications (VBA). Introduction to Macros Recording Macros Absolute and Relative How to Run a Macro Basics of Code Writing The VBA Environment (the ?VBE? window) Essential Tips, Tricks, Shortcuts Understanding VBA and Best Practice Crucial VBA Objects and Structures Variables and Data Types Conditionals (If, Select Case) Loops (For, Do) Interaction Interact with Data, Sheets, the Excel Application Interact with User (Message Box, Input Box) Errors Run Editing Debuging Handeling Errors Additional course details: Nexus Humans Excel - VBA Bootcamp 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 Excel - VBA Bootcamp 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.

Mercer’s Financial Education Clinic – Helping You Plan for the Future We are excited to invite you to Mercer’s Financial Education Clinic, a group session designed to help you take control of your financial future. This session will provide expert guidance on key financial topics, equipping you with the knowledge to make informed decisions about your finances. What Will Be Covered? During this session, we will explore: The importance of making a will and the potential risks of not having one The role and significance of Power of Attorney documents An overview of inheritance tax Possible planning strategies and solutions to manage estate matters effectively This interactive session will give you the opportunity to gain practical insights and ask questions to help you better understand how to plan and protect your financial legacy. Whether you're thinking about the future for yourself or your loved ones, this session will provide valuable guidance to support your estate planning journey. We encourage all employees to attend and take advantage of this valuable financial education opportunity. Session Details: Date: 12th November 2025 Time: 9:30 a.m. – 10:30 a.m. Location: Virtual

Mercer’s Financial Education Clinic – Helping You Plan for the Future We are excited to invite you to Mercer’s Financial Education Clinic, a group session designed to help you take control of your financial future. This session will provide expert guidance on key financial topics, equipping you with the knowledge to make informed decisions about your finances. What Will Be Covered? During this session, we will explore: Key steps to build a strong financial foundation early in your career Strategies for saving effectively and getting onto the property ladder The importance of starting a retirement plan early Building confidence around financial decision-making as a young professional This interactive session will give you the opportunity to gain practical insights and ask questions to help you take control of your financial future from the very beginning of your career. Whether you're just starting out or looking to strengthen your financial understanding, this session will offer valuable tips and tools to support your goals. We encourage all employees to attend and take advantage of this valuable financial education opportunity. Session Details: Date: 12th November 2025 Time: 11:00 a.m. – 12:00 p.m. Location: Virtual

This Health & Safety in the Care Sector Course works alongside, and helps, learners understand Standard 13 of the Care Certificate. This Standard touches on the legislation, policies & responsibilities relating to Health & Safety in the care sector, as well as looking at accidents and sudden illnesses.

QuickBooks for the Self Employed Course Overview This "QuickBooks for the Self Employed" course provides learners with a comprehensive understanding of using QuickBooks Self-Employed (QBSE) to efficiently manage finances, track income and expenses, and generate key financial reports. Designed for self-employed individuals, this course will equip learners with the skills to streamline accounting processes, ensuring financial accuracy and time-saving capabilities. Learners will also gain insights into setting up accounts, managing receipts, creating invoices, and preparing for tax season, all with the goal of simplifying the financial management aspect of self-employment. Upon completion, learners will be confident in using QuickBooks for tax reporting and overall financial management. Course Description This course offers a thorough exploration of QuickBooks Self-Employed (QBSE), covering key aspects of financial management tailored for freelancers and small business owners. The modules include connecting accounts, managing receipts, creating invoices, applying tax rules, and generating essential reports. Learners will delve into adding rules, creating and amending bank rules, and understanding the QuickBooks interface. Each section has been crafted to ensure learners can confidently navigate QBSE, setting them up for success in managing their finances effectively. The course also covers the integration of QBSE with QuickBooks Online (QBO), providing learners with an in-depth understanding of the software’s full potential. By the end of the course, learners will have gained the skills to manage their self-employed finances efficiently and prepare for tax season with ease. QuickBooks for the Self Employed Curriculum: Module 01: Introduction Module 02: First Account Connected Module 03: Receipts in Inbox Module 04: Adding Rules Module 05: Create an Invoice Module 06: Home Page Details Module 07: Connect Another Account Module 08: Creating Bank Rule on 070 Account Module 09: Amending the Rules Module 10: Reports Module 11: Transaction Adding – When Not on the Bank Module 12: QBSE and QBO Interface Module 13: Conclusion (See full curriculum) Who is this course for? Individuals seeking to manage their finances effectively as self-employed professionals. Professionals aiming to streamline their financial processes and reporting. Beginners with an interest in accounting software and financial management for freelancers. Entrepreneurs and small business owners looking to simplify accounting tasks. Career Path Freelance Accountant Financial Administrator for Small Businesses Self-Employed Entrepreneur Bookkeeping Assistant Tax Preparation Assistant

This course aims to provide a more in depth understanding of COSHH & RIDDOR.

Pushy boardroom bullies... battling agendas... conflicts of interest. Here are the most common drivers of trouble in the boardroom, and tools for making things right.