7520 Personal Development courses in Liverpool delivered Online

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Overview In this course, you will create complex reports using tools in Crystal Reports 2016. You will: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency. 1 - CREATING RUNNING TOTALS Topic A: Create a Running Total Field Topic B: Modify a Running Total Field Topic C: Create a Manual Running Total 2 - WORKING WITH CROSS-TABS Topic A: Create a Cross-Tab Report Topic B: Format a Cross-Tab Report Topic C: Create Groups in Cross-Tab Reports 3 - ADDING SUBREPORTS Topic A: Insert a Subreport Topic B: Edit a Subreport Topic C: Share Variables 4 - CREATING DRILL-DOWNS IN A REPORT Topic A: Create a Drill-Down Topic B: Create Headings for Drill-Down Data 5 - USING SQL STATEMENTS IN REPORT PROCESSING Topic A: Create a Report Using SQL Queries Topic B: Summarize Report Data Topic C: Create Joins Using SQL Topic D: Create Subqueries Topic E: Create an SQL Expression Field 6 - CREATING COMPLEX FORMULAS Topic A: Work with Loops Topic B: Work with Arrays 7 - ADDING CHARTS TO REPORTS Topic A: Create Charts Topic B: Create a Chart with Drill-Down Topic C: Create a Top N Chart Topic D: Create a Cross-Tab Chart Topic E: Create Charts for Grouped Data Topic F: Format a Chart Topic G: Create a Chart Template 8 - ENHANCING REPORT FUNCTIONALITY Topic A: Organize Data Based on a Hierarchy Topic B: Create a Dynamic Image Topic C: Create a Report Alert Topic D: Create a Geographic Map 9 - APPENDIX Appendix A: Managing Reports Appendix B: Processing Data on the Server Appendix C: Detecting and Fixing Problems

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE Topic A: Explore Crystal Reports Topic B: Use Crystal Reports Help Topic C: Customize Report Settings 2 - WORKING WITH REPORTS Topic A: Create a Report Topic B: Modify a Report Topic C: Display Specific Report Data Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS Topic A: Create a Formula Topic B: Edit a Formula Topic C: Filter Data by Using a Formula Topic D: Work with Advanced Formulas and Functions Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS Topic A: Create a Parameter Field Topic B: Use a Range Parameter in a Report Topic C: Create a Prompt 5 - GROUPING REPORT DATA Topic A: Group Report Data Topic B: Modify a Group Report Topic C: Group by Using Parameters Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT Topic A: Format a Report Topic B: Insert Objects in a Report Topic C: Suppress Report Sections Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA Topic A: Create a Report Based on Excel Data Topic B: Modify a Report Generated from Excel Data Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA Topic A: Export Data Topic B: Create Mailing Labels 9 - APPENDIX Appendix A: Setting Up and Configuring Data Sources Appendix B: Using Report Processing Techniques Appendix C: Using Functions in Formulas

