Get in Touch

Course Outline

Advanced functions

  • Logical functions
  • Mathematical and statistical functions
  • Financial functions

Search and data handling

  • Search and matching techniques
  • MATCH and INDEX functions
  • Advanced management of value lists
  • Validating cell input values
  • Database functions
  • Summarizing data using histograms
  • Circular references - Practical aspects

Tables and Pivot Charts

  • Dynamic data description using PivotTables
  • Elements and calculated fields
  • Data visualization using PivotCharts

Working with external data

  • Data export and import procedures
  • Exporting and importing XML files
  • Data import from databases
  • Connections to databases or XML files
  • Online data analysis via Web Query

Analytical tools and issues

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

Conditional Formatting

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

Time value of money

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

Trends and financial forecasts

  • Trend types (functions)
  • Forecasting techniques

Securities

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

Requirements

Participants must have a strong understanding of Microsoft Excel. Basic knowledge of finance is also recommended.

 14 Hours

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories