MS Excel Tutorial by RCostillas

09/16/2024

Maaari ba na ilimit ang number of entries sa isang column or row ng hindi gumagamit ng VBA? Pwedeng pwede yan! Kung gusto mo matutunan, manood lamang sa video na eto.

Watch full video on YouTube:
https://youtu.be/VX8dsgAwPng?si=BC2D92QuljdZYrkMvq=hd1080

09/02/2024

Masakit sa ulo na date format: UK or US date format ba gagamitin? Paano ba natin ireresolve?

Watch full video on YouTube:
https://youtu.be/v2up2oE6eCM?si=FrWUQtjWoPs3CTVCvq=hd1080

08/30/2024

One of the most annoying errors we often face in Excel is related to date formatting. It can be confusing to know what to do when we encounter this issue, and there are times when we're unsure how to resolve it. Fortunately, there are several methods to address this problem. One option is to use a combination of functions to create formulas that can convert UK date formats to US date formats or vice versa. In this approach, you’ll see how easily this can be done without the need for helper columns. Watch the video to learn more.

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

One of the most frustrating errors we often face in Excel is related to date formatting. It can be confusing to know what to do when we encounter this issue,...

08/06/2024

With Microsoft 365, establishing a cross-reference dropdown list in Excel has become straightforward, thanks to the spill formula and the integration of IF, FILTER, and XLOOKUP functions, rendering VBA unnecessary. This approach simplifies the creation of dynamic, interconnected dropdowns, enhancing data analysis accuracy and reliability. To gain further insights into implementing this technique, please refer to the accompanying video tutorial.

Watch full video:
https://youtu.be/S2fFDpShKQc?si=vhKxBpjpZx3WLC-Lvq=hd1080

By utilizing the advanced features of Microsoft 365, Excel users can efficiently create cross-reference dropdown lists through the strategic use of functions...

06/15/2024

𝗔𝗳𝗳𝗼𝗿𝗱𝗮𝗯𝗹𝗲 𝗘𝘅𝗰𝗲𝗹 𝗧𝗲𝗺𝗽𝗹𝗮𝘁𝗲: 𝗟𝗲𝗮𝘃𝗲 𝗧𝗿𝗮𝗰𝗸𝗲𝗿

To purchase, please visit the link below. Thanks!
https://forms.gle/JaB7iGMLmgf5vdoRA

06/03/2024

Alam mo na ba kung pano magreverse ng ating data? Manual mo pa din ba siya ginawa, like copy and paste records? Huwag na magalala, madali lang natin magagawa eto using ang functions na Sortby o combination ng Index and Rows functions.

Kung gusto mo matutunan paano eto gawin, watch mo na ang ating video sa link na eto...

There are times when you need to transform your data, like reversing the order of a list. Doing this manually is tedious and error-prone. In this video, we’l...

05/05/2024

And it's a wrap! 🙏
Microsoft Excel 2019 (Part 1)

05/02/2024

Microsoft Word, mahirap po ba?
Alam nyo ba na ung unang work natin eh MS Word Formatter? Tara simulan na natin ang training!

04/30/2024

Thank you guys for attending sa ating recent training in "𝗖𝗿𝗲𝗮𝘁𝗶𝗻𝗴 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 𝗶𝗻 𝗘𝘅𝗰𝗲𝗹". We're excited to see how you utilize these new skills in your professional environment. 💪🙌👏

04/20/2024

Excited to see my 1st batch of MS Word trainees. Let's do this! 🙏

04/13/2024

Kita kits ulit tayo mamaya guys sa ating
Creating Dashboard in
Excel Training
Pwede pa humabol. Click nyo lang ung link sa comment section

04/12/2024

Quick question lang po:
Ano bang magandang next Excel training ang gusto mo?

1. Excel Essentials (Basic to Intermediate)
2. Pivot Tutorial
3. VBA Series (Part 1 to Part 3)
4. Any other excel topics?

Note: We have training this Saturday, April 13, regarding Creating Dashboard in Excel. Baka may gusto pang humabol :-)

04/08/2024

𝗘𝗺𝗯𝗮𝗿𝗸 𝗼𝗻 𝗬𝗼𝘂𝗿 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 𝗠𝗮𝘀𝘁𝗲𝗿𝘆 𝗝𝗼𝘂𝗿𝗻𝗲𝘆❗
Are you ready to take your Excel skills to the next level and become a dashboard maestro? Our Excel Dashboard Training is your ticket to unlocking the full potential of data visualization and analysis.

𝗖𝗼𝗻𝘁𝗮𝗰𝘁 𝘂𝘀 𝗳𝗼𝗿 𝗺𝗼𝗿𝗲 𝗱𝗲𝘁𝗮𝗶𝗹𝘀.
𝗙𝗕 𝗣𝗮𝗴𝗲: MS Excel Tutorial by RCostillas
𝗘𝗺𝗮𝗶𝗹: [email protected]
𝗪𝗵𝗮𝘁𝘀𝗔𝗽𝗽: +1 368 9970902