Uncovering Emotional Root Causes of Health Challenges Instructor Craig Weiner, DC, Licensed MetaHealth Foundation Trainer, EFT Master Trainer of Trainers. Learn to apply a method of analysis that effectively guides the application and integration of EFT, Matrix Reimprinting and other alternative healing modalities you may already currently use for yourself and on your clients. Discover how symptoms and disease are actually an intelligent process that is the body’s attempt to heal stress and trauma. With this knowledge, fear can be greatly reduced and a therapeutic intervention can then be utilized in a more precise way. You and your clients will achieve results faster and will be amazed at the insights, connections and progress they make in their healing journey. META-Health is the science, practice and art of Body-Mind-Social Health with a focus on how specific stress triggers, emotions and beliefs affect specific organ symptoms. META-Health is a methodology based on Integrative Medicine and Prevention and is practiced by all types of health professionals interested in a precise and effective Body-Mind-Social analysis and approach towards most effectively supporting individuals working to find emotional and physical healing. Your trainer for this Foundation weekend will be Craig Weiner, who has worked in the complementary health care field for over 30 years. He brings his professional clinical experience, his years as an educator and certified trainer in the Emotional Freedom Techqniques and Matrix Reimprinting and as a licensed META-Health Foundation Trainer. In the Foundation Course you will get the overview of the META-Health concepts and its implications for self-healing, assistance in transforming disease, and achieving sustainable health and resilience, including: Rhythms of life, and the organism’s self-regulating intelligence How the bio-logical needs change your perception and create life strategies How to decode the language of your organs Recognize the key points and phases of the healing process Experience the powerful META-Analytics questions Use the 8 milestones of META-Health to address the whole system and its soil Find META-meanings to create resilience Demonstrations and practical exercises will lead you to deeply integrate the wisdom of your body, and inspire you to actively claim and support your health. You will understand the natural, dynamic path of healing, and be empowered to lift your – and others’ – consciousness to make use of our potential! During this weekend we will spend time reviewing the core META-Health Principles: Our body-mind is highly intelligent Bio-logical survival and stress strategies, regeneration and resilience are at play in our brain, nervous system and hormonal system Significant emotional experiences shape our beliefs, personality and lifestyle Specific individual stress triggers influence typical organ tissues and functions The cycle of stress, regeneration and learning goes through distinct points and phases Awareness and imagination are capabilities of our brain which can recreate meaning and reprogram body-mind’s reactions There is no pre-requisite to taking this weekend course. Anyone who is interested can participate in the META-Health Foundation Training. The Foundation Training is the first step in becoming a certified META-Health Practitioner. Times: The course is a 12 hours training and will be held from 9:00 to 4:00 Seattle/Pacific time on both Friday and Saturday with a 60 minute lunch break held at approximately 12:30pm.

Fatigue Reset: Crack Pacing once and for all! Module One: Your fatigue experience is about to get easier! Welcome to your Fatigue Reset! Here you will find everything you need to know about how you too can Crack pacing once and for all with my unique pacing method. Pacing often isn’t enough in itself to help someone achieve full recovery - attention to other healthy protocols is usually important too. But pacing is the way to make life feel easier, soon, and as well as helping to control your symptoms it gives your body the stability it needs to do whatever restorative work is needed. In short, pacing is vital - so I’m delighted you’ve signed up for this course.  Welcome 4 mins483 MB What is pacing? 187 KB Why you need this course 6 mins753 MB How to get the most from this course 4 mins490 MB About my own Fatigue Recovery journey 202 KB Module Two: The importance of getting into the right mindset. Tackling life with extreme fatigue can be difficult emotionally, not just physically. This module talks about a very important mindset shift that will help to ensure you adapt to pacing as quickly as possible. Although it’s a technique that’s often discussed, I hope my way of explaining it will encourage you to really try it. Why finding acceptance is so important 6 mins868 MB A simple technique to help you find acceptance5 mins662 MB Some more reframing examples 190 KB Module Three: My pacing method. This module contains step by step tutorials about my pacing method, including how to complete the different templates provided. If viewing on a small screen, you may wish to print the templates off first so that you can look at them clearly as I'm explaining the different sections. A brief introduction before we get started 3 mins343 MB Step 1 - Creating a master task list 24 mins612 MB Task List MASTER.pdf 51.1 KB Task List MASTER.xlsx 19.4 KB Step 2 - Pacing your week 11 mins311 MB Weekly plotter MASTER.pdf 46.5 KB Weekly plotter MASTER.xlsx 17.4 KB Step 3 - Planning your day 15 mins398 MB Daily scheduler MASTER.pdf 291 KB Daily scheduler MASTER.xlsx 22 KB Step 3a - Carrying out a daily review 7 mins261 MB How to put it all into practice 6 mins753 MB Getting started guide 224 KB Module Four: Further guidance to help you make this a success. The support and guidance in this module is here to help you as you start to put my pacing method into practice. Updates will be made each month and you will be alerted when new content is available. My support for you 2 mins210 MB Frequently asked questions and answers 334 KB Quick tips for re-sizing tasks 202 KB Some more examples of delegating and outsourcing tasks 182 KB Using your baseline 190 KB How to rest 9 mins1.26 GB Resting factsheet (summary points) 16.5 KB Module Five: Moving to a more sustainable pacing approach. When the time is right, this lighter approach to pacing will help you stick to your baseline while enjoying carrying out each day with a little less structure and up-front planning. Why I feel moving to a simplified approach is important 3 mins337 MB My 'Guardrails' approach to pacing 9 mins1.29 GB A guide to my Guardrails approach 170 KB The End I'm so pleased you've made it this far, and I wish you all the very best with your ongoing fatigue rescue journey. A few final words 3 mins371 MB

