Get in Touch

Course Outline

Advanced functions

  • Logical functions
  • Mathematical and statistical functions
  • Financial functions

Search and data

  • Search and matching
  • MATCH and INDEX functions
  • Advanced management of value lists
  • Data validation for cell input
  • Database functions
  • Summarizing data using histograms
  • Circular references - Practical Aspects

Tables and Pivot Charts

  • Dynamic data analysis using PivotTables
  • Elements and calculated fields
  • Data visualization with pivot charts

Working with external data

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

Analytical issues

  • Goal Seek option
  • Analysis ToolPak add-in
  • Scenarios and Scenario Manager
  • Solver and data optimization
  • Macros and creating custom functions
  • Starting 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
  • Capitalization and discounting
  • Simple interest
  • Nominal and effective interest rates
  • Cash flows
  • Depreciation

Trends and financial forecasts

  • Trend types (functions)
  • Forecasts

Securities

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

Requirements

Good knowledge of Microsoft Excel is required. Basic finance knowledge is also recommended.

 14 Hours

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories