ViewTube

ViewTube
Sign inSign up

Info

In this channel you would get interesting and new perspectives and tips about financial modeling, data analytics and MS Excel.

I would also occasionally share insights about interview preparation techniques mainly focused on finance roles.

Links

Tags

Finance
MS Excel
Financial Modeling
Skill
Upgrade
equity research
investment banking
advanced excel
Analytics
Power BI
Financial Analytics
Advanced Financial Modelling
Lambda
Dynamic Arrays

Stats

Joined October 12, 2013
315,955 total views
India

Videos

Power Query: Match Transactions to the Latest Price Using Multiple Criteria
11:36
Power Query: Match Transactions to the Latest Price Using Multiple Criteria

259 views

1mo ago

Understanding numerical operations in MS Excel | BODMAS
11:17
Understanding numerical operations in MS Excel | BODMAS

117 views

10mo ago

MS Excel fundamentals cell referencing
12:25
MS Excel fundamentals cell referencing

108 views

10mo ago

Modeling revolver without circular reference | Easier and accurate
5:01
Modeling revolver without circular reference | Easier and accurate

684 views

10mo ago

Smart Modeling | Build financial models that retain and rewind assumptions
1:09:01
Smart Modeling | Build financial models that retain and rewind assumptions

248 views

10mo ago

Building financial model with Dynamic Array | The BEST framework
54:10
Building financial model with Dynamic Array | The BEST framework

600 views

1y ago

Circular reference in dynamic arrays
6:43
Circular reference in dynamic arrays

221 views

1y ago

Ultimate guide to think like a financial modeler | Evolving from accounting to financial modeling
19:01
Ultimate guide to think like a financial modeler | Evolving from accounting to financial modeling

219 views

1y ago

Financial Modeling with Lambdas - upgrade to 2025 way of making models
6:14
Financial Modeling with Lambdas - upgrade to 2025 way of making models

429 views

1y ago

Why you should avoid IRR?
4:43
Why you should avoid IRR?

384 views

1y ago

Automate calculations in MS Word
9:26
Automate calculations in MS Word

5,600 views

1y ago

Dos and DONTs for dynamic arrays | Never mix legacy approach with dynamic arrays
5:29
Dos and DONTs for dynamic arrays | Never mix legacy approach with dynamic arrays

182 views

1y ago

Playlists

Green Belt - Suggested videos
3 videos
Green Belt - Suggested videos
Event alert
2 videos
Event alert
The BEST framework
2 videos
The BEST framework
BEST framework
1 videos
BEST framework
Alternatives to IF function
2 videos
Alternatives to IF function
Time Value of Money
6 videos
Time Value of Money
A to Z of Waterfall charts in MS Excel | Take your waterfall charts to the next level
4 videos
A to Z of Waterfall charts in MS Excel | Take your waterfall charts to the next level
Case studies - Preread
3 videos
Case studies - Preread
Session 2 - Preread
1 videos
Session 2 - Preread
Session 1 - Preread
5 videos
Session 1 - Preread

ModelingViz

Profectus Academy
ModelingViz: Are you framing the right equation? | Financial Modeling
9:01
ModelingViz: Are you framing the right equation? | Financial Modeling

204 views

7y ago

Profectus Academy
When to use CAGR for forecasting? | Advantages and disadvantages
10:04
When to use CAGR for forecasting? | Advantages and disadvantages

12,000 views

6y ago

Profectus Academy
Modeling Viz: Fundamental element of model (addendum)
5:21
Modeling Viz: Fundamental element of model (addendum)

194 views

7y ago

Profectus Academy
What is financial modelling? | Five blind men of financial modeling
5:15
What is financial modelling? | Five blind men of financial modeling

567 views

7y ago

Profectus Academy
Introduction to dynamic array in Microsoft Excel
15:55
Introduction to dynamic array in Microsoft Excel

1,300 views

6y ago

Profectus Academy
Fundamentals of dynamic array| How to frame a dynamic array formula in MS Excel
19:53
Fundamentals of dynamic array| How to frame a dynamic array formula in MS Excel

680 views

6y ago

Profectus Academy
Building financial statement model using dynamic array
32:38
Building financial statement model using dynamic array

1,200 views

6y ago

Profectus Academy
Webinar: Financial modeling with Tables and Dynamic arrays
50:13
Webinar: Financial modeling with Tables and Dynamic arrays

