• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

3454 Accounting & Finance courses delivered Online

Introduction to Investment Banking

By Online Training Academy

Unlock the fundamentals of Investment Banking with our comprehensive course designed for aspiring financial professionals. Whether you're starting your career or aiming to deepen your understanding, our "Introduction to Investment Banking" covers everything you need to know. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access This course on Introduction to Investment Banking covers essential topics that equip learners with a deep understanding of the field. Students will gain knowledge about the principles and practices of investment banking, including its ethical considerations. They will explore the intricate structures and various aspects involved in investment banking operations. A focus on valuation methods will enable learners to assess the worth of companies and assets accurately. They will also delve into the processes of Initial Public Offerings (IPOs), understanding how companies go public. Additionally, the course covers Merger and Acquisition (M&A) transactions, providing insights into how companies merge or acquire others. Lastly, learners will study Leveraged Buyouts (LBOs), learning about the financial strategies used to acquire companies using borrowed funds. Overall, this curriculum offers a comprehensive foundation in investment banking, preparing students for roles where financial expertise and strategic insights are crucial. Course Curriculum Module 01: Introduction to Investment Banking Module 02: Ethics in Investment Banking Module 03: Structure and Sides of Investment Banking Module 04: Valuation Methods in Investment Banking Module 05: Initial Public Offering (IPO) Module 06: Merger and Acquisition (M&A) Module 07: Leveraged Buyout (LBO) Learning Outcomes: Understand fundamentals of Investment Banking operations and terminology. Apply ethical principles in various scenarios within Investment Banking. Analyse the structure and functions of Investment Banking organisations. Utilise different valuation methods for financial analysis in Investment Banking. Evaluate processes involved in Initial Public Offerings (IPOs) in Investment Banking. Examine strategies and implications of Mergers and Acquisitions (M&A) in finance. CPD 10 CPD hours / points Accredited by CPD Quality Standards Introduction to Investment Banking 1:30:20 1: Module 01: Introduction to Investment Banking 10:10 2: Module 02: Ethics in Investment Banking 09:03 3: Module 03: Structure and Sides of Investment Banking 08:58 4: Module 04: Valuation Methods in Investment Banking 18:51 5: Module 05: Initial Public Offering (IPO) 18:13 6: Module 06: Merger and Acquisition (M&A) 10:07 7: Module 07: Leveraged Buyout (LBO) 13:58 8: CPD Certificate - Free 01:00 Who is this course for? Graduates seeking finance sector careers. Professionals in finance exploring Investment Banking. Individuals interested in financial markets and corporate finance. Business students focusing on finance and banking. Anyone aiming for roles in financial advisory services. Career path Investment Analyst Corporate Finance Manager Mergers and Acquisitions Specialist Financial Advisor Equity Research Analyst Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Introduction to Investment Banking
Delivered Online On Demand1 hour 30 minutes
£12

Financial Investigator Training

By Online Training Academy

