2084 Design courses delivered Online

Duration 2 Days 12 CPD hours This course is intended for Authors Overview Please refer to course overview This course teaches experienced authors advanced report building techniques to enhance, customize, manage, and distribute reports. Additionally, the student will learn how to create highly interactive and engaging reports that can be run offline by creating Active Reports. Create query models Build a query and connect it to a report Answer a business question by referencing data in a separate query Create reports based on query relationships Create join relationships between queries Combine data containers based on relationships from different queries Create a report comparing the percentage of change Introduction to dimensional reporting concepts Examine data sources and model types Describe the dimensional approach to queries Apply report authoring styles Introduction to dimensional data in reports Use members to create reports Identify sets and tuples in reports Use query calculations and set definitions Dimensional report context Examine dimensional report members Examine dimensional report measures Use the default measure to create a summarized column in a report Focus your dimensional data Focus your report by excluding members of a defined set Compare the use of the filter() function to a detail filter Filter dimensional data using slicers Calculations and dimensional functions Examine dimensional functions Show totals and exclude members Create a percent of base calculation Create advanced dynamic reports Use query macros Control report output using a query macro Create a dynamic growth report Create a report that displays summary data before detailed data and uses singletons to summarize information Design effective prompts Create a prompt that allows users to select conditional formatting values Create a prompt that provides users a choice between different filters Create a prompt to let users choose a column sort order Create a prompt to let users select a display type Examine the report specification Examine report specification flow Identify considerations when modifying report specifications Customize reporting objects Distribute reports Burst a report to email recipients by using a data item Burst a list report to the IBM Cognos Analytics portal by using a burst table Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship Enhance user interaction with HTML Create interactive reports using HTML Include additional information with tooltips Send emails using links in a report Introduction to IBM Cognos Active Reports Examine Active Report controls and variables Create a simple Active Report using Static and Data-driven controls Change filtering and selection behavior in a report Create interaction between multiple controls and variables Active Report charts and decks Create an Active Report with a Deck Create an Active Report with 11.0 visualizations

The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience. Who is this course for? Excel 2019 Intermediate is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Excel 2019 Intermediate is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Intro Introduction 00:01:00 Section 01 Linking Worksheets and Workbooks 00:07:00 Linking Worksheets with 3D References 00:05:00 Understanding the Consolidate Feature 00:06:00 Section 02 What are Range Names 00:06:00 Creating Range Names Using the Name Box and Define Name 00:06:00 Creating Range Names Using Create from Selection 00:03:00 Section 03 Understanding the Differences Between Sorting and Filtering 00:03:00 Sorting Lists 00:07:00 Filtering Lists 00:06:00 Creating Subtotals 00:05:00 Section 04 Creating Tables and Understanding the Benefits 00:06:00 Understanding the Elements of a Table 00:05:00 Formatting a Table 00:05:00 Sorting and Filtering Tables 00:04:00 Filtering with Slicers 00:07:00 Calculating with Tables 00:06:00 Removing Erroneous Table Data 00:05:00 Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 What is Conditional Formatting 00:03:00 Conditional Formatting-HIghlight Cells and Top Bottom Rules 00:06:00 Conditional Formatting-Data Bars, Icon Sets, and Color Scales 00:06:00 Using Custom Fonts and Colors 00:03:00 Using Custom Conditional Formatting 00:05:00 Modyfing or Removing Conditional Formatting 00:04:00 Section 06 What are Charts 00:06:00 Forecasting with Trendlines 00:05:00 Creating a Chart Template 00:04:00 Displaying Trends with Sparklines 00:08:00 Creating Charts 00:05:00 Understanding Chart Elements 00:05:00 Modifying Chart Elements 00:05:00 Changing and Moving Charts 00:03:00 Filtering a Chart 00:04:00 Formatting Charts 00:13:00 Adjusting Numbering 00:06:00 Creating Dual Axis Charts 00:05:00 Section 07 What is a PivotTable 00:05:00 Creating a PivotTable 00:07:00 Working with the PivotTable Fields Pane 00:10:00 Basic Data Organization and Analysis with PivotTables 00:08:00 Formatting PivotTables 00:05:00 Creating a PivotChart 00:04:00 Modifying and Formatting a PivotChart 00:04:00 Using Slicers and Timeline Slicers 00:08:00 Section 08 Using the PivotTable and PivotChart Wizard 00:03:00 Adding a Calculated Field 00:04:00 Adding a Calculated Item 00:04:00 Applying Conditional Formatting to a PivotTable 00:06:00 Creating Filter Pages for a PivotTable 00:04:00 Enabling the PowerPivot Add-in 00:11:00 Recap Recap 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

ISO 14001:2015 (EMS) Lead Auditor Training Course

The world of banking isn’t just about numbers — it’s the rhythm behind the economy’s pulse. This Introduction to Banking Course walks you through the core concepts that shape today’s financial systems. From the origins of banking and types of financial institutions to how interest, credit, and digital banking influence everyday life — this course builds a solid foundation for those curious about how money moves. Whether you’re exploring a future in finance or simply want a better grasp of how banks function, you’ll find clarity without the jargon. Designed for anyone looking to get familiar with banking in a structured, accessible way, this course helps demystify terms that often seem reserved for insiders. You’ll explore topics like central banking, risk management, monetary policy, and the global banking framework — all without needing a calculator in hand. With content that flows smoothly and explanations that don’t send you running to a dictionary, this course offers exactly what’s needed to make sense of the banking sector. It’s all online, available on your schedule, and perfectly suited for those who prefer learning without the pressure of a classroom. Meet the Accreditation This premium online course titled Introduction to Banking ensures your professional development with CPD accreditation. You'll have the privilege of learning in your own time, at your own pace and earning an accredited certification. Key Benefits Eligibility for a CPD Quality Standards (CPD QS)-accredited certificate on successful completion of Introduction to Banking Course Learning materials of the course contain engaging voiceover and visual elements for your comfort Freedom to study at your own pace 24/7 access to the Introduction to Banking course materials for 12 months Full Tutor support on weekdays (Monday - Friday) On the Introduction to Banking course, we guarantee that you will gain relevant skills and tremendous knowledge on the subject. The certificate you'll achieve after completing the Introduction to Banking course will help you land the job you want in a related field. Enjoy a pleasant and professional 100% online learning experience, enrol in our Introduction to Banking course today, and take control of your career! Course Curriculum: Module 01: Banking: An Introduction Module 02: Bank Activities and Services Module 03: Categories and Types of Banking Institutions Module 04: International Banking Module 05: Bank Financial Management Module 06: Bank Risk Management How is the Introduction to Banking assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Introduction to Banking training is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the Introduction to Banking course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Introduction to Banking training.

Tired of searching and accumulating all the relevant courses for this specific field? It takes a substantial amount of your time and, more importantly, costs you a fortune! Well, we have just come up with the ultimate solution for you by giving this all-inclusive Ms Excel: Excel PowerQuery and PowerPivot mega bundle. This 40 courses mega bundle keeps you up-to-date in this field and takes you one step ahead of others. Keeping in mind the latest advancements in this ever-emerging sector, the Ms Excel: Excel PowerQuery and PowerPivot bundle covers all the state-of-the-art tools and techniques required to become a competent worker in this area. You will encounter specific courses relevant to the sector. We take you from the most introductory fundamentals to advance knowledge in a step-by-step manner. In addition, the Ms Excel: Excel PowerQuery and PowerPivot bundle also consists of courses related to some soft skills that you will need to succeed in any industry or job sector. This Ms Excel: Excel PowerQuery and PowerPivot Bundle consists of the following premium courses: Course 01: Microsoft Excel Level 3 Course 02: New Functions in Microsoft Excel 2021 Course 03: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 04: Microsoft Excel: Excel Sheet Comparison with VBA Course 05: Microsoft Excel: Master Power Query in 120 Minutes! Course 06: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 07: Excel Pivot Tables Course 08: Data Analysis in Microsoft Excel Complete Training Course 09: Excel Must know Formulas and Functions Course 10: Excel spreadsheet for Beginner Course 11: Excel Data Analysis Course 12: Excel Vlookup, Xlookup, Match and Index Course 13: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 14: MS Word Diploma Course 15: Proofreading & Copyediting Course 16: PowerPoint Diploma 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 Course 26: Planning & Control Using Microsoft Project 2013, 2016 & 2019 Course 27: Data Protection and Data Security Level 2 Course 28: Office Skills and Administration Management Diploma Course 29: Touch Typing Essentials Course 30: Document Control Moreover, this bundles include 10 career-focused courses: Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Course 04: Video Job Interview for Job Seekers Course 05: Create a Professional LinkedIn Profile Course 06: Business English Perfection Course Course 07: Networking Skills for Personal Success Course 08: Boost Your Confidence and Self-Esteem Course 09: Public Speaking Training Course 10: Learn to Fight Procrastination Our cutting-edge learning package offers top-notch digital aid and first-rate tutor support. You will acquire the crucial hard and soft skills needed for career advancement because this bundle has been thoroughly examined and is career-friendly. So don't overthink! Enrol today. Learning Outcomes This unique Ms Excel: Excel PowerQuery and PowerPivot mega bundle will help you to- Quench your thirst for knowledge Be up-to-date about the latest advancements Achieve your dream career goal in this sector Know the applicable rules and regulations needed for a professional in this area Acquire some valuable knowledge related to Ms Excel: Excel PowerQuery and PowerPivot to uplift your morale The bundle 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. Moreover, you can learn from any place in your own time without travelling for classes. Certificate: PDF Certificate: Free for all 40 courses Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Ms Excel: Excel PowerQuery and PowerPivot bundle is designed to assist anyone with a curious mind, anyone looking to boost their CVs or individuals looking to upgrade their career to the next level can also benefit from the learning materials. Requirements The courses in this bundle has been designed to be fully compatible with tablets and smartphones. Career path This Ms Excel: Excel PowerQuery and PowerPivot bundle will give you an edge over other competitors and will open the doors for you to a plethora of career opportunities. 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 (Microsoft Excel Level 3) 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.

