Profectus Academy
4.18K subscribers
1:07:37
Mastering vector operations in MS Excel
Profectus Academy
375 views • 4 months ago
8:35
How to determine SWP in volatile returns environment?
Profectus Academy
105 views • 5 months ago
9:18
How to model depreciation under straight line method?
Profectus Academy
257 views • 5 months ago
8:46
IDC circularity solved!! Modelling interest during construction without circular reference
Profectus Academy
666 views • 6 months ago
5:27
How to do mid-year discounting in MS Excel using the NPV function? | Mid-year discounting formula
Profectus Academy
727 views • 7 months ago
5:19
Why does XIRR give wrong answer? | Is XIRR returning 0% or 2.98023E-09? | Learn the alternative
Profectus Academy
1.2K views • 7 months ago
10:00
How to automate calculation in MS Word and Zoho Writer? | Sum, Product and many more
Profectus Academy
1.2K views • 8 months ago
6:19
1 Cell referencing
Profectus Academy
84 views • 8 months ago
5:28
How to repeat set of values varying number of times in MS Excel
Profectus Academy
1K views • 8 months ago
6:33
How to automatically add numbering to text in a single cell in MS Excel?
Profectus Academy
4.5K views • 8 months ago
16:56
Introduction to equity and business valuation - Part 1
Profectus Academy
397 views • 1 year ago
8:21
How to add data labels to waterfall chart created with Up down bars?
Profectus Academy
3.2K views • 1 year ago
7:49
How to connect slicer to waterfall charts in MS Excel?
Profectus Academy
7.1K views • 1 year ago
10:55
How to create waterfall charts in MS Excel
Profectus Academy
2.6K views • 1 year ago
10:26
How to change the colors of all the bars in MS Excel waterfall chart? | Use arrows instead of bars
Profectus Academy
7.4K views • 1 year ago
1:01
What is the difference between Value and NumberValue function
Profectus Academy
290 views • 1 year ago
7:20
Find number of days employees worked in a month
Profectus Academy
1K views • 1 year ago
5:48
Trim function not working? No-break space could be the reason
Profectus Academy
5.6K views • 1 year ago
20:31
MS Excel 101: Text functions in MS Excel
Profectus Academy
599 views • 1 year ago
9:24
How to apply slicer on formulas in MS Excel
Profectus Academy
10K views • 1 year ago
13:04
How to value life insurance company? | Embedded value and distance to market cap
Profectus Academy
5.8K views • 2 years ago
1:02:24
Mathematical thinking for MS Excel, financial modelling and programming
Profectus Academy
6.1K views • 2 years ago
4:22
XLOOKUP vs Lookup vs Index Match? Xlookup performance issues
Profectus Academy
2K views • 2 years ago
18:06
When and how to use Scan() and Reduce() functions in MS Excel? | Build dynamic cork screw models
Profectus Academy
1.7K views • 2 years ago
11:41
How to calculate portfolio draw down in MS Excel?
Profectus Academy
1.4K views • 2 years ago
14:07
When and how to use ByRow and ByCol functions in MS Excel
Profectus Academy
1.7K views • 2 years ago
10:13
Create dynamic debt amortization schedule with just one function using Lambda
Profectus Academy
3.1K views • 2 years ago
4:06
Reverse wild card lookup | How to lookup when lookup value is in between a larger text?
Profectus Academy
1K views • 2 years ago
8:01
Create Lambda function step by step | ProductIF
Profectus Academy
535 views • 2 years ago
5:40
Instead of using Nested IF, use LOOKUP and XLOOKUP
Profectus Academy
757 views • 2 years ago
Load More