1383 Courses

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

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 1 Days 6 CPD hours This course is intended for This course is designed for individuals who may need to present information effectively in a professional environment. Overview Define what makes a presentation effective. Plan presentations. Design a presentation framework. Develop the presentation body. Create supporting materials. Prepare for your presentation. Deliver presentations. Conduct a question-and-answer session. Deliver group presentations and virtual presentations. The ability to deliver presentations is vital to achieving advancement for yourself and for your ideas. Few skills in life will contribute to your success as much as presentation skills. Without a dynamic and coherent presentation, even stellar ideas can fail to convince your audience. In this course, you will learn to organize your ideas to create coherent and convincing oral presentations, while also utilizing available visual aids and using public-speaking techniques to strengthen your delivery. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. Prerequisites To ensure your success, you will need to have experience writing in a professional context and creating presentations using Microsoft Office PowerPoint. 1. Defining Presentation Effectiveness Identify Qualities of Effective Presentations Evaluate Yourself as a Presenter 2. Planning Presentations Analyze the Audience Establish Your Presentation\'s Objectives 3. Designing the Presentation Create the Presentation Structure Organize the Presentation Body Write the Conclusion First Write the Introduction 4. Developing the Presentation Body Select Evidence Write the Presentation Body Create Visuals 5. Creating Supporting Materials Create a Slide Deck Create Speaker Aids Create Audience Handouts 6. Preparing for Your Presentation Rehearse the Presentation Plan Event Logistics 7. Delivering Presentations Connect with Your Audience Present Powerfully Utilize a Slide Deck Effectively 8. Conducting a Question-and-Answer Session Answer Questions Handle Challenging Questions 9. Presenting in Common Business Scenarios Plan and Deliver a Virtual Presentation Plan and Deliver Group Presentations 10. Key Course Information This course focuses on the skills necessary to prepare and deliver an effective presentation; that being said, the learner will not be creating, delivering, or designing a specific presentation from start to finish in this course (this course only provides the foundational knowledge for doing this work back at the office). This course consists of instructor lecture along with course activities corresponding with the main course objectives. In terms of the course activities, 50% will be discussion based - 25% will be in a group-work format - and 25% will be hands-on/involve a digital tool, such as a PowerPoint or Word file. The intent is for students leaving this course to take the skills learned and apply them to their efforts of creating more effective presentations upon returning to the workplace. Additional course details: Nexus Humans Effective Presentations (Second Edition) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Effective Presentations (Second Edition) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Are you looking to elevate your professional skills to new heights? Introducing our Statistics for Data Science & Machine Learning at QLS Level 7 Advanced Diploma, a QLS-endorsed course bundle that sets a new standard in online education. This prestigious endorsement by the Quality Licence Scheme (QLS) is a testament to the exceptional quality and rigour of our course content. The bundle comprises 11 CPD-accredited courses, each meticulously designed to meet the highest standards of learning. This endorsement not only highlights the excellence of our courses but also assures that your learning journey is recognised and valued in the professional world. The purpose of Statistics for Data Science & Machine Learning at QLS Level 7 Advanced Diploma is to provide learners with a comprehensive, skill-enriching experience that caters to a variety of professional needs. Each course within the bundle is crafted to not only impart essential knowledge but also to enhance practical skills, ensuring that learners are well-equipped to excel in their respective fields. From gaining cutting-edge industry insights to mastering critical thinking and problem-solving techniques, this bundle is an amalgamation of learning experiences that are both enriching and empowering. Moreover, Statistics for Data Science & Machine Learning at QLS Level 7 Advanced Diploma goes beyond just online learning. Upon completion of the bundle, learners will receive a free QLS Endorsed Hardcopy Certificate & 11 CPD Accredited PDF Certificate, a tangible acknowledgement of their dedication and hard work. This certificate serves as a powerful tool in showcasing your newly acquired skills and knowledge to potential employers. So, why wait? Embark on this transformative learning journey today and unlock your potential with Statistics for Data Science & Machine Learning at QLS Level 7 Advanced Diploma! This premium bundle comprises the following courses, QLS Endorsed Course: Course 01: Statistics & Probability for Data Science & Machine Learning at QLS Level 7 Advanced Diploma CPD QS Accredited Courses: Course 02: Statistical Concepts and Application with R Course 03: Learn Financial Analytics and Statistical Tools Course 04: Statistical Analysis Course 05: Quick Data Science Approach from Scratch Course 06: Complete Python Machine Learning & Data Science Fundamentals Course 07: Mathematics Fundamentals - Percentages Course 08: Mathematics Fundamentals Course 09: Computer Simulation of Realistic Mathematical Models Course 10: Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course 11: Decision Making and Critical Thinking Course 12: Time Management Training - Online Course Learning Outcomes Upon completion of the bundle, you will be able to: Acquire industry-relevant skills and up-to-date knowledge. Enhance critical thinking and problem-solving abilities. Gain a competitive edge in the job market with QLS-endorsed certification. Develop a comprehensive understanding of Data Science & Machine Learning. Master practical application of theoretical concepts. Improve career prospects with CPD-accredited courses. The Statistics for Data Science & Machine Learning at QLS Level 7 Advanced Diplomaoffers an unparalleled learning experience endorsed by the Quality Licence Scheme (QLS). This endorsement underlines the quality and depth of the courses, ensuring that your learning is recognised globally. The bundle includes 11 CPD-accredited courses, each meticulously designed to cater to your professional development needs. Whether you're looking to gain new skills, enhance existing ones, or pursue a complete career change, this bundle provides the tools and knowledge necessary to achieve your goals. The Quality Licence Scheme (QLS) endorsement further elevates your professional credibility, signalling to potential employers your commitment to excellence and continuous learning. The benefits of this course are manifold - from enhancing your resume with a QLS-endorsed certification to developing skills directly applicable to your job, positioning you for promotions, higher salary brackets, and a broader range of career opportunities. Embark on a journey of professional transformation with Statistics for Data Science & Machine Learning at QLS Level 7 Advanced Diploma today and seize the opportunity to stand out in your career. Enrol in Data Science & Machine Learning now and take the first step towards unlocking a world of potential and possibilities. Don't miss out on this chance to redefine your professional trajectory! Certificate of Achievement: QLS-endorsed courses are designed to provide learners with the skills and knowledge they need to succeed in their chosen field. The Quality Licence Scheme is a distinguished and respected accreditation in the UK, denoting exceptional quality and excellence. It carries significant weight among industry professionals and recruiters. Upon completion, learners will receive a Free Premium QLS Endorsed Hard Copy Certificate titled 'Statistics & Probability for Data Science & Machine Learning at QLS Level 7 Advanced Diploma' & 11 Free CPD Accredited PDF Certificates. These certificates serve to validate the completion of the course, the level achieved, and the QLS endorsement. Please Note: NextGen Learning is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Statistics for Data Science & Machine Learning at QLS Level 7 Advanced Diploma bundle is ideal for: Professionals seeking to enhance their skills and knowledge. Individuals aiming for career advancement or transition. Those seeking CPD-accredited certification for professional growth. Learners desiring a QLS-endorsed comprehensive learning experience. Requirements You are cordially invited to enroll in this bundle; please note that there are no formal prerequisites or qualifications required. We've designed this curriculum to be accessible to all, irrespective of prior experience or educational background. Career path Upon completing the Statistics for Data Science & Machine Learning at QLS Level 7 Advanced Diploma course bundle, each offering promising prospects and competitive salary ranges. Whether you aspire to climb the corporate ladder in a managerial role, delve into the dynamic world of marketing, explore the intricacies of finance, or excel in the ever-evolving field of technology. Certificates CPD Quality Standard Certificate Digital certificate - Included Free 11 CPD Accredited PDF Certificates. QLS Endorsed Certificate Hard copy certificate - Included

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Accountancy will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate skills for your next promotion, this Accountancy will help you keep ahead of the pack. The Accountancy incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Further, this Accountancy will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in this job sector. Consequently, you'll sharpen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Accountancy, you can equip yourself with the essentials to keep you afloat in the competition. Along with this Accountancy course, you will get 10 premium courses, an original Hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Accountancy Bundle Consists of the following Premium courses: Course 01: Accountancy Course 02: Positive Psychology Masterclass Course 03: Level 3 Tax Accounting Course 04: Level 3 Xero Training Course 05: Theory of Constraints, Throughput Accounting and Lean Accounting Course 06: Internal Audit Training Diploma Course 07: Team Management Course 08: Business Analysis Level 3 Course 09: Microsoft Excel Training: Depreciation Accounting Course 10: GDPR Data Protection Level 5 Course 11: Microsoft Excel Level 3 As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the Accountancy to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Accountancy: Pay once and get lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills 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 (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But with this special offer, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. Curriculum of Accountancy Bundle Course 01: Accountancy Introduction The Role of an Accountant Accounting Concepts and Standards Double-Entry Bookkeeping Balance Sheet Income statement Financial statements Cash Flow Statements Understanding Profit and Loss Statement Financial Budgeting and Planning Auditing Course 02: Positive Psychology Masterclass Turn Negativity into Positivity Turn Anxiety & Frustrations into Positivity Turn Surviving Into Thriving Create a Positive Mental Aptitude Master the Top Six Positivity Traits Turn Adversity into Resilience Master Your Grit Scale Turn Physical Dexterity into Positive Psychology Set Positive Boundaries Become More Genuine and Authentic Live Out Giving First Detach Yourself from the End Result Course 03: Level 3 Tax Accounting Tax System and Administration in the UK Tax on Individuals National Insurance How to Submit a Self-Assessment Tax Return Fundamentals of Income Tax Advanced Income Tax Payee, Payroll and Wages Capital Gain Tax Value Added Tax Import and Export Corporation Tax and many more ... Course 04: Level 3 Xero Training Introduction Getting Started Invoices and Sales Bills and Purchases Bank Accounts Products and Services Fixed Assets Payroll VAT Returns Course 05: Theory of Constraints, Throughput Accounting and Lean Accounting The Theory of Constraints and Throughput Accounting Lean Accounting Part 1 Lean Accounting Part 2 Summary and Lean Accounting Assignment Course 06: Internal Audit Training Diploma Auditing as a Form of Assurance Internal Audit Procedures Technology-based Internal Audit Internal Control and Control Risk Audit Interviews Reporting Audit Outcome UK Internal Audit Standards Career as an Auditor Course 07: Presenting Financial Information Presenting Financial Information The Hierarchy of Performance Indicators The Principle of Effective Reports Guidelines for Designing Management Reports Methods of Presenting Performance Data The Control Chart: Highlighting the Variation in the Data The Pareto Chart: Highlighting Priorities Exercise: The Control Chart An Example Management Report Interpreting Performance Data Supporting Colleagues by Giving Feedback Data Visualisation Part 01 Data Visualisation Part 02 Data Visualisation Part 03 Data Visualisation Part 04 Final Thoughts on Presenting Financial Information Course 08: Business Analysis Level 3 Introduction to Business Analysis Business Processes Business Analysis Planning and Monitoring Strategic Analysis and Product Scope Solution Evaluation Investigation Techniques Ratio Analysis Stakeholder Analysis and Management Process Improvement with Gap Analysis Documenting and Managing Requirements Career Prospect as a Business Analyst in the UK Course 09: Microsoft Excel Training: Depreciation Accounting Introduction Depreciation Amortization and Related Terms Various Methods of Depreciation and Depreciation Accounting Depreciation and Taxation Master Depreciation Model Conclusion Course 10: GDPR Data Protection Level 5 GDPR Basics GDPR Explained Lawful Basis for Preparation Rights and Breaches Responsibilities and Obligations Course 11: Microsoft Excel Level 3 Microsoft Excel 2019 New Features Getting Started with Microsoft Office Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Excel Templates CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Accountancy bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Accountancy is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones, so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course; it can be studied in your own time at your own pace. Career path Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now With a single payment you will gain access to Stock Market Investing & Trading - Level 2 including 11 Career development courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Trade efficiently in the stock market, learning advanced techniques and strategies from the Stock Market Investing & Trading - Level 2 course. The Stock Market Investing & Trading - Level 2 course aims to equip you with all the required knowledge and skills to trade like a pro in the stock market and gain a consistent profit. You'll be trained on technical and candlestick chart analysis to equip you with the skills to perceive the market accurately. You'll also learn trading tips, exploring tools and exchange policy. What's more, you'll explore some mistakes of new traders that will protect you from making poor trading decisions. Thrive in the stock market by enrolling today! Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. All of our courses have interactive online modules that allow studying to take place where and when you want it to. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Stock Market Investing & Trading - Level 2: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home Courses are included with this Bundle: Course 1: Stock Market Investing for Beginners Course 2: Forex Trading Level 3 Course 3: Budgeting and Forecasting Course 4: Business Analysis Level 3 Course 5: Level 2 Financial Planning and Management Course Course 6: Corporate Finance: Working Capital Management Course 7:Team Management Course 8: Microsoft Excel Level 3 Course 9: GDPR Data Protection Level 5 Course 10: Financial Modeling Using Excel Course 11: Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 12: Risk Management Level 7 Curriculum: Course 1: Stock Market Investing for Beginners Module 01: Introduction to the Course Module 02: Introduction to Stocks Module 03: Money Required for Primary Investment Module 04: Opening an Investment Account Module 05: Brokerage Account Walkthrough Module 06: Finding Winning Stocks Module 07: Earning from Dividends Module 08: Diversifying Portfolio Module 09: Investment Plan Module 10: Rebalancing Portfolio Module 11: Understanding Order Types Module 12: Investment Tax Module 13: Investment Rules: Rule-1 Module 14: Investment Rules: Rule-2 Module 15: Investment Rules: Rule-3 Module 16: Investment Rules: Rule-4 Module 17: Investment Rules: Rule-5 Module 18: Stock Market Dictionary Module 19: Setting Up the Trading Platform Course 2: Forex Trading Level 3 Module 1: Introduction to Forex Trading Module 2: Major Currencies and Market Structure Module 3: Kinds of Foreign Exchange Market Module 4: Money Management Module 5: Fundamental Analysis Module 6: Technical Analysis Module 7: Pitfalls and Risks Module 8: Managing Risk Module 9: Trading Psychology Course 3: Budgeting and Forecasting Unit-1. Introduction Unit-2. Detail Budget Requirement Unit-3. Process of Making Budget Course 4: Business Analysis Level 3 Module 01: Introduction to Business Analysis Module 02: Business Processes Module 03: Business Analysis Planning and Monitoring Module 04: Strategic Analysis and Product Scope Module 05: Solution Evaluation Module 06: Investigation Techniques Module 07: Ratio Analysis Module 08: Stakeholder Analysis and Management Module 09: Process Improvement with Gap Analysis Module 10: Documenting and Managing Requirements Module 11: Career Prospect as a Business Analyst in the UK Course 5: Level 2 Financial Planning and Management Course Personal Finance Calculations Saving for Retirement Building Credit to Buy a Home Personal Finance Guides for Beginners Cashflow Management Budgets and Money Management Course 6: Corporate Finance: Working Capital Management Module 01: Course Introduction Module 02: Introduction to Working Capital Management Module 03: Trade Credit and Receivable Management Module 04: Payables Management Module 05: Inventory Management Practices Module 06: Cash Management Practice Course 8: Microsoft Excel Level 3 Microsoft Excel 2019 New Features Getting Started with Microsoft Office Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Excel Templates Course 9: GDPR Data Protection Level 5 Module 01: GDPR Basics Module 02: GDPR Explained Module 03: Lawful Basis for Preparation Module 04: Rights and Breaches Module 05: Responsibilities and Obligations Course 10: Financial Modeling Using Excel Welcome to the Course! Get the Overview of What You'll Learn Planning your Financial Model Building a Model Template Projecting the Income Statement Projecting the Balance Sheet Projecting Cash Flows Advanced Financial Modeling BONUS LESSON: Top 5 Excel Features for Financial Modellers Course 11: Fraud Management & Anti Money Laundering Awareness Complete Diploma Module 01: Introduction to Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Development of Anti-Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Office Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Suspicious Conduct and Transactions Module 09: Awareness and Training Course 12: Risk Management Level 7 Module 01: Introduction to Risk Management Module 02: Risk and Types of Risk Module 03: Benefits of Risk Management Module 04: Enterprise Risk Management Module 05: Risk Management Process Module 06: Risk Analysis & Assessment Module 07: The Risk Evaluation Process Module 08: Managing Financial Risks Module 09: The Fundamentals of Operational Risk Management Module 10: Managing Technology Risks Module 11: Managing Legal & Political Risk Module 12: Environmental Risk Assessment Module 13: Risk Assessment at Workplace Module 14: Market & Social Risk Assessment Module 15: Preparing Risk Management Plan: Step by Step 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 (Previously it was £10 * 12 = £120) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 125 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Stock Market Investing & Trading - Level 2. It is available to all students, of all academic backgrounds. Requirements Our Stock Market Investing & Trading - Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Certificates Certificate of completion Digital certificate - Included

