3449 Courses delivered Online

Overview Learn about contract triggers, including European vs. American style, and variations like one-touch, no-touch, and double no-touch options. Who the course is for Risk managers IT System developers Traders and derivatives teams Consultants and brokers Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

***Limited Time Offer*** Give a compliment to your career and take it to the next level. This Business Law will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Business Law will help you keep ahead of the pack. The Business Law incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and knowledge, reaching out to the level of expertise required for your position. Further, this Business Law 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 profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of Business Law, you can equip yourself with the essentials to keep you afloat into the competition. Along with this Business Law course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. Courses are included in this Bundle: Course 01: Business Law Course 02: Commercial Law 2021 Course 03: Compliance & Business Risk Management Course 04: GDPR Data Protection Level 5 Course 05: Level 3 Tax Accounting Course 06: Investment Course 07: Business Analysis Level 3 Course 08: Budgeting and Forecasting Course 09: Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 10: Business Writing Course 11: Workplace Confidentiality So, enrol now to advance your career! 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) P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. Curriculum: Course 1: Business Law Course 2: Commercial Law 2021 01: Introduction of Commercial law 02: Business Organisations 03: International Trade: the Theory, the Institutions, and the Law 04: Sales of Goods Law 05: Consumer Law and Protection 06: E-Commerce Law 07: Competition Law Course 3: Compliance & Business Risk Management 1: Introduction to Compliance 2: Five basic elements of compliance 3: Compliance Management System (CMS) 4: Compliance Audit 5: Compliance and Ethics 6: Risk and Types of Risk 7: Introduction to Risk Management 8: Risk Management Process Course 4: GDPR Data Protection Level 5 01: GDPR Basics 02: GDPR Explained 03: Lawful Basis for Preparation 04: Rights and Breaches 05: Responsibilities and Obligations Course 5: Level 3 Tax Accounting 01: Tax System and Administration in the UK 02: Tax on Individuals 03: National Insurance 04: How to Submit a Self-Assessment Tax Return 05: Fundamentals of Income Tax 06: Payee, Payroll and Wages 07: Value Added Tax 08: Corporation Tax 09: Double Entry Accounting 10: Management Accounting and Financial Analysis 11: Career as a Tax Accountant in the UK Course 6: Investment 01: Introduction to Investment 02: Types and Techniques of Investment 03: Key Concepts in Investment 04: Understanding the Finance 05: Investing in Bond Market Course 7: Business Analysis Level 3 01: Introduction to Business Analysis 02: Business Processes 03: Business Analysis Planning and Monitoring 04: Strategic Analysis and Product Scope 05: Solution Evaluation Course 8: Budgeting and Forecasting Unit-1. Introduction Unit-2. Detail Budget Requirement Unit-3. Process of Making Budget Course 9: Fraud Management & Anti Money Laundering Awareness Complete Diploma 01: Introduction to Money Laundering 02: Proceeds of Crime Act 2002 03: Development of Anti-Money Laundering Regulation 04: Responsibility of the Money Laundering Reporting Office 05: Risk-based Approach Course 10: Business Writing Words to Cut Building Strong Sentences SCQA How to Write Punchy Summaries Words that Work, Feedback that Improves ProofReading Makes Perfect Course 11: Workplace Confidentiality 01: Introduction to workplace confidentiality 02: Business Etiquettes and Types of Confidentiality 03: The Importance of Confidentiality 04: Confidentiality with Co-workers 05: Preventing Confidentiality Breach 06: How Employers Can Protect Confidential Information CPD 120 CPD hours / points Accredited by CPD Quality Standards 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 Give a compliment to your career and take it to the next level. This Commercial law will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this coursewill help you keep ahead of the pack. The Commercial law incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and knowledge, reaching out to the level of expertise required for your position. Further, this coursewill 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 profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Commercial law, you can equip yourself with the essentials to keep you afloat into the competition. Along with this course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. What other courses are included with this Commercial law? Course 1: Business Law Course 2: Level 3 Tax Accounting Course 3: Contract Law UK Level 3 Course 4: GDPR Data Protection Level 5 Course 5: Compliance & Business Risk Management Course 6: Anti Money Laundering (AML) Regulation for AML Officers Diploma Course 7: Business Analysis Level 3 Course 8: Business Management Advanced Diploma Course 9: International Law Course 10: International Relations So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Commercial law: One payment, but lifetime access to 11 CPD courses Certificate, 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 and in-demand skills without leaving your home. 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 £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Curriculum of Commercial law Bundle Course 1: Commercial Law 2021 Introduction Business Organisations International Trade: the Theory, the Institutions, and the Law Sales of Goods Law Consumer Law and Protection E-Commerce Law Competition Law Course 2: Business Law Understanding Business Law European Community Law The Court System Civil and Alternative Dispute Resolution Contract & Business Law Employment Law Agency Law Consumer Law and Protection Law of Tort Business Organisations Company Law Business Property Competition Law Course 3: 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 Payee, Payroll and Wages Value Added Tax Corporation Tax Double Entry Accounting Management Accounting and Financial Analysis Career as a Tax Accountant in the UK Course 4: Contract Law UK Level 3 Introduction to UK Laws Ministry of Justice Agreements and Contractual Intention Considerations and Capacities of Contact Laws Terms within a Contract Misinterpretations and Mistakes Consumer Protection Privity of Contract Insurance Contract Laws Contracts for Employees Considerations in International Trade Contracts Laws and Regulations for International Trade Remedies for Any Contract Breach Course 5: GDPR Data Protection Level 5 GDPR Basics GDPR Explained Lawful Basis for Preparation Rights and Breaches Responsibilities and Obligations Course 6: Compliance & Business Risk Management Introduction to Compliance Five basic elements of compliance Compliance Management System (CMS) Compliance Audit Compliance and Ethics Risk and Types of Risk Introduction to Risk Management Risk Management Process Course 7: Anti Money Laundering (AML) Regulation for AML Officers Diploma Introduction to Money Laundering Proceeds of Crime Act 2002 Development of Anti-Money Laundering Regulation Responsibility of the Money Laundering Reporting Office Risk-based Approach Customer Due Diligence Record Keeping Suspicious Conduct and Transactions Awareness and Training Course 8: 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 9: Business Management Advanced Diploma Introduction to Business Management Operations Management Introduction to Business Analysis Strategic Analysis and Product Scope Project Management Business Development and Succession Planning Commercial Law- Business Process Management Planning & Forecasting Operations Performance Management Management of Cash and Credit Managing Risk and Recovery Quality Management Communication Skills Business Environment Organisational Skills Negotiation Techniques Human Resource Management Motivation and Counselling Customer Service Time Management Conflict Management Course 10: International Law Basics of International Law Sources of International Law International Law and Municipal Law International Organisations International Law of Human Rights Private International Law International Criminal Law Law of Treaties Territory and Jurisdiction Law of the Sea International Commercial Law International Environmental Law Course 11: International Relations Understanding International Relations Historical Context Actors in International Relations Theories in International Relations I: Realism and Liberalism Theories in International Relations II: The Marxist, The Constructivist and The Feminist Tradition International Political Economy Recent Issues in International Relations War International Organisation CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Commercial law 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 Commercial law is fully compatible with PC's, Mac's, Laptop, Tablet 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 these various CPD certificate will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Commercial Law 2021) 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.

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 Sports Agent 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 Sports Agent will help you keep ahead of the pack. The Sports Agent 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 Sports Agent 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 Sports Agent, you can equip yourself with the essentials to keep you afloat in the competition. Along with this course, you will get 10 premium courses, an original Hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Sports Agent Bundle Consists of the following Premium courses: Course 01: Football/Sports Agent Course 02: English Law and Legal System Level 3 Course 03: Law and Contracts - Level 2 Course 04: Level 3- Public Relation Course Course 05: Stakeholder Management Course 06: Facilities Management Level 3 Course 07: Business Management Advanced Diploma Course 08: Investment Course 09: Basic Business Finance Course 10: Level 3 Tax Accounting Course 11: Effective Communication Skills Diploma So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Course: 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 Gain valuable knowledge without leaving your home 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 £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Curriculum Course 01: Football/Sports Agent Introduction to Sports Agent Industry Duties and Functions of Sports Agent Characteristics, Types and Socio-Economic Aspects of Sports Agents Sports Agency Model and Regulations Representative Bodies and Brand Building Networking, Sponsorship and Required Skills Becoming a Sports Agent Course 02: English Law and Legal System Level 3 The Legal Workplace and Professionals Law and Legal Systems Contract Law & Business Law Human Rights Law Employment Law Property Law Mortgage Law Wills, Probate & Estate Law Criminal Law Other Common Laws & Legal Matters Course 03: Law and Contracts - Level 2 Introduction to UK Laws Ministry of Justice Agreements and Contractual Intention Considerations and Capacities of Contact Laws Terms within a Contract Misinterpretations and Mistakes Consumer Protection Privity of Contract Insurance Contract Laws Contracts for Employees Considerations in International Trade Contracts Laws and Regulations for International Trade Remedies for Any Contract Breach Course 04: Level 3- Public Relation Course Introduction to Public Relations Concepts of Public Relations Management and Organisation of Public Relations Public Relations Tactics and Research Major Fields of Public Relations Practice Part I Major Fields of Public Relations Practice Part II Social Media and PR Crisis management Ethics & Professionalism in Public Relations Course 05: Stakeholder Management Introducing Stakeholder Management Stakeholder Theories Stakeholder Mapping Building Strong Business Relationships With Stakeholders Stakeholder Engagement Stakeholder Engagement Through Effective Communication Monitoring and Evaluating the Engagement Managing Stakeholder Conflict Course 06: Facilities Management Level 3 Module 01: Introduction to Facility Management Module 02: Space Management Module 03: Managing Workplace Services Module 04: Human Resource and Contract Management Module 05: Lease Purchase and Vendor Management Module 06: Health and Safety at Work Module 07: Sustainable Facility Management Module 08: Maintenance and Repairs Module 09: Project Management Module 10: Business Development and Succession Planning Course 07: Business Management Advanced Diploma Introduction to Business Management Operations Management Introduction to Business Analysis Strategic Analysis and Product Scope Project Management Business Development and Succession Planning Business Process Management Planning & Forecasting Operations Performance Management Management of Cash and Credit Managing Risk and Recovery Quality Management Communication Skills Business Environment Organisational Skills Negotiation Techniques Human Resource Management Motivation and Counselling Customer Service Time Management Conflict Management Course 08: Investment Introduction to Investment Types and Techniques of Investment Key Concepts in Investment Understanding the Finance Investing in Bond Market Investing in Stock Market Risk and Portfolio Management Course 09: Basic Business Finance What is Business Finance? Why Businesses Fail The Principles of Business Finance Part 1 The Principles of Business Finance Part 2 The Balance Sheet The Income Statement The Cashflow Statement A Business Finance Exercise Financial Performance Indicators Investment Analysis Investment Analysis Exercise Key Learning Points in Business Finance Course 10: 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 Inheritance Tax Double Entry Accounting Management Accounting and Financial Analysis Career as a Tax Accountant in the UK Course 11: Effective Communication Skills Diploma Business Communication Verbal and Non-verbal Communication Written Communication Electronic Communication Communicating with Graphic Effectively Working for Your Boss CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Sports Agent 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 Sports Agent 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 Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Football/Sports Agent) 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.

CPD Certified | 8-in-1 Diploma Bundle | Free PDF Certificate | 24/7 Learner Support

In the ever-evolving landscape of remote work, Virtual Assistants have become indispensable, addressing a recent surge in demand in the UK job market. Navigating through the intricacies of hiring and managing virtual support staff is in high demand, especially in content creation, skill development, and online meeting management. Learning Outcomes: Upon completion of this Virtual Assistant Fundamentals bundle, you should be able to: Streamline content creation processes for optimal productivity. Master personal assistant roles and hone essential skills. Effectively manage online meetings with finesse and professionalism. Polish business writing prowess for impactful communication. Develop strategies for social media management and engagement. Attain proficiency in financial analysis and bookkeeping practices. Our comprehensive "Virtual Assistant Fundamentals" course is tailored to equip you with the prowess needed to thrive in this dynamic environment. Whether you're a business owner seeking efficient support or an aspiring Virtual Assistant eager to stand out, this course offers a strategic blend of essential skills, from business writing to financial analysis and social media strategy, ensuring you are primed for success in the virtual realm. Join us in reshaping the future of work as we delve into the core competencies that define a proficient Virtual Assistant. This Virtual Assistant Fundamentals Bundle Consists of the following Premium courses: Course 01: Hiring Virtual Assistants for Content Creation Course 02: Personal Assistant & Skill Development Training Course 03: Online Meeting Management Course 04: Business Writing Course 05: Social Media Strategist Training Course 06: Financial Analysis Course 07: Accounting and Bookkeeping Level 2 Course 08: Email Writing Training Course 09: Level 2 Microsoft Office Essentials Course 10: Working from Home Essentials Course 11: Freelancing on UpWork CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to excel in virtual support roles. Entrepreneurs seeking efficient virtual assistance. Professionals looking to enhance their remote collaboration skills. Requirements No requirements to enrol this Virtual Assistant Fundamentals course. Career path Content Creation Specialist: £30,000 - £45,000 per annum. Personal Assistant & Skill Developer: £25,000 - £40,000 per annum. Social Media Strategist: £28,000 - £42,000 per annum. Financial Analyst: £35,000 - £50,000 per annum. Online Meeting Manager: £28,000 - £45,000 per annum. Freelancer on UpWork: Variable, depending on projects and expertise. Certificates CPDQS Accredited e-Certificate Digital certificate - Included CPDQS Accredited Hard-Copy Certificate Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Hiring Virtual Assistants for Content Creation) 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.

Malcolm Frodsham, Director and Founder of Real Estate Strategies will present the Q3 RES Forecast results and give his thoughts on how the real estate market will perform over the coming months. There will be time for questions from attendees following the presentation. We look forward to you joining us then. Click here to book your place.

Overview This comprehensive course on Excel PowerQuery and PowerPivot will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel PowerQuery and PowerPivot comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Excel PowerQuery and PowerPivot. It is available to all students, of all academic backgrounds. Requirements Our Excel PowerQuery and PowerPivot is fully compatible with PC's, Mac's, Laptop, Tablet 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 3 sections • 28 lectures • 01:50:00 total length •pivot table power query power pivot - 1: 00:09:00 •pivot table power query power pivot - 2: 00:01:00 •pivot table power query power pivot - 3: 00:02:00 •pivot table power query power pivot - 4: 00:03:00 •pivot table power query power pivot - 5: 00:01:00 •pivot table power query power pivot - 6: 00:04:00 •pivot table power query power pivot - 7: 00:08:00 •pivot table power query power pivot - 8: 00:05:00 •pivot table power query power pivot - 9: 00:03:00 •pivot table power query power pivot - 10: 00:04:00 •pivot table power query power pivot - 11: 00:04:00 •pivot table power query power pivot - 12: 00:02:00 •pivot table power query power pivot - 13: 00:03:00 •pivot table power query power pivot - 14: 00:05:00 •pivot table power query power pivot - 15: 00:02:00 •pivot table power query power pivot - 16: 00:03:00 •pivot table power query power pivot - 17: 00:03:00 •pivot table power query power pivot - 18: 00:08:00 •pivot table power query power pivot - 19: 00:02:00 •pivot table power query power pivot - 20: 00:04:00 •pivot table power query power pivot - 21: 00:05:00 •pivot table power query power pivot - 22: 00:09:00 •pivot table power query power pivot - 23: 00:04:00 •pivot table power query power pivot - 24: 00:03:00 •pivot table power query power pivot - 25: 00:04:00 •pivot table power query power pivot - 26: 00:09:00 •Resources - Excel PowerQuery and PowerPivot: 00:00:00 •Assignment - Excel PowerQuery and PowerPivot: 00:00:00

