Get in Touch

Course Outline

Advanced functions

  • Logic functions
  • Mathematical and statistical functions
  • Financial functions

Search and data

  • Search and matching techniques
  • Using MATCH and INDEX functions
  • Advanced management of value lists
  • Validating values entered in cells
  • Database Functions
  • Summarizing data using histograms
  • Circular references - Practical applications

Tables and Pivot Charts

  • Dynamically describing data with PivotTables
  • Elements and calculated fields
  • Visualizing data with Pivot Charts

Working with external data

  • Exporting and importing data
  • Importing and exporting XML files
  • Pulling data from databases
  • Establishing connections to databases or XML files
  • Online data analysis - Web Query

Analytical issues

  • Goal Seek option
  • The Analysis ToolPak add-in
  • Scenarios and the 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 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 and functions
  • Forecasting methods

Securities

  • Rate of profit
  • Profitability analysis
  • Securities investment and risk measurement

Requirements

Participants should possess a solid command of Microsoft Excel. A basic understanding of finance is also recommended.

 14 Hours

Testimonials (3)

Upcoming Courses

Related Categories