The objective of the program is to educate participants with knowledge of advance excel tools for data analysis and presenting using hands-on exercises that are relevant for accounting and finance professionals.
Learn using advanced Excel tools
Preparing charts for data presentation
Perform financial statement analysis
Perform sensitivity and scenario analysis for Budgets
Learn to record macros
Who should attend
Finance managers, finance controllers, auditors, internal auditors, corporate finance professionals, budgeting managers, financial analysts, chartered accountants, private bankers, wealth managers and finance graduates or post graduates at the final stage of finishing their degree.
Naming Cells and Ranges
Linking & Embedding
Linking Data within and between worksheets
Linking Data from Excel to a Word Document
Linking an excel Chart to a Word Document
Sensitivity analysis using data tables
Goal Seek and Solver tool for Budgeting
Advanced excel formulas:
VLOOKUP & HLOOKUP
NPV, IRR, MIRR
IF, AND, OR
Macros recording and application
Charting in Excel
Preparing different types of charts – column, bar, line, pie, scatter
Creating a combination chart
Adding a Secondary Axis to a chart
Changing the chart type for a particular data series
Adding a data series to a chart
Removing a data chart from a chart
Re – positioning chart title
Re – positioning the chart legend
Moving and formatting chart data label
Modifying chart axis scales
Preparing dynamic charts
Mohit Malhotra, CFA
Over 14 years of experience in portfolio and investment analysis, business valuations, corporate finance and financial modeling.
Currently there are no public classes/sessions scheduled for this course yet. For any in-house or private training, please contact us.
Get 15% discount, if you are a Current Student who is currently attending an Executive Education, CMA, Claritas, or CISI course with us.
Get 15% discount, if you are a Past Student who has completed a course with us.
Get 15% discount, when three or more individuals from the same organization register.
Get 10% discount, when you register 2 weeks prior to the course start date.