Course Outline

Advanced Functions for Government

  • Logical functions
  • Mathematical and statistical functions
  • Financial functions

Search and Data Management for Government

  • Search and matching capabilities
  • Functions MATCH and INDEX
  • Advanced management of value lists
  • Validation of values entered in cells
  • Database functions
  • Summarizing data using histograms
  • Circular references: practical aspects

Tables and Pivot Charts for Government

  • Dynamic data description using PivotTables
  • Elements and calculated fields in PivotTables
  • Visualizing data with pivot charts

Working with External Data for Government

  • Exporting and importing data
  • Exporting and importing XML files
  • Importing data from databases
  • Connecting to databases or XML files
  • Analyzing data online via web queries

Analytical Tools for Government

  • Goal Seek option
  • The Analysis ToolPack 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 for Government

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

Time Value of Money for Government

  • The present and future value of capital
  • Capitalization and discounting techniques
  • Simple interest calculations
  • Nominal and effective interest rates
  • Cash flow analysis
  • Depreciation methods

Trends and Financial Forecasts for Government

  • Types of trend functions
  • Financial forecasting techniques

Securities Analysis for Government

  • Rate of return on investments
  • Profitability analysis
  • Investing in securities and risk assessment measures

Requirements

Requires proficient knowledge of Microsoft Excel and a foundational understanding of finance for government applications.

 14 Hours

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories