3350 Courses

Master advanced Excel skills and boost your career with our Microsoft Excel Advanced Diploma Course. Gain proficiency in data analysis, understand advanced features, and develop practical expertise.

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

Master data retrieval in Excel with our XLOOKUP and VLOOKUP course. Learn to efficiently find and analyze data, enhancing your spreadsheet skills for better decision-making.

CPD Accredited | Free PDF Certificate | 20 CPD Points | Lifetime Access | Tutor Support

Unlock the full potential of Microsoft Excel with our course for everyone. Learn essential skills and advanced techniques to excel in any data-driven role.

Master Microsoft Excel with this comprehensive online certification bundle. Learn advanced formulas, data analysis, automation, and visualizations for professional success.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

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

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

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.