9766 Courses

Free QLS Endorsed Certificate | 11 in 1 Exclusive Bundle with Free Certificates | 150 CPD Points | Installment Payment

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

Getting Started The CMI Level 5 Extended Diploma in Management and Leadership course is designed for practising or aspiring middle managers and leaders at operations, division, departmental or specialist level, who are typically accountable to a senior manager or business owner. Leading and managing individuals and teams to deliver in line with the organisational strategy is the primary role of a practising manager. You'll develop the core strategic skills and competencies required to manage teams and individuals effectively, enabling you to deliver long-lasting results. The CMI Level 5 Extended Diploma in Management and Leadership is an extensive course focusing on improving your capabilities and core management skills such as planning, problem-solving, leadership, strategy, communication, conflict, resource management and organisation. Achieving the CMI Level 5 Extended Diploma in Management and Leadership qualification will enhance your credibility and enable you to outperform in demanding roles and situations. You'll have a wide range of modules to choose from, and depending on your career goals, you can select the modules that will be most effective for your progression. Key Benefits For Learners: Improve your capabilities and core management skills Develop the knowledge and skills required for managing and leading individuals and teams Provide an extensive knowledge of skills to excel in specific management areas For Organisations: Deliver aims and objectives in line with wider organisational strategy Provide you with a fully wider range of skills and knowledge required to be a manager as part of an organisation Focus on the areas that are most appropriate to your role and organisation. Key Highlights Are you an aspiring Manager or Leader looking for career development? Then, the CMI Level 5 in Management and Leadership qualification offered by the School of Business and Technology London is the right solution for you. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our CMI-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience.   Career Pathways The CMI Level 5 Management & Leadership can open many career pathways including, but not limited to: Operations Manager, with an estimated salary of £51,577 per annum Divisional Manager, with an estimated salary of £48,613 per annum Departmental Manager, with an estimated salary of £34,997 per annum Regional Manager, with an estimated salary of £51,372 per annum About Awarding Body Chartered Management Institute established over 60 years ago as the British Institute of Management back then; it has developed the UK's very first diploma in management studies. In the years that followed CMI has consistently been at the forefront of all aspects of management and leadership. Today CMI is the only chartered professional awarding body committed to offering the highest standards in management and leadership excellence. Presently over 100,000 managers use its unique services daily. CMI qualifications aim for managers and leaders at any level, and it remains the only Awarding Body which can award Chartered Manager status - the ultimate management accolade. Employers highly value the qualifications awarded by CMI, and boost your career prospects. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 18 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by CMI-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies Get Foundation Chartered Manager status upon course completion Fast Track to Chartered Manager status. You will be eligible to apply for Chartered Manager status, the ultimate professional accolade for managers, after completing the course and with 3+ years of experience in a managerial role. Access to CMI Management Direct. It has 100,000s of reliable and validated management and leadership resources, including company and industry reports, videos, checklists, E-books, and journals. You have access to CMI Membership and Support for the duration of your study. Assessment For each module you study, you will complete a written assignment of 3000 to 4,000 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your CMI-approved tutor. Entry Requirements This course is designed for current or aspiring mid-level managers. You don't need any formal qualifications to study this course. However, to be eligible for this course, you must:  Be 19 years of age and over Have some team leading or supervisory experience or managerial experience in the junior or middle management level Possess the ability to complete the Level 5 course Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression A possible progression route on successful completion of a CMI Level 5 in Management and Leadership would be to, Progress to other qualifications at the next level (e.g. from Level 5 Certificate to level 6 or 7 Certificate) Progression to Bachelor Degree Top Up in Business Management. Why gain a CMI Qualification? This online CMI Level 5 Extended Diploma in Management and Leadership course is perfect if you are a current or aspiring mid-level manager looking to advance in your career. The globally recognised CMI Level 5 Extended Diploma is perfect for you if you want to increase your opportunities for obtaining a middle management position. The substantial leadership skills and knowledge you'll develop with this course will be remarkably effective. You can fast-track to apply for Chartered Manager status, the ultimate professional accolade for managers, after completing the CMI Level 5 Diploma or Extended Diploma in Management and Leadership course and with 3+ years of experience in a managerial role. You may also wish to further your ongoing personal and professional development by accessing other CMI courses, such as the CMI Level 6 or Level 7 courses in Management and Leadership. Studying for a CMI qualification offers you more than just academic standing. When you enrol with us for the CMI Level 5 Extended Diploma in Management and Leadership, you will have access to CMI Membership and Support for the duration of your study alongside your qualification. CMI graduates achieve remarkable things: 72% agree that their CMI qualification gave them a competitive edge in the job application process. 89% agree they use the skills learnt on their accredited qualification in their current role. 88% agree that the accredited qualification gave them good career prospects. Recent CMI graduates earn a median of 28k compared to just 21k for a typical business studies graduate. Employers highly value the qualifications awarded by CMI, and over 80% of managers agree that a CMI qualification is essential to becoming a professional manager. Learners must complete a combination to a minimum of 540 TUT hours, 54 credits to achieve this qualification. There is a barred combination of units - learners taking 502 cannot select 503, 505 or 511 and learners taking 526 cannot select 501 or 502. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Managing Performance Reference No : CMI 504 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the rationale for managing performance within organisations. 2. Know how to manage performance. 3. Understand frameworks, diagnostic and evaluation tools used for performance management. UNIT2- Principles of Developing, Managing and Leading Individuals and Teams to Achieve Success Reference No : CMI 502 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand approaches to developing, managing and leading teams 2. Understand approaches to achieving a balance of skills and experience in teams. 3. Know techniques for leading individuals and teams to achieve success. UNIT3- Principles of Management and Leadership in an Organisational Context Reference No : CMI 501 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand factors which impact on an organisation's internal environment. 2. Understand the application of management and leadership theories. 3. Understand the knowledge, skills and behaviours to be effective in a management and leadership role. UNIT4- Principles of Delivering Coaching and Mentoring Reference No : CMI 507 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the role and purpose of coaching and mentoring within an organisation. 2. Understand the use of models and processes used in workplace coaching and mentoring. 3. Know how to manage the delivery of effective coaching and mentoring. UNIT5- Managing Stakeholder Relationships Reference No : CMI 509 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the different types and value of stakeholder relationships. 2. Understand the frameworks for stakeholder management. 3. Know how to manage stakeholder relationships. UNIT6- Managing Conflict Reference No : CMI 510 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the types, causes, stages and impact of conflict within organisations. 2. Understand how to investigate conflict situations in the workplace. 3. Understand approaches, techniques, knowledge, skills and behaviours for managing conflict. UNIT7- Planning, Procuring and Managing Resources Reference No : CMI 516 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the importance of effective and efficient resource use in organisations. 2. Know how to plan resources to meet organisational objectives. 3. Know how to procure resources. UNIT8- Principles of Innovation Reference No : CMI 517 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the role of innovation within organisations. 2. Understand the process of managing innovation in an organisation. UNIT9- Principles of Marketing Products and Services Reference No : CMI 523 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the role of marketing to support the achievement of organisational objectives. 2. Understand the factors in the organisation's marketing environment which impact on the marketing of a product or service. 3. Know how to market a product or service. UNIT10- Conducting a Management Project Reference No : CMI 524 Credit : 10 || TQT : 100 LEARNING OUTCOME 1. Know how to plan a management project. 2. Be able to conduct a management project. UNIT11- Managing Finance Reference No : CMI 520 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand finance within organisations. 2. Know how to set and manage budgets. UNIT12- Using Data and Information for Decision Making Reference No : CMI 521 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the use of data and information in decision making. 2. Be able to interpret data and information to support decision making. 3. Know how to present data and information used for decision making. UNIT13- Managing Change Reference No : CMI 514 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the reasons for change in organisations. 2. Understand approaches to change management. 3. Understand how to initiate, plan and manage change in an organisation. UNIT14- Creating and Delivering Operational Plans Reference No : CMI 515 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the principles of operational planning in an organisation. 2. Know how to create an operational plan in line with organisational objectives. 3. Know how to manage and lead the delivery of an operational plan. UNIT15- Principles of Managing and Leading Individuals and Teams to Achieve Reference No : CMI 503 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand approaches to managing and leading teams. 2. Know how to achieve a balance of skills and experience in teams. 3. Know techniques for managing and leading individuals and teams to achieve success. UNIT16- Forming Successful Teams Reference No : CMI 505 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the purpose and characteristics of successful teams. 2. Understand approaches to team formation. 3. Know how to analyse and respond to the challenges of team formation. UNIT17- Managing Equality, Diversity and Inclusion Reference No : CMI 506 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand legal and organisational approaches to equality, diversity and inclusion. 2. Understand the role and responsibilities of a manager in relation to equality, diversity and inclusion. 3. Know how to develop and implement plans which support equality, diversity and inclusion within an organisation. UNIT18- Principles of Developing a Skilled and Talented Workforce Reference No : CMI 508 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the benefits of developing a skilled and talented workforce. 2. Understand the factors which influence workforce development. 3. Understand the scope of learning and development as part of a workforce development strategy. UNIT19- Principles of Recruiting, Selecting and Retaining Talent Reference No : CMI 511 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the factors that impact on recruitment and selection. 2. Know how to plan for recruitment and selection. 3. Understand approaches to the recruitment and selection of a diverse and talented workforce. UNIT20- Workforce Planning Reference No : CMI 512 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the rationale for workforce planning. 2. Understand the principles and practices of workforce planning. UNIT21- Managing Projects to Achieve Results Reference No : CMI 513 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the role of projects in delivering organisational strategy. 2. Understand processes for initiating, planning and managing projects. 3. Understand the factors which contribute to effective project management. UNIT22- Managing Risk Reference No : CMI 518 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the scope of business risk management. 2. Understand the process for managing business risk. UNIT23- Managing Quality and Continuous Improvement Reference No : CMI 519 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the scope and purpose of quality management within organisations. 2. Understand approaches for managing quality. 3. Understand the application of continuous improvement within organisations. UNIT24- Managing the Customer Experience Reference No : CMI 522 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the principles of managing the customer experience. 2. Understand the customer journey in the context of an organisation. 3. Know how to manage the customer experience. UNIT25- Using Reflective Practice to Inform Personal and Professional Development Reference No : CMI 525 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the value of reflective practice to inform personal and professional development. 2. Know how to apply reflective practice to inform personal and professional development. UNIT26- Principles of Leadership Practice Reference No : CMI 526 Credit : 8 || TQT : 80 LEARNING OUTCOME 1. Understand leadership practice in an organisation. 2. Understand leadership styles 3. Understand the impact of leadership within organisations. UNIT27- Strategic Corporate Social Responsibility and Sustainability Reference No : CMI 608 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand corporate social responsibility and sustainability in organisational contexts. 2. Know how corporate social responsibility and sustainability is applied in an organisational setting. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. Management Direct As part of the program, you will get access to CMI Management Direct, which provides a rich foundation of management and resource for students. The Management Direct is packed with content, including: E-Books Articles Leader videos Idea for leaders Models and so much more... How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Birth Right Hypnobirthing is a full antenatal birth preparation course for pregnancy. Particularly useful for those who are scared of giving birth. Whether this is your first or tenth baby this information is essential. Whether you're looking for a natural birth or support for your caesarean birth this course will support you and give you the tools for the best birth for you.

This qualification is for learners who wish to gain the knowledge, skills and confidence to effectively coach or mentor people within an organisational context. It is also an ideal qualification for those who wish to commence a career in coaching or mentoring.

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

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.

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