600 Finance courses in Polegate delivered Live Online

Ideal for those already using Excel but who really want to get to grips with formulas and functions. Course overview Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages. It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong.  This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. Objectives By the end of the course you will be able to: Construct Formulas Use a range of common Functions Work with absolute and relative references in formulas Create percentage calculations Use named ranges in formulas Use the XLOOKUP command Create formulas with date and use date functions Use formulas in conditional formatting Use a range of Count functions Use the formula auditing tools Content Formulas vs Functions Constructing formulas Using functions Common Excel functions Using the function wizard vs the formula bar Formulas in tables Absolute vs relative references in formulas Using absolute references in formulas Using partial absolute referencing Range Naming Naming ranges Using range names in formulas Single and multi-cell ranges Working with percentages Creating formulas with percentages Percentage breakdowns Percentage increases Formatting as a percentage Using Lookups Using XLOOKUP to insert information from other spreadsheets Calculating with dates Calculating with dates Using date functions Using formulas in conditional formatting Using conditional formulas Using functions in conditional formatting Count functions COUNT COUNTA COUNTBLANK Formula auditing Using the auditing facility Tracing how formulas are made up Tracing precedents and dependants Evaluating formulas Error checking Showing formulas on a sheet

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

Advanced Microsoft Excel Training Course on Bookkeeping Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Tables and Bordering Look up References (Vlookup, Hlookup,etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis

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.

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.

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