Get in Touch

Course Outline

Advanced functions

  • Logical functions
  • Mathematical and statistical functions
  • Financial functions

Search and data

  • Searching and matching
  • MATCH and INDEX functions
  • Advanced management of value lists
  • Validating cell input
  • Database functions
  • Summarising data using histograms
  • Circular references – Practical considerations

Tables and Pivot Charts

  • Dynamic data description using PivotTables
  • Components and calculated fields
  • Data visualisation using pivot charts

Working with external data

  • Exporting and importing data
  • Exporting and importing XML files
  • Importing data from databases
  • Connecting to databases or XML files
  • Online data analysis – Web Query

Analytical techniques

  • Goal Seek option
  • Analysis ToolPak add-in
  • Scenarios and Scenario Manager
  • Solver and data optimisation
  • Macros and creating custom functions
  • Initiating and recording macros
  • Working with VBA code

Conditional Formatting

  • Advanced conditional formatting using formulas and form elements (e.g., checkboxes)

Time value of money

  • Present and future value of capital
  • Capitalisation and discounting
  • Simple interest
  • Nominal and effective interest rates
  • Cash flows
  • Depreciation

Trends and financial forecasts

  • Trend types (functions)
  • Forecasting

Securities

  • Rate of return
  • Profitability
  • Investing in securities and risk metrics

Requirements

Proficiency in Microsoft Excel is required. Foundational knowledge of finance is also recommended.

 14 Hours

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 2600 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (3)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories