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

5413 Courses in Cardiff delivered Live Online

Excel - Automating Excel with Macros and Analysis Tools

By Nexus Human

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 be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data. This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. Working with Multiple Worksheets and Workbooks Working with Named Ranges Link Cells Across Worksheets and Workbooks Use 3D References to Calculate Across Worksheets Consolidate Data Use Formula Auditing and Error Checking Reveal Formulas Trace Cell Precedents and Dependents Locate Errors in Formulas Watch and Evaluate Formulas Reviewing and Protecting Workbooks Control Data Entry via Data Validation Protect Workbook Access Protect Worksheets and Cell Content Add and Edit Comments Prepare a Workbook for Distribution Modify Excel's Default Settings Using Macros to Automate Workbook Functionality Create Macros via Recording Run Macros via Buttons and Shortcuts Assign Macros to the Quick Access Toolbar and Ribbon Assign Macros to Objects View Macro Code Forecasting and Analysis Data Use Conditional Formatting to Highlight, Sort and Filter Key Data Advanced Conditional Formatting using Formulas Create Sparklines to Visualise Data Add Trendlines to Charts to Visualise and Forecast Trends Use Data Tables and Scenarios to Project Potential Outcomes Use Goal Seek to Calculate Outcomes Forecast Data Trends Using Solver

Excel - Automating Excel with Macros and Analysis Tools
Delivered OnlineFlexible Dates
£197

QNUK Level 3 Award in Mental Health in the Workplace (RQF)

5.0(172)

By Comply Sense

This level 3 award training will equip you with all the tools you need to be able to understand, deal with and support people struggling with their wellness and/ or ill mental health. You will also gain 8 UCAS Points by attending this course.

QNUK Level 3 Award in Mental Health in the Workplace (RQF)
Delivered OnlineFlexible Dates
£199

Excel - Excel Essentials and Formulas

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers. Overview Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation. This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data. Getting Started with Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter and Edit Cell Data Fill Cells with Series of Data (AutoFill and Flash Fill) Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions and use Autocomplete Reuse Formulas and Functions Create an Absolute Reference Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Move and Copy Data between Cells Search for and Replace Data Use Spellcheck and Proofing Formatting a Worksheet Apply Text Formats Apply Number Formats Align Cell Contents Apply and Copy Cell Styles Apply Basic Conditional Formatting Printing Workbooks Preview and Print a Workbook Controlling Page Layout Adding Headers and Footers Set Print Titles and Print Ranges Managing Workbooks Manage Worksheets Insert and Delete Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties

Excel - Excel Essentials and Formulas
Delivered OnlineFlexible Dates
£197

Developing Numeracy & Literacy across the Curriculum

By Marell Consulting Limited

Get strategies for developing numeracy and literacy across the curriculum.

Developing Numeracy & Literacy across the Curriculum
Delivered in Birmingham or UK Wide or OnlineFlexible Dates
£297

Foundations in Palliative and End of Life Care

By M&K Update Ltd

This course provides the necessary knowledge and skills to facilitate development in palliative and end of life care.

Foundations in Palliative and End of Life Care
Delivered in person or OnlineFlexible Dates
Price on Enquiry

Informed Consent in Clinical Practice

By M&K Update Ltd

This one-day course equips you to fully understand your role in the consenting process and matters that you need to take into consideration in order for the consent to be valid.

Informed Consent in Clinical Practice
Delivered in person or OnlineFlexible Dates
Price on Enquiry

Effective Questioning

By Marell Consulting Limited

When used effectively, questioning is a useful teaching and learning strategy. During this workshop we will discuss how questioning can be used effectively to assess, challenge and stretch pupils progress.

Effective Questioning
Delivered in Birmingham or UK Wide or OnlineFlexible Dates
£297

Level 4 Award in Understanding the EQA of Assessment Processes and Practice

By White Rose Learning

Join us for this exciting online event where you can gain a Level 4 Award in Understanding the External Quality Assurance of Assessment Processes and Practice. Whether you're new to the field or looking to enhance your skills, this event is perfect for you.

Level 4 Award in Understanding the EQA of Assessment Processes and Practice
Delivered OnlineFlexible Dates
£250

Adult High Flow Nasal Oxygen Therapy for Nurses and AHPs

By M&K Update Ltd

This course provides learners with the knowledge and skills necessary to care for the adult patient requiring High Flow Nasal Oxygen (HFNO).

Adult High Flow Nasal Oxygen Therapy for Nurses and AHPs
Delivered in person or OnlineFlexible Dates
Price on Enquiry

BOHS RP402 Refresher Online - Surveying and Sampling Strategies for Asbestos in Buildings

By Airborne Environmental Consultants Ltd

P402 Surveying and sampling strategies for asbestos in buildings is the industry standard qualification for asbestos surveyors. In addition to holding the qualification, asbestos surveyors are required to undertake and provide evidence of annual refresher training.

BOHS RP402 Refresher Online - Surveying and Sampling Strategies for Asbestos in Buildings
Delivered in Manchester + 1 more or OnlineFlexible Dates
£225