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 RU-vid channel so you can receive our new videos that we are always releasing.
Cheers,
John Michaloudis Chief Inspirational Officer www.myexcelonline.com
Sometimes. There are some functions that are PC only. If you are deciding between two, I'd do a PC right away. If you already have a mac, I'd recommend trying to do what you can and then if you get stuck, think about getting a PC.
Sometimes. There are some functions that are PC only. If you are deciding between two, I'd do a PC right away. If you already have a mac, I'd recommend trying to do what you can and then if you get stuck, think about getting a PC.
Sure. It's hard to share your file here for us to troubleshoot, but if you visit www.myexcelonline.com/microsoft-excel-consulting-services/ we can help with more specific issues.
Holy smokes where have you been all my life. So many excel YT channels do run of the mill stuff you can find on google or Excel forums. Or the way they teach/show it is just confusing. Question, how can i get this to work when using conditioner formatting to. To elaborate: I use conditional formatting to change the background of a cell based on the value (date) entered in the cell, or a different cell in that row. So 23jun24 is entered in A1 and turns white, which enters 23feb25 in B1 with the rule that B1 turns red when todays date is after 23feb25. I want B3 to check if B2 is red, and change its color if true. Ive been doing trial and error with your 1st method and i can't get it to do that. I initially tried the VBA method (which i just found out is a thing today) and promptly killed several brain cells. Any advice would be very much appreciated
Great question! It'd be too much for me to answer here, but please feel free to contact our consulting services to help! www.myexcelonline.com/microsoft-excel-consulting-services/
Can I download the offline version of Visio Plan 2 for desktop if my subscription is for Office 365 Business Premium? I thought it only came with the online version of Visio? I just don't want to wake up to a huge charge on my credit card
I would like to do this but not for today's date I have dates throughout the year and need to highlight anything that took more then 30 days to close 😅
I believe only 2 columns can be compared at a time. So for your request, I would recommend comparing column by column. So column 1 with list a and column 1 with list b and then column 2 with list a and column 2 with list b, etc.
I need to remove non-breaking spaces only. And I don't have a blank column to use for a function (I don't want to add one in the middle of my data). How can I find these things?
Shouldn't there be a New button with NewForm(VideoDetails) in OnSelect to clean everything from the form and EditForm(VideoDetail) in OnSelect property of VideoGallery to bring the form back to edit mode after selecting a row in the gallery? And I guess the SubmitForm function would also work on a new record, provided the form is in the new mode.
So sorry to hear that. Sometimes it is a settings issue specifically with your account or maybe a setting within the app. We can help troubleshoot if you would like to contact our consulting services at www.myexcelonline.com/microsoft-excel-consulting-services/
It's really helpful, i have 2 more columns for Date and time. Could you tell me how do I edit that formula for add button. When I do ,date:date.text, there comes an error
Thanks for the question! Without seeing your project, it'd be hard to troubleshoot, but good news: we have consulting services to help with specific issues like this. Please visit www.myexcelonline.com/microsoft-excel-consulting-services/