Get in Touch

Course Outline

Advanced Functions

  • Logical functions
  • Mathematical and statistical functions
  • Financial functions

Search and Data Management

  • Search and matching techniques
  • MATCH and INDEX functions
  • Advanced management of value lists
  • Data validation for cell entries
  • Database functions
  • Data summarization using histograms
  • Circular references - Practical considerations

PivotTables and Pivot Charts

  • Dynamic data description using PivotTables
  • PivotTable elements and calculated fields
  • Data visualization using Pivot Charts

Working with External Data

  • Data export and import procedures
  • Exporting and importing XML files
  • Importing data from databases
  • Establishing connections to databases or XML files
  • Online data analysis using Web Queries

Analytical Tools

  • Goal Seek functionality
  • The Analysis ToolPak add-in
  • Scenarios and Scenario Manager
  • Solver and data optimization
  • Macros and custom function creation
  • Starting 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 flow analysis
  • Depreciation methods

Trends and Financial Forecasts

  • Trend types and trend functions
  • Forecasting techniques

Securities Analysis

  • Rate of return
  • Profitability metrics
  • Investment in securities and risk measures

Requirements

Requires strong proficiency in Microsoft Excel. Basic knowledge of finance is also recommended.

 14 Hours

Number of participants


Price per participant

Testimonials (3)

Provisional Upcoming Courses (Require 5+ participants)

Related Categories