25360 Courses delivered Online

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 classroom, 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. 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. 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

This Diploma in Health and Social Care - Level 3 qualification (Accredited by Qualifi, UK) has been created to develop and reward the health and social care workers of today and the future, and to continue to bring recognition and professionalism to the health and social care sector. The rationale of this Level 3 Diploma in Health and Social Care programme is to provide a career path for learners who wish to develop their care capabilities within the health and social care sector. The programme provides the opportunity for individuals to forge a career in health and social care by seeking a greater knowledge and understanding industry, and to support the individual's development into senior positions. Program Overview: Diploma in Health and Social care - Level 3 Key Highlights of Level 3 Diploma in Health and Social care qualification are: Program Duration: 6 Months (Fast-Track Mode Available) Program Credits: 60 Credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Undergraduate degree programme. Alumni Status No Cost EMI Option (Instalment option is available on LSBR Website) Aims of this Level 3 Diploma in Health and Social Care qualification To equip individuals with the knowledge, understanding and skills required for success in employment in the health and social care sector To enable progression to the first year of a degree or related professional qualification To provide specialist study relevant to individual vocations and environments in which learners are currently working, or to which learners are aiming to work, within the health and/or social care sector To develop learners' ability to contribute positively to good practice in the health and social care environment through effective use and combination of the knowledge and skills gained in the qualifications To develop skills and techniques, personal qualities and attributes essential for successful performance in working life and thereby enabling learners to make an immediate contribution to employment. Mandatory Units: The Qualifi Level 3 Diploma in Health and Social Care qualification consists of 4 mandatory units for a combined total of 40 credits An introduction to Health and Social Care (10 credits) Communication for Health and Social Care (10 credits) Promoting Health in the Population (10 Credits) Person-Centred Care (10 credits) Optional Units: The learner must also achieve a minimum of 20 credits from these units. Understanding Diabetes Care (10 credits) Understanding Stroke Care (10 credits) Understanding Dementia Care (10 credits) Who is this course for? Working Professionals, O-Level holders and those who wish to progress in their Career. Requirements The Level 3 Diploma in Health and Social Care (Accredited by Qualifi) qualifications has been designed to be accessible without artificial barriers that restrict access and progression. Learners are expected to hold the following: Qualifications at Level 2 and/or Work experience in the health and social care sector and demonstrate ambition with clear career goals, or A Level 3 qualification in another discipline and want to develop their careers in health and social care. In certain circumstances, learners with considerable experience but no formal qualifications may be considered Career path Career Progression Learners completing the Level 3 Diploma in Health and Social Care can progress to: Level 4 Diploma in Health and Social Care, or The First Year of Undergraduate study in Health and Social Care, or Directly into employment in an associated profession.

Business Intelligence: In-House Training Business Intelligence (BI) refers to a set of technology-based techniques, applications, and practices used to aggregate, analyze, and present business data. BI practices provide historical and current views of vast amounts of data and generate predictions for business operations. The purpose of Business Intelligence is the support of better business decision making. This course provides an overview of the technology and application of BI and how it can be used to improve corporate performance. What you will Learn You will learn how to: Specify a data warehouse schema Identify the data and visualization to be used for data mining and Business Intelligence Design a Business Intelligence user interface Getting Started Introductions Agenda Expectations Foundation Concepts The challenge of decision making What is Business Intelligence? The Business Intelligence value proposition Business Intelligence taxonomy Business Intelligence management issues Sources of Business Intelligence Data warehousing Data and information Information architecture Defining the data warehouse and its relationships Facts and dimensions Modeling, meta-modeling, and schemas Alternate architectures Building the data warehouse Extracting Transforming Loading Setting up the data and relationships Dimensions and the Fact Table Implementing many-to-many relationships in data warehouse Data marts Online Analytical Processing (OLAP) What is OLAP? OLAP and OLTP OLAP functionality Multi-dimensions Thinking in more than two dimensions What are the possibilities? OLAP architecture Cubism Tools OLAP variations - MOLAP, ROLAP, HOLAP BI using SOA Applications of Business Intelligence Applying BI through OLAP Enterprise Resource Planning and CRM Business Intelligence and financial information Business Intelligence User Interfaces and Presentations Data access Push-pull data access Types of decision support systems Designing the front end Presentation formats Dashboards Types of dashboards Common dashboard features Briefing books and scorecards Querying and Reporting Reporting emphasis Retrofitting Talking back Key Performance Indicators Report Definition and Visualization Typical reporting environment Forms of visualization Unconstrained views Data mining What is in the mine? Applications for data mining Data mining architecture Cross Industry Standard Process for Data Mining (CISP-DM) Data mining techniques Validation The Business Intelligence User Experience The business analyst role Business analysis and data analysis Five-step approach Cultural impact Identifying questions Gathering information Understand the goals The strategic Business Intelligence cycle Focus of Business Intelligence Design for the user Iterate the access Iterative solution development process Review and validation questions Basic approaches Building ad-hoc queries Building on-demand self-service reports Closed loop Business Intelligence Coming attractions - future of Business Intelligence Best practices in Business Intelligence

Enhance your knowledge of natural gas and LNG sales agreements with EnergyEdge course. Enroll now to gain valuable industry knowledge and skills.

Who can apply for this MBA – Artificial Intelligence program? Anyone with an undergraduate degree with a minimum of 50% marks Minimum of one year of professional experience Professionals looking to grow their career with a Master degree in Management Professionals wishing to make a transition to mid-level and higher positions

In this live course, I share my insights from my experience as a school librarian and governors’ clerk, into how teachers use children's books in the classroom, what they are looking for in school visits and how to prepare for them. I will be joined by voice coach, Cat Clancy, and confidence coach, Vie Portland.