Duration 2 Days 12 CPD hours This course is intended for Report Authors Overview Create query models Create reports based on query relationships Introduction to dimensional data Introduction to dimensional data in reports Dimensional report context Focus your dimensional data Calculations and dimensional functions Create advanced dynamic reports This offering teaches Professional Report Authors about advanced report building techniques using relational data models, dimensional data, and ways of enhancing, customizing, managing, and distributing professional reports. The course builds on topics presented in the Fundamentals course. Activities will illustrate and reinforce key concepts during this learning activity. Create query models Build a query and connect it to a report Answer a business question by referencing data in a separate query Create reports based on query relationships Create join relationships between queries Combine data containers based on relationships from different queries Create a report comparing the percentage of change Introduction to dimensional reporting concepts Examine data sources and model types Describe the dimensional approach to queries Apply report authoring styles Introduction to dimensional data in reports Use members to create reports Identify sets and tuples in reports Use query calculations and set definitions Dimensional report context Examine dimensional report members Examine dimensional report measures Use the default measure to create a summarized column in a report Focus your dimensional data Focus your report by excluding members of a defined set Compare the use of the filter() function to a detail filter Filter dimensional data using slicers Calculations and dimensional functions Examine dimensional functions Show totals and exclude members Create a percent of base calculation Create advanced dynamic reports Use query macros Control report output using a query macro Create a dynamic growth report Create a report that displays summary data before detailed data and uses singletons to summarize information Design effective prompts Create a prompt that allows users to select conditional formatting values Create a prompt that provides users a choice between different filters Create a prompt to let users choose a column sort order Create a prompt to let users select a display type Examine the report specification Examine report specification flow Identify considerations when modifying report specifications Customize reporting objects Distribute reports Burst a report to email recipients by using a data item Burst a list report to the IBM Cognos Analytics portal by using a burst table Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship Enhance user interaction with HTML Create interactive reports using HTML Include additional information with tooltips Send emails using links in a report Introduction to IBM Cognos Active Reports Examine Active Report controls and variables Create a simple Active Report using Static and Data-driven controls Change filtering and selection behavior in a report Create interaction between multiple controls and variables Active Report charts and decks Create an Active Report with a Data deck Use Master detail relationships with Decks Optimize Active Reports Create an Active Report with new visualizations

