One of the basic skills needed to carry out daily tasks professionally is the ability to use Microsoft Excel to manage and create equations and statistics. This training program is designed to provide participants with the knowledge and skills necessary to use advanced technologies in Excel efficiently and effectively.
At the end of the training program, the participant should be able to:
1 Cell styles
2 Pasting values, formulas, and formats with Paste Special
3 Formatting Cells
4 Highlight key data with Excel Conditional Formatting
5 Filter by color
6 Recording Macros - The perfect way to avoid repetitions
1 The secret of fast scrolling: navigation and keyboard shortcuts
2 Fix the top row of your Excel tables
3 Split Screens - Use multiple screens simultaneously
4 Excel formulas
5 Creating drop-down menus in Excel
6 F keys (F1 to F12) - Using Excel's function keys
7 How to select visible cells only
1 Fixing cell references properly
2 Grouping Excel rows and columns
3 Working on multiple sheets at the same time
4 Find
5 Create easily printable documents by using Set Print Area
6 What Are Circular References in Excel?
7 Trace precedents - Display the relationship between formulas and cells
1 Nested function
2 Sum; Sumif; Sumifs
3 Round functions
4 Iferror
5 Vlookup
6 Index; Match; Index
7 Offset; Offset
8 Financial functions: FV and PV
9 Discounting Cash flows and calculating Net Present Value (NPV)
10 Financial functions: IRR
11 Financial functions: PMT and building a complete loan schedule
12 Date functions
1 Excel tips
1 Financial modeling Don'ts - Worst practices we should avoid
2 Financial modeling Do's - This is what solid modelers do
3 The different types of models
4 What is the right level of detail in a financial model?
1 Forecasting guidelines: apply these principles when forecasting financials
2 How to build a complete model?
3 Forecasting Income statement financials
4 Forecasting Balance sheet financials
1 Create a mapping of financials
2 Building an output P
3 Filling in the output P
4 Calculating percentage variances and applying conditional formatting
5 Building an output Balance sheet
6 Adding the forecast period
1 Calculating historical percentage ratios and use Index and Match for scenarios
2 Building a flexible model with Vlookup
3 Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %
4 Building a Fixed asset roll forward
5 Building a Financial liabilities schedule
6 Building an Equity schedule
7 Preparing a Cash flow structure
8 Calculating Cash flows and completing the model
Basic knowledge in Microsoft Excel
-
Attending a training program in accounting or finance (for those without a financial accounting background)
-
Availability of a computer for practical application
-
Names of the training programs that are integrated (enriched) with the training program:
Names of the training programs that after the training program:
Add Comment