Please click the link below to find out more about the training.
https://forms.gle/YaCtVbDuf72SurHK6

04/07/2024

Ignite your passion for Power Query! We express our gratitude for your engagement in this illuminating training. Understand that the journey of mastering Power Query is a continuous one. Seize every chance to refine your skills and excel. Here's to your ongoing success in harnessing the power of Power Query!

04/06/2024

See you in a bit guys!
Power Query Fundamentals Training

03/27/2024

𝗠𝗮𝘀𝘁𝗲𝗿 𝘁𝗵𝗲 𝗘𝘀𝘀𝗲𝗻𝘁𝗶𝗮𝗹𝘀: 𝗨𝗻𝗹𝗲𝗮𝘀𝗵 𝘁𝗵𝗲 𝗣𝗼𝘄𝗲𝗿 𝗼𝗳 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆❗

Join us for an immersive journey into the heart of Excel data manipulation! Dive deep into the essential techniques of Power Query, and emerge equipped to transform your data like never before. Don't miss out on this opportunity to elevate your skills and excel in data management. Sign up now for our Power Query Fundamentals training!

𝗖𝗼𝗻𝘁𝗮𝗰𝘁 𝘂𝘀 𝗳𝗼𝗿 𝗺𝗼𝗿𝗲 𝗱𝗲𝘁𝗮𝗶𝗹𝘀.
FB Page: MS Excel Tutorial by RCostillas
Email: [email protected]
WhatsApp: +1 (368) 997 0902

𝗡𝗼𝘄 𝗢𝗽𝗲𝗻 𝗳𝗼𝗿 𝗥𝗲𝗴𝗶𝘀𝘁𝗿𝗮𝘁𝗶𝗼𝗻❗
Please see below link.

https://forms.gle/hxpYYvQV55LueLgA8

03/24/2024

Quick survey: Anyone interested in learning Power Query? Taas ang mga paa!
Tentative date would be on April 6

03/21/2024

Keep the flame of curiosity alive! Thank you for joining us in this enriching training session. Remember, the journey of learning never ends. Embrace every opportunity to grow and evolve. Cheers to your continued success!

03/12/2024

Problem solved using VBA...

03/11/2024

Thank you po for your kind feedback. We really appreciate po. 🥰🙏

03/11/2024

I'm pleased to share the results of our recent Excel Dashboard Training, featuring the completed dashboards crafted by our students. Congratulations to both of you, Mark and Ercil, as you have great potential in the field of data analytics. Continuously refine your skills and maintain a commitment to lifelong learning!

For those interested in our Excel training, there's a session scheduled for this Saturday, March 16, focusing on gaining fundamental knowledge in writing functions and formulas. Feel free to reach out if you're interested in joining.

You may also request for a one-on-one training, if you believe you require personalized training. We look forward to seeing you soon.

03/11/2024

𝐄𝐦𝐩𝐨𝐰𝐞𝐫 𝐘𝐨𝐮𝐫 𝐄𝐱𝐜𝐞𝐥 𝐄𝐱𝐩𝐞𝐫𝐭𝐢𝐬𝐞: 𝐌𝐚𝐬𝐭𝐞𝐫𝐢𝐧𝐠 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬 & 𝐅𝐨𝐫𝐦𝐮𝐥𝐚𝐬❗

Enhance your Excel skills and boost your professional career with our specialized training on Writing Functions and Formulas! Join a dynamic session crafted to elevate your spreadsheet abilities, acquiring essential skills in creating efficient formulas, automating calculations, and increasing productivity. Seize the opportunity – enroll now for a practical learning experience!

Contact us for more details.
FB Page: MS Excel Tutorial by RCostillas
Email: [email protected]
WhatsApp: +1 (368) 997 0902

Now Open for Registration!
Please see below link.

https://forms.gle/Ch44UL7K7mMqJ9LF7

03/03/2024

𝗘𝗺𝗯𝗮𝗿𝗸 𝗼𝗻 𝗬𝗼𝘂𝗿 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 𝗠𝗮𝘀𝘁𝗲𝗿𝘆 𝗝𝗼𝘂𝗿𝗻𝗲𝘆❗

Are you ready to take your Excel skills to the next level and become a dashboard maestro? Our Excel Dashboard Training is your ticket to unlocking the full potential of data visualization and analysis.

Contact us for more details.
FB Page: MS Excel Tutorial by RCostillas
Email: [email protected]
WhatsApp: +1 368 9970902

