'%3e%3cmask%20id='mask0_1329_59790'%20style='mask-type:luminance'%20maskUnits='userSpaceOnUse'%20x='-5'%20y='0'%20width='26'%20height='16'%3e%3cpath%20d='M20.1429%200H-5V16H20.1429V0Z'%20fill='white'%20/%3e%3c/mask%3e%3cg%20mask='url(%23mask0_1329_59790)'%3e%3cpath%20d='M20.1432%200H-4V16H20.1432V0Z'%20fill='white'%20/%3e%3cpath%20d='M12.1712%205.7855L20.1494%200.710932V0H19.5955L10.5022%205.7855H12.1712Z'%20fill='%23BD0034'%20/%3e%3cpath%20d='M11.7904%2010.5332L20.1499%2015.8447V14.7824L13.4594%2010.5332H11.7904Z'%20fill='%23BD0034'%20/%3e%3cpath%20d='M-4%201.21758L3.15087%205.78551H4.81988L-4%200.155273V1.21758Z'%20fill='%23BD0034'%20/%3e%3cpath%20d='M4.4386%2010.5332L-4%2015.902V16H-2.47487L6.1148%2010.5332H4.4386Z'%20fill='%23BD0034'%20/%3e%3cpath%20d='M18.4964%200H10.0435V5.37692L18.4964%200Z'%20fill='%231A237B'%20/%3e%3cpath%20d='M6.3096%200H-2.10742L6.3096%205.37692V0Z'%20fill='%231A237B'%20/%3e%3cpath%20d='M20.1497%205.78563V2.11658L14.416%205.78563H20.1497Z'%20fill='%231A237B'%20/%3e%3cpath%20d='M20.1497%2014.1614V10.5332H14.416L20.1497%2014.1614Z'%20fill='%231A237B'%20/%3e%3cpath%20d='M-1.63379%2016H6.30842V10.9418L-1.63379%2016Z'%20fill='%231A237B'%20/%3e%3cpath%20d='M10.0435%2016H18.0072L10.0435%2010.9418V16Z'%20fill='%231A237B'%20/%3e%3cpath%20d='M-4%2010.5332V14.3248L1.93507%2010.5332H-4Z'%20fill='%231A237B'%20/%3e%3cpath%20d='M-4%205.78551H1.93507L-4%201.98572V5.78551Z'%20fill='%231A237B'%20/%3e%3cpath%20d='M7.05722%200V6.73341H-4V9.58529H7.05722V16H9.29457V9.58529H20.1504V6.73341H9.29457V0H7.05722Z'%20fill='%23BD0034'%20/%3e%3c/g%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_1329_59790'%3e%3crect%20width='16'%20height='16'%20rx='8'%20fill='white'%20/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Certificate
Excel for Financial Applications
| Issued to: | Sabina Sarkisova |
| Issued date: | November 16, 2020 |
| Issued by: | AMT Training |
Excel tools for speed and efficiency
During this session, participants are introduced to Excel keyboard shortcuts, efficient worksheet navigation, formula construction and financial functions. The session includes lots of practical, real life Excel based exercises.
Advanced Excel
This program covers a range of tools and techniques in Excel designed to improve effectiveness and efficiency.
Advanced formatting (30 minutes stds)
Key topics:
- Setting up toolbars so that Excel can be used as efficiently as possible
- Setting up formatting styles
- Custom number formats
Working wih Text and Dates (30 minutes stds)
Key topics:
- Creating dynamic headings and footnotes in the model
- Working with dates
- Concatenation
- TEXT function
- UPPER, LOWER, PROPER functions
- TRIM and CLEAN functions
- RIGHT, LEFT & MID functions
- DATE, DAY, MONTH, YEAR functions
Flexible output tables (90 minutes stds)
Key topics:
- Functions and tools to manipulate and summarize financial information
- VLOOKUP and HLOOKUP
- OFFSET
- INDEX
- MATCH
- Data validation
- INDIRECT
Keeping circularities under control (30 minutes stds)
Key topics:
- Working with intentional circular references
- Debugging a file containing non-intentional circular references
Issued by
AMT Training
Awarded to
Sabina Sarkisova
About the issuer
AMT Training
For over 20 years we have been equipping analysts and associates with core skills for banking and finance. Our clients include the top ten investment banks and some of the biggest private equity firms in the world.
Accreditations and Associations
AMT courses are officially accredited by the Chartered Institute for Securities and Investment and each full day course can be logged as 6 hours of CPD for institutions including ICAEW, ACCA, CFA and solicitor regulatory authority. Find out more.
Global expertsAMT’s network of offices spans EMEA, APAC and the Americas. Our people have first-hand experience of investment banking and the diversity of our team reflects the regions, sectors, subject areas, languages and cultures with which we work. Experienced client service managers, working out of our offices in London, New York and Hong Kong, provide local support for customers across the world’s largest financial centres.