Fully Approved Course - CPD and ILM Approved 100% online training, 90 minutes course Stop & start at anytime No time limit Course Description A leader doesn’t necessarily have to be a ‘manager’, but it’s difficult to see how a manager could be truly effective without having at least some leadership skills. This course starts by introducing the basics of leadership and explores where the concept originated from. It then goes on to discuss various leadership theories, including situational leadership, contingency theories, transactional and transformational leadership and more. It then moves on to discuss developing teams including and team members by looking at the role leaders play in this. The final two modules cover the role communication plays in effective leadership and finishes off with a module about moving forward together to achieve a shared vision. Modules: Leadership and Management Leadership Theories Team Development and Leadership Individuals Within Teams Communicating One-to-One with Individuals Moving Forward Together Target Audience This course is aimed at supervisors and managers that want to develop more effective relationships with members of their teams. T he course can be a great starting point for people new to their leadership role as well as more established managers that want to enhance their skills. This acts as a great introduction to the subject. This course can be sold to individuals who are doing the training for themselves or it can be pitched to businesses who might want to put all of their first line management team through the training, so they are all work in the same way and have the same skill set. Advantages CPD approval means that this course can be used by those that need to prove they are continually developing themselves. ILM approval means that this course can provide candidates with a recognised management qualification. A strong leader will motivate their team, improving morale and efficiency and ensure that their team is of a common purpose. Online training is flexible, efficient and cost effective meaning the candidate can progress through the modules at their own pace and in their own time, so they can fit the training around their work and personal life. Further Progression For candidates that want to add more qualifications to their CV our Introduction to Emotional Intelligence course is a great introduction to that aspect of Leadership and management. For candidates specifically interested in developing resilient teams our Developing Teamwork course goes hand in hand with this one and expands on some of the key ideas and how they can be applied to teams. For candidates new to management roles Managing Meetings would be a great next step although working through any of our range of Business Skills courses would be valuable.

This half-day workshop delivered face-to-face or online is designed for anyone in your organisation that wants to become a Neurodiversity Champion - someone who wants to educate and change the way that Neurodiversity is viewed in the workplace.

