"Mang Tech Hub: Your Tech Oasis" Welcome to Mang Tech, your all-encompassing tech hub where we unravel the mysteries of Excel, Google Sheets, Coding, SQL, Power BI, Mobile Tech, and more. Whether you're a tech enthusiast or a professional looking to sharpen your digital skills, our RU-vid channel is your go-to destination for comprehensive tutorials, expert insights, and hands-on demonstrations. Excel and Google Sheets Mastery Coding Demystified SQL Made Simple Power BI for Data Analysis Mobile Tech and App Development Tech Reviews and Comparisons Live Demonstrations and Challenges Community Engagement 🌟 Why Choose Mang Tech:Expert Guidance,Practical Application,Comprehensive Learning,Engagemen Whether you're looking to boost your career, enhance your digital literacy, or simply geek out on the latest tech trends, Mang Tech is your tech oasis. Subscribe now and unlock the full potential of the digital world at your fingertips. Stay curious, stay tech-savvy! 🌐💡📱💻🔍
Please change your practice data it's totally unprofessional, use actual office use Large Data Set E.g like HR Salry or Emp Data Production Data Sales Data Service industry data Hospitality Data This datasets are perfect e.g
First of all, thank you for your valuable feedback. I understand the importance of using more professional and realistic datasets to enhance the learning experience, particularly as we move toward advanced topics like dashboard creation. In these videos, I will be demonstrating how to work with datasets commonly used in professional settings, such as HR salary data, sales data, and production data. However, for now, my focus is on creating content for beginners-those who are just starting with Excel and formulas. Building this foundational knowledge is essential before advancing to more complex topics like dashboards.
@@mangtech2608 dashboard is another level bt when we are working a specific dataset (Sometime unstructured messy data sometimes not daily )so in office we are applying so many formulas and combined sheets merge using basics formulas also From Text , Maths, logical & lookup , Financial sometimes sometimes it's vry hard to understand how to apply basics formulas on this kind data set that's why we are looking kind of data set similar like office data how to use even basics formulas using as advanced and nested combination formulas using basics formulas that is my point. Sir and thankyuh so much for reply I'll conect with your channel for upcoming updates with this kind of dataset for learning basics formula Series and Tricks using as advanced and nested an combined and conditionally.
@amarpawar4113, if you're looking for training on specific datasets, I recommend pursuing separate training for that. My focus is on providing dashboard training that is commonly used. and upcoming videos very important about of dashboard section👍
You're very welcome! I'm glad the information was helpful to you. If you have any more questions or need further assistance, feel free to ask anytime. Happy scheduling! 😊
You have multiple options to do this , In cell A2, enter the start date again: =A1 In cell A3, enter the formula to generate the next date: =A2+1, Select cell A3, and then drag the fill handle (the small square at the bottom-right corner of the cell) down the column to create a sequence of dates until you reach the end date in cell B1.
You have one more options Just Type Month first date in A1 , And Last Date in B1, And Type this Formula in A2 (=IF(ROW()-1+DATE(YEAR(A$1),MONTH(A$1),DAY(A$1)) <= $B$1, ROW()-1+DATE(YEAR(A$1),MONTH(A$1),DAY(A$1)), "") And copy paste all the way You date is Ready. *Note:- press Ctrl + Shift + Enter after typing the formula*
Thank you so much for your kind words! I'm glad to hear that you love the videos and are learning Excel formulas and functions. Your support means a lot to me. I'll keep working hard to provide valuable content.
I have a doubt .I calculated percentage data but click percentage option adding 00% like 25.56 no. adding % result come 2556% . please help for this issue
Bro please yeh background ( music )mai mat Kara Karo bhut kharab hai.bhut Ganda or koe mtlb nhi hai iska.. distract karta hai... Samjh bhi nhi aata kuch please... Hatao isko
Sir Aap apna new channel banaye Aapka channel old ho chuka Hai Aur abhi tak Channel monotize nhi hua hai New channel banaye aur education category select kare To Aapka. Channel jald grow.karega Thank you
