7080 Courses near White Colne 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

Unlock the Power of Teams: Elevate your leadership with our Building and Leading Effective Teams course. Learn the art of collaboration, communication, and synergy to create high-performing teams that drive success Course overview Duration: 1 day (6 hours) Everyone works in teams today in one way or another. Whatever we do in the workplace we need to interact with another person or a number of people at various times. It is important that we know how to communicate, how to listen, how to work together and how to overcome conflict when it arises in our workplace. Challenges are often created by a lack of trust, poor conflict handling skills, a lack of shared vision and confusion over roles and responsibilities. This course will help delegates understand how to encourage more productive team working in the workplace. By the end of the course delegates will be able to describe what makes a High Performing Team and realistically assess their current strengths and weaknesses. Delegates will also be able to identify and plan behavioural changes that will improve the team’s performance. The course is experiential based with lots of learning by doing activities, reflecting and discussion. This will allow team members to get to know/improve their knowledge of team colleagues and energise or re-energise teams. Objectives  Know more about their colleagues Be able to describe what makes a high performing team Understand the importance of playing to different strengths and skills Recognise the need for clear and effective communication Content The Importance of Team Work The importance of teamwork The ‘third dimension’ – how working together has the potential to achieve more The dangers of an overly competitive workplace culture Psychological Safety Team Development Models Stages of Team Development Behaviours at each stage Dysfunctional Teams – what does good and bad look like Characteristics of high performing and elite teams Teaming and Leadership Skills Teaming competencies Active Listening Proactive Language Values and Beliefs Building Mental Fitness of Teams Becoming an inspirational leader Establishing a climate of psychological safety Team Challenges The importance of Accountability The Team Charter Smart Teams:Building TrustBuilding CollaborationOvercoming ConflictGaining CommitmentDeveloping Shared Goals The importance of shared goals Effective Team communication

This course will explore ways to support and enhance the quality of care provided to the individual approaching end of life, their families and their carers.

An instructor-led leadership learning programme based on emotional intelligence and social neuroscience, designed to boost leadership 'PowerSkills.' A practical programme that provides leaders with a learning journey that equips them with the tools and techniques to connect, empathise, communicate effectively, build employee engagement and influence.

Total SAGE Training (Sage 50 Accounts + Sage Payroll Training) Want to open the door to working in Finance and Accountancy Industry? Starting our Total Sage Training courses will enhance your career potentials and give you the skills and knowledge you need to get started in Finance and Accountancy Industry. Total Sage Training courses are combined with Sage 50 Accounts and Sage Payroll Training. You will receive a CPD Completion Certificate from Osborne Training once you finish the course. You also have an Option to attain Certificate from SAGE(UK) subject to passing the exams. What qualification will I gain for Sage Training Courses? CERTIFICATION FROM SAGE (UK) As Osborne Training is a Sage (UK) Approved training provider, you could gain the following qualifications provided that you book and register for exams and pass the exams successfully: Sage 50c Computerised Accounting Course (Level 1) Sage 50c Computerised Accounting Course (Level 2) Sage 50c Computerised Accounting Course (Level 3) Sage 50c Computerised Payroll Course (Level 1) Sage 50c Computerised Payroll Course (Level 2) Sage 50c Computerised Payroll Course (Level 3) Level 1 Working with Sage 50 Accounts Program Basics. Creating Account names, Numbers & Bank Payments Financials Bank Reconciliations Generating Customers Invoices Monitoring Customer Activity Generating Product Invoices & Credit Notes Compiling & Sending Customer Statements Creating Customer Receipts & Purchase Invoices Supplier Payments Managing Recurring Entries Generating Reports & Information The Active Set-Up Wizard VAT Changes. Level 2 An overview of the Sage program Entering opening balances, preparing and printing a trial balance Creating customer records Creating supplier records Setting up opening assets, liabilities and capital balances, Producing routine reports Checking data, Entering supplier invoices Posting error corrections, amending records Invoicing, generating customer letters, entering new products, checking communication history Banking and payments, producing statements, petty cash Audit trails, correcting basic entry errors, reconciling debtors and creditors Creating sales credit notes, Processing purchase credit notes Preparing journals Verifying Audit Trail Purchase orders, processing sales orders Processing Trial Balance Creating Backups Restoring data Writing-off bad debts Level 3 Creating a Chart of Accounts to Suit Company Requirements Sole Trader Accounts preparation The Trial Balance preparation Errors in the Trial Balance Disputed Items Use of the Journal Prepare and Process Month End Routine Contra Entries The Government Gateway and VAT Returns Bad Debts and Provision for Doubtful Debts Prepare and Produce Final Accounts Management Information Reports Making Decisions with Reports Using Sage The Fixed Asset Register and Depreciation Accruals and Prepayments Cash Flow and Forecast Reports Advanced Credit Control