Virtual Agile Teams: On-Demand Agile teams are a must in this world of intense competition, marketing demands, and changing expectations. Global virtual teaming has become a necessity as organizations become increasingly distributed, with suppliers and clients actively engaged in joint projects. Agile Teams now work across geographical, organizational, and cultural boundaries to deliver solutions and services to global users. Distance and differences may amplify the effect of issues and factors that are relatively straightforward for co-located Agile teams. This workshop delivers practical concepts and techniques that participants will start using immediately with their virtual Agile teams. The goal of the course is to enable you to successfully execute your preferred Agile or Scrum methods in a virtual project team environment. What you will Learn At the end of this program, you will be able to: Explain the characteristics of a virtual team and how they differ from a co-located team Build an effective virtual Agile team using a Team Charter approach Develop Release Plans, including prioritizing user stories, with a virtual Agile Team Construct a Sprint plan, including effective user story estimates, virtually Execute a Sprint, including essential Agile or Scrum ceremonies, virtually Conduct effective virtual meetings in an environment supportive of Agile and Scrum methods Foundation Concepts Agile Mindset and Values Agile Benefits and Methods Scrum Overview Co-located vs. Virtual Teams Forming Virtual Agile Teams Exploring Virtual Leadership Focusing on Virtual Agile Leaders Developing a Virtual Agile Team Charter Meeting Team Challenges in a Virtual Environment Planning Releases with a Virtual Agile Team Planning releases overview Estimating user stories Prioritizing user stories Setting release parameters Getting consensus on the release plan Planning a Sprint for a Virtual Project Sprint Planning Overview Confirming Sprint Scope with Virtual Agile Teams Developing a Sprint Delivery Plan for Virtual Agile Teams Running a Sprint in a Virtual Environment Self-organizing a Sprint for a Virtual Agile Team Using Scrum tools in a Virtual Environment Conducting End of Sprint Meetings in a Virtual Environment Iterating as a Virtual Agile Team Creating an Environment for Success Piloting a virtual Agile team Creating an Agile-friendly virtual environment

AgileSHIFT® AgileSHIFT® is the change your organization needs: the business landscape is changing and transformation is necessary. But it is also hard. This program is aimed to drive transformational change throughout an organization. This new enterprise agility guidance empowers individuals to use a lightweight tailorable framework to understand, engage with, and champion change by embracing agile and lean ways of working. Taking a holistic view of an organization, AgileSHIFT® will create and support the champions of change your business needs in order to thrive in an increasingly competitive and disruptive workplace. What You Will Learn At the end of this program you will be able to: Identify why organizations need to create a culture of enterprise agility in response to a changing context Recognize how to think and work differently to enable change Explore agile and lean thinking concepts and how they relate to running and changing your organization Utilize key concepts of the AgileSHIFT® framework Describe the AgileSHIFT® delivery approach Getting Started A changing context Enterprise agility The Purpose of AgileSHIFT® The AgileSHIFT® Framework AgileSHIFT® principles AgileSHIFT® practices AgileSHIFT® roles AgileSHIFT® workflow Benefits of AXELOS.com Summary and Next Steps

Level 3 & 4 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

14 in 1 "Personal Finance and Debt Management" Bundle only at £79 Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for a Personal Finance and Debt Management course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Personal Finance and Debt Management bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Personal Finance and Debt Management course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries and help you along your learning journey. Advanced audio-visual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Personal Finance and Debt Management, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Personal Finance and Debt Management Bundle Consists of the following Premium courses: Course 01: Financial Modeling Course for a Non-Finance Background Course 02: Debt Management - Online Course Course 03: Improve your Financial Intelligence Course 04: Professional Personal Finance Course Course 05: Capital Budgeting & Investment Decision Rules Course 06: Budgeting and Forecasting Course 07: Financial Analysis Course 08: Investment Banking & Valuation Course 09: Finance Assets Course 10: Level 3 Tax Accounting Course 11: Essentials of UK VAT Course 12: Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 13: English Law and Legal System Level 3 Course 14: Decision Making and Critical Thinking How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Personal Finance and Debt Management expertise and essential knowledge, which will assist you in reaching your goal. Curriculum of Bundle Course 01: Financial Modeling Course for a Non-Finance Background Module 01: Introduction Module 02: Project Cost Module 03: Depreciation Module 04: Schedule of Term Loan Module 05: Profit and Loss Account Module 06: Preparation of Balance sheet CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Personal Finance and Debt Management bundle. Requirements Our Personal Finance and Debt Management course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Personal Finance and Debt Management expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Hard copy certificate - Included You will get the PDF Certificate for the title course (Financial Modeling Course for a Non-Finance Background) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Financial Modeling Course for a Non-Finance Background) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.