🚀 Unlock the Power of Microsoft Excel with Our Excel VBA Programming Training Course! 📊 Are you ready to take your Excel skills to the next level? Dive deep into the world of Excel VBA programming and unleash the full potential of this powerful tool! Our comprehensive online course, 'Microsoft Excel VBA Programming Training,' is designed to equip you with the expertise needed to automate tasks, streamline processes, and boost productivity within Excel. Here's what you'll learn in this dynamic course: 📌 Section 1: Introduction Get acquainted with the fundamentals of Excel VBA programming. Understand its significance and explore the vast possibilities it offers to transform your Excel experience. 📌 Section 2: Macros Master the art of creating and executing macros to automate repetitive tasks and significantly reduce manual work. Learn to streamline your workflow like a pro! 📌 Section 3: VBA Editor Navigate the VBA Editor seamlessly. Gain proficiency in using this interface to write, edit, and debug your VBA code effectively. 📌 Section 4: Variables and Procedures Understand the concept of variables and procedures in VBA. Learn how to declare, assign, and utilize them efficiently to optimize your coding process. 📌 Section 5: Loops and IF Statements Discover the power of loops and conditional IF statements. Harness these constructs to create dynamic and responsive Excel applications. 📌 Section 6: Error Handling Learn robust error-handling techniques to troubleshoot issues and create resilient VBA programs. 📌 Section 7: User Defined Functions Unlock the potential of creating custom functions tailored to your specific needs, enhancing Excel's capabilities beyond its default functions. 📌 Section 8: Assignments Apply your newfound knowledge through hands-on assignments and practical exercises to reinforce your skills. 📌 Section 9: Creating Forms Explore the creation of user-friendly forms and interfaces within Excel, making interactions more intuitive and efficient. Whether you're a beginner or have some experience in Excel, this course is tailored to suit your learning needs. With comprehensive modules, real-world examples, and expert guidance, you'll gain the confidence to create powerful VBA scripts and automate Excel operations like never before! Join us today and embark on a transformative journey in mastering Microsoft Excel VBA programming. Elevate your Excel skills and become a proficient VBA programmer! Enroll now and excel in Excel VBA programming! 💡📈✨ Course Curriculum Section 1 - Introduction What is VBA 00:00 Object Orientated Programming 00:00 Section 2 - Macros Macros Initial Setup 00:00 Recording a Macro 00:00 Saving a Macro 00:00 Section 3 - VBA Editor Launching VBA 00:00 VB Editor 00:00 Custom Menu 00:00 Naming Projects 00:00 Modules 00:00 Code Window 00:00 Comments 00:00 Section 4 - Variables and Procedures Introduction 00:00 Vraibales 00:00 Variable Exercise 00:00 What are Procedures 00:00 What are Procedures - Part Two 00:00 What are Procedures - Part Three 00:00 Message Boxes 00:00 Input Box 00:00 Input Box - Part Two 00:00 Basic Navigation 00:00 Sheets 00:00 Draft LessonCell Navigation 00:00 Advanced Sheets 00:00 Offset 00:00 Section 5 - Loops and IF Statements Introduction 00:00 Operators 00:00 Using Variables 00:00 What is Automation 00:00 For Loop 00:00 Do Loops 00:00 IF Statements 00:00 IF Statements - Part Two 00:00 Select Case 00:00 Section 6 - Error Handling Debugging 00:00 Section 7 - User Defined Functions UDFs 00:00 Section 8 - Assignments Introduction 00:00 Exercise 1 - Record a Macro 00:00 Exercise 2 - Duplicating Data 00:00 Exercise 3 - Generate a Report 00:00 Generate a Report - Part Two 00:00 Exercise 4 - Inner and Outer Loops 00:00 Inner and Outer Loops - Part Two 00:00 Inner and Outer Loops - Part Three 00:00 Inner and Outer Loops - Part Four 00:00 Inner and Outer Loops - Part Five 00:00 Section 9 - Creating Forms Form Controls 00:00 Building the Form 00:00 Initialize the Form 00:00 Command Buttons 00:00 Command Buttons - Part Two 00:00

Duration 3 Days 18 CPD hours This course is intended for Report Authors Overview What is IBM Cognos Analytics ? Reporting Examine dimensionally modelled and dimensional data sources Examine personal data sources and data modules Examine List reports Aggregate measure/fact data Use shared dimensions to create multi-fact queries Add repeated information to reports Create crosstab reports Create complex crosstab reports Format, sort, and aggregate data in a crosstab report Create discontinuous crosstab reports Create Visualization reports Add business logic to reports using IBM Cognos Analytics ? Reporting Focus reports using filters Focus reports using prompts Augment reports using calculations Extend report functionality in IBM Cognos Analytics - Reporting Customize reports with conditional formatting Conditionally format one crosstab measure based on another Drill-through definitions Enhance the report layout Use additional report building techniques This offering provides Business and Professional Authors with an introduction to report building techniques using relational data models. Techniques to enhance, customize, and manage professional reports will be explored. Activities will illustrate and reinforce key concepts during this learning opportunity. What is IBM Cognos Analytics - Reporting? Create a simple list report Create a report from a dimensionally modeled relational data source Examine personal data sources and data modules Upload personal data Upload custom images Use navigation paths Create a report from a personal data source Examine list reports Group data in a list Format columns in a list Include headers and footers in a list Enhance a list report Aggregate measure/fact data Identify differences in aggregation Explore data aggregation Use shared dimensions to create multi-fact queries Create a multi-fact query in a list report Add repeated information to reports Create a mailing list report Create crosstab reports Add measures to a crosstab Data sources for a crosstab Create a simple crosstab report Create complex crosstab reports Add items as peers Create crosstab nodes and crosstab members Create a complex crosstab report Format, sort, and aggregate data in a crosstab Sort, format, and aggregate a crosstab report Create discontinuous crosstab reports Present unrelated items using a discontinuous crosstab Create a visualization report Create and format a visualization report Create a report that uses a Map visualization Show the same data graphically and numerically Focus reports using filters Apply filters to a report Apply a detail filter on fact data in a report Apply a summary filter to a report Focus reports using prompts Create a prompt by adding a parameter Add a value prompt to a report Add a Select & search prompt to a report Create a cascading prompt Augment reports using calculations Add calculations to a report Display prompt selections in the report title Customize reports with conditional formatting Create a multilingual report Highlight exceptional data and conditionally render a column Drill-through definitions Let users navigate to related data in IBM Cognos Analytics Enhance report layout Create a report structured on data items Create a condensed list report Use additional report building techniques Section a report and reuse objects within the same report Reuse layout components in a different report Explore options for reports that contain no data Additional course details: Nexus Humans B6158 IBM Cognos Analytics - Author Reports Fundamentals (v11.0.x) 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 B6158 IBM Cognos Analytics - Author Reports Fundamentals (v11.0.x) 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.