Тёмный
MyOnlineTrainingHub
MyOnlineTrainingHub
MyOnlineTrainingHub
Подписаться
Teaching you Excel and Power BI skills that will get you noticed and promoted. For more, check out my courses here: www.myonlinetraininghub.com/courses
How to Add & Use Checkboxes in Excel in 2024
10:55
6 месяцев назад
Pros Use This Technique to Avoid PivotTables
6:38
6 месяцев назад
Комментарии
@ignaciojerome
@ignaciojerome 20 часов назад
This is what I need to know. Thank you for this video and will surely learn excel.❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub 18 часов назад
Glad it was helpful!
@vernfb5189
@vernfb5189 21 час назад
What I like about this video is you didn't use clickbait like " Make $500 a day". This is about as straightforward as it gets.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 18 часов назад
Thank you!
@Cristype1diabetic
@Cristype1diabetic 21 час назад
Hey Mynda, is this opportunities is to work from anywhere, I mean, I live in Brazil and have a laptop and internet. Is it possible work from here?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 18 часов назад
Absolutely, yes!
@geekatari4391
@geekatari4391 23 часа назад
I consider myself a pro, but I haven't really gone into VBA much, so maybe it's time to step up my game.
@AlThePal78
@AlThePal78 День назад
I am not going to lie, I don't ever seem to see these jobs because I use to be pretty decent with excel
@DB-Au
@DB-Au День назад
Better than Chat GPt and gemini, Queenslander!
@user-fg7xn7pn9e
@user-fg7xn7pn9e День назад
Straight, to the point delivery. I just bought your power Pivot and DAX course, so excited to learn from the best!
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Awesome to hear! I'm excited to get you up and running with these amazing tools. 👏
@viksabharwal2811
@viksabharwal2811 День назад
Your mode of instruction is so easy to understand . Thanks, Mynda. Can we, please, get the sample Excel file to practice like the other videos.
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Thank you. As usual, the file link is in the video description. 😉
@viksabharwal2811
@viksabharwal2811 День назад
Excellent, concise, simple, easy-to-understand narrative. Mynda, while replicating the exercise, when I expand the entire YEAR field I only get "QTR 1" and not the other 3 qtrs for the years. I do, however, change the table format to NONTABLE format and then change it back to table format before adding and cleaning it in Power query. Why?
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Thank you! Sounds like a locale issue with the dates. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QKgS3hrrmvw.html
@tiger131071
@tiger131071 День назад
I've been freelancing as a spreadsheet consultant (google sheets and excel) for the last 3 years and I love it! Independence, freedom and can stay away from the politics within a company 😃 I'm in the UK and once clients work with me they tend to come back for further work once they know I am reliable and provide excellent value for money. I have a background in financial insurance and so apart from my spreadsheets skills I can draw upon various other skills and experience from that which helps a lot. All in all, I really enjoy it.
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Awesome to hear about your success as a freelancer. Congratulations.
@demolayakp
@demolayakp День назад
confused as to why 1- discount? why not just multiply directly with discount?
@demolayakp
@demolayakp День назад
ah never mind got it. in this case 1 represents 100% . gotcha!
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Glad you figured it out 👍
@user-lf6yc6tq1f
@user-lf6yc6tq1f День назад
Thank you so much
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
You're most welcome 😊
@mathijs9365
@mathijs9365 День назад
Company hire some one from India who are far more cheaper
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Yep, that’s going to happen but there will always be companies who value local talent and need people to help in person.
@khurramsaeed3985
@khurramsaeed3985 День назад
Hey I m trying to use sequence formula but doesn't work could you please assist me in alternative formula. I'm trying to build my dashboard. I will be highly appreciated ❤
@joppy125
@joppy125 День назад
=ROW(Current Cel/Cel range) - #blankrows above it.
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
The alternate formula is in the video description for the dashboard you're trying to build. If you're still stuck, you're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@bobert8618
@bobert8618 День назад
OK, I love her accent....
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Thank you 😊
@kdunlap3289
@kdunlap3289 День назад
Indeed is full of scammers. My daughter had terrible results, eventually resulting in her bank account being closed and her name tagged by the bank, so that she may never bank there again.
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Sorry to hear that. I find it surprising given that it's a job site for employers to post job openings. I'm not sure how you would get scammed.
@lipsapatro7105
@lipsapatro7105 День назад
Hello, I can't find more options to add the Expense & Donught pivot table in the Report connection. What else can I do?
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Not sure what you mean exactly. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Not sure what you mean, sorry. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@Abdullah__Meshal
@Abdullah__Meshal День назад
you depend us every time. Thank alot. I used my knowledge of excel in daily work in my job. This makes me very strong to deal with data especially if you deal with big data and from different sources. These works develop me and help me to know different problems of data at least in the same work in other parties. I take advantage this point to start search in special works after my official job. Good and big chances for deep learn in excel skills. Power query, power pivot, pivot table,conditional formatting, advanced formulas and at least little vba will support in smarts works. Thank you master teacher.
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Glad it was helpful. Keep working hard. I wish you every success.
@joshuamanampiu6489
@joshuamanampiu6489 День назад
Thank you so much!
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
You're welcome!
@therencevaldez2841
@therencevaldez2841 День назад
Hi this maybe slightly out of topic, but why is getpivotdata with text and amount, the $ and comma disappears in Chart Title. Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Not sure what you mean. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@mykola_kanyuk
@mykola_kanyuk День назад
Also Excel is importand in conjunction with most CRM system for importing and exporting data, including data in CSV format
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Yes, good point 🙏
@ramruttunaubeeluck9235
@ramruttunaubeeluck9235 День назад
Thank you very much
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
You are welcome 😊
@AZGATOR2002
@AZGATOR2002 День назад
Wow, what a great video. I never really considered freelance, I will now. Thank you for this.
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Glad it was helpful!
@heinzthedutch
@heinzthedutch День назад
Upsides are the money, definitely. Downsides are delays in data-supply and debates with IT-departments which often cause me almost never being able to work full-time on 1 project. Over the past years I therefore moved to building one-off Excel/VBA tools as well as maintaining reports I built for other customers in the past, at the same time. Great video, greetings from the NL.
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Thank you! I hear you regarding debates with IT departments. I did that in a prior life too 🤦‍♀️
@ReimaginedbySteve
@ReimaginedbySteve День назад
I definitely want to pivot (table 🤦‍♂) away from IT to Business Intelligence. I don't like the way IT is going with everything going off-prem into the cloud. There's no challenge in it anymore for me.
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Interesting. I'm sure you're well positioned to 'pivot' to BI.
@ReimaginedbySteve
@ReimaginedbySteve День назад
Actually, who am I kidding. I'll be replaced by AI whichever direction I go so maybe OnlyFans is the answer! 😬🙈
@silversolver7809
@silversolver7809 День назад
@@ReimaginedbySteve No you won't be replaced, that will happen to tasks, not people. Just like what Lotus & Excel did 30-40 years ago-automated some tasks but created more tasks for humans to use the new info which was previously too costly or difficult to obtain.
@brianxyz
@brianxyz 22 часа назад
@@ReimaginedbySteve 🤣
@vardaankaushal8560
@vardaankaushal8560 День назад
Thanks a lot for the video, it has motivated me to get started with my career for excel jobs. Can you make video regarding projects that can reflect skills to client
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Great to hear! Good idea for a topic 🙏 I'll add it to the list.
@chrism9037
@chrism9037 День назад
Great video Mynda. I've used channels like yours to teach myself advanced skills (PQ, Power BI, DAX, etc) and parlaid that into consulting work after I retired from my Fortune 50 company. A lot of companies, especially smaller companies, don't know what they don't know; this is a big opportunity for people with advanced Excel and related skills.
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
That's awesome to hear, Chris! You're absolutely right that many small businesses don't know what they don't know. It's so rewarding helping them work more efficiently with tools they already have.
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
❓ Do you use Excel to boost your income? Share your experience in the comments! Learn Excel with my courses: bit.ly/makemoney24courses
@khurramsaeed3985
@khurramsaeed3985 День назад
Hey, I m trying to put the sequence formula but unfortunately doesn't working in my excel sheet which in 365. Could you please assist me in this matter I will be highly appreciated ❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
If you have 365, then you have SEQUENCE. You can type =SEQ in a cell and it should appear in the list of functions available. If not, then you haven't got 365 and you should use the alternate formula in the video description. If you're still stuck, you can post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@xiigoraya
@xiigoraya День назад
I find it really hard to put a tree map on spreadsheet. Does anybody have the tutorial for spreadsheet?
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Not sure what you mean by 'spreadsheet'. If you mean Google Sheets, then it doesn't have treemap charts.
@arantxatzeitel
@arantxatzeitel День назад
I just found your Chanel as I have a project that I have to tackle down. I was forced to become a data analyst, even if I was originally a Japanese translator. Thank you so much. You’re saving me❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Wonderful to hear! All the best in your new career 🍀
@SteveSwanson999
@SteveSwanson999 2 дня назад
I have long been a user of the Windows Key Paste you discussed. THANK YOU SO MUCH about displaying the clipboard and frequently used special characters! It's a big plus on an already powerful tool
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
So pleased you can make use of it.
@ReimaginedbySteve
@ReimaginedbySteve 2 дня назад
Thanks Mynda. All of it was really helpful.🤩
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
You are most welcome! 😊🙏
@Khaled_Samir
@Khaled_Samir 2 дня назад
If i have data for many years and i wanna display date range from the current year Vs same range in previous year , for example from 1st to 3rd of june 2024 comparing with 1st to 3rd of june 2023 ?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
You can do that with Power Pivot's DAX time intelligence measure: SAMEPERIODLASTYEAR If you'd like to learn Power Pivot and DAX, please consider my course: www.myonlinetraininghub.com/power-pivot-course
@user-in5ur2nf6z
@user-in5ur2nf6z 2 дня назад
Infact madom i dont have about this knowledge it useful about excel those function how to usei dont knowand that function expand our writing systum an accrose instantly what we in analyze excel its fast way some functions am not lessoning men still am using 365 excel version and i expecting about back again basic function to advance your some vedieo and in oder you sooo explainable and so adorable thanks regarding this show vedieo
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
Glad it was helpful 🙏😊
@jamesbennett5421
@jamesbennett5421 2 дня назад
My favorite Paste Special? when you have numbers but somehow they are represented as Text. Copy 1, then Paste Special Multiply. Poof, all of your numbers that were Text are now Numbers.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
Yes, another great use 👍 thanks for sharing.
@sixtiethofasecond
@sixtiethofasecond 2 дня назад
EOM & Sequence - where have you been the last 20+ years??? Off beam question - IFS, do you know if this would be available within Filemaker?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
Not sure, sorry. I’m not familiar with Filemaker.
@MidtownMadness1
@MidtownMadness1 2 дня назад
Half-way in, great so far! Thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
Awesome to hear 😁🙏
@raihansafa5514
@raihansafa5514 2 дня назад
Thank you so much, really helpful
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
Glad it helped! 😊🙏
@jraj2380
@jraj2380 2 дня назад
Thanks a lot. It fulfilled my purpose. :🙂👍
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
Glad to hear that 😊🙏
@tejashri3155
@tejashri3155 2 дня назад
Hi I have a query on handling dynamic combining sharepoint excel files. So I have many files in a folder which gets refreshed on a month basis--File name and file count changes every month based on the data fetched from source. How can I define to always fetch all the files in the folder irrespective of file count or names? Kindly advice
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
If you don't apply any filters on the folder contents it will always get all files in the folder.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
If you don't apply any filters on the folder, it will always get all files.
@tejashri3155
@tejashri3155 2 дня назад
@@MyOnlineTrainingHub Ahh thats great the, I didnt expect such a quick response, thanks much :)
@tejashri3155
@tejashri3155 День назад
@@MyOnlineTrainingHub Hi, I have tried combining my files and ended up in an issue. All my excels not necessarily have the same sheets, Im trying to combine a sheet which is present in file 2, not in file 1. I have managed to edit my parameter and sample file query to refer to file 2 and now all good in transform sample file query. it now refers to my file 2 which contains the required step. However merge query failed in expand table step as the table column in file 1 is shown as error (due to missing sheet), while all other rows have tables.Can you please advice how to we handle this missing sheets while combining excels and merging them together..Please note that I have already fixed the sample file and everything is file except the Expanded table step.
@nour-eddineoumakhlouf5296
@nour-eddineoumakhlouf5296 2 дня назад
Endless learning ! Thank you so much for all your efforts
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
Happy to hear that!
@TheNeilsolaris
@TheNeilsolaris 2 дня назад
With the very hidden worksheet property, you can also password protect it, so nobody else can access the objects in the developer section without entering a password. That's what I do with one of my files.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
Nice.
@TheNeilsolaris
@TheNeilsolaris 2 дня назад
@@MyOnlineTrainingHub In case anyone is wondering how, in the developer tab, click on tools, then select VBA Project Properties, then Protection, and enter your password.
@mostafahwafy
@mostafahwafy 2 дня назад
i have an issue.. i tried to update PQ in excel but data preview in preview tab options shows only { Monospaced & Show Whitespace }? why is this? i hope to tell me how show other options it's important to show them plz...
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
You can turn off the monospaced etc. via the View at in the Power Query editor.
@mostafahwafy
@mostafahwafy 2 дня назад
@@MyOnlineTrainingHub it's already turned off from the view tab and from power query options and there is two options only in the view tab how can I get quality coulmn option? Is there a solution?
@itorres008
@itorres008 2 дня назад
Also 3 years late. ☺ Good tutorial on the subject, but also on many Excel features in general. Question: I have always thought of Budgets as "What you believe you'll spend" vs the Actual, yet you have "Plan" and "Forecast" figures which to me would be synonymous and could be used as "What you believe you'll spend". Perhaps you're using Forecast as a beginning of year budget and Plan as some budget amounts approved during the year, but what are Forecast and Plan in your schema? Thanks.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 дня назад
Glad you enjoyed it! Plan is the same as Budget. Forecast is what you now expect once some Actuals start coming in and can be updated each month.