Excel Applications in Finance & Accounting

Course Info

Length: 1 Week

Type: In Classroom

Available Dates

Venue

  • Oct-21-2024

    Barcelona

  • Oct-21-2024

    Dubai

  • Oct-27-2024

    Amsterdam

  • Oct-27-2024

    London

  • Nov-04-2024

    Kuala Lumpur

  • Nov-04-2024

    Istanbul

  • Nov-11-2024

    Paris

  • Nov-11-2024

    Singapore

  • Nov-18-2024

    Barcelona

  • Nov-18-2024

    Dubai

  • Nov-24-2024

    London

  • Nov-24-2024

    Amsterdam

  • Dec-02-2024

    Kuala Lumpur

  • Dec-02-2024

    Istanbul

  • Dec-09-2024

    Singapore

  • Dec-09-2024

    Paris

  • Dec-16-2024

    Barcelona

  • Dec-16-2024

    Dubai

  • Dec-22-2024

    London

  • Dec-23-2024

    Istanbul

  • Dec-29-2024

    Amsterdam

  • Dec-30-2024

    Kuala Lumpur

  • Jan-06-2025

    Barcelona

  • Jan-06-2025

    Amsterdam

  • Jan-06-2025

    Dubai

  • Jan-06-2025

    London

  • Jan-20-2025

    Kuala Lumpur

  • Jan-20-2025

    Istanbul

  • Jan-27-2025

    Singapore

  • Jan-27-2025

    Paris

  • Feb-03-2025

    Barcelona

  • Feb-03-2025

    Amsterdam

  • Feb-03-2025

    London

  • Feb-03-2025

    Dubai

  • Feb-17-2025

    Istanbul

  • Feb-17-2025

    Kuala Lumpur

  • Feb-24-2025

    Singapore

  • Feb-24-2025

    Paris

  • Mar-03-2025

    Dubai

  • Mar-03-2025

    London

  • Mar-03-2025

    Amsterdam

  • Mar-03-2025

    Barcelona

  • Mar-17-2025

    Istanbul

  • Mar-17-2025

    Kuala Lumpur

  • Mar-24-2025

    Paris

  • Mar-24-2025

    Singapore

  • Apr-07-2025

    Amsterdam

  • Apr-07-2025

    London

  • Apr-07-2025

    Barcelona

  • Apr-07-2025

    Dubai

  • Apr-21-2025

    Kuala Lumpur

  • Apr-21-2025

    Istanbul

  • Apr-28-2025

    Paris

  • Apr-28-2025

    Singapore

  • May-05-2025

    London

  • May-05-2025

    Amsterdam

  • May-05-2025

    Dubai

  • May-05-2025

    Barcelona

  • May-19-2025

    Istanbul

  • May-19-2025

    Kuala Lumpur

  • May-26-2025

    Singapore

  • May-26-2025

    Paris

  • June-02-2025

    Barcelona

  • June-02-2025

    Amsterdam

  • June-02-2025

    London

  • June-02-2025

    Dubai

  • June-16-2025

    Istanbul

  • June-16-2025

    Kuala Lumpur

  • June-23-2025

    Singapore

  • June-30-2025

    Amsterdam

  • June-30-2025

    London

  • June-30-2025

    Dubai

  • June-30-2025

    Barcelona

  • June-30-2025

    Paris

  • July-07-2025

    Dubai

  • July-07-2025

    Barcelona

  • July-07-2025

    Amsterdam

  • July-07-2025

    London

  • July-21-2025

    Istanbul

  • July-21-2025

    Kuala Lumpur

  • July-28-2025

    Singapore

  • July-28-2025

    Paris

  • Aug-04-2025

    London

  • Aug-04-2025

    Amsterdam

  • Aug-04-2025

    Barcelona

  • Aug-04-2025

    Dubai

  • Aug-18-2025

    Kuala Lumpur

  • Aug-18-2025

    Istanbul

  • Aug-25-2025

    Paris

  • Aug-25-2025

    Singapore

  • Sep-01-2025

    London

  • Sep-01-2025

    Barcelona

  • Sep-01-2025

    Amsterdam

  • Sep-01-2025

    Dubai

  • Sep-15-2025

    Istanbul

  • Sep-15-2025

    Kuala Lumpur

  • Sep-22-2025

    Singapore

  • Sep-29-2025

    London

  • Sep-29-2025

    Amsterdam

  • Sep-29-2025

    Dubai

  • Sep-29-2025

    Barcelona

  • Sep-29-2025

    Paris

  • Oct-06-2025

    Barcelona

  • Oct-06-2025

    London

  • Oct-06-2025

    Amsterdam

  • Oct-06-2025

    Dubai

  • Oct-20-2025

    Istanbul

  • Oct-20-2025

    Kuala Lumpur

  • Oct-27-2025

    Paris

  • Oct-27-2025

    Singapore

  • Nov-03-2025

    London

  • Nov-03-2025

    Dubai

  • Nov-03-2025

    Amsterdam

  • Nov-03-2025

    Barcelona

  • Nov-17-2025

    Kuala Lumpur

  • Nov-17-2025

    Istanbul

  • Nov-24-2025

    Paris

  • Nov-24-2025

    Singapore

  • Dec-01-2025

    Amsterdam

  • Dec-01-2025

    Dubai

  • Dec-01-2025

    Barcelona

  • Dec-01-2025

    London

  • Dec-15-2025

    Istanbul

  • Dec-15-2025

    Kuala Lumpur

  • Dec-22-2025

    Singapore

  • Dec-29-2025

    London

  • Dec-29-2025

    Amsterdam

  • Dec-29-2025

    Paris

  • Dec-29-2025

    Dubai

  • Dec-29-2025

    Barcelona

Course Details

Course Outline

5 days course

Introduction to Excel in Finance and Accounting

 

  • Overview of Excel: Importance, applications, and basic functions.
  • Basic financial calculations using Excel: Time value of money, loan payments, and investment returns.
  • Introduction to financial modeling: Building a simple financial model.

Advanced Excel Functions for Finance

 

  • Advanced Excel functions: IF statements, VLOOKUP, HLOOKUP, INDEX, MATCH, and array formulas.
  • Excel in investment analysis: NPV, IRR, and MIRR functions.
  • Budgeting and forecasting: Using Excel to plan and project financial outcomes.

 

Data Analysis and Visualization

 

  • Data analysis in Excel: PivotTables, conditional formatting, and data validation.
  • Charting and visualization: Creating dynamic charts and dashboards.
  • Using Power Query and Power Pivot to manage large datasets.

Excel in Accounting and Auditing

 

  • Accounting functions in Excel: Creating balance sheets, income statements, and cash flow statements.
  • Auditing in Excel: Data tracing, error checking, and spreadsheet security.
  • Automating tasks: Introduction to macros and VBA programming.

Future Trends and Excel Add-ins

 

  • Advanced Excel tools for Finance and Accounting: Power BI, Solver, and Risk Analysis add-ins.
  • Integrating Excel with other business intelligence tools: Overview and best practices.
  • Future trends in financial analysis and reporting: How to stay up-to-date with Excel updates and new features

Course Video