Get in Touch
 Duration 14 hours

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.

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