Course Overview Learn all the essential skills to become an expert in Office Administrator. From this comprehensive Office Administration course, you will be able to understand the principles of Office Administrator. In the step-by-step training process, you will acquire practical skills along with theoretical knowledge. The Qualified professionals will assist you throughout this learning process. This Office Administration is structured to ensure you have all the adequate skills to secure a position in this competitive industry. You will achieve the confidence and competency to bear all the responsibilities of this profession. The course will add all the right credentials to your resume and increase your employability in this growing industry. Learning Outcomes Explain the office administration Acquire the skills of an effective administration Master the negotiation techniques Learn and implement skills like conflict management, stress management, and time management Who is this course for? Anyone who is now employed in this field or who aspires to be one should take this course. Your knowledge will grow through taking this course, which will also strengthen your resume. To demonstrate your newly gained knowledge, develop crucial abilities and receive a professional credential. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Office Administration course is intended to assist you in obtaining the dream job or maybe the promotion you've always desired. With the assistance and direction of our Office Administration course, learn the vital abilities and knowledge you require to succeed in your life. Office Administration Introduction to Office Administration 00:14:00 Skills of an Effective Administrator 00:15:00 Business Writing Skills 00:40:00 Communication Skills 00:25:00 Managing Meetings and Giving Feedback 01:24:00 Organisational Skills 01:16:00 Telephone Etiquette 01:07:00 Negotiation Techniques 00:16:00 Conflict Management 00:14:00 Stress Management 00:16:00 Time Management 00:37:00 Microsoft Excel Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft PowerPoint Edit Text 00:13:00 Build a Presentation 00:27:00 Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Insert Images 00:10:00 Insert Shapes 00:15:00 Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Assignment Assignment - Office Administration 00:00:00 Recommended Materials Workbook - Office Administration 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Learn Ms Office with Expert bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Learn Ms Office with Expert related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Learn Ms Office with Expert bundle will help you build a solid foundation to become a proficient worker in the sector. This Learn Ms Office with Expert Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: MS Word Diploma Course 2: Proofreading & Copyediting Course 3: PowerPoint Diploma Course 4: Microsoft Excel Level 3 Course 5: New Functions in Microsoft Excel 2021 Course 6: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 7: Microsoft Excel: Excel Sheet Comparison with VBA Course 8: Microsoft Excel: Master Power Query in 120 Minutes! Course 9: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10: Excel Pivot Tables Course 11: Data Analysis in Microsoft Excel Complete Training Course 12: Excel Must know Formulas and Functions Course 13: Excel spreadsheet for Beginner Course 14: Excel Data Analysis Course 15: Excel Vlookup, Xlookup, Match and Index Course 16: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 17: PowerBI Formulas Course 18: Outlook Tips and tricks Course 19: Excel PowerQuery and PowerPivot Course 20: Complete Microsoft Power BI 2021 Course 21: The Complete Microsoft Outlook Masterclass Course 22: Microsoft Access Complete Course (Beginner, Intermediate, Advanced) Course 23: Microsoft Access Tables and Queries Course 24: Microsoft Access Databases Forms and Reports Course 25: Microsoft Teams 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Learning Outcome This tailor-made Learn Ms Office with Expert bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Learn Ms Office with Expert Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete Learn Ms Office with Expert training materials, you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Learn Ms Office with Expert bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Learn Ms Office with Expert Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

The Car Mechanic & Car Maintenance Level 3 Diploma offers a detailed, thorough approach to mastering car mechanics and vehicle upkeep. This course is ideal for those keen to dive into the automotive industry, whether you're looking to deepen your knowledge or start a new journey. With the increasing demand for qualified professionals in the automotive sector, this qualification equips you with the expertise needed to understand car systems and maintenance techniques. Whether it’s diagnosing faults, performing repairs, or maintaining a vehicle’s performance, the course is structured to provide a strong foundation and equip you with the core knowledge to thrive in the industry. The car repair industry continues to expand, and as vehicles become more advanced, the need for skilled professionals grows. By the end of this course, you’ll have the tools to work on a range of car systems, enhancing your ability to diagnose problems efficiently and carry out necessary repairs. This qualification opens doors to a variety of roles in the automotive sector, whether it’s working in repair garages, car dealerships, or as a self-employed mechanic. Get ready to learn everything you need to succeed in this fast-paced and ever-evolving field. ________________________________________________________________________ Learning Outcomes: Understand safety protocols and maintenance essentials for car mechanics. Demonstrate proficiency in general car maintenance practices. Identify and interpret vehicle warning lights effectively. Master the inspection and maintenance of tyres, wheels, and brakes. Gain comprehensive knowledge of car engine, cooling, fuel, and electrical systems. Acquire restoration skills, from planning to reassembly and test driving. ________________________________________________________________________ Key Features: CPD Certified Car Mechanic & Car Maintenance Level 3 Diploma With Complete Career Guide 10 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum: Car Mechanic & Car Maintenance Module 01: Introduction to Safety and Maintenance Module 02: General Maintenance for Car Mechanics Module 03: Vehicle Warning Lights Module 04: Tyres and Wheels Module 05: The Engine Module 06: The Cooling System Module 07: The Fuel System Module 08: The Electrical System Module 09: The Drivetrain Module 10: The Braking System Module 11: Car Restoration Plan Module 12: Restoring the Car's Interior Module 13: Restoring the Car's Exterior Module 14: Restoring the Engine Module 15: Reassemble & Test Drive Module 16: Hearing Conservation at Workplace Module 17: Provision and Use of Work Equipment Regulations Module 18: Selection and Conformity of Work Equipment Module 19: Safe Functionality of Work Equipment Module 20: Monitoring and Evaluation of Work Equipment Module 21: Maintenance of Work Equipment ________________________________________________________________________ Complete Career Guide for Car Mechanic & Car Maintenance Level 3 Diploma (A to Z) List of career guide courses included in Car Mechanic & Car Maintenance Level 3 Diploma With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment Accreditation All of our courses are fully accredited, including this Car Mechanic & Car Maintenance Course, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in Car Mechanic & Car Maintenance. Certification Once you've successfully completed your Car Mechanic & Car Maintenance Course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our Car Mechanic & Car Maintenance Course certification has no expiry dates, although we do recommend that you renew them every 12 months. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Car Mechanic & Car Maintenance Course can be taken by anyone who wants to understand more about the topic. With the aid of this course, you will be able to grasp the fundamental knowledge and ideas. Additionally, this Car Mechanic & Car Maintenance Course is ideal for: Aspiring Car Mechanics Individuals interested in car restoration Automotive enthusiasts seeking in-depth knowledge Mechanics aiming to enhance their skill set Requirements Learners do not require any prior qualifications to enrol on this Car Mechanic & Car Maintenance Course. You just need to have an interest in Car Mechanic & Car Maintenance Course. Career path After completing this Car Mechanic & Car Maintenance Course you will have a variety of careers to choose from. The following job sectors of Car Mechanic & Car Maintenance Course are: Car Mechanic - £25K to 35K/year. Automotive Technician - £25K to 40K/year. Vehicle Restoration Specialist - £30K to 45K/year. Automotive Engineer - £30K to 50K/year. Garage Manager - £35K to 55K/year. Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.