Decision Making and Problem Solving: In-House Training We may live in an era of fast technology and increasing reliance upon automation, but our human abilities to think critically, make careful decisions, and solve nuanced problems are more important than ever. Our personal lives depend on those things, and so do the lives of our organizations. Since business is now conducted at remarkable speeds, we put our organizations at great risk daily when we have weak competencies with decision-making and problem-solving. Decisions and solutions that are executed impulsively and without structured approaches can create more problems or make existing ones worse! This course aims to help participants improve their skills so they can execute well and add value to the workplace. Learners will experience multiple decision-making and problem-solving models, tools, and techniques meant for the real world. They will learn how to align their growing toolboxes with the right situational contexts so that they can transfer that skill to the workplace. They will also discover how indecision, cognitive bias, and default thought processes can create obstacles to effective decision-making and problem-solving. What you will Learn Recognize the importance of making a sound decision in a timely manner Infer types of cognitive biases and obstacles that impact decision-making Separate facts, requirements, ideas, and perceptions when making a decision or solving problems Apply structured decision-making and problem-solving approaches Conduct cause and effect and Force Field analyses Evaluate alternative solution methods using various techniques Analyze real world situations to determine the best aligned decision-making and problem-solving models, tools, and techniques Implement decision-making and problem-solving models, tools, and techniques Foundation Concepts Contextualizing decisiveness and problem-solving Discriminating between decisiveness and problem-solving Understanding Decision-Making Decision-making challenges and impacts Key drivers of good decision-making Thought processes and obstacles Knowledge, skills, and abilities (KSAs) Decision-Making Models and Supporting Tools Decision-making models, tools, and guidelines Tools to evaluate alternatives Translating requirements into action Problem-Solving Defining the problem Problem-solving models Cause and effect analysis Quick hit vs. innovative problem-solving Summary and Next Steps Course summary Personal action plan

This is a practical ‘non-medical’ day for front line practitioners working with children and young people who have experienced serious trauma in their life. We work to strengthen understanding of children who have faced issues of trauma emerging from abuse, violence, loss and family breakdown. Online Course now available via Teachable Platform – Impact of Trauma Learn at your own pace… lots of text and video support Course Category Meeting emotional needs Behaviour and Relationships Inclusion Teaching and Learning Description This is a practical ‘non-medical’ day for front line practitioners working with children and young people with serious issues arising from trauma. Drawing from the international research and literature and our own experience over many years as educational psychologists of the challenges of children with major social and emotional needs, we will explore together what the best practice can and could look like. We explore the language and key concepts of trauma and outline very practical classroom strategies. We look at what Psychology may help us in our understanding of children who have faced trauma. We explore the themes of: Hyperarousal Intrusive thoughts Constricted lives We look at triggers, self-regulation and unpack a range of strategies.  We explore what young people with these difficulties really need from us. We also spend time looking at the emotional impact on practitioners working with children with such needs and what helps at a personal and team level. We can all do something – we do not have to wait for expert therapists to arrive!  Testimonials I had no idea… It had a huge impact Belonging and feelings are so important Excellent! Learning Objectives Increased confidence regarding developing inclusive practice for traumatised children in mainstream schools Simple understandable explanation trauma understood Access to a wider range of practical strategies to impact on social and behavioural needs Deeper understanding of core values surrounding inclusion of emotionally disabled children Opportunity to reflect on professional attitudes and behaviour towards parents and pupils with complex emotional needs New skills, scripts and processes to make inclusion successful Who Is It For? Practitioners working in schools and other settings with children and young people of all ages Key workers Teaching Assistants with support roles Heads and deputies SENCOs Advanced skills teachers Primary and secondary classroom teachers Parents Local authority support services Course Content The course explores the questions:What does it take for a child to:Feel safe and secureMourn the past traumaReconnect with ordinary relationships with children and adults?How can we start to develop an understanding of traumatised children?What is the true impact of trauma?What else can we do to go about including high profile children or young people with challenging emotional needs?What useful psychological constructs can we use to guide us?This course also explores practical strategies, concepts and language for key adults rebuilding relationships with individual pupils.This is a participative day that aims to be explorative and practical. Opportunities to develop empathy with the children of concern will be created.If you liked this course you may well like:FRESH APPROACHES TO BEHAVIOUR AND RELATIONSHIPS

The professional working world has changed more rapidly than could have been envisaged at the time of the introduction of GDPR and the Data Protection Act 2018. With more people working from home post-Covid and the ever increasing risk of cyber-attacks, this short course is aimed at taking stock of current practice and risk, as well as considering ICO enforcement action and the implications of hybrid working. It is also a great recap on the rules as they stand and what you need to know to comply. The course will cover: UK GDPR - A timely reminder of the rules ICO enforcement action and what we can learn Data Protection Impact Assessments - when and how to do them Hybrid working and UK GDPR Managing cyber attacks from a UK GDPR perspective Target Audience The online course is suitable for staff of all levels, from support staff to senior partners. Resources Course notes will be provided to all delegates which may be useful for ongoing reference or cascade training. Please note a recording of the course will not be made available. Speaker Matthew Howgate, Consultant, DG Legal Matt is a non-practising solicitor who has considerable experience in regulatory issues and advising on complex issues of compliance and ethics. He is also an expert in data protection, UK GDPR and on the civil legal aid scheme. Matthew is a lead trainer on and co-developed the LAPG Certificate in Practice Management (a training programme for legal managers and law firm owners) as well as regularly providing training on legal aid Supervision, costs maximisation, data protection and security and on general SRA compliance.

We are excited to announce the Online version of the Step by Step Course. It will include live demonstrations of the process that you will then follow. Unique opportunity to be guided step by step and experience meditative practice of icon painting.