MS Excel Tutorial by RCostillas

09/10/2025

How to Create a Heatmap Chart in Excel | Excel VBA TAGALOG

Watch full video:
https://youtu.be/CBmaXTiIj5w?si=3moiQPeUkvPhWS9Rvq=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

09/10/2025

Looking for ways to get the unique list on your items using a formula? Maybe you're thinking of adding a helper column to count the occurrence of each item and get its first instance. This is definitely one way of achieving this. But, certainly there's smoother way of getting the job done.

If you're using Office 365, you can use Unique function

If you're using other MS Office version, an array formula with combination of Index and Match functions is your solution.

Watch this short video tutorial to learn the trick.

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

How to Extract Unique Values in a ListLooking for ways to get the unique list on your items using a formula? Maybe you're thinking of adding a helper column ...

09/07/2025

Excel VBA Login | TAGALOG

Watch full video:
https://youtu.be/aBFRvlKy7yk?si=zW-dNwnzW0nwnpWOvq=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

09/07/2025

Excel VBA Login | Excel VBA TAGALOG

Watch full video:
https://youtu.be/aBFRvlKy7yk?si=-rJsl9C7Mbq0RDOwvq=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

09/03/2025

Limit Number of Entries in a Column or Row | Excel Tagalog Tutorial

Watch full video:
https://youtu.be/VX8dsgAwPng?si=-tZRdi2LR2_GYupMvq=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

08/31/2025

Insert Picture in a Range | Excel VBA TAGALOG

Watch full video:
https://youtu.be/h7vOdsZMcKM?si=2LeO-SqkNDLeVN-Rvq=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

08/27/2025

How to Consolidate Data in Excel Fast | EXCEL TAGALOG

Watch full video:
https://youtu.be/qD1IszKi9cI?si=Ulk2xC3vWujSUIY2vq=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

08/24/2025

Combine Multiple Worksheets into One Using Excel VBA | TAGALOG

Watch full video:
https://youtu.be/8m4k9flf_oI?si=w5QQeDWuJYa_btTcvq=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

08/24/2025

No Textjoin function but you need to combine text? No worries, let's create a custom function using VBA!

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

Combined Text Using VBA - No Textjoin | Excel VBA TAGALOGIf you're working in an older version of Excel that doesn't support the TEXTJOIN function, VBA offer...

08/21/2025

✅ Another Excel training session completed with my Canadian student!

Always a pleasure to connect and empower learners through SuperProf.

📊 Looking to level up your Excel skills?
Check out my SuperProf profile for full training details and personalized sessions.

🔗 Visit my SuperProf Profile
https://www.superprof.ca/microsoft-office-specialist-master-and-excel-expert-providing-excel-training-and-consultation-more-than-yrs-freelance.html

08/20/2025

How to Create Lending System in Excel | Excel Tagalog

Watch full video:
https://youtu.be/gg5veHvGC8Q?si=02E-PvDJ0IC9aaa6vq=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

08/17/2025

Remove Formulas and Keep Values Only | Excel VBA TAGALOG

Watch full video:
https://youtu.be/LXVEd1APThw?si=j3ERVX9bvYf9rhX7vq=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