3350 Courses

Are you ready to embark on an enlightening journey of wisdom with the Market Research Analyst bundle and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Market Research Analyst Advanced Diploma. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Marketing Principles Course 02: Marketing Secrets for High Sales Course 03: Marketing Strategies for Business Course 04: Learn with Case Study - Market Research Course 05: Research Methods in Business Course 06: Business Intelligence Analyst Course Course 07: Excel at Marketing Through a Well-Defined Marketing Strategy Course 08: Sales Analysis in Excel Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Market Research Analyst Advanced Diploma bundle illuminate your path to wisdom. The Market Research Analyst Advanced Diploma bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Market Research Analyst Advanced Diploma package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Market Research Analyst bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Market Research Analyst Advanced Diploma community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Market Research Analyst bundle. Establish robust bases across each course nestled within the Market Research Analyst bundle. Decipher intricate concepts through the articulate content of the Market Research Analyst bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Market Research Analyst bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Market Research Analyst bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Market Research Analyst bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Market Research Analyst bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Market Research Analyst bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Market Research Analyst journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Market Research Analyst bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Market Research Analyst bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Are you looking to enhance your AML, KYC and Risk Management skills? If yes, then you have come to the right place. Our comprehensive course on AML, KYC and Risk Management will assist you in producing the best possible outcome by mastering the AML, KYC and Risk Management skills. The AML, KYC and Risk Management is for those who want to be successful. In the AML, KYC and Risk Management, you will learn the essential knowledge needed to become well versed in AML, KYC and Risk Management. Our AML, KYC and Risk Management starts with the basics of AML, KYC and Risk Management and gradually progresses towards advanced topics. Therefore, each lesson of this AML, KYC and Risk Management is intuitive and easy to understand. Why would you choose the AML, KYC and Risk Management from Compliance Central: Lifetime access to AML, KYC and Risk Management course materials Full tutor support is available from Monday to Friday with the AML, KYC and Risk Management Learn AML, KYC and Risk Management skills at your own pace from the comfort of your home Gain a complete understanding of AML, KYC and Risk Management Accessible, informative AML, KYC and Risk Management learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the AML, KYC and Risk Management bundle Study AML, KYC and Risk Management in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your AML, KYC and Risk Management Curriculum Breakdown Diploma in Anti Money Laundering (AML) 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 Officer 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 KYC Module 01: Introduction to KYC Module 02: Customer Due Diligence Module 03: AML (Anti-Money Laundering) Module 04: KYC, AML, and Data Privacy Regulations for Businesses Operations in the United Kingdom Module 05: Regulations to be Complied by Industries Module 06: Methods for carrying out KYC and AML and the Future of KYC Compliance Risk Management Process Module 01: Introduction to Risk Management. Module 02: Risk Management Process. Module 03: Benefits of Risk Management. Module 04: Enterprise Risk Management. Module 05: Managing Financial Risks. Module 06: Managing Technology Risks. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The AML, KYC and Risk Management helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in AML, KYC and Risk Management. It is also great for professionals who are already working in AML, KYC and Risk Management and want to get promoted at work. Requirements To enrol in this AML, KYC and Risk Management, all you need is a basic understanding of the English Language and an internet connection. Career path The AML, KYC and Risk Management will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to AML, KYC and Risk Management. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99