Are you fascinated by the world of financial crime? Ready to delve into the intricate art of investigation? Our comprehensive Financial Investigator Training is designed just for you! Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In the Financial Investigator Training, learners will explore the fundamentals of financial investigation, including the various types and characteristics of financial crimes. They will gain a comprehensive understanding of the laws and regulations aimed at combating financial fraud. Through practical exercises, they will develop skills in collecting, preserving, and analyzing evidence crucial to financial investigations. Additionally, participants will learn about the role and responsibilities of a financial investigator, along with the essential components of a financial crime response plan. This curriculum equips learners with the knowledge and techniques necessary to identify, investigate, and respond to various forms of financial crime effectively. Course Curriculum Module 01: Introduction to Financial Investigation Module 02: Introduction to Financial Investigator Module 03: Categories of Financial Crimes Module 04: Characteristics of Financial Crimes Module 05: Laws against Financial Fraud Module 06: Collecting, Preserving and Gathering Evidence Module 07: Financial Crime Response Plan Learning Outcomes: Identify key concepts in financial investigation techniques for introductory understanding. Recognize the role and responsibilities of a financial investigator proficiently. Classify various types of financial crimes accurately and categorically. Describe essential characteristics distinguishing different forms of financial crimes concisely. Summarise relevant laws concerning financial fraud adequately and comprehensively. Demonstrate proficiency in collecting, preserving, and handling evidentiary material meticulously. CPD 10 CPD hours / points Accredited by CPD Quality Standards Financial Investigator Training 1:09:40 1: Module 01: Introduction to Financial Investigation 07:23 2: Module 02: Introduction to Financial Investigator 13:01 3: Module 03: Categories of Financial Crimes 12:14 4: Module 04: Characteristics of Financial Crimes 07:40 5: Module 05: Laws against Financial Fraud 10:39 6: Module 06: Collecting, Preserving and Gathering Evidence 07:30 7: Module 07: Financial Crime Response Plan 10:13 8: CPD Certificate - Free 01:00 Who is this course for? Law enforcement professionals seeking financial investigation specialisation. Financial analysts aiming to broaden their skill set in investigation techniques. Compliance officers wishing to enhance their understanding of financial crimes. Legal professionals interested in gaining expertise in financial fraud investigation. Anyone looking to pursue a career in financial crime investigation. Career path Financial Investigator Fraud Analyst Compliance Officer Intelligence Analyst Law Enforcement Officer Forensic Accountant Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Financial Investigator Training
Delivered Online On Demand1 hour 12 minutes
£12

UK Self Assessment Tax Return

By Compliance Central

UK Self Assessment Tax Return course is for those who want to advance in this field. Throughout this course, you will learn the essential skills and gain the knowledge needed to become well versed in UK Self Assessment Tax Return. Our course starts with the basics of UK Self Assessment Tax Return and gradually progresses towards advanced topics. Therefore, each lesson of this UK Self Assessment Tax Return is intuitive and easy to understand. So, stand out in the job market by completing the UK Self Assessment Tax Return course. Get an accredited certificate and add it to your resume to impress your employers. Along with the UK Self Assessment Tax Return course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Curriculum Breakdown of the UK Self Assessment Tax Return Course Introduction to Self Assessment Logging into the HMRC System Fill in the Self Assessment Return CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this UK Self Assessment Tax Return course. Requirements To enrol in this UK Self Assessment Tax Return course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to UK Self Assessment Tax Return. Tax Accountant: £30,000 to £50,000 per year Tax Consultant: £35,000 to £60,000 per year Tax Analyst: £25,000 to £45,000 per year Financial Advisor (specializing in tax): £35,000 to £60,000 per year Tax Compliance Officer: £25,000 to £40,000 per year 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 each

UK Self Assessment Tax Return
Delivered Online On Demand1 hour
£12

Mastering Quickbooks Online - CPD Certified

By Compliance Central

Are you looking to enhance your Quickbooks skills? If yes, then you have come to the right place. Our comprehensive course on Quickbooks will assist you in producing the best possible outcome by mastering the Quickbooks skills. The Quickbooks course is for those who want to be successful. In the Quickbooks course, you will learn the essential knowledge needed to become well versed in Quickbooks. Our Quickbooks course starts with the basics of Quickbooks and gradually progresses towards advanced topics. Therefore, each lesson of this Quickbooks course is intuitive and easy to understand. Why would you choose the Quickbooks course from Compliance Central: Lifetime access to Quickbooks course materials Full tutor support is available from Monday to Friday with the Quickbooks course Learn Quickbooks skills at your own pace from the comfort of your home Gain a complete understanding of Quickbooks course Accessible, informative Quickbooks learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Quickbooks Study Quickbooks in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Quickbooks Course Quickbooks Curriculum Breakdown of the Quickbooks Course Getting prepared - access the software and course materials Getting started Setting up the system Nominal ledger Customers Suppliers Sales ledger Purchases ledger Sundry payments Sundry receipts Petty cash VAT - Value Added Tax Bank reconciliation Payroll / Wages Reports Tasks CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Quickbooks course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Quickbooks. It is also great for professionals who are already working in Quickbooks and want to get promoted at work. Requirements To enrol in this Quickbooks course, all you need is a basic understanding of the English Language and an internet connection. Career path The Quickbooks course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Quickbooks. 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 each

