jazfin videos

We trade in $s and verbs from the perspective that both are imbued and
interchangeable. If you get value from our content click the Donate button,
OR pay it outward please.

This video will demonstrate the use of the OFFSET formula in both excel and VBA to pull in values across worksheets within a workbook. Jazfin Company is a service provider with a focus in data management and automation for a variaty of professionals, please contact us with your specific needs under the Contact Us tab.

Please don't forget to fund these tutorials using the Donate button (top right of the Video Library) if they are adding value.

This video will walk you through VBA code for automating the opening of your computer files from various drives on the device and allowing for multiple extensions, saving you time in the morning especially when you have many files that need opening before beginning the day.

Leave comments under the YouTube channel or under the Contact Us tab (top menu left) if you are interested in seeing more or would like Jazfin Company to develop specific material.

Please don't forget to fund these tutorials using the Donate button (top right of the Video Library) if they are adding value.

This video will show you how to set up the Developer tab and produce your first macro. The tutorials are intended to be light hearted and easy to follow by a variety of audiences. Have fun setting up your first macro! and please don't forget to Subscribe and Donate (top R) if you get value out of the content.

This tutorial will go over a macro on how to hide and unhide columns and rows in Microsoft Office Excel using VBA. The training will go over some tips and tricks for locating the position in an excel spreadsheet quickly and it’ll explain algebra using an unconventional approach.

Jazfin Company envisions incorporating these type of videos in math courses (mostly high school level) in the hopes of raising students' interest and for taking practical approaches to teaching mathematics.

This video is the first (1) in a series of nine (9) tutorials, which will walk you through approaches in Microsoft Office Excel available for setting up the minimum variance frontier of a 10+ asset portfolio. The series will incorporate the Solver application, macros, matrix setup, INDEX/MATCH, array & various other formulas in Excel, and graphs.

If you have any questions or comments please leave them under the YouTube channel or click the Contact Us button.

This video is the second (2) in a series of nine (9) tutorials, which will walk you through approaches in Microsoft Office Excel available for setting up the minimum variance frontier of a 10+ asset portfolio. The video begins focusing on the portfolio variance calculation of a 10+ asset portfolio, specifically focusing on automating the covariance matrix utilizing INDIRECT, INDEX, and array formulas in MS Office Excel.

If you have any questions or comments please leave them under the YouTube channel or click the Contact Us button.

This video is the third (3) in a series of nine (9) tutorials, which will walk you through approaches in Microsoft Office Excel available for setting up the minimum variance frontier of a 10+ asset portfolio. The video focuses on a work around for the following formula: ={MMULT(MMULT(TRANSPOSE(AC5:AC16),P5:AA16),AC5:AC16)} used for calculating portfolio variance and standard deviation. We also focus on covariance calculations.

If you have any questions or comments please leave them under the YouTube channel or click the Contact Us button.

This video is the fourth (4) in a series of nine (9) tutorials, which will walk you through approaches in Microsoft Office Excel available for setting up the minimum variance frontier of a 10+ asset portfolio. Using VBA to set and reset Name Ranges for source data.

If you have any questions or comments please leave them under the YouTube channel or click the Contact Us button.

This video is the fifth (5) in a series of nine (9) tutorials, which will walk you through approaches in Microsoft Office Excel available for setting up the minimum variance frontier of a 10+ asset portfolio.

Utilizing Solver for the optimal portfolio and an example of the VBA script that runs and re runs the program for 420+ times to generate various asset baskets, which lead us to the ultimate blend to pick. And an example of the optimal portfolio at an equally weighted allocation is also presented.

If you have any questions or comments please leave them under the YouTube channel or click the Contact Us button.