721 views

6y ago

Profectus Academy
Using Min and Max functions as alternative to IF function
8:14
Using Min and Max functions as alternative to IF function

1,100 views

6y ago

Profectus Academy
How to use Xlookup and Vlookup as alternative to IF function | Income tax calculation with many slab
11:47
How to use Xlookup and Vlookup as alternative to IF function | Income tax calculation with many slab

787 views

6y ago

Profectus Academy
How to extract individual words from a string in MS Excel? | How to create word cloud in MS Excel?
23:52
How to extract individual words from a string in MS Excel? | How to create word cloud in MS Excel?

5,600 views

6y ago

How It Should Have Ended
How Bumblebee Should Have Ended
5:47
How Bumblebee Should Have Ended

6,700,000 views

7y ago

MS Excel Tips and Tricks

Profectus Academy
How to automatically get sum of large N number of values in MS Excel | Working with dynamic arrays
14:58
How to automatically get sum of large N number of values in MS Excel | Working with dynamic arrays

640 views

6y ago

Profectus Academy
Cool MS Excel trick to create automatic score card charts| Make impressive dashboards showing KPIs
14:56
Cool MS Excel trick to create automatic score card charts| Make impressive dashboards showing KPIs

916 views

6y ago

Profectus Academy
How to repeat cell values or set of values n number of times? Cross join in MS Excel
12:54
How to repeat cell values or set of values n number of times? Cross join in MS Excel

42,000 views

6y ago

Profectus Academy
Introduction to dynamic array in Microsoft Excel
15:55
Introduction to dynamic array in Microsoft Excel

1,300 views

6y ago

Profectus Academy
Fundamentals of dynamic array| How to frame a dynamic array formula in MS Excel
19:53
Fundamentals of dynamic array| How to frame a dynamic array formula in MS Excel

680 views

6y ago

Profectus Academy
How to make a loan amortisation schedule using dynamic array in MS Excel
17:15
How to make a loan amortisation schedule using dynamic array in MS Excel

1,800 views

6y ago

Profectus Academy
How to sort columns in MS Excel
1:17
How to sort columns in MS Excel

205 views

6y ago

Profectus Academy
Webinar: Financial modeling with Tables and Dynamic arrays
50:13
Webinar: Financial modeling with Tables and Dynamic arrays

721 views

6y ago

Profectus Academy
How to use Xlookup and Vlookup as alternative to IF function | Income tax calculation with many slab
11:47
How to use Xlookup and Vlookup as alternative to IF function | Income tax calculation with many slab

787 views

6y ago

Profectus Academy
How to get financial year in MS Excel
2:18
How to get financial year in MS Excel

837 views

6y ago

Profectus Academy
How to get fiscal quarter or fiscal month in MS Excel and Zoho Sheets | Do it the right way
3:16
How to get fiscal quarter or fiscal month in MS Excel and Zoho Sheets | Do it the right way

1,400 views

6y ago

Profectus Academy
Using Min and Max functions as alternative to IF function
8:14
Using Min and Max functions as alternative to IF function

1,100 views

6y ago

Equity research

Profectus Academy
How to do management analysis for equity research?
16:03
How to do management analysis for equity research?

760 views

6y ago

Shorts

Get negative numbers in bracket in MS Excel
Get negative numbers in bracket in MS Excel

1,000 views

Use relative reference as default with MS Excel tables #excel #tables #structuredreference
Use relative reference as default with MS Excel tables #excel #tables #structuredreference

263 views

Get dates cleaned in MS Excel | Fail proof import method #MSExcel #powerquery #datacleaning #date
Get dates cleaned in MS Excel | Fail proof import method #MSExcel #powerquery #datacleaning #date

617 views

Smart Modeling | Financial Models that retain and rewind past assumptions
Smart Modeling | Financial Models that retain and rewind past assumptions

691 views

Excel # reference trick explained #shorts
Excel # reference trick explained #shorts

1,400 views

Why does MS Excel have NumberValue function when it already had Value fhunction?
Why does MS Excel have NumberValue function when it already had Value fhunction?

217 views

How to use Vlookup to pull data from columns to the left of your Lookup value?
How to use Vlookup to pull data from columns to the left of your Lookup value?

660 views

Instead of using complex NestedIF, use this
Instead of using complex NestedIF, use this

395 views