Excel Applications in Finance & Accounting

Course Info

Length: 1 Week

City: Kuala Lumpur

Type: In Classroom

Available Dates

  • June-03-2024

    Kuala Lumpur

  • July-01-2024

    Kuala Lumpur

  • July-29-2024

    Kuala Lumpur

  • Aug-05-2024

    Kuala Lumpur

  • Sep-02-2024

    Kuala Lumpur

  • Sep-30-2024

    Kuala Lumpur

  • Oct-07-2024

    Kuala Lumpur

  • Nov-04-2024

    Kuala Lumpur

  • Dec-02-2024

    Kuala Lumpur

  • Dec-30-2024

    Kuala Lumpur

Dates in Other Venues

  • May-26-2024

    London

  • May-26-2024

    Amsterdam

  • June-03-2024

    Istanbul

  • June-10-2024

    Singapore

  • June-10-2024

    Paris

  • June-17-2024

    Dubai

  • June-17-2024

    Barcelona

  • June-23-2024

    Amsterdam

  • June-23-2024

    London

  • July-01-2024

    Istanbul

  • July-08-2024

    Paris

  • July-08-2024

    Singapore

  • July-15-2024

    Barcelona

  • July-15-2024

    Dubai

  • July-21-2024

    London

  • July-22-2024

    Istanbul

  • July-28-2024

    Amsterdam

  • Aug-05-2024

    Istanbul

  • Aug-12-2024

    Singapore

  • Aug-12-2024

    Paris

  • Aug-19-2024

    Barcelona

  • Aug-19-2024

    Dubai

  • Aug-25-2024

    London

  • Aug-25-2024

    Amsterdam

  • Sep-02-2024

    Istanbul

  • Sep-09-2024

    Singapore

  • Sep-09-2024

    Paris

  • Sep-16-2024

    Barcelona

  • Sep-16-2024

    Dubai

  • Sep-22-2024

    London

  • Sep-23-2024

    Istanbul

  • Sep-29-2024

    Amsterdam

  • Oct-07-2024

    Istanbul

  • Oct-14-2024

    Paris

  • Oct-14-2024

    Singapore

  • Oct-21-2024

    Barcelona

  • Oct-21-2024

    Dubai

  • Oct-27-2024

    London

  • Oct-27-2024

    Amsterdam

  • Nov-04-2024

    Istanbul

  • Nov-11-2024

    Paris

  • Nov-11-2024

    Singapore

  • Nov-18-2024

    Dubai

  • Nov-18-2024

    Barcelona

  • Nov-24-2024

    London

  • Nov-24-2024

    Amsterdam

  • Dec-02-2024

    Istanbul

  • Dec-09-2024

    Singapore

  • Dec-09-2024

    Paris

  • Dec-16-2024

    Dubai

  • Dec-16-2024

    Barcelona

  • Dec-22-2024

    London

  • Dec-23-2024

    Istanbul

  • Dec-29-2024

    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