AAT Level 4 Professional Diploma in Accounting AAT Level 4 is the highest level or final stage of the AAT Accounting qualification. This qualification provides the skills necessary for a 'Finance Officer' role including the complex management accounting tasks, general management skills, drafting financial statements and specialist learning areas. This provides you with an opportunity to become a professional member of AAT and use MAAT after your name. You are also entitled to exemptions in the UK's chartered and certified accounting qualifications. Besides, if you want to pursue your career further in University, you are entitled to exemptions for up to two years in various universities in the UK. You will be awarded “AAT Level 4 Professional Diploma in Accounting certificate” from the Association of Accounting Technicians (AAT), once you have passed all the professional-level qualification exams and skill tests. Once you finish Level 4 you become a professional member of AAT and you may use MAAT after your name to stand out from the crowd as an officially Accredited Accountant. What you will gain? Here you'll learn how to draft financial statements for limited companies, perform complex management accounting tasks and develop your own management skills, perform tax calculation for business & individuals and other specialist learning areas. The Level 4 Professional Diploma in Accounting covers the following areas: Management Accounting: Budgeting Management Accounting: Decision and Control Financial Statements of Limited Companies Accounting Systems and Controls Business Tax Personal Tax

Just Grow A Pair Tackling toxic masculinity, and mental health in the workplace. Information coming soon: watch this space! Workshop outline: Details coming soon: watch this space! 2-hour workshop packages At Mindmaps Wellbeing, we know that every business is unique, and no team is the same. That’s why we’ve developed our range of short, specialist wellbeing and mental health themed workshops—a fully flexible approach to workplace training. With our selection of engaging and impactful 2-hour workshops, you can build a programme that truly meets your organisation’s needs. Whether you’re looking to manage stress, challenge stigma, or avoid burnout, you choose the sessions that suit your team best. Our training courses and workshop collection Book multiple workshops on the same day to save Why Mindmaps Wellbeing? Mindmaps Wellbeing is the trusted training provider for businesses looking to enhance workplace mental health and employee wellbeing. Our training is designed and delivered by registered Mental Health Nurses, ensuring credibility, expertise, and real-world application. Focus on culture change – Our training goes beyond theory transfer, aiming to embed lasting behavioural shifts that foster a positive, mentally healthy workplace Flexible delivery options – We offer in-person, online, and hybrid training solutions to fit your organisation’s needs Proven impact and measurable results – Our training leads to improved employee engagement, productivity, and retention Engaging and actionable – All our courses include interactive activities, case studies, and real-world applications for immediate impact Contact us for more information.

Medication Awareness training is essential in the Health and Social Care Sector. This course aims to provide learners with the knowledge required to support the use of medication in Health and Social Care settings. It provides information on the different types, classifications and forms of medication, as well as providing guidance on safe storage and disposal.

Empty Spaces, Expressionless Faces. Supporting colleagues in a hybrid workplace Dementia touches more than memory — it weaves into the lives, relationships, and wellbeing of everyone involved. This engaging 2 hour workshop dives into the types and prevalence of dementia, the daily realities for those affected, and how we can step up—individually, locally, and nationally. We’ll explore support, tackle tricky ethical questions, and break down stigma Workshop outline: Understand the types and symptoms of dementia Explore sources of support Reflect on ethical considerations Learn how to support others effectively Apply awareness in your workplace and communities Expect fresh insights, straight-talking discussions, and practical supports you can take back to your workplace. Plus, further signposting to keep your learning journey going. 2-hour workshop packages At Mindmaps Wellbeing, we know that every business is unique, and no team is the same. That’s why we’ve developed our range of short, specialist wellbeing and mental health themed workshops—a fully flexible approach to workplace training. With our selection of engaging and impactful 2-hour workshops, you can build a programme that truly meets your organisation’s needs. Whether you’re looking to manage stress, challenge stigma, or avoid burnout, you choose the sessions that suit your team best. Our training courses and workshop collection Book multiple workshops on the same day to save Why Mindmaps Wellbeing? Mindmaps Wellbeing is the trusted training provider for businesses looking to enhance workplace mental health and employee wellbeing. Our training is designed and delivered by registered Mental Health Nurses, ensuring credibility, expertise, and real-world application. Focus on culture change – Our training goes beyond theory transfer, aiming to embed lasting behavioural shifts that foster a positive, mentally healthy workplace Flexible delivery options – We offer in-person, online, and hybrid training solutions to fit your organisation’s needs Proven impact and measurable results – Our training leads to improved employee engagement, productivity, and retention Engaging and actionable – All our courses include interactive activities, case studies, and real-world applications for immediate impact Contact us for more information.

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers