- Видео 857
- Просмотров 9 289 345
MyExcelOnline.com
США
Добавлен 10 апр 2014
Subscribe to our channel to receive FREE weekly Microsoft Excel tutorials, training & online courses!
G’day, my name is John Michaloudis and I am the founder of MyExcelOnline. I’m in my early 40's and I am currently living in the North of Spain and I´m married and have two beautiful kids (Mikel & Ánne).
This channel will help you get better at Microsoft Excel very quickly and become more efficient in your office with our quick Excel for beginner & advanced tutorials on various features such as: Excel Formulas & Functions, Vlookup, Pivot Tables, Excel Macros, VBA Programming, Power Query, Power Pivot, Power BI, Charts, Excel Dashboards plus MUCH MORE!
As a gift to you, please download our Free 101 Ready Made Excel Templates: www.myexcelonline.com/107-73.html
Don't forget to subscribe to our RUclips channel so you can receive our new videos that we are always releasing.
Cheers,
John Michaloudis
Chief Inspirational Officer
www.myexcelonline.com
G’day, my name is John Michaloudis and I am the founder of MyExcelOnline. I’m in my early 40's and I am currently living in the North of Spain and I´m married and have two beautiful kids (Mikel & Ánne).
This channel will help you get better at Microsoft Excel very quickly and become more efficient in your office with our quick Excel for beginner & advanced tutorials on various features such as: Excel Formulas & Functions, Vlookup, Pivot Tables, Excel Macros, VBA Programming, Power Query, Power Pivot, Power BI, Charts, Excel Dashboards plus MUCH MORE!
As a gift to you, please download our Free 101 Ready Made Excel Templates: www.myexcelonline.com/107-73.html
Don't forget to subscribe to our RUclips channel so you can receive our new videos that we are always releasing.
Cheers,
John Michaloudis
Chief Inspirational Officer
www.myexcelonline.com
How to Find and Replace in Microsoft Excel
In this tutorial, we will show you how to use the find and replace dialog box in Microsoft Excel. First, we will show you an example when the replace method could be helpful and then we will show you how to do the replace. This is a great video for anyone wanting to know more about find and replace in Microsoft Excel.
Check out our Blog entry for How to Find and Replace in Microsoft Excel here:
www.myexcelonline.com/blog/how-to-find-and-replace-in-excel-5-easy-examples/
How to Find and Replace in Microsoft Excels Time Stamps⌚
00:00 - Introduction to How to Find and Replace in Microsoft Excel
00:15 - An Example of When to Use Find and Replace in Microsoft Excel
00:36 - Using the Find and Replace...
Check out our Blog entry for How to Find and Replace in Microsoft Excel here:
www.myexcelonline.com/blog/how-to-find-and-replace-in-excel-5-easy-examples/
How to Find and Replace in Microsoft Excels Time Stamps⌚
00:00 - Introduction to How to Find and Replace in Microsoft Excel
00:15 - An Example of When to Use Find and Replace in Microsoft Excel
00:36 - Using the Find and Replace...
Просмотров: 227
Видео
The Essential MAX IFS Formula in Excel
Просмотров 3179 часов назад
In this tutorial, we will show you how to use the MAXIFS formula in Microsoft Excel. We will go over what the S is for in the IF formula. Then, we will show you how to get a max value based on two sets of criteria in Excel. This is a great video for anyone wanting to understand the MAXIFS formula in Excel. Check out our Blog entry for The Essential MAX IFS Formula in Excel here: www.myexcelonli...
How to Use IF Statement & Drop Down Menu in Excel
Просмотров 30012 часов назад
In this tutorial, we will show you how to create a drop down based on an IF statement in Excel. First, we will show you how to create a drop down list that will allow you to first select the criteria for the second drop box. Then, we will show you how to make a second drop box to take the value of the first one and return different values in the list based on what has been selected in the first...
How to Undo Cancel of a Meeting in Outlook
Просмотров 12214 часов назад
In this tutorial, we will show you how to undo a cancelling of a meeting in Outlook. Have you ever deleted a meeting and then was unable to find it to restore it? Then this is a great video for you because we will show you how to undo the cancelling on a meeting in Microsoft Outlook. Check out our Blog entry for How to Undo Cancel of a Meeting in Outlook here: www.myexcelonline.com/blog/uncance...
How to Set Transparent Color for Pictures in Powerpoint
Просмотров 12316 часов назад
In this tutorial, we will show you how to set the background color of an image to transparent in Powerpoint. First, we will show you how to insert an image into Powerpoint and then we will show you how to make that background transparent for better visibility in Powerpoint. This is a great video for anyone needing to change the background color in an image in Powerpoint. Check out our Blog entr...
How to Convert Seconds to Minutes in Microsoft Excel
Просмотров 219День назад
In this tutorial, we will show you how to convert seconds to minutes in Microsoft Excel. First, we will go over the convert function that allows you to convert almost anything from one unit to another. This is a great video for anyone needing to convert seconds to minutes in Microsoft Excel. Check out our Blog entry for How to Convert Seconds to Minutes in Microsoft Excel here: www.myexcelonlin...
How to Generate a Venn Diagram in Excel
Просмотров 279День назад
In this tutorial, we will show you how to generate a Venn Diagram in Microsoft Excel. This is a very simple process. First, we will insert the Venn Diagram and then we will show you how to create labels and change the colors of the circles in the Venn Diagram. This is a great video for anyone needing to quickly generate a Venn Diagram. Check out our Blog entry for How to Generate a Venn Diagram...
How to Change Status in Microsoft Teams
Просмотров 198День назад
In this tutorial, we will show you how to change your status in Microsoft Teams. This is a great video for anyone wanting to let others know if they are available or not for a meeting or other functionality in Microsoft Teams. Check out our Blog entry for How to Change Status in Microsoft Teams here: www.myexcelonline.com/blog/microsoft-teams-status-active/ How to Change Status in Microsoft Tea...
How to Use VLookup in Microsoft Excel to Find Rows Easily
Просмотров 290День назад
In this tutorial, we will show you how to use VLOOKUP to find rows easily in Microsoft Excel. We will go over the Microsoft Excel VLOOKUP function and it's arguments. This is a great video for anyone needing to return a value in a dataset based on the value of another cell in Microsoft Excel. Check out our Blog entry for How to Use VLookup in Microsoft Excel to Find Rows Easily here: www.myexce...
Quick Microsoft Excel Tornado Graph Tutorial
Просмотров 27814 дней назад
In this tutorial, we will show you how create a Tornado Graph in Microsoft Excel. First, we will show you which graph to insert and then we will show you how to customize the data series and axes. This is a great video for anyone wanting to learn about a tornado graph in Microsoft Excel. Check out our Blog entry for Quick Microsoft Excel Tornado Graph Tutorial here: www.myexcelonline.com/blog/t...
Excel Date Shortcut: Add n Weeks to a Date Quickly
Просмотров 38614 дней назад
In this tutorial, we will show you how to add any number of weeks to a date in Microsoft Excel. This formula is flexible enough to account for any number of weeks. This is a great video for anyone needing to quickly add weeks to a date in Microsoft Excel. Check out our Blog entry for Excel Date Shortcut: Add n Weeks to a Date Quickly here: www.myexcelonline.com/blog/excel-add-weeks/ Excel Date ...
Highlighting Blank Cells in Microsoft Excel Using Conditional Formatting
Просмотров 20914 дней назад
Highlighting Blank Cells in Microsoft Excel Using Conditional Formatting
How to Mute to Improve Meeting Focus in Microsoft Teams
Просмотров 13414 дней назад
How to Mute to Improve Meeting Focus in Microsoft Teams
How to Use Autofit to Adjust Column Widths in Excel
Просмотров 26814 дней назад
How to Use Autofit to Adjust Column Widths in Excel
What is the Difference Between An Appointment and a Meeting in Microsoft Outlook?
Просмотров 19621 день назад
What is the Difference Between An Appointment and a Meeting in Microsoft Outlook?
🔥Get 30+ Microsoft Excel & Office courses for ONLY $1🔥
Просмотров 25521 день назад
🔥Get 30 Microsoft Excel & Office courses for ONLY $1🔥
How to Use Conditional Formatting for a Date 30 Days Earlier Than Today
Просмотров 26121 день назад
How to Use Conditional Formatting for a Date 30 Days Earlier Than Today
Best Fonts in Microsoft Word for 2024 Documents
Просмотров 29621 день назад
Best Fonts in Microsoft Word for 2024 Documents
How to Use the ISNA Function to Prevent an Error in Excel
Просмотров 25421 день назад
How to Use the ISNA Function to Prevent an Error in Excel
Calculate a Date 180 Days from Today in Microsoft Excel
Просмотров 31121 день назад
Calculate a Date 180 Days from Today in Microsoft Excel
How to Put a YouTube Video into PowerPoint
Просмотров 15728 дней назад
How to Put a RUclips Video into PowerPoint
How to Freeze a Column in Microsoft Excel
Просмотров 274Месяц назад
How to Freeze a Column in Microsoft Excel
How to Make a Microsoft Outlook Email Template
Просмотров 372Месяц назад
How to Make a Microsoft Outlook Email Template
How to Freeze Second Row in Excel Fast
Просмотров 383Месяц назад
How to Freeze Second Row in Excel Fast
How to Add Multiple Numbers in Microsoft Excel
Просмотров 251Месяц назад
How to Add Multiple Numbers in Microsoft Excel
How to Create a Background in Microsoft Teams Fast
Просмотров 212Месяц назад
How to Create a Background in Microsoft Teams Fast
How to Create a Locked (Freeze) Row in Microsoft Excel
Просмотров 262Месяц назад
How to Create a Locked (Freeze) Row in Microsoft Excel
How to Quickly Sort Data in Microsoft Excel
Просмотров 229Месяц назад
How to Quickly Sort Data in Microsoft Excel
Quick Microsoft Outlook Email Back Up: Save to Hard Drive in Minutes
Просмотров 343Месяц назад
Quick Microsoft Outlook Email Back Up: Save to Hard Drive in Minutes
How to Reference Another Sheet in Microsoft Excel
Просмотров 251Месяц назад
How to Reference Another Sheet in Microsoft Excel
Am I correct in my understanding that responders to a Microsoft Excel Forms survey are (or can be) anonymous?
Having issues when connecting my form to the gallery. When I try to edit the fields, the button is greyed out even though I've connected it to my data source. Any suggestions?
Teh first question I would have is do you have a Microsoft business account or a personal one? It may work better with a business one. If that doesn't help, please feel free to contact our consulting services here for additional help: www.myexcelonline.com/microsoft-excel-consulting-services/
Thank you for these videos. New sub
You are welcome!
Thank you for sharing! I believe it's quite useful to translate words into various languages within the same Excel file.
Yes it is! Thanks for watching!
amaizing! it looks so simple after watching this video
Oh, that's great! So glad you found it helpful!
After I've changed the active cell color, the color of all my colored columns is deactivated. Who do I keep my column color.
You could try using VBA to change the previous cell back to the original color before changing the new one.
@MyExcelOnline Greetings I don't know if you might be available for a brief call? about the possibility of scheduling a business discussion concerning your Udemy course aimed at enhancing its reach, boosting potential student enrollment and sales, and fostering positive reviews. @YAGI TEAM W.W
Using this in May 2024, so informative and clear! Thank you!
So glad it helped!
I believe your perspectives could greatly benefit my work. Any suggestions?🙂🙏
Sure. How can I help you?
Great video but the audio quality makes it very challenge to listen with headphones on
Yes. Sorry about that. We have since gotten a new mic, so hopefully you will keep watching our newer ones.
That was very helpfull
Glad it helped. Thanks for watching!
The plosives are very distracting
I'm sorry, I don't understand your comment.
For people who think she is talking faster, put your speed at 0.75
Thanks for the tip! And yes, we cut this one too short when editing, so it seems faster.
@@MyExcelOnline thanks
you're welcome!
Im Grade 4 and i need this to do thanks for you! :) wish me luck :D
Good luck! I am so glad you are learning at a young age! your future self will be glad you are good at Word!
:)
Looking forward to helping!
Your work is truly impressive! Could you share your thoughts on my work?🙂🙏
Thanks! So glad you like it! Yes, we can review work! Check out this link: www.myexcelonline.com/microsoft-excel-consulting-services/
thank you very much.... 😍😍😍😍😍 you saved me
You're welcome! Glad it helped!
You're welcome! So glad it helped!
You're welcome! Glad it helped!
Thank you....
You're welcome!
Your work is very impactful and commendable. Your praise boosts my morale.?🙂🙏
Wow, thanks for the comment! So glad you find the videos helpful.
Ctrl+E? Is for
Thanks for the question! CTRL+E does autofill.
Is this dynamic ?
What if the Data is changed.. will that still provide correct dashboard data?
If you have a formula, then yes, it should.
Is there a way to auto add columns or rows so as not to move them manually when querying?
You could most likely autoadd using VBA.
So useful ...thank you
You are welcome!
I need the cell to change with each new row though. When I use any of these ways it only goes by the cell listed in the formula (which would be A2 in your example) So instead of using A3 or A4 etc to choose whether the conditional formatting sticks it only uses A2 :(
Do you have a $ before the 2 in the conditional formatting? If so, take the $ out and see what happens. Hope that helps!
I'm subscriber from Philippines, this is amazingly awesome =)
So glad you like it and thanks so much for subscribing!
I want to list the number 1 8 times, then a blank cell, then the number 2 8 times and so on. I also want it to stop after listing the number 18 8 times. So let's say I copy the formula to Row 300, I don't want to see numbers greater than 18. Could you help me with a formula/function, please?
I think for this, you may need to use VBA and do a loop that will loop. So you could set a counter for 1-18 and then loop 18 times. So something like this: Dim intCounter As Integer Dim intRepeat As Integer Dim rngCurrentCell As Range Set rngCurrentCell = Range("A1") intCounter = 1 Do Until intCounter = 19 intRepeat = 1 Do Until intRepeat = 9 rngCurrentCell = intCounter intRepeat = intRepeat + 1 Set rngCurrentCell = rngCurrentCell.Offset(1, 0) Loop intCounter = intCounter + 1 Loop
This is the information i want to lean on how to creat an email and it's signature for the beginners. But unfortunately she forgot that she is teaching the beginners. She's just so fast, and the video is no longer saving its purpose for the leaners.
So sorry. A few of our videos were cut too short in some of the edits. For these few, we recommend using the slower playback speed on RUclips. We tried to have better editing for most other videos.
Thank you for saving me having to recreate a complicated spreadsheet!!
Glad it was helpful! Thanks for watching!
Very usfull ❤
Glad it was helpful!
well explained, thank you.
You're welcome. Glad you liked it!
Access is no longer listed on the Office 365 Business page. The only way I could find to get it was to buy the standalone version for ~$160
I didn't see it on their site, either! Thanks for the info!
@@MyExcelOnline I was able to find it. I tried posting the link but it wouldn't work
I found it listed under the drop down header "Installable desktop apps" in the table breaking down each business plan.
Oh, great! Thanks for letting us know!
How to do it on entire sheet at once
You could write a macro to do that.
@@MyExcelOnline any tutorial ?
Sorry, we do not have a tutorial on this yet, but we can add it to the list.
Hi, thanks for your video. The issue with this formula is if the “0” is the result of a formula, it does not work. How can we use it if my Os values are the result of a formula?
Hi. I am not sure why you aren't getting the count. I just tested it with a formula cell. Here is what I used: =COUNTIFS(B2:B21,">=0"). The video is got >0 not >=0, so I modified that here. Hope that helps!
YOU ARE A BLESSING. I had the same doc and everything wondering why it worked for others and not me. Thank you! God bless you!!!
You are so welcome! Thank you for watching and for letting us know!
Awesome my love you're a star
So glad you liked it! Thanks so much for watching!
Did he say anything about having to go to his website share your details (subscribe), and then receive a link that takes you to Microsoft OneDrive if you have it well, if you don't .... that is that.
Hello , first thanks for your great explanation your are aa great teacher , second i have a question, i set up a lookup field and a calculated field and the calculated field should join the value of the look up field and another field together but since I'm storing the value of the ID in lookup field i found the calculated field joins the ID number instead of the text , how to solve this problem with keeping the option of whenever i change the values in the tables used as a reference for the lookup field it changes the values in the lookup field itself Thanks in advance 😊
Thanks for the compliment! One suggestion I have as long as the correct ID is being returned would be to make a query from the table and join what you are wanting on the calculated field and use the query as your recordset instead of the table. Let me know if that works!
Good work Sir! To access your videos by download, is there a monthly subscription attached to it?
Hi and thank you! This full course is completely free.
This was very helpful, Thank you!
Glad it was helpful! Thanks for watching!
Excellent video, straight to the point.
Thanks! So glad you liked it!
followed exactly what you did and it returns "#n/a"
Is the value you are looking for missing in your source data?
I already have a MSFT 365 account but when I try to sign up it still asks me to create a new account...none of what you directed worked. I was forced to create a new account and then when I tried to sign in it gave me a "denied" error message. Even after I sign it keeps trying to force me to create an account. Also, it nevers asks me for a CC to do the 1 month trial. Also, per the MSFT support rep you MUST have a BUSINESS account to get project...
Yes, you would need a business account.
Thank u so much informative and i learn so much.
So glad you were able to learn a lot! Thanks for watching!
good job team
Thank you!
Is there a way to make a font the default for all your documents? Not having to change them each time?
Yes. That would be under the normal template. Here is Microsoft's link on how to change it: support.microsoft.com/en-us/office/change-the-normal-template-normal-dotm-06de294b-d216-47f6-ab77-ccb5166f98ea
you made it easy😢!!
So glad you found it helpful!
Please give me your data i want to perform same task
thank you
You're welcome. Thanks for watching!
Thank you❤
No problem!
Can you make a drop-down list of 3 colors to choose one color? I want to color every cell with either green, orange or red. The cells have different text in them. Thank you
Yes you could! You would need to create a Case statement in VBA and set a variable to the chosen color.
@@MyExcelOnline can you please create a video on that. Thank you
I'll add it to the list.
I followed the VBA for adding sheets inside of sheets and kept getting a bug error.
Hi. Thanks for watching! I would recommend downloading the sample workbook and comparing it to what you have written, as VBA needs to be exact. Or you can go back over the video and double check every line to see that it matches yours. The link to download it is in the description. Hope that helps!