It’s no secret that a large proportion of heavy Excel users come from the financial world, including financiers, accountants, bookkeepers, economists, and analysts.
These users need very specific skills that most Excel courses cannot fully cover.
Especially for these users, we designed this Excel for Analysts and Finance Course. In the course we focus and delve into the huge variety of tools and functions in finance, economics, data analysis, and statistics included in the latest versions of Excel.
Live online Excel Course for Finance Professionals
It's all about your data!
Course Duration
12 Hours
Course Level
Advanced
Overview

Who is it for?
Financial employees, analysts and economists who want to get more out of Excel
Pre-requisites
Advanced level skills in Excel

Topics
- Pivot tables
- Creating a dashboard that includes PIVOT, layout tools, graphs, conditional formatting.
- Conditional formatting with formulas – for dynamic emphases that include many conditions
- Create drop-down lists and INDIRECT dependent drop-down lists
- Database formulas for analyzing DSUM, DGET,
- Logical formulas: IF, AND, OR,
- IFERROR, ISNA, ISTEXT error management formulas
- Aggregation formulas: COUNTIF / S, SUMIF / S
- Formulas for searching for data and comparing tables: VLOOKUP, HLOOKUP, MATCH, INDEX
- Auxiliary formulas for searching and optimizing data: TRIM, CONCAT, INDIRECT, SUMPRODUCT, VALUE and more
- WHAT IF ANALYSIS
- Goal Striving, Sensitivity Analysis, Scenarios, SOLVER, Forecast Graph (Excel 16)
- Excel Updates 16
- POWER QUERY = Optimizing data and creating automation to work in Excel
- Upload data directly from SQL or Excel server, data optimization
The list of topics above is partial and only an outline. A full and detailed syllabus will be sent as part of a bespoke proposal that will be tailored to your organization and your requests.
