The main objective of this course is to upskill intermediate Excel users to an advanced level. The Advanced Excel Course at AXL Computer Academy will give you the skills you need to become an Excel Professional, like advanced formula techniques, sophisticated lookups, cleaning and preparing data for analysis etc. Here you will learn how to build professional dashboards in Excel.
Lorem ipsum dolor sit amet, consectetur adipisicing elit,
sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
Vlookup & Hlookup
, Index; Match; Index & Match
,
Indirect; Vlookup & Indirect,Columns; Vlookup & Columns,Vlookup & Choose,Offset; Offset & Match
.
FV and PV, Discounting Cash flows and calculating Net Present Value (NPV)
,
IRR
. PMT and building a complete loan schedule
FV and PV, Discounting Cash flows and calculating Net Present Value (NPV)
,
IRR
. PMT and building a complete loan schedule
FV and PV, Discounting Cash flows and calculating Net Present Value (NPV)
,
IRR
. PMT and building a complete loan schedule
Let's create a mapping of financials
Building an output P&L sheet
Filling in the output P&L sheet with historical financials
Calculating percentage variances and applying conditional formatting
Building an output Balance sheet
Using Index, Match, Match to fill in the output Balance sheet
Adding the forecast period