Mastering Quickbooks Online - CPD Certified
Delivered Online On Demand3 hours
£12

Internal Auditing: AML, KYC & Risk Management - 8 Courses Bundle

By NextGen Learning

In the UK alone, financial institutions were fined over £300 million for non-compliance with Anti-Money Laundering (AML) regulations in the past three years. With the constantly evolving landscape of financial regulations and the intricacies of risk management, there is a soaring demand for professionals well-versed in AML, KYC, and comprehensive risk management. This meticulously curated Internal Auditing: AML, KYC & Risk Management bundle of eight courses offers an in-depth understanding of critical areas like Internal Audit Skills, Anti-Money Laundering (AML) Training, Know Your Customer (KYC), HR Audit, Corporate Risk and Crisis Management, Financial Investigator, Financial Analysis, and Advanced Tax Accounting. Each of these courses sheds light on the intricate processes and systems in place, ensuring that participants have a robust theoretical foundation in these specialised fields. Secure your future in finance - dive into our courses and master AML, KYC, and more today! The eight key Courses in Financial Compliance and Risk Management Internal Audit Skills Anti-Money Laundering (AML) Training Know Your Customer (KYC) Certificate in HR Audit Corporate Risk and Crisis Management Financial Investigator Financial Analysis Advanced Tax Accounting Learning Outcomes Understand the fundamentals and intricacies of AML and KYC regulations and compliance. Gain insights into effective internal audit processes and methodologies. Delve into human resource auditing and its relevance in modern organisations. Grasp the principles behind corporate risk assessment and crisis management. Analyse financial data, detect anomalies and understand advanced tax accounting processes. Learn to operate within the legal framework and uphold the highest standards of compliance and ethics in financial practices. Dive deep into the realm of financial regulations and risk management with these comprehensive courses. Start your journey with a keen understanding of Internal Audit Skills, understanding how audits play a pivotal role in ensuring organisational effectiveness and compliance. The Anti-Money Laundering (AML) Training and Know Your Customer (KYC) courses emphasise the importance of understanding and complying with international financial standards, ensuring businesses operate within the legal framework. With the HR Audit course, learn how human resource practices can be evaluated for effectiveness and compliance. Further, the Corporate Risk and Crisis Management course offers a holistic view of the uncertainties businesses face and strategies to mitigate them. The Financial Investigator module brings to light the methodologies used in probing financial anomalies, while Financial Analysis aids in interpreting financial statements and predicting business trends. Finally, the Advanced Tax Accounting module enriches learners with the complexities of tax laws and their application in real-world scenarios. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring financial compliance officers. Audit professionals aiming to enhance their knowledge. Individuals interested in corporate risk management. Professionals keen on understanding financial investigations and analysis. HR professionals aiming to diversify into HR auditing. Career path Financial Compliance Officer - £35K to £60K/year. Internal Auditor - £28K to £55K/year. Corporate Risk Manager - £40K to £80K/year. Financial Investigator - £30K to £50K/year. HR Audit Specialist - £30K to £55K/year. Financial Analyst - £32K to £60K/year. Tax Accountant - £28K to £58K/year. 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

Internal Auditing: AML, KYC & Risk Management - 8 Courses Bundle
Delivered Online On Demand34 hours
£39

Advanced Diploma in Microsoft Excel

By SkillWise

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 Advanced Diploma in Microsoft Excel 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 the professional training that employers are looking for in today's workplaces. The Advanced Diploma in Microsoft Excel Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Advanced Diploma in Microsoft Excel 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 Advanced Diploma in Microsoft Excel 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 Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Advanced Diploma in Microsoft Excel? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD QS-accredited qualifications after course completion Receive one-to-one assistance 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 Advanced Diploma in Microsoft Excel 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Advanced Diploma in Microsoft Excel 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 skills. Prerequisites This Advanced Diploma in Microsoft Excel does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Advanced Diploma in Microsoft Excel was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This Advanced Diploma in Microsoft Excel is a great way for you to gain multiple skills from the comfort of your home.

Advanced Diploma in Microsoft Excel
Delivered Online On Demand
£29

The Magic of Macros

By IIL Europe Ltd

The Magic of Macros The Magic of Macros Learn how Excel's Macros (a.k.a. VBA), can create incredible results in the blink of an eye! We'll start with a few basics, then move to more advanced topics and work through an example. Watch Excel create multiple totals in basically one line of code! This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

The Magic of Macros
Delivered Online On Demand30 minutes
£15

NFTs Demystified: An Easy-to-Follow Course

By NextGen Learning

Unlock the power of NFTs Demystified with our easy-to-follow course. This course provides a comprehensive overview of the concept, technology, and market behind NFTs Demystified, providing learners with the knowledge to navigate this emerging field with confidence. Discover the potential of NFTs Demystified and gain the skills to create, sell, and invest in them. Learning Outcomes: Understand the fundamentals of Non-Fungible Tokens (NFTs) Gain knowledge of blockchain and Ethereum technology Explore NFT marketplaces and projects Learn about NFT security and standards Create and sell NFTs with ease Gain insights into the future of NFTs This NFTs Demystified: An Easy-to-Follow course is a comprehensive overview of NFTs Demystified, covering topics such as blockchain, Ethereum, NFT marketplaces, NFT security and standards, creating and selling NFTs, investing in NFTs, and the future of NFTs. NFTs Demystified is a rapidly growing field that has the potential to revolutionise the digital market. Understanding NFTs and the technology behind them can give learners a competitive edge in their professional careers and open up new opportunities. This course is designed to provide learners with a solid foundation of NFTs Demystified. With expertly curated content, learners will gain a comprehensive understanding of NFTs and the technology behind them. The course is self-paced, allowing learners to complete it at their own convenience. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Entrepreneurs looking to capitalize on the potential of NFTs Demystified Investors seeking to gain insights into the NFT market Professionals looking to upskill in the digital market Curious learners seeking to understand NFTs Demystified Anyone interested in emerging technologies and their potential Career path Blockchain Developer - £45,000 to £75,000 Digital Marketer - £25,000 to £55,000 NFT Project Manager - £50,000 to £80,000 Cryptocurrency Trader - £30,000 to £60,000 NFT Art Curator - £35,000 to £65,000

NFTs Demystified: An Easy-to-Follow Course
Delivered Online On Demand3 hours
£15

Conditional Formatting in Excel

By The Teachers Training

Overview Conditional Formatting in Excel Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Conditional Formatting in Excel Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Conditional Formatting in Excel Unit 01: Introduction 00:01:00 Unit 02: What is conditional formatting? 00:04:00 Unit 03: Data bars 00:02:00 Unit 04: Colour scales 00:03:00 Unit 05: Icon sets 00:03:00 Unit 06: Top/bottom rules 00:04:00 Unit 07: Highlight cells rules 00:09:00 Unit 08: More rules 00:07:00

Conditional Formatting in Excel
Delivered Online On Demand33 minutes
£27.99

Complete Microsoft Excel

4.7(26)

By Academy for Health and Fitness

Are you looking to improve your current abilities or make a career move? Our unique Complete Microsoft Excel Course might help you get there! Expand your expertise with high-quality training - study the Complete Microsoft Excel and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This Complete Microsoft Excel online training course is accredited by CPD with 15 CPD points for professional development. Students can expect to complete this training course in around 11 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Complete Microsoft Excel course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enroling on this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. The Complete Microsoft Excel course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enroling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enroling on the Complete Microsoft Excel course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the program. Why Prefer this Complete Microsoft Excel Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support Experts created the Complete Microsoft Excel course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover on the Course: >> Complete Microsoft Excel << Module 01: Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Module 02: Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Module 03: Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Module 04: Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Module 05: Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Module 06: Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Module 07: Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Module 08: Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Module 09: Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Module 10: Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Module 11: Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Module 12: Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Module 13: Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Module 14: Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Module 15: Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Module 16: Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Module 17: Creating Sparklines and Mapping Data Create Sparklines MapData Module 18: Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Module 19: Excel Templates Excel Templates Assessment Process Once you have completed all the modules in the Complete Microsoft Excel course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Complete Microsoft Excel
Delivered Online On Demand11 hours
£12