369 Courses

Enroll today and gain the mergers and acquisitions modelling skills needed to guide high-stakes business decisions and transactions.  1.5+ Hours of Video 3.5+ Hours to Complete20+ Interactive Exercises1 Recognised Certificate Course Overview Our comprehensive M&A Modelling certification program teaches the essential skills needed to build robust financial models for merger and acquisition valuations. Through step-by-step video lessons and hands-on exercises, you will learn to structure flexible models that provide vital insights into deal outcomes. This self-paced online course focuses on real-world applications in investment banking, private equity, and corporate development. The curriculum covers all aspects of M&A models including key concepts like goodwill, accretion/dilution, consolidation of financial statements, and optimal deal structuring. With over 1 hour of content and 20+ exercises, the program provides the necessary tools and techniques to become an expert in merger modelling.  “I was previously unsure of all the financial jargon and concepts, now I feel I have taken steps towards getting the big picture of finance. I really liked the Excel web integration!” Rachel Crawford Course Highlights Introduction to M&A Model Components and Framework Step-by-Step Merger Model Recipe and Methods Modelling Goodwill, Purchase Price Allocation, Accretion/Dilution Consolidating Balance Sheets and Financial Statements Optimizing Ownership Structure and Capital Funding Real World Case Studies and Debriefs Certificate Upon Completion

Advanced Diploma | 20 in 1 CPD Certified Bundle | ++Gifts: Free 20 PDF+ Transcript Certificate | 24/7 Learner Support

Advanced Diploma | 20 in 1 CPD Certified Bundle | ++Gifts: Free 20 PDF+ 1 Transcript Certificates | 24/7 Learner Support

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now With a single payment you will gain access to Stock Market Investing & Trading - Level 2 including 11 Career development courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Trade efficiently in the stock market, learning advanced techniques and strategies from the Stock Market Investing & Trading - Level 2 course. The Stock Market Investing & Trading - Level 2 course aims to equip you with all the required knowledge and skills to trade like a pro in the stock market and gain a consistent profit. You'll be trained on technical and candlestick chart analysis to equip you with the skills to perceive the market accurately. You'll also learn trading tips, exploring tools and exchange policy. What's more, you'll explore some mistakes of new traders that will protect you from making poor trading decisions. Thrive in the stock market by enrolling today! Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. All of our courses have interactive online modules that allow studying to take place where and when you want it to. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Stock Market Investing & Trading - Level 2: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home Courses are included with this Bundle: Course 1: Stock Market Investing for Beginners Course 2: Forex Trading Level 3 Course 3: Budgeting and Forecasting Course 4: Business Analysis Level 3 Course 5: Level 2 Financial Planning and Management Course Course 6: Corporate Finance: Working Capital Management Course 7:Team Management Course 8: Microsoft Excel Level 3 Course 9: GDPR Data Protection Level 5 Course 10: Financial Modeling Using Excel Course 11: Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 12: Risk Management Level 7 Curriculum: Course 1: Stock Market Investing for Beginners Module 01: Introduction to the Course Module 02: Introduction to Stocks Module 03: Money Required for Primary Investment Module 04: Opening an Investment Account Module 05: Brokerage Account Walkthrough Module 06: Finding Winning Stocks Module 07: Earning from Dividends Module 08: Diversifying Portfolio Module 09: Investment Plan Module 10: Rebalancing Portfolio Module 11: Understanding Order Types Module 12: Investment Tax Module 13: Investment Rules: Rule-1 Module 14: Investment Rules: Rule-2 Module 15: Investment Rules: Rule-3 Module 16: Investment Rules: Rule-4 Module 17: Investment Rules: Rule-5 Module 18: Stock Market Dictionary Module 19: Setting Up the Trading Platform Course 2: Forex Trading Level 3 Module 1: Introduction to Forex Trading Module 2: Major Currencies and Market Structure Module 3: Kinds of Foreign Exchange Market Module 4: Money Management Module 5: Fundamental Analysis Module 6: Technical Analysis Module 7: Pitfalls and Risks Module 8: Managing Risk Module 9: Trading Psychology Course 3: Budgeting and Forecasting Unit-1. Introduction Unit-2. Detail Budget Requirement Unit-3. Process of Making Budget Course 4: Business Analysis Level 3 Module 01: Introduction to Business Analysis Module 02: Business Processes Module 03: Business Analysis Planning and Monitoring Module 04: Strategic Analysis and Product Scope Module 05: Solution Evaluation Module 06: Investigation Techniques Module 07: Ratio Analysis Module 08: Stakeholder Analysis and Management Module 09: Process Improvement with Gap Analysis Module 10: Documenting and Managing Requirements Module 11: Career Prospect as a Business Analyst in the UK Course 5: Level 2 Financial Planning and Management Course Personal Finance Calculations Saving for Retirement Building Credit to Buy a Home Personal Finance Guides for Beginners Cashflow Management Budgets and Money Management Course 6: Corporate Finance: Working Capital Management Module 01: Course Introduction Module 02: Introduction to Working Capital Management Module 03: Trade Credit and Receivable Management Module 04: Payables Management Module 05: Inventory Management Practices Module 06: Cash Management Practice Course 8: Microsoft Excel Level 3 Microsoft Excel 2019 New Features Getting Started with Microsoft Office Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Excel Templates Course 9: GDPR Data Protection Level 5 Module 01: GDPR Basics Module 02: GDPR Explained Module 03: Lawful Basis for Preparation Module 04: Rights and Breaches Module 05: Responsibilities and Obligations Course 10: Financial Modeling Using Excel Welcome to the Course! Get the Overview of What You'll Learn Planning your Financial Model Building a Model Template Projecting the Income Statement Projecting the Balance Sheet Projecting Cash Flows Advanced Financial Modeling BONUS LESSON: Top 5 Excel Features for Financial Modellers Course 11: Fraud Management & Anti Money Laundering Awareness Complete Diploma 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 Office 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 Course 12: Risk Management Level 7 Module 01: Introduction to Risk Management Module 02: Risk and Types of Risk Module 03: Benefits of Risk Management Module 04: Enterprise Risk Management Module 05: Risk Management Process Module 06: Risk Analysis & Assessment Module 07: The Risk Evaluation Process Module 08: Managing Financial Risks Module 09: The Fundamentals of Operational Risk Management Module 10: Managing Technology Risks Module 11: Managing Legal & Political Risk Module 12: Environmental Risk Assessment Module 13: Risk Assessment at Workplace Module 14: Market & Social Risk Assessment Module 15: Preparing Risk Management Plan: Step by Step How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 12 = £120) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 125 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Stock Market Investing & Trading - Level 2. It is available to all students, of all academic backgrounds. Requirements Our Stock Market Investing & Trading - Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Certificates Certificate of completion Digital certificate - Included