Dive deep into the world of spreadsheet mastery with our 'Data Analysis, Automating and Visualisation in Excel' course. This comprehensive programme takes you on a transformative journey from the rudiments of worksheet modifications to the advanced arts of data forecasting. Within each module, you'll unveil the secrets behind efficient list management, compelling visualisations, and the magic of PivotTables, among many other features. Moreover, automation isn't left behind; it's the heart and soul, making your workbook a living entity that breathes efficiency. By the end, you'll not only be fluent in Excel's vast toolkit but also possess the flair to present data in engaging, insightful ways. Learning Outcomes: Master the art of efficient worksheet modification and effective list management. Harness the power of data analysis tools to make informed decisions. Craft compelling visuals using charts, Sparklines, and data mapping techniques. Implement PivotTables and PivotCharts to dissect complex data sets effortlessly. Automate workbook functionalities for optimised and streamlined processes.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/03/Data-Analysis-Automating-and-Visualisation-in-Excel.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why buy this Data Analysis, Automating and Visualisation in Excel? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Data Analysis, Automating and Visualisation in Excel Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience Who is this Data Analysis, Automating and Visualisation in Excel course for? Individuals looking to enhance their data visualisation and analysis prowess. Managers wanting a streamlined approach to handling large datasets. Academic researchers aiming to present their data in a more compelling format. Finance professionals seeking efficient ways to dissect and forecast financial data. Marketing strategists aiming to leverage data for improved decision-making. Career path Data Analyst: £30,000 - £50,000 per annum Financial Analyst: £35,000 - £55,000 per annum Market Research Analyst: £28,000 - £45,000 per annum Business Intelligence Analyst: £32,000 - £56,000 per annum Operations Analyst: £30,000 - £52,000 per annum Research Scientist (Data-oriented): £35,000 - £60,000 per annum Prerequisites This Data Analysis, Automating and Visualisation in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis, Automating and Visualisation in Excel was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Assignment Assignment - Data Analysis, Automating and Visualisation in Excel 00:00:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special NFT for Beginners Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The NFT for Beginners Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This NFT for Beginners Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This NFT for Beginners Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this NFT for Beginners? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the NFT for Beginners there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This NFT for Beginners course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This NFT for Beginners does not require you to have any prior qualifications or experience. You can just enrol and start learning.This NFT for Beginners was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This NFT for Beginners is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 01: Introduction to Non-Fungible Tokens Introduction to Non-Fungible Tokens 00:25:00 Module 02: Blockchain and Ethereum Blockchain and Ethereum 00:25:00 Module 03: NFT Marketplaces and Projects NFT Marketplaces and Projects 00:25:00 Module 04: NFT Security and Standards NFT Security and Standards 00:20:00 Module 05: Creating and Selling NFTs Creating and Selling NFTs 00:20:00 Module 06: Investing In NFTs Investing In NFTs 00:25:00 Module 07: The Future of NFTs The Future of NFTs 00:20:00

Dive deep into the realm of Excel with our meticulously designed course on 'Excel Pivot Tables, Pivot Charts, Slicers, and Timelines'. Unlock the secrets of powerful data visualisation tools like Dashboards, Slicers, and Timelines, while mastering the art of reporting by varying time intervals. Whether you wish to streamline your reporting tasks or augment your analytical capabilities, this course will provide you with the tools and techniques to extract insights from data seamlessly. Highlights of the Dynamic Excel Gantt Chart and Timelines : Discover the secrets of finding the key to doing your best work Understand how to reach your most productive level based on scientific research and principles Explore the hidden productivity recipes of professionals and the most successful people in the world Develop a routine for greater productivity both at home and at work Understand the time management strategies for managing your time when dealing with multiple urgent tasks Discover how to achieve higher productivity by making just a few simple changes Learn simple yet highly effective productivity hacks that you can apply in minutes or less Explore science-backed advice for developing a 'Productivity Mindset' and beat procrastination Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who is this Course for? Data analysts aiming to bolster their data visualisation techniques. Professionals in finance, sales, and marketing looking to generate detailed reports. Researchers keen on presenting data in an insightful manner. Students aspiring to enhance their data representation and analysis skills. Project managers wanting to make data-driven decisions How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Requirements The Dynamic Excel Gantt Chart and Timelines is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16. Career Path Data Analyst: £30,000 - £50,000 Financial Analyst: £35,000 - £55,000 Sales Analyst: £28,000 - £47,000 Market Researcher: £24,000 - £45,000 Data Visualization Specialist: £32,000 - £52,000 Business Intelligence Analyst: £38,000 - £60,000 Course Curriculum Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Getting started with your Pivot Table 00:04:00 Drill Down 00:01:00 Managing the Field List 00:02:00 Changing the Calculation type with Value Field Settings 00:06:00 Growing your Pivot Table with Multiple Fields 00:04:00 Formatting the Pivot Table 00:05:00 Sorting and Filtering the Pivot Table 00:03:00 Creating a Dashboard with Slicers, Timelines and Pivot Charts 00:09:00 Reporting by day, month, qtr, or year within the Pivot Table 00:04:00 Refreshing the Pivot Data with new data 00:03:00 Adding your own calculations into the Pivot Table 00:03:00 The power of the Filter Section in the Pivot Table 00:04:00 PowerQuery 00:12:00 PowerPivot 00:21:00 Assignment Assignment - Excel Pivot Tables, Pivot Charts, Slicers, and Timelines 00:00:00