Discover the potential of data visualization through our training on creating interactive dashboards in Excel! Specifically designed for individuals looking to enhance their abilities in constructing dynamic and user-friendly dashboards within Microsoft Excel, this practical program offers a thoroug...

03/02/2024

The HR survey dashboard provides a comprehensive overview of employee feedback and engagement data, allowing HR professionals to easily track trends, measure satisfaction levels, and identify areas for improvement within the organization. The dashboard offers customizable visuals and interactive charts to help HR teams analyze survey results effectively and make data-driven decisions to enhance the employee experience.

Watch full video:
https://youtu.be/4MLt2-YjiAUvq=hd1080

How to Create a Survey Analysis Dashboard in ExcelHere's my entry for Maven Analytics .. The survey analysis is all about employees'...

02/22/2024

Nowadays, creating a unique ID or primary key in Excel is relatively easy if you know how to use the Query editor or PowerQuery in Excel. However, if your current version does not support this or you don't have an idea on how to do this, you may find yourself thinking of doing this using a formula.

In this video, you will learn how to create your own primary key using the combination of several functions primarily the IF and ROW functions.

Watch full video:
https://youtu.be/xCv6G-6yikovq=hd1080

How to Create a Unique ID or Primary Key Using IF and ROW Functions | Excel Tagalog TutorialNowadays, creating a unique ID or primary key in Excel is relativ...

02/04/2024

Gusto mo ba matuto gumawa ng simpleng lending system? Watch nyo lang eto guys 🥰

Full video on Youtube:
https://youtu.be/gg5veHvGC8Q?si=1b-DasFwK_cdlrnNvq=hd1080

Lending is likely one of the most widespread businesses globally. Employing a monitoring tool is essential for efficient supervision and preventing errors th...

12/08/2023

Isang Tanong, Isang Sagot sa Excel #1
Transform Data Using Power Query

Watch full video:
https://youtu.be/TGVOAjfw-SAvq=hd1080

12/04/2023

𝙃𝙤𝙬 𝙩𝙤 𝘾𝙤𝙢𝙗𝙞𝙣𝙚 𝙑𝙨𝙩𝙖𝙘𝙠 𝙖𝙣𝙙 𝙓𝙡𝙤𝙤𝙠𝙪𝙥 𝙛𝙪𝙣𝙘𝙩𝙞𝙤𝙣𝙨

𝙒𝙖𝙩𝙘𝙝 𝙛𝙪𝙡𝙡 𝙫𝙞𝙙𝙚𝙤:
https://youtu.be/qD1IszKi9cIvq=hd1080

Have you ever considered the potential synergy of combining VSTACK and XLOOKUP functions? I believe it's a powerful combination, allowing you to consolidate data and perform lookups without loading the VSTACK-produced array. And yes, it's totally achievable. If you're keen on learning how to do this, just tune in to this quick video tutorial.

How to Combine XLOOKUP and VSTACK functionsHave you ever considered the potential synergy of combining VSTACK and XLOOKUP functions? I believe it's a powerfu...

12/02/2023

𝙀𝙭𝙩𝙖𝙘𝙩 𝙛𝙞𝙧𝙨𝙩, 𝙢𝙞𝙙𝙙𝙡𝙚 𝙖𝙣𝙙 𝙡𝙖𝙨𝙩 𝙣𝙖𝙢𝙚 (𝙞𝙣𝙘𝙡𝙪𝙙𝙞𝙣𝙜 𝙥𝙧𝙚𝙛𝙞𝙭 𝙖𝙣𝙙 𝙨𝙪𝙛𝙛𝙞𝙭 𝙪𝙨𝙞𝙣𝙜 𝙛𝙤𝙧𝙢𝙪𝙡𝙖)

𝙒𝙖𝙩𝙘𝙝 𝙛𝙪𝙡𝙡 𝙫𝙞𝙙𝙚𝙤:
https://youtu.be/CISxX5voyIUvq=hd1080

Looking for ways on how you could split first, middle and last name in a cell using a formula? How about if your data has some prefix, for example Dr. or Prof., and suffix such as Jr. Sr.? How are you going to split these names in a smooth way that you're not going to manually doing it?

I guess you need to watch this video as this will guide you on how to achieve this using a combination of functions. Formulas are provided to you in the video.

1. Extract First and Last Name
- The formula that we have used in this example only applies if your data has single space.

2. Extract First, Middle and Last Name
- The formula that we have used in this example only applies if your data has a mixed name format which means that some of your data have middle name (2 spaces) and some don't (1 space) only.

3. Extract names with Prefix and Suffix
- The formula that we have used in this example applies if your data has a variety of format. For example, some of our names in our list have prefix, some may have suffix, others have both prefix and suffix while the rest don't have any prefix and suffix at all.

How to Split Names Using a FormulaLooking for ways on how you could split first, middle and last name in a cell using a formula? How about if your data has s...