Implement long-term and short-term financial strategies, as well as identify new revenue streams herewith this outstanding Investment Banking

CPD Certified Diploma| 22 in 1 Premium Bundle| Free PDF & Transcript Certificate| Lifetime Access| Learner Support

Financial Modelling Training 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 Financial Modelling Training 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 5 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. Module 01: Basic Financial Calculations Basic Financial Calculations 00:36:00 Module 02: Overview of Financial Markets, Financial Assets, and Market Participants Overview of Financial Markets, Financial Assets, and Market Participants 00:37:00 Module 03: Financial Statement Modelling Financial Statement Modelling 00:30:00 Module 04: Types of Financial Models Types of Financial Models 00:35:00 Module 05: Sensitivity Analysis Sensitivity Analysis 00:38:00 Module 06: Sales and Revenue Model Sales and Revenue Model 00:36:00 Module 07: Cost of Goods Sold and Inventory Model Cost of Goods Sold and Inventory Model 00:38:00 Module 08: Valuation Methods Valuation Methods 00:32:00

The Financial Modeling Course is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Financial Modeling Course consists of several modules that take around 2 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays 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 Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion PDF Certificate at £9.99. Print copy by post is also available at an additional cost of £15.99 and the same for PDF and printed transcripts. Course Content Introduction Introduction 00:02:00 Project cost Project Cost - Assets 00:06:00 Project Cost - Preliminary and Preoperative Expenses 00:04:00 Project Cost - Working capital 00:10:00 Project Cost - Means of Finance 00:04:00 Depreciation Depreciation and Written down value 00:09:00 Schedule of Term Loan Set Up Term Loan 00:05:00 EMI or Montly Installment calculation 00:05:00 Calculation of Interest and Principal 00:06:00 Term loan schedule completion 00:06:00 Profit and Loss Account Basics of Profit and Loss Account 00:11:00 Profit and Loss Account statement 00:07:00 Preparation of Balance sheet Basics of Balance Sheet 00:08:00 Balance Sheet Preparation 00:10:00 Cash flow and Final Balance sheet 00:08:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Overview: ***Limited Time Offer*** ★★★ Enrolment Gift: Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £200 - Enrol Now! ★★★ Accounting and Finance is the language of business. It is essential for understanding how businesses operate and make decisions. This Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax course will teach you the fundamentals of accounting and finance, including financial statements, budgeting, financial markets, and risk management. This Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax course bundle will equip learners with in-depth knowledge and in-demand skills in key areas of accounting and finance. You will master the use of industry-standard software. You will also learn how to use popular accounting software such as Xero, Sage 50, Quickbooks, and Payroll & Vat-Tax. The curriculum also covers critical topics such as financial modelling, fraud detection, and the latest trends in financial management. Along with this Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax bundle, you will get 19 premium courses, an original Hardcopy, 20 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This 20-in-1 Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax bundle consists of the following Courses: Course 01: Accounting and Finance Diploma Course 02: Applied Accounting Course 03: Managerial Accounting Masterclass Course 04: Changes in Accounting: Latest Trends Encountered by CFOs in 2022 Course 05: Level 3 Tax Accounting Course 06: Introduction to VAT Course 07: Level 3 Xero Training Course 08: QuickBooks Online Bookkeeping Diploma Course 09: Diploma in Sage 50 Accounts Course 10: Cost Control Process and Management Course 11: Learn to Read, Analyse and Understand Annual Reports Course 12: Financial Statements Fraud Detection Training Course 13: Finance Principles Course 14: Financial Management Course 15: Financial Modelling Course - Learn Online Course 16: Improve your Financial Intelligence Course 17: Financial Analysis Course 18: Banking and Finance Accounting Statements Financial Analysis Course 19: Financial Ratio Analysis for Business Decisions Course 20: Budgeting and Forecasting So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax bundle. Learning Outcomes of Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax bundle: Understand the basic concepts of accounting and finance. Apply accounting principles to record and analyze financial transactions. Prepare financial statements, such as balance sheets and income statements. Develop skills in payroll software and systems for accurate processing. Develop budgets and manage financial resources. Understand the financial markets and how to invest money. Understand and manage payroll processes efficiently within any organisational structure. Learn payroll best practices to ensure timely and error-free payments. Key Features of the Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax Course: FREE Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax CPD-accredited certificate Get a free student ID card with Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax training (£10 applicable for international delivery) Lifetime access to the Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax course materials The Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax program comes with 24/7 tutor support Get instant access to this Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax course Learn Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax training from anywhere in the world The Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax training is affordable and simple to understand The Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax training is entirely online Enrol today to deepen your understanding of the topic Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax. Description: This Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax diploma offers learners the opportunity to acquire the skills that are highly valued in this field. With this Certification, graduates are better positioned to pursue career advancement and higher responsibilities within this setting. The skills and knowledge gained from this Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax course will enable learners to make meaningful contributions to related fields, impacting their experiences and long-term development. The Course curriculum of Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax bundle: Course 01: Accounting and Finance Diploma Module: 01 Accounting Introduction First Transactions T Accounts introduction T-Accounts conclusion Trial Balance Income Statement Balance Sheet Module: 02 Balance Sheet Variations Accounts in practise Balance Sheets what are they Balance Sheet Level 2 Income Statement Introduction Are they Expenses, or Assets Accounting Jargon Module: 03 Accruals Accounting is Fundamental Trial Balance 3 days ago More Fixed Assets and how it is shown in the Income Statement Stock movements and how this affects the financials Accounts Receivable How to calculate the Return on Capital Employed Transfer Pricing - International Rules = = = > > > and 19 more courses = = = > > > Certification of Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax bundle: After successfully completing the Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £9.99*20 = £199.7) Hard Copy Certificate: Free (For The Title Course: Previously it was £14.99) Enrol in this Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax bundle course today and take your career to the next level! Who is this Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax course for? This Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax bundle course is perfect for anyone who wants to learn about accounting and finance, or who wants to improve their skills in these areas. It is also a great choice for anyone who wants to learn how to use Xero, Sage 50, Quickbooks, Payroll & Vat-Tax. Requirements This Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax bundle course has been designed to be fully compatible with tablets and smartphones. Career path Become a skilled Accountant with our Accounting and Finance: Xero, Sage 50, Quickbooks, Payroll & Vat-Tax Training and explore your opportunities in sectors such as: Accountant: £25,000 - £50,000 Financial analyst: £30,000 - £60,000 Investment banker: £40,000 - £100,000 Chartered accountant: £50,000 - £120,000 Financial controller: £60,000 - £150,000 Chief financial officer: £100,000 - £200,000 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 (Accounting and Finance) absolutely Free! Other Hard Copy certificates are available for £14.99 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

