Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
Testimonials (1)
active interaction between trainer and participants