Excel Applications in Finance & Accounting

Course Info

Date: June-09-2025

Length: 1 Week

City: Istanbul

Fees: 3,900

Type: In Classroom

Available Dates

  • Mar-10-2025

    Istanbul

  • June-09-2025

    Istanbul

  • Sep-08-2025

    Istanbul

  • Dec-08-2025

    Istanbul

Dates in Other Venues

  • Dec-30-2024

    Kuala Lumpur

  • Feb-24-2025

    London

  • Feb-24-2025

    Dubai

  • Mar-10-2025

    Singapore

  • Mar-10-2025

    Paris

  • Mar-10-2025

    Kuala Lumpur

  • Mar-10-2025

    Barcelona

  • Mar-10-2025

    Amsterdam

  • Apr-28-2025

    London

  • Apr-28-2025

    Dubai

  • June-09-2025

    Barcelona

  • June-09-2025

    Paris

  • June-09-2025

    Amsterdam

  • June-09-2025

    Kuala Lumpur

  • June-09-2025

    Singapore

  • June-23-2025

    Dubai

  • June-23-2025

    London

  • Aug-25-2025

    Dubai

  • Aug-25-2025

    London

  • Sep-08-2025

    Paris

  • Sep-08-2025

    Kuala Lumpur

  • Sep-08-2025

    Singapore

  • Sep-08-2025

    Amsterdam

  • Sep-08-2025

    Barcelona

  • Oct-06-2025

    Dubai

  • Oct-06-2025

    London

  • Dec-01-2025

    Dubai

  • Dec-01-2025

    London

  • Dec-08-2025

    Barcelona

  • Dec-08-2025

    Paris

  • Dec-08-2025

    Singapore

  • Dec-08-2025

    Kuala Lumpur

  • Dec-08-2025

    Amsterdam

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