Financial Analysis in Excel Training Course
Throughout the training, we will explore financial analysis topics using the advanced features of Excel.
This course is designed for financial analysts, accountants, and anyone looking to enhance their spreadsheet skills in the realm of financial analysis.
This course is available as onsite live training in Uzbekistan or online live training.Course Outline
Advanced functions
- The logic functions
- Mathematical and statistical functions
- Financial functions
Search and data
- Search and matching
- Functions MATCH (MATCH) and INDEX (INDEX)
- Advanced management of lists of values
- Validate the value entered in the cell
- Database Functions
- Summary data by using the histogram
- Circular references - Practical Aspects
Tables and Pivot Charts
- The dynamic description of the data using PivotTables
- Elements and calculated fields
- Visualize data using pivot chart
Working with external data
- Exporting and importing data
- Exporting and importing XML file
- Importing data from databases
- Connections to a database or an XML file
- Analyzing data online - Web Query
Analytical issues
- Option Goal Seek
- The Analysis ToolPack addition
- Scenarios, Scenario Manager
- Solver and optimization data
- Macros and create your own functions
- Starting and recording macros
- Working with VBA code
Conditional Formatting
- Advanced conditional formatting using formulas and form elements (eg box - checkbox)
Time value of money
- The current and future value of capital
- Capitalization and discounting
- Interest made simple
- Nominal and effective interest procetowa
- Cash flows
- Depreciation
Trends and financial forecasts
- Types (functions) trend.
- Forecasts
Securities
- The rate of profit
- Profitability
- Investing in securities and risk measures
Requirements
Requires good knowledge of Microsoft Excel. Basic knowledge of finance is also indicated.
Need help picking the right course?
Financial Analysis in Excel Training Course - Enquiry
Testimonials (1)
active interaction between trainer and participants
DEEWEELYN DE LUNA - TRACTEBEL RED INC.
Course - Financial Analysis in Excel
Related Courses
Financial Markets
14 HoursThis introductory course aims to provide participants with a comprehensive and detailed understanding of key financial markets, including their purpose, function, main activities, and regulatory frameworks. It is designed to serve as both a refresher and an educational experience, challenging participants to gain the maximum benefit from it. Active feedback and discussion will be encouraged throughout the sessions, which are intended to be interactive rather than merely reactive and factual.
The primary goal is to ensure that by the end of the course, all delegates will be significantly better equipped to handle client interactions and their ongoing needs. They will also have a clearer context for the services and markets in which they are involved.
FinOps
7 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is aimed at cloud administrators, cloud architects, technology heads, and financial analysts who wish to record, manage, monitor, and process financial assets of an organization in the cloud.
By the end of this training, participants will be able to use FinOps practices in an organization to forecast costs, optimize processes, and perform financial management operations in the cloud.
FinOps For Engineers
14 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is aimed at engineers who wish to drive more business value with FinOps in building and supporting services for an organization.
By the end of this training, participants will be able to:
- Understand the principles of FinOps and relate them to the methodologies and disciplines in software engineering.
- Learn and understand the basic functions and responsibilities of a FinOps team.
- Know the responsibilities of engineering and operations team members in the FinOps functions.
FinOps Certified FOCUS Analyst Preparation
14 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is aimed at intermediate-level finance professionals who wish to gain a comprehensive knowledge of FinOps principles and methodologies, including cloud financial management, optimization strategies, and collaboration among finance, engineering, and business teams.
By the end of this training, participants will be able to:
- Understand the FinOps framework, principles, and phases.
- Manage cloud costs effectively through data analysis and governance.
- Collaborate between finance, engineering, and business units to align cloud spend.
- Use FinOps tools for cost allocation, forecasting, and optimization.
- Prepare for the FinOps Certified FOCUS Analyst exam.
FinOps Certified Professional Preparation
21 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is aimed at advanced-level cloud financial management professionals who wish to validate their expertise in financial operations (FinOps) related to cloud cost management.
By the end of this training, participants will be able to:
- Gain advanced knowledge required for the FinOps Certified Professional exam.
- Understand complex FinOps practices, including cost optimization, budget management, and reporting.
- Develop practical skills in applying FinOps strategies in real-world scenarios.
- Prepare for a successful completion of the FinOps Certified Professional exam.
Introduction to Fixed Income
14 HoursThe Introduction to Fixed Income training course provides a comprehensive overview of fixed income securities, tailored for individuals who are looking to gain a robust understanding of these securities and the financial markets they operate in.
FinOps Certified Practitioner (FOCP) Preparation
14 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is aimed at professionals who wish to learn more and enhance their knowledge about FinOps in preparation to take the FinOps Certified Practitioner certification exam.
By the end of this training, participants will be able to:
- Understand cloud usage and cost modeling, cost allocation, and resource planning.
- Understand the pillars of FinOps and their implementation in an organization.
- Learn how the organization works to define the pricing model goals and use historical data in making pricing model adjustments.
- Take the FinOps Certified Practitioner certification exam with confidence.
GnuCash for Business Accounting and Financial Management
7 HoursGnuCash is an open-source, cross-platform double-entry accounting system tailored for personal and small business financial management. It offers a wide range of comprehensive accounting features, including invoicing, expense tracking, reconciliation, and financial reporting. GnuCash also supports integration with online banking, multiple currencies, and the ability to export and import data in various formats such as QIF, OFX, and CSV.
This instructor-led, live training (available both online and onsite) is designed for business professionals at beginner to intermediate levels who aim to manage and automate their accounting, billing, and reporting processes using GnuCash effectively.
By the end of this training, participants will be able to:
- Install, configure, and customize GnuCash for business use.
- Set up business accounts and manage transactions using double-entry accounting principles.
- Generate financial statements and reports for analysis and auditing purposes.
- Integrate GnuCash with banks, external systems, and online data sources.
- Automate recurring transactions and handle multi-currency operations efficiently.
Format of the Course
- Interactive lectures and discussions.
- Practical exercises and real-world business scenarios.
- Hands-on configuration and data entry in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Investment Banking: Introduction to Structured Products
21 HoursIntroduction to Structured Products
The course aims to provide delegates with an introduction to the Structured Products utilized in investment banking. Upon completion, all participants will have a practical understanding of the subject and will be able to answer:
- What are structured products?
- Why are they issued?
- How do issuers and investors benefit from them?
- How do you structure and price a variety of derivative products?
- What are the risks and costs associated with producing structured financial products?
- What are embedded derivatives?
- What are exotic options?
- What are the considerations for pricing and hedging these products?
Learning Xero
14 HoursThis instructor-led, live training (onsite or remote) is aimed at accountants and bookkeepers who wish to use Xero for bookkeeping.
By the end of this training, participants will be able to:
- Get a real-time view of cashflow.
- Link bank accounts to Xero for bank reconciliation.
- Prepare and check VAT (Value Added Tax) returns in Xero.
- Create reports for sharing amongst team members.
Management Accounting and Finance for Non-Finance Professionals
14 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is aimed at beginner-level non-finance professionals who wish to have a foundational understanding of financial and accounting principles that are essential for effective decision-making in business.
By the end of this training, participants will be able to:
- Understand basic financial and accounting concepts that are essential for business decision-making.
- Interpret and analyze financial statements such as income statements, balance sheets, and cash flow statements.
- Apply key financial ratios to assess the financial health of a business.
- Develop and manage budgets and perform variance analysis to monitor business performance.
- Use break-even analysis to support operational and strategic decisions.
Open Bank Project for Developers
14 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is aimed at developers who wish to use Open Bank Project API to develop and test decentralized applications that can be integrated easily with digital banking systems.
By the end of this training, participants will be able to:
- Set up the necessary development environment to start developing applications with OBP API.
- Understand the Open Bank Project architecture, technology, and concepts.
- Learn how to use and customize OBP API to develop and build applications for banking.
- Explore the features, tools, APIs, and sandboxes in OBP.
- Implement security and integrations in OBP API connectors and adapters.
A Practical Guide to Successful Pricing Strategies
7 HoursWhy should you attend?
We live and work in an increasingly global market that presents numerous opportunities at every turn, which we must seize. However, these opportunities come with increased competition and complexity. Understanding the best methods to find and select the most suitable and competitive prices for your products or services is essential for the success and growth of any business. The knowledge, techniques, and strategies you will gain during our training will help you enhance the profitability and effectiveness of your business.
Turning theory into practice:
The goal of this one-day training course is to simplify and explain successful pricing strategies. You’ll leave our event more confident and positive about continuing and expanding your business. We will provide you with practical examples and strategies to improve your knowledge of pricing, helping you achieve your plans and targets.
Who should attend?
This course is designed for sales managers, marketing managers, product managers, account managers, pricing analysts, and managing directors. It is also essential for executives who are new to pricing or have limited experience in the subject.
Basics of Customizing for Financial Accounting: GL, AP, AR in SAP S/4 HANA (S4F12)
35 HoursThis instructor-led, live training in Uzbekistan (online or onsite) is aimed at application consultants and business process owners who wish to learn how to configure business processes for SAP S/4 HANA financials module.
By the end of this training, participants will be able to:
- Understand the basic customizing settings in the main components of Financial Accounting with SAP S/4HANA.
- Configure the master data settings (G/L accounts, customer and vendor accounts) of FA with SAP S/4HANA.
- Configure document control, posting control, and financial document clearing settings of FA with SAP S/4HANA.