This Microsoft Excel Training Bundle will teach you to create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at high level. Also, our Excel experts are available to answer your queries and help you along your learning journey. Advanced audiovisual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Excel, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This 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 Sheet Comparison with VBA Course 04: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 05: Microsoft Excel Master Power Query in 120 Minutes! Course 06: Microsoft Excel Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Financial Modeling Using Excel Course 08: Business Analysis Level 3 Course 09: Touch Typing Essentials Course 10: Information Management Course 11: Data Protection and Data Security Level 2 Course 12: Microsoft Teams Course 13: Office Skills and Administration Management Diploma Course 14: Creativity and Problem-Solving Skills Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 14 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. Curriculum of Bundle Course 01: Microsoft Excel Level 3 Microsoft 019 New Features Getting Started Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and Pivot Charts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparkline's and Mapping Data Forecasting Data Templates Course 02: New Functions in Microsoft 021 Introduction and Agenda RANDARRAY UNIQUE SEQUENCE SORT and SORTBY SORT A Practical Example FILTER FILTER A Practical Example Other Useful New Functions Using the New Functions in Reports Course 03: Microsoft Excel Sheet Comparison with VBA Introduction to Compare Data Workbook Comprehensive Introduction to Compare Data Excel VBA Workbook Modify VBA Codes to Suit Your Needs Data Cleaning, Format and Structure Your Datasets with Power Query Practical and Real world application of Compare Data Workbook Conclusion Course 04: Top 50 Microsoft Excel Formulas in 50 Minutes! promo Getting the most of the course How to Get the most of the course Text formulas Text Formulas Exercise Text Formulas Exercise (answers) and many more... Course 05: Microsoft Master Power Query in 120 Minutes! Power Query Intro and version Introduction Query Editor Ribbon Trim in Excel Power Query Format Dates and Values and many more... Course 06: Automated Dashboard Using Advanced Formula, VBA, Power Query Introduction Prepaid Expenses Models: Resources Download Accounting for Prepaid Expenses Formulas Detailed: Introduction to three Models and many more... Course 07: Financial Modeling Using Excel Welcome to the Course! Get the Overview of What You'll Learn Planning your Financial Model Building a Model Template Projecting the Income Statement and many more... Course 08: Business Analysis Level 3 Introduction to Business Analysis Business Processes Business Analysis Planning and Monitoring Strategic Analysis and Product Scope Solution Evaluation and many more... Course 09: Touch Typing Essentials Introduction How to Set up Your Computer How to type the letters F and J How to type the letters D and K How to type the letters S and L How to type the letter A and ; (semicolon) How to type the letters E and I And Many More... Course 10: Information Management Introduction to Information Management Information Management Strategy Databases and Information Management Management Information Systems (MIS) Auditing Information Systems Ethical and Social Issues and Data Protection Course 11: Data Protection and Data Security Level 2 GDPR Basics GDPR Explained Lawful Basis for Preparation Rights and Breaches Responsibilities and Obligations Course 12: Microsoft Teams MS Teams - Introduction Mastering MS Teams Top MS Teams Tips Course 13: Office Skills and Administration Management Diploma Personal Assistant Admin Support Administrative Management Organisational Skills Telephone Etiquette and many more... Course 14: Creativity and Problem Solving Skills CPD 150 CPD hours / points Accredited by CPD Quality Standards Certificates Certificate of completion Digital certificate - Included