In the digital age, the ability to interpret and predict data trends is paramount. Introducing 'Data Analysis and Forecasting in Excel', a comprehensive course tailored to unveil the intricacies of Excel's powerful tools. Dive deep into the world of worksheets, discover the magic of PivotTables, and unravel the secrets of data visualisation. Whether you're a novice eager to delve into data or a seasoned analyst looking to refine your skills, this course promises a transformative journey into the realm of Excel analytics. The curriculum is designed with the utmost care to ensure a holistic understanding. From the basics of modifying worksheets to the advanced techniques of forecasting data, every module is a step towards mastering Excel. With a focus on real-world applications, learners will be equipped to harness the potential of Excel, making data-driven decisions with confidence and precision. Visualisation is at the heart of understanding data. This course not only teaches you how to analyse data but also how to represent it effectively using charts, PivotCharts, and the innovative Sparklines. By the end of this course, you'll be adept at mapping data, automating workbook functionalities, and employing lookup functions with finesse. Learning Outcomes: Master the techniques of modifying and organising worksheets for optimal data representation. Understand and implement effective list management strategies within Excel. Analyse complex datasets and derive meaningful insights. Design and create compelling visual representations using charts and other visual tools. Efficiently utilise PivotTables and PivotCharts for advanced data analysis. Integrate and manage data across multiple worksheets and workbooks. Implement lookup functions and audit formulas to ensure data accuracy and integrity. Why buy this Data Analysis and Forecasting in Excel course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Data Analysis and Forecasting in Excel Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience Who is this Data Analysis and Forecasting in Excel course for? Individuals keen on mastering Excel for data interpretation and visualisation. Business analysts aiming to enhance their data forecasting abilities. Students pursuing a career in data analytics or business intelligence. Managers and decision-makers seeking to make data-driven strategies. Researchers looking to streamline and enhance their data processing techniques. Career path Data Analyst: Average salary range £30,000 - £50,000 annually. Business Intelligence Analyst: Average salary range £35,000 - £55,000 annually. Market Research Analyst: Average salary range £27,000 - £45,000 annually. Financial Analyst: Average salary range £35,000 - £60,000 annually. Operations Research Analyst: Average salary range £40,000 - £65,000 annually. Management Analyst: Average salary range £45,000 - £70,000 annually. Prerequisites This Data Analysis and Forecasting in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis and Forecasting in Excel was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00

Unleash the power of data with our Data Analysis in Excel course, where you'll journey through the realm of spreadsheet analysis and uncover the secrets hidden within your data. In today's data-driven world, the ability to navigate, interpret, and extract insights from data is a coveted skill. Whether you're a professional looking to enhance your analytical capabilities or a student aiming to excel in data-driven fields, this course empowers you to harness Excel's full potential for data analysis. From modifying worksheets to forecasting future trends, you'll master the art of data manipulation, visualization, and analysis with confidence and precision. Learning Outcomes Master the art of modifying Excel worksheets to suit your data analysis needs. Discover advanced data analysis techniques, including working with lists and lookup functions. Create compelling data visualizations using charts, PivotTables, and PivotCharts. Effortlessly manage multiple worksheets and workbooks, making data organization a breeze. Apply data forecasting techniques and automate workbook functionality, saving time and boosting productivity. Why choose this Data Analysis in Excel course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Data Analysis in Excel course for? Professionals seeking to enhance their data analysis skills. Students preparing for careers in data-driven industries. Analysts, researchers, and data enthusiasts eager to upskill. Business professionals looking to make data-driven decisions. Anyone interested in harnessing Excel for powerful data analysis. Career path Data Analyst: £25,000 - £47,000 Business Analyst: £26,000 - £50,000 Financial Analyst: £26,000 - £56,000 Market Research Analyst: £24,000 - £40,000 Operations Analyst: £23,000 - £48,000 Business Intelligence Analyst: £27,000 - £56,000 Prerequisites This Data Analysis in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis in Excel was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Recommended Materials Workbook - Data Analysis in Excel 00:00:00 Assignment Assignment - Data Analysis in Excel 00:00:00

Overview A 1-day course on inflation-linked bonds and derivatives, focusing on the UK market in particular. We examine how inflation is defined and quantified, the choice of index (RPI vs. CPI), and the most common cash flow structures for index-linked securities. We look in detail at Index-linked Gilts, distinguishing between the old-style and new-style quotation conventions, and how to calculate the implied breakeven rate. Corporate bond market in the UK, and in particular the role of LPI in driving pension fund activity. Inflation swaps and other derivatives, looking at the mechanics, applications and pricing of inflation swaps and caps/floors. The convexity adjustment for Y-o-Y swaps is derived intuitively. Who the course is for Front-office sales product control research Traders Risk managers Fund managers Project finance and structured finance practitioners Accountants, auditors, consultants Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview 2 day course on single name CDS, index CDS and index CDS options and how to use them to express views and hedge risks in credit markets Who the course is for Consultants Analysts Managers C-Level executives People in need of knowledge to develop a blockchain strategy People working with blockchain projects Regulators Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview 1 day course covering mechanics, pricing and applications of cross currency swaps (CCS) and cross currency basis swaps (CCBS) Who the course is for Corporate treasurers and financial institution asset-liability management staff Interest rate and FX derivative traders, salespeople and quants Multi-lateral development banks Fixed income asset managers Risk management Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now