- 1 595
- 2 377 488
Harry Viral
Nepal
Приєднався 18 тра 2019
Learn how to use Microsoft Excel, Power Query, Power Pivot and Power BI in a quick and easy way, thanks to our digestible Excel tutorials. We add new Excel tutorials on a regular basis.
Is this your first time on Harryviralk? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the Harryvirals! :)
See you in the next video!
Is this your first time on Harryviralk? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the Harryvirals! :)
See you in the next video!
Amazing VLOOKUP Formula with Lookup Value From Within Description
Welcome to our latest Excel tutorial! In this video, we dive deep into the powerful VLOOKUP formula and demonstrate how to extract lookup values from within a description. Whether you're a beginner or an experienced Excel user, this tutorial will enhance your data management skills and streamline your workflow.
📌 Topics Covered:
Introduction to VLOOKUP
How to use VLOOKUP with complex text strings
Practical examples and step-by-step guide
Tips and tricks for efficient data lookup
📊 Why Watch?
Understanding and mastering VLOOKUP can save you hours of work and make your data analysis more accurate and efficient. Learn how to tackle complex lookup scenarios with ease!
🔔 Don't Forget to Like, Share, and Subscribe!
If you find this tutorial helpful, please give it a thumbs up, share it with your colleagues, and subscribe to our channel for more Excel tips and tricks!
💬 Comments and Feedback:
We'd love to hear from you! Leave your questions and feedback in the comments below. What other Excel features would you like to learn about?
📚 Related Videos:
Mastering VLOOKUP in Excel
Advanced Excel Formulas and Functions
Tips for Efficient Data Management in Excel
📌 Topics Covered:
Introduction to VLOOKUP
How to use VLOOKUP with complex text strings
Practical examples and step-by-step guide
Tips and tricks for efficient data lookup
📊 Why Watch?
Understanding and mastering VLOOKUP can save you hours of work and make your data analysis more accurate and efficient. Learn how to tackle complex lookup scenarios with ease!
🔔 Don't Forget to Like, Share, and Subscribe!
If you find this tutorial helpful, please give it a thumbs up, share it with your colleagues, and subscribe to our channel for more Excel tips and tricks!
💬 Comments and Feedback:
We'd love to hear from you! Leave your questions and feedback in the comments below. What other Excel features would you like to learn about?
📚 Related Videos:
Mastering VLOOKUP in Excel
Advanced Excel Formulas and Functions
Tips for Efficient Data Management in Excel
Переглядів: 66
Відео
Unveiling the Mystery: What I Discovered Using Google Image Search
Переглядів 11121 день тому
Have you ever wondered what you can uncover with just a single image? In this video, I take you on a journey using Google Image Search to find the origins, details, and surprising information about a mysterious image I found. Watch as I explore various sources and piece together the story behind the image. Don't forget to like, comment, and subscribe for more intriguing content! Thanks for watc...
Efficient Student Score Compilation Using Power Query: One-Sheet Solution!
Переглядів 17921 день тому
In this tutorial, learn how to streamline your student score management using Power Query in Excel. I'll guide you through the steps to consolidate multiple individual student subject scores into a single, organized sheet. This method is perfect for educators and administrators looking to save time and enhance data organization. Whether you're managing grades, assessments, or evaluations, Power...
Merge Data Effortlessly | video no. 55 | Excel tips
Переглядів 5628 днів тому
Welcome to Video No. 55 in our Excel Tips series! In this tutorial, we'll show you how to merge data effortlessly in Excel. Whether you're combining multiple worksheets, consolidating information, or merging cells, this video has you covered. 🔍 What You'll Learn: How to use the "Merge & Center" function Tips for merging data from multiple sources Using the "CONCATENATE" and "&" functions to com...
How to Calculate Date Ranges Excluding Public Holidays Using Power Query
Переглядів 149Місяць тому
Formula:List.Dates([Start Date], Duration.Days([End Date] - [Start Date]) 1, #duration(1, 0, 0, 0)) In this video, I demonstrate how to use Power Query in Excel to calculate the count of dates between specified start and end dates, excluding public holidays. This step-by-step tutorial covers: Loading data into Power Query. Expanding date ranges to individual dates. Merging with a list of public...
Calculating Age in Excel is super easy! How to Calculate Age in Excel Using the DATEDIF Function
Переглядів 125Місяць тому
Welcome to our tutorial on calculating age in Excel using the DATEDIF function! Whether you're managing personal data or handling large datasets, knowing how to calculate age accurately is a valuable skill. In this video, we'll walk you through the steps to easily compute age from a date of birth.
How to Create a Cylinder Chart in Microsoft Excel - Step-by-Step Tutorial
Переглядів 64Місяць тому
How to Create a Cylinder Chart in Microsoft Excel - Step-by-Step Tutorial
How to Always Display the Cast Icon in Your Browser
Переглядів 26Місяць тому
How to Always Display the Cast Icon in Your Browser
How to Replace Words in Excel (and avoid unnecessary mistakes)
Переглядів 20Місяць тому
How to Replace Words in Excel (and avoid unnecessary mistakes)
How to Make Borders in Excel | Video 53
Переглядів 30Місяць тому
How to Make Borders in Excel | Video 53
How to Select Two Different Columns in Excel at the Same Time | video 52
Переглядів 35Місяць тому
How to Select Two Different Columns in Excel at the Same Time | video 52
How to Calculate the Median in Excel (Quick and Easy)
Переглядів 752 місяці тому
How to Calculate the Median in Excel (Quick and Easy)
How to Insert Bullet Points in Excel (Quick and Practical Solution)
Переглядів 502 місяці тому
How to Insert Bullet Points in Excel (Quick and Practical Solution)
How to Add Leading Zeros in Excel (Two Most Common Ways)
Переглядів 772 місяці тому
How to Add Leading Zeros in Excel (Two Most Common Ways)
Automate multiple excel file | AWESOME Excel trick to combine data from multiple sheets
Переглядів 692 місяці тому
Automate multiple excel file | AWESOME Excel trick to combine data from multiple sheets
How to Count Words in Excel (Quick and Easy)
Переглядів 252 місяці тому
How to Count Words in Excel (Quick and Easy)
How to Add Subscript in Excel (the Simplest Way)
Переглядів 372 місяці тому
How to Add Subscript in Excel (the Simplest Way)
How to Add the Dollar Sign in Excel (Quick and Easy)
Переглядів 242 місяці тому
How to Add the Dollar Sign in Excel (Quick and Easy)
How to Hide Gridlines in Excel (the Easy Way)
Переглядів 112 місяці тому
How to Hide Gridlines in Excel (the Easy Way)
How to Show or Hide the Formula Bar in Excel (Quick and Easy)
Переглядів 182 місяці тому
How to Show or Hide the Formula Bar in Excel (Quick and Easy)
How to Generate Random Numbers in Excel (3 Different Ways)
Переглядів 192 місяці тому
How to Generate Random Numbers in Excel (3 Different Ways)
How to color cell in excel? Video 41 | excel for beginners
Переглядів 272 місяці тому
How to color cell in excel? Video 41 | excel for beginners
How to Convert PDF to an Excel File (Quick and Easy) | video no. 40 | Excel for beginner
Переглядів 422 місяці тому
How to Convert PDF to an Excel File (Quick and Easy) | video no. 40 | Excel for beginner
How to Check Spelling in Excel and Avoid Typos
Переглядів 202 місяці тому
How to Check Spelling in Excel and Avoid Typos
How to Calculate Percentage Increase in Excel (The Right Way)
Переглядів 222 місяці тому
How to Calculate Percentage Increase in Excel (The Right Way)
How to Roundup and Rounddown in excel | Excel for beginner | Excel Series
Переглядів 132 місяці тому
How to Roundup and Rounddown in excel | Excel for beginner | Excel Series
How to Move columns in excel Pro tip 😧 | Excel for beginner
Переглядів 242 місяці тому
How to Move columns in excel Pro tip 😧 | Excel for beginner
How to Use AutoFill in Excel (Best Practices) | Excel for beginner | vidoe no. 35
Переглядів 242 місяці тому
How to Use AutoFill in Excel (Best Practices) | Excel for beginner | vidoe no. 35
How to Insert Comment and Note in Excel | Video no. 34 | Excel for beginner series
Переглядів 132 місяці тому
How to Insert Comment and Note in Excel | Video no. 34 | Excel for beginner series
How to Switch Rows and Columns in Excel (the Easy Way) | video no. 33 | Excel for Beginners
Переглядів 362 місяці тому
How to Switch Rows and Columns in Excel (the Easy Way) | video no. 33 | Excel for Beginners
I can't not see the edit sign on samsung 😢
Thanks
please sorry one of my friend use a photo and win dv2025 but after the result i ask him to send me the photo used to be selected i use this photos with the website you show in this video the website reject the photo by saying that the head is bigger than ,thy is why i do not rely on these website of course it is good to use it but dont trust it 100% over 100% using this website to check is not official.
Wow! You're my hero today! You just helped me de-hyphenate over 600 ISBN's without wearing out my keyboard... and myself! :)
Wc
Everything is clear, vut for EndDate you didn't do anything. You just filtered values for StartDate and you do all process for StartDate, but main data refreshing also works for EndDate?! How does it possible?!
Instruction/commentary is really necessary here for what I need
Thanks bro
Wc
Thank you
Ayo
Ayo
You should do this in English,lol
😱😱😱
😮😮
Why are you not talking
भाई बोल कर बता देता
Ha Bhai sahi Kaha
OMG THIS IS SO HELPFUL AND THE ANSWER I WAS LOOKING FOR.🥰🥰
How to send voice note
Thanks Sir, Very Helpful Video
My favorite part about this video was how it didn't do anything.
The "bacteria growth" part doesn't make sense. If you're going to cook it what's the difference. Isnt that the main point ppl make when they say you don't need to deep clean chicken before cooking.
i agree, maybe its a type of bacteria that isnt killed by heat 😅 i know theres something similar like that when it comes to reheating leftover rice
thank you brother
current education minister of nepal
i have a similar scenario but when i drag the autofill i get an error on the 9th row that continues. i saw a video saying that formating a cell as a date doesnt actually consider it as a date but as a text. but it didnt explain anything more than that.i would appreciate some help here
Hello Hari viral, how to calculate dynamic calendar in work hours of works on excel
Will be making video soon 😀
@@HarryViral thank you, will be waiting
The video does not keep up with your explanation. This video is a waste of time. No wonder there are no thumbs up!
very useful video🥰
Gyatt
I do the exact same thing but it doesnt work?
Watched four times Went too fast Tried my best anyway Couldn't get it to work Going to try another site where hopefully someone can actually explain what needs to be done Thanks for nothing...UGH!
What if I would like the sum to show as all minutes vs hours and minutes?
Very helpful. thanks bro.
Welcome bro 😁
when the data is very huge and iF you want to find mathicng values and also identify which cell it is matching use this formula: =IFERROR("B is Present in A" & MATCH(B2, A:A, 0), "B is Absent in A")
Where do i find billing zip code on a Venmo card?
Super ❤. I used it now
thank you! i tried to do it in google spreadsheets and online microsoft excel, but it is only doable in the microsoft excel program i think.
Absolutely the video is Awesome thanks ..
Welcome 🤗
Could you please make video on how to write readable SQL code , and what are the formatting we should follow while writing SQL code
Formula not clear
Thats the wrong answer, John is 1.13 min not 1.22min
It is 1.22 hours.. not minutes.. *60 if you need minutes
Or you can multiply with 1440 if you need minutes
very useful 😍
Glad you think so! 😉
Very helpfull thank u
Sir mujhe google sheet mai Evey column mai every each word kay baad comma lagana automatically how it's possible
Google sheet can't do . Try in excel
@@HarryViral Sir please bata dijiye kaise hoga sir mainy kafi UA-cam video dekh li mujhe nhi samj aa raha hai sir
Hello sir I am your subscriber I need your help please help me sir 🙏🙏🙏
Ok
thanks for the video! Exactly what I was looking for! just subscribed👍
Thank you ☺️
Sir,how to get these ad links to paste in ms word
Thank you
Welcome
Formula is not clear.
Thank so,so much! Exactly what I was looking for!!!
Video not clear
Plz watch latest video with clear video I have made of this
thank you for this video, really helps my reports thousands data, btw, i am operation data supervisor
Welcome 🤗 plz Share this video and help others
How to do it on iPad? It doesn't show the edit sign