Get ready for an exceptional online learning experience with the Financial Engineering & Risk Management bundle! This carefully curated collection of 30 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Financial Engineering & Risk Management is a dynamic package that blends the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Financial Engineering & Risk Managementpackage has something for everyone. As part of the Financial Engineering & Risk Management package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Financial Engineering & Risk Management bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following 30 CPD Accredited Courses: Course 01: Financial Analysis Course 02: Financial Management Course 03: Basic Business Finance Course 04: Improve your Financial Intelligence Course 05: Financial Investigator Course 06: FinTech Course 07: Investment Course 08: Business and Data Analytics for Beginners Course 09: Business and Financial Modeling Specialisation Course 10: Corporate Finance: Profitability in a Financial Downturn Course 11: Banking and Finance Accounting Statements Financial Analysis Course 12: Financial Accounting Course 13: Finance: Financial Risk Management Course 14: Anti-Money Laundering (AML) Training Course 15: Capital Budgeting & Investment Decision Rules Course 16: Making Budget & Forecast Course 17: Financial Modeling Using Excel Course 18: Learn Financial Analytics and Statistical Tools Course 19: Statistics Course 20: Economics Course 21: Professional Personal Finance Course Course 22: Ultimate Guide to Financial Security Course 23: Trading and Financing: Candlestick Pattern Course 24: Blockchain & Cryptocurrency Course 25: Penny Stocks Day Trading Course 26: Stock Market Day Trading Strategies Course 27: Financial Consultant Training Course 28: Develop Your Career in Finance: Blue Ocean Strategy Course 29: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 30: Xero Accounting and Bookkeeping Online What will make you stand out? On completion of this online Financial Engineering & Risk Managementbundle, you will gain: CPD QS Accredited Proficiency After successfully completing the Financial Engineering & Risk Managementbundle, you will receive a FREE CPD PDF Certificates as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials. The online test with immediate results You can study and complete the Financial Engineering & Risk Management bundle at your own pace. Study for the Financial Engineering & Risk Management bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Financial Engineering & Risk Management bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Financial Engineering & Risk Management, a rich anthology of 30 diverse courses. Each course in the Financial Engineering & Risk Management bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This Financial Engineering & Risk Management bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Financial Engineering & Risk Management bundle offers you the flexibility and convenience to learn at your own pace. Make the Financial Engineering & Risk Management package your trusted companion in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Financial Engineering & Risk Managementbundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements Without any formal requirements, you can delightfully enrol in this Financial Engineering & Risk Managementbundle. Career path Unleash your potential with the Financial Engineering & Risk Management bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Financial Engineering & Risk Management bundle package. Certificates CPD Quality Standard Certificate Digital certificate - Included 30 CPD Accredited Digital Certificates and A Hard Copy Certificate

Explore endless possibilities and achieve tangible results with our wide range of online courses, prepared to suit every interest and skill level. Each course is thoughtfully designed for flexibility and useful application, ensuring you can learn and grow at your own pace from anywhere and transform your talents to accomplish your goals.  Whether you're advancing your career, pursuing a passion, or seeking new opportunities, our courses will assist you in reaching your goals. Join us today and take the next step in your personal and professional journey with confidence and convenience. Start shaping your future now.  This 20-in-1 Ultimate Excel Beginner to Advanced bundle consists of the following Courses: Course 01: MS Word Diploma Course 02: Proofreading & Copyediting Course 03: PowerPoint Diploma Course 04: Microsoft Excel Level 3 Course 05: New Functions in Microsoft Excel 2021 Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Microsoft Excel: Excel Sheet Comparison with VBA Course 08: Microsoft Excel: Master Power Query in 120 Minutes! Course 09: 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 Additionally, you will get 5 other career-guided courses in this Excel Beginner to Advanced bundle: Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Course 04: Video Job Interview for Job Seekers Course 05: Create a Professional LinkedIn Profile So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this Excel Beginner to Advanced bundle. Learning Outcomes of Excel Beginner to Advanced Bundle This career-oriented bundle will help you to Gain the ability to excel in the role of Excel Beginner to Advanced Know your responsibilities as Excel Beginner to Advanced and convey your experience to others Gain excellent interpersonal and communication skills Know the pros and cons of working as Excel Beginner to Advanced Adhere to the regulations around this area Gain time and risk management skills to ensure efficiency Manipulate technological advancement to become more effective Maintain moral standards and set an example for your peers CPD 250 CPD hours/points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Excel Beginner to Advanced bundle. Requirements This Excel Beginner to Advanced course has been designed to be fully compatible with tablets and smartphones. Career path Having this 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 (MS Word Diploma) for 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.

Level 4 & 5 QLS Endorsed | 20-in-1 Diploma Bundle | 20 Free CPD PDF| Lifetime Access

Level 4 & 5 QLS Endorsed | 20-in-1 Diploma Bundle | 20 Free CPD PDF+ 1 Transcript Certificate| Lifetime Access