![EXCEL WIZARD IN MINUTES](/img/default-banner.jpg)
- 371
- 449 372
EXCEL WIZARD IN MINUTES
United Arab Emirates
Приєднався 16 лют 2022
Welcome to the Excel Wizard in Minutes Channel! With 250+ videos, you will learn all the tricks to master excel from shortcuts to formulas passing by painful formatting...If you are more advanced, you can even learn about pivots, charts, power query and how to develop macros to automate your dashboards.
The catch is that all videos are short and straight to the point! No time wasted!
If you are:
- Totally new to excel
- Advanced in excel but want to deepen your knowledge
- Short on time
Then this channel is for you!
The catch is that all videos are short and straight to the point! No time wasted!
If you are:
- Totally new to excel
- Advanced in excel but want to deepen your knowledge
- Short on time
Then this channel is for you!
Excel Formula to Create Hyperlink 🔗 in Cell - Websites🌐, Files📁, Workbook Navigation🧭!
🔗 Excel Formula to Create Hyperlink: Website, Files, and More! 🌐📁
Welcome to a comprehensive guide on using Excel formulas to create hyperlinks within your spreadsheets! In this tutorial, we'll dive into various scenarios, from linking to websites to connecting files and cells. Master these techniques and become an Excel hyperlink pro! 🚀
In this video, you'll learn:
🔹 Creating Web Links with Precision: Discover the formula to create hyperlinks that seamlessly direct you to websites. Avoid common pitfalls, like ensuring the "https" prefix for correct linking.
🔹 Navigating Between Sheets: Learn how to craft formulas that link to cells in different sheets. Easily connect information within your workbook for streamlined navigation.
🔹 Intra-Sheet Cell Linking: Dive into the method of linking cells within the same sheet. Effortlessly jump to important data points without the hassle of scrolling.
🔹 Linking to Various File Types: Explore formulas that generate hyperlinks to a diverse range of files, be it PDFs, Word documents, Excel files, or any other file type you need.
🔹 Efficient File Linking Trick: Uncover a valuable trick for creating multiple hyperlinks to files within a single folder in one go. Boost your productivity and keep your spreadsheets organized.
Key Formulas and Concepts Covered:
HYPERLINK() function for creating various types of hyperlinks.
Linking to websites with proper URL formatting.
Linking to cells in the same sheet and different sheets.
Creating hyperlinks to different file types.
Crafting conditional hyperlinks based on cell values.
Whether you're a beginner looking to enhance your Excel skills or a seasoned user aiming to optimize your workflow, this tutorial has something for everyone. By the end, you'll be equipped with the knowledge to effortlessly create hyperlinks that enhance the interactivity and usability of your spreadsheets.
Don't miss out on this Excel hyperlink extravaganza! Watch now and take your Excel game to the next level. Don't forget to like, comment, and subscribe for more valuable Excel tips and tutorials. 📊📚
🔔 Stay tuned for more insightful tutorials! And as always, happy Excel-ing! 📈📊
***Links
Data: mega.nz/file/eDIUmYqL#cfQqVGMNE-uF9GRQSlFnBPAUyRNk4YKM9KmPlkUeJeU
Completed: mega.nz/file/3LRAnBbL#BsFBlhi74oDD0NxeuMUPb1v8oQot5bM8owFad66eVP8
#ExcelFormulas #Excel #MsExcel #exceltutorial
Welcome to a comprehensive guide on using Excel formulas to create hyperlinks within your spreadsheets! In this tutorial, we'll dive into various scenarios, from linking to websites to connecting files and cells. Master these techniques and become an Excel hyperlink pro! 🚀
In this video, you'll learn:
🔹 Creating Web Links with Precision: Discover the formula to create hyperlinks that seamlessly direct you to websites. Avoid common pitfalls, like ensuring the "https" prefix for correct linking.
🔹 Navigating Between Sheets: Learn how to craft formulas that link to cells in different sheets. Easily connect information within your workbook for streamlined navigation.
🔹 Intra-Sheet Cell Linking: Dive into the method of linking cells within the same sheet. Effortlessly jump to important data points without the hassle of scrolling.
🔹 Linking to Various File Types: Explore formulas that generate hyperlinks to a diverse range of files, be it PDFs, Word documents, Excel files, or any other file type you need.
🔹 Efficient File Linking Trick: Uncover a valuable trick for creating multiple hyperlinks to files within a single folder in one go. Boost your productivity and keep your spreadsheets organized.
Key Formulas and Concepts Covered:
HYPERLINK() function for creating various types of hyperlinks.
Linking to websites with proper URL formatting.
Linking to cells in the same sheet and different sheets.
Creating hyperlinks to different file types.
Crafting conditional hyperlinks based on cell values.
Whether you're a beginner looking to enhance your Excel skills or a seasoned user aiming to optimize your workflow, this tutorial has something for everyone. By the end, you'll be equipped with the knowledge to effortlessly create hyperlinks that enhance the interactivity and usability of your spreadsheets.
Don't miss out on this Excel hyperlink extravaganza! Watch now and take your Excel game to the next level. Don't forget to like, comment, and subscribe for more valuable Excel tips and tutorials. 📊📚
🔔 Stay tuned for more insightful tutorials! And as always, happy Excel-ing! 📈📊
***Links
Data: mega.nz/file/eDIUmYqL#cfQqVGMNE-uF9GRQSlFnBPAUyRNk4YKM9KmPlkUeJeU
Completed: mega.nz/file/3LRAnBbL#BsFBlhi74oDD0NxeuMUPb1v8oQot5bM8owFad66eVP8
#ExcelFormulas #Excel #MsExcel #exceltutorial
Переглядів: 71
Відео
Create Custom Data Validation Checks (Advanced Rules) ✔️for better Excel Data Entry
Переглядів 9821 годину тому
Create custom data validation excel: Mastering Custom Data Validation Formulas in Excel | Advanced Techniques and Examples Are you ready to take your data validation skills to the next level in Excel? Join us in this tutorial where we dive into the realm of custom data validation formulas. Learn how to create advanced validation rules and ensure data accuracy like never before. In this video, w...
How to use Google Translate in Excel to Translate Multiple Columns at Once
Переглядів 61914 днів тому
How to use Google Translate in Excel to Translate Multiple Columns at Once Learn how to use Google Translate in Excel to translate multiple columns at once with this comprehensive tutorial. We will explore two approaches to achieve this: Approach A: Using the Translate Functionality in Excel Discover how to use the translate function in Excel. While this method is straightforward, it involves m...
How to Remove 🚫 Conditional Formatting in Excel
Переглядів 9021 день тому
How to Remove Conditional Formatting in Excel: Say goodbye to unwanted formatting headaches in Excel! 🚫 In our latest tutorial, we're diving into the essential skill of removing conditional formatting with precision and ease. Here's what you'll learn: A) Unlock the magic of removing conditional formatting for your entire sheet at once. Streamline your workflow by wiping the slate clean effortle...
Increase the Font Size of the Formula Bar
Переглядів 36128 днів тому
Increase the Font Size of the Formula Bar 🔍 Struggling with a tiny font size in your Excel Formula Bar? In this tutorial, I'll guide you through the steps to increase the font size and make your formulas more visible for a seamless Excel experience. ✨ Steps to Increase Formula Bar Font Size: 📂 Go to File , Options , General. 🖱️ Change the font size settings to make your formula bar more legible...
Mastering Excel's Accounting Number Formats🧾- Change Colors, Add Icons, Symbols, Currencies & More!
Переглядів 153Місяць тому
Mastering Excel's Accounting Number Formats: Tips and Tricks 📊 Dive into the world of accounting number formats in Excel with our latest video! 📈 If you're looking to elevate your spreadsheet skills, you're in the right place. In this comprehensive tutorial, we'll cover everything you need to know about Excel's accounting number formats. 🔍 What's on the agenda? A) Uncover the power of the accou...
Find the Previous Business Day📅 in Excel
Переглядів 70Місяць тому
Find the Previous Business Day in Excel Are you tired of manually hunting for the previous business day in Excel? We've got the solutions you need in our latest tutorial! 📈 In this video, we'll dive into the world of Excel formulas to help you effortlessly find the previous working day, while considering weekends and even a list of holidays. No more headaches or manual counting - we've got you ...
Linking Cells Across Excel Sheets For Easy Navigation 🤫🔗!
Переглядів 332Місяць тому
how to add a link to a different tab in excel & how to use hyperlink in excel in same worksheet Welcome to a tutorial that will revolutionize how you navigate within your Excel workbooks! In this video, we'll delve deep into the art of creating hyperlinks to cells in the same sheet and across different sheets. Not just through manual linking, but also with dynamic formulas that adapt to your ch...
What is Data Validation in Excel? Restrict inputs with drop down and checks(Dates, Numbers, Txt len)
Переглядів 109Місяць тому
What is Data Validation in Excel? Restrict inputs with drop down and checks(Dates, Numbers, Txt len)
Apply Conditional Formatting 🎨 to an Entire Row in Excel
Переглядів 3612 місяці тому
Apply Conditional Formatting 🎨 to an Entire Row in Excel
Ifs Explained in a simple way! 🥸 Forget Multiple IF statements!!
Переглядів 2642 місяці тому
Ifs Explained in a simple way! 🥸 Forget Multiple IF statements!!
Custom Number Format for Millions and Thousands - Excel Cosmetics 💄 for Dashboards!
Переглядів 912 місяці тому
Custom Number Format for Millions and Thousands - Excel Cosmetics 💄 for Dashboards!
Flash Fill Does Not Work 🤬🤬- How to Enable it and get Correct Results
Переглядів 7572 місяці тому
Flash Fill Does Not Work 🤬🤬- How to Enable it and get Correct Results
NetworkDays🗓️ - Excel Formula to Calculate Working Days without Week Ends and Holidays
Переглядів 1173 місяці тому
NetworkDays🗓️ - Excel Formula to Calculate Working Days without Week Ends and Holidays
Send Bulk Emails from Excel Spreadsheet 📧 - FREE VBA Workbook incl multiple attachments🖇
Переглядів 3833 місяці тому
Send Bulk Emails from Excel Spreadsheet 📧 - FREE VBA Workbook incl multiple attachments🖇
A Secret🤫 Formula to Send Dynamic Emails📧 from Excel
Переглядів 2603 місяці тому
A Secret🤫 Formula to Send Dynamic Emails📧 from Excel
Revert back to original Sort (Unsort) order in Excel 👌 - Quick Magic Trick!
Переглядів 7133 місяці тому
Revert back to original Sort (Unsort) order in Excel 👌 - Quick Magic Trick!
Create Progress (Data) Bars in Excel Cells 🎨with Conditional Formatting
Переглядів 9613 місяці тому
Create Progress (Data) Bars in Excel Cells 🎨with Conditional Formatting
How to use IF function with PARTIAL Text Match - Wildcards (*️⃣, ❓)
Переглядів 2434 місяці тому
How to use IF function with PARTIAL Text Match - Wildcards (*️⃣, ❓)
Excel Custom Number Format: Add Colors🎨, Emojis🤪, and Symbols🔼 for Fun and Insight!
Переглядів 2584 місяці тому
Excel Custom Number Format: Add Colors🎨, Emojis🤪, and Symbols🔼 for Fun and Insight!
Get First / Last Name and Domain from Email Address 📧+ Create Emails from Names in Excel
Переглядів 6014 місяці тому
Get First / Last Name and Domain from Email Address 📧 Create Emails from Names in Excel
Workday📆 - How to Add or Subtract Working Days to a Date
Переглядів 2394 місяці тому
Workday📆 - How to Add or Subtract Working Days to a Date
Amazing Excel Navigation Buttons▶️!
Переглядів 2,9 тис.5 місяців тому
Amazing Excel Navigation Buttons▶️!
Excel Sorting Like a Pro: Multiple Cols, Icons🚦, Colors 👩🎨 & even a Custom List📝
Переглядів 1975 місяців тому
Excel Sorting Like a Pro: Multiple Cols, Icons🚦, Colors 👩🎨 & even a Custom List📝
How to use Conditional Formatting in Excel with Formula ✅- Get it Right Every time!
Переглядів 2205 місяців тому
How to use Conditional Formatting in Excel with Formula ✅- Get it Right Every time!
7 Tricks 🤹 with IF formula that Every Analyst Should know! (Wildcard, Between, List Check, etc...)
Переглядів 2375 місяців тому
7 Tricks 🤹 with IF formula that Every Analyst Should know! (Wildcard, Between, List Check, etc...)
How to Format Phone Numbers 📞 in Excel And deal with the Disappearing 0 in front of Numbers
Переглядів 1996 місяців тому
How to Format Phone Numbers 📞 in Excel And deal with the Disappearing 0 in front of Numbers
How to Split🪓First and Last Name In Excel (4 Methods with/without Formula)
Переглядів 2246 місяців тому
How to Split🪓First and Last Name In Excel (4 Methods with/without Formula)
Extract Year, Month, (Week) Day and Time from Date🗓️ in Excel
Переглядів 6246 місяців тому
Extract Year, Month, (Week) Day and Time from Date🗓️ in Excel
can u make a video..on dashboard ...with storytellin and some decision
Hey Sharukh! Thanks a lot :). Can you explain to me what you mean by storytelling and decision?
nice teaching
Nice
@@SidKnight thankssss :)
For more content like this, subscribe: ua-cam.com/users/excelwizardinminutes?submission=1
Excellent explanation 👍
thanksss. It s a complex topic, glad it s clear :)
Great explanation! However, I now need to import multiple PDF's wand they each have multiple tables. Power query only lets me select one of the tables in a given PDF file. Is there a way around this?
There are a couple of ways i think. 1) have a query for each table. Ie u write 1 for table 1 in all the pdf, 1 for table etc... 2) use chatgpt. I m actually making a video on the topic but it wont come out soon. Try the free version and if needed, u might have to buy a chatgpt subscription. U upload the files and tells chatgpt to extract the table data in excel. It will do
@@EXCELWIZARDINMINUTES thank you for the rapid response
@yp4577 u r welcome. If u want access the chatgpt video, send me an email and i give u the link for a couple of days
Amazing Amazing
Thank u :)
Wow! really cool!
U can also check the video in the description about basic data validation
I thought I knew everything about excel, but this is new to me...
There are sooo many things in Excel, it never ends
Very helpful.
Thank you Dinesh! :)
For more content like this one, subscribe: ua-cam.com/users/excelwizardinminutes?submission=1
There is no flash fill option in ms excel 2007😢
yeah it got introduced in 2013. You might have to upgrade. Trust me, it s worth it!
Thank you so much, your're explaining this difficult-ish topic so clearly, without anything weighing it down. Well done
@@xavierbourguignon37220 ohh thank you :)))
WHen I was considering a data model, I was hoping it could be applied to Tables in the new workbook. The method here still has the Data Model applied to the original workbook
Very helpful thank you rami
Thank you Jean Marc :)) Hopefully more to come
Hello, for method 2 how can I make the slicers filter for an existing table like yours on 3:45? I followed the steps but the slicer doesn't filter for the original table, only for the new pivot table.
@@haydengw u need to add any table u want to filter to the data model and follow the step ie, do the relationships and sort
@@EXCELWIZARDINMINUTES Thank you for the reply. I have retried these steps even making a new table with my original data, but when I create a slicer for my table it does not create the slicer categories in the correct order.
@@haydengw i dont know what to say. U might be missing a step. Try with dummy data like mine and see first if u get the result. Something like 10 rows of data are easier to see and check
@@EXCELWIZARDINMINUTES Okay sounds good. I will email you a video demonstrating my issue later today but I appreciate your help
@@haydengw ok, when you do, please write here so i can try to go to my email and check it
For more content like this, subscribe😊: ua-cam.com/users/excelwizardinminutes?submission=1
This is the best Excel Tutorial I've ever seen on youtube. Straight forward but not missing any details! Thank you for your advice! However, I do have one question. Have you ever managed to get the labeling of the rows over the bars?
@timobllscn3954 hello! I have not tried it but try 1) manually moving them. U grab a label, keep the mouse pressed, them move the label 2) there is an otion to change the place of the labels. Have a look at the options, i am sure u ll find it
what if you have inputs that are zero how can i still use this?
@@notebynote3 it will still show on the graph. On the place where there is 0, the bar will not be visible. So i guess it still works
thank you so much this video solved my problem
Great to hear :))
Thank you for the video
none of the methods work. there is a pattern because it works within a different worksheet. I guess excel is having a brain-fart moment... 😫😫
@bopkakayht u might have some pattern that excel intelligence doesnt recognise😅
Excellent “How to” video. Thank you for this!
thank youuu :)))
This is really really good. just in time thank you very much
@@aliengg89 you are welcome :))
Can I use the List transform method to combine files with not only different headers but different number of columns with no unique column/column header between them. My clinical trial databases all make headings and number of columns as per their own company. No one column header or internal info matches the other databases. But they all have the same trials in them. I just need to throw the duplicates and keep unique records as one database may be more up-to-date and have listed more trials and the other might be missing some trials.
everything can be done but i guess in your case, the complexity is big. try to use some of the power steps and rule to make your databases as streamlined as possible before you combine
@@EXCELWIZARDINMINUTES Thank you! What i will do is clean up the data first by splitting the 'identifier' column into NCT ID and other unnecessary extra text/numbers. That way I will have the NCT ID as a common column among all the databases. AND THEN COMBINE THE WORKSHEETS.
For more content like this, subscribe:🤗 ua-cam.com/users/excelwizardinminutes?submission=1
For more content like this, subscribe :))) : ua-cam.com/users/excelwizardinminutes?submission=1
Hello, Bing map does not offer key any more, could you please make a update on you file with google key maybe ?
Check this article from Microsoft. It s pretty recent: learn.microsoft.com/en-us/bingmaps/getting-started/bing-maps-dev-center-help/getting-a-bing-maps-key#creating-a-bing-maps-key It says that now you need a key for Azure maps. i m sure it will have documentation on how to connect.
@@EXCELWIZARDINMINUTES Thank you for your quick replay. It may sound simple adjusting the file, its not simple for me and the would be the case for many other. Would please adjust for us ? This file is very very well set up, i have been through almost 10 different software and non of them is as good and functional as this file.
@mirocucu7477 Unfortunately, it will mean a new set up ect...in the future, i will consider making a new video once i get into the details of those new maps. Sorry for not being able to fix ur issus at the moment 🥲
@@EXCELWIZARDINMINUTES thank you for your replay
Superb tutorial 🙏🏼
@surjagain that s soo nice 😍
Thank you. This is so benefit for my task.
Now you can filter all tables at once 😅
For more content like this, subscribe: ua-cam.com/users/excelwizardinminutes?submission=1
I am not seeing the second pivot table in report connections what to do?
I think this will help: www.skillademia.com/blog/pivot-table-slicer/#:~:text=However%2C%20if%20the%20%E2%80%9CReport%20Connections,the%20%E2%80%9CData%E2%80%9D%20group%20tools
For more content like this, Subscribe: ua-cam.com/users/excelwizardinminutes?submission=1
Wonderful!!!
Hopefully, u saw the video before trying to make the data model again from scratch in a new Excel file 😅😅
Wow, amazing! 👏 Thank you!!
You are more than welcome ! :)
very good.👋👋👋 superb solution for not to count returning value of "".
Thank you 😊😊
Thank you, useful video and explained very clearly 🙏🏼
More than welcome 😊😊
How can change Y axis value like 1,2,3
Am not sure i understood what you mean. You can set the values of the y axis from the chart options. Feel free to look at the basic videos in my chart playlist
Thanks for the video, informative and very helpful 🙏🏼
You are Welcome ! :)
For more content like this, subscribe: ua-cam.com/users/excelwizardinminutes?submission=1
Amazing tech thanks bro ❤❤❤
U r welcome bro! Feel free to share the channel with anybody interested: ua-cam.com/users/excelwizardinminutes?submission=1
Wow😮❤
Thanks Nahlas! Who knew u could do this in excel ? Hehe
THANK YOU! I needed this.
This way, annoying users that click on everything would ruin ur dashboard 😅
For more videos like this, subscribe to : ua-cam.com/users/excelwizardinminutes?submission=1
Thank you so much! This is making my life so much easier!
You are welcome Paula! :) i hope all my videos are like this hehe
Hello, thank you for this helpful video , is it possible to change the adress that is listed in the Excel that you provide ? because i have tried to change it but the formula only works on the adress you gave and not mine and if it's possible can you please tell me how i am trying to modify it so it can give me the distance between adress ( street postal code city)
Hello, yes of course. You have to look at the comments before yours. Some ppl had issues and i listed all the possible options (such as not having a working key) i know about.
@@EXCELWIZARDINMINUTES Thank you for your time , the Problem i am facing is not listed in the commets before because i do have a working API key but when i use the formula to calculate the distance with the adress that i enter (form : street postal code city) it's always the #VALUE error
@@meryemwardani6769 try to use a normal address to get the latitude and longitude. for example Paris. Check if it works for you.
Sometimes, if the address is vague, it doesnt give you the lat and long
@@EXCELWIZARDINMINUTESit gave me the latitude and longitude with no Problem but it does not give me the distance between them.
💯 👩💻
I m glad u liked it! 😊
Love this! Very clear explanation which helped me to save time. Thank you for this.
so nice of you to leave such a great comment :)
You deserve a million subs
That s so nice of you! Please spread the word to colleagues and friends 😇 i m tryin to help as many ppl as possible with excel. I know excel can be such a headache!
You have a wonderful tips Thanks a lot
U r welcome!😊😊