Introduction to finance modeling:

Introduction to excel sheet- financial and accounting features
selecting, formatting,feeding formulae,feeding data etc
enter and edit information in a worksheet and manage workbooks
navigate worksheets and workbooks
linking one worksheet from another
introduction to financial formulae
moving and copying information, copying formulae
manipulate worksheet data, format the contents of a worksheet.
prepare ,setup and print information
sorting and filtering worksheet

Working with charts & tables

abstracting charts & graphs etc
analysing, modifying and printing a chart
modifying titles,labels,axes,gridlines and legends
working with data series,data tables, data range etc.
formatting charts, data series, chart area options etc.
Working with templates, styles and formats

Using financial and logical functions

finding a periodical loan payment
displaying the absolute value of a number
finding periodic interest payment
calculate EMI
Using automations & date functions
Testing Cells using various functionalities

Analysis of data

hands in exercise will be provided and participants will be asked to plot charts and analyse the data with the help of functions and tools

Case study

to have more limited understanding of financial modeling with excel, live examples will be studied:
A corporate Balance sheet and Profit & loss statement shall be provided
Based on the above mentioned formulae and given information, all the key financial ratios will be calculated.
Inference and Drawing calculations.