MS Excel Tutorial by RCostillas

07/20/2025

Heatmap charts offer an elegant solution for visualizing relationships between two variables, transforming numerical data into intuitive color-coded representations. While Excel doesn't include a dedicated heatmap feature, you can easily create these powerful visualizations using Excel's built-in conditional formatting capabilities

Watch full video:
https://youtu.be/CBmaXTiIj5wvq=hd1080

How to Create a Heatmap Chart in ExcelOne of the most beautiful ways to present two-axis data is through Heatmap Charts. While Excel currently doesn't have a...

07/17/2025

How to Create Floating Icons | Excel VBA TAGALOG

Watch full video:
https://youtu.be/7WKrEsvPDsw?si=pusLW1eZWE1gIjFOvq=hd1080

Excel Tips and Tricks playlist:
https://www.youtube.com/watch?v=T4T2PJVT_js&list=PL6u1_VTMTuroJ2vYazClV476kTJHb4Gyb

Excel VBA Masterclass playlist:
https://www.youtube.com/watch?v=OicQufk1gPc&list=PL6u1_VTMTurp6B78RPxwPnfh9M9OpOaiw

Need assistance on your Excel reports, dashboard or automation tool?
https://www.superprof.ca/microsoft-office-specialist-master-and-excel-expert-providing-excel-training-and-consultation-more-than-yrs-freelance.html

07/14/2025

Filter ListBox Based on Textbox | EXCEL VBA TAGALOG

Watch full video:
https://youtu.be/AZ7yGXYgqTg?si=Mor8xJVPeCFRvXhTvq=hd1080

Excel Tips and Tricks playlist:
https://www.youtube.com/watch?v=T4T2PJVT_js&list=PL6u1_VTMTuroJ2vYazClV476kTJHb4Gyb

Excel VBA Masterclass playlist:
https://www.youtube.com/watch?v=OicQufk1gPc&list=PL6u1_VTMTurp6B78RPxwPnfh9M9OpOaiw

Need assistance on your Excel reports, dashboard or automation tool?
https://www.superprof.ca/microsoft-office-specialist-master-and-excel-expert-providing-excel-training-and-consultation-more-than-yrs-freelance.html

07/12/2025

👉 Our "Employee Database" template is now available on RaketPh— check out the link if you'd like to grab your own copy!

Click here 👇
https://www.raket.ph/excelintheworkplace/products/employee-database-in-excel

07/11/2025

Daily Monitoring Tool | TAGALOG

Watch full video:
https://youtu.be/JrVHiGN0FSU?si=49L0TC2hqt4dOiB4vq=hd1080

Excel Tips and Tricks playlist:
https://www.youtube.com/watch?v=T4T2PJVT_js&list=PL6u1_VTMTuroJ2vYazClV476kTJHb4Gyb

Excel VBA Masterclass playlist:
https://www.youtube.com/watch?v=OicQufk1gPc&list=PL6u1_VTMTurp6B78RPxwPnfh9M9OpOaiw

Need assistance on your Excel reports, dashboard or automation tool?
https://www.superprof.ca/microsoft-office-specialist-master-and-excel-expert-providing-excel-training-and-consultation-more-than-yrs-freelance.html

07/09/2025

If you are working or using an Excel tracker, it would be good to have a timestamp for every record that you are entering. Having this extra field on your tracker will surely help you track progress of a certain record whether on which date and time you enter the record in the system as well as if there are any status change.

You may probably think of doing this in VBA, but you might don’t know where to start. If you’re not into VBA programming, you may end up not to include this critical field anymore.

There’s an easier way to do this using a combination of different functions and of course, Nested If. In this video tutorial, I will explain how this formula works. Please watch until the very end of this video.

Watch full video:
https://youtu.be/Arfi9fwqa4Mvq=hd1080



https://youtu.be/Arfi9fwqa4Mvq=hd1080

If you are working or using an Excel tracker, it would be good to have a timestamp for every record that you are entering. Having this extra field on your tr...