High-Income Excel Skills Worth Learning in 2024 (Free File)

[@MyOnlineTrainingHub]

Get all 3 courses in a discounted bundle from the Dashboard course page: 👩‍🏫 Power Query course: bit.ly/powerquery240319 👩‍🏫 Power Pivot & DAX course: bit.ly/powerpivot240319 👩‍🏫 Excel Dashboards course: bit.ly/dashboards240319

[@shakiraasfoor7599]

i think they became expired with the rise of power bi

[@mohamedmehana4321]

@@shakiraasfoor7599 Power Bi is built upon those courses...if you understood Power Query & Dax then you can master Power BI

[@jatigre1]

For anyone watching these lectures, and if you've had actual classes, you know you can't blink. So please take your time to create those pathways in your mind. Thanks for the knowledge!

[@MyOnlineTrainingHub]

😁glad you enjoyed it!

[@melbruning]

​@MyOnlineTrainingHub thank you!! You're an exceptional instructor... so glad I found you. :)

[@999_pan]

Been using PQ for a couple years now and the most amazing piece was loading/cleaning and anonymising an xml source file into excel worksheet for generic viewing which took a previous incumbent 2~3 hours to complete... the PQ refresh brought it down to 7 seconds.. Absolute hero for a day😇

[@MyOnlineTrainingHub]

Woo hoo, Alan! Congratulations on that result. Power Query really is THAT amazing. I just wish more people knew.

[@notesfromleisa-land]

Learning PQ was the best thing to support my work. It gooses all results to save time and frustration. I always recommend people invest in a class. Most benefit from a structured learning approach to build confidence and efficiency.

[@ItsjustmeAR]

I did the same with PQ. Took a 3 - 5 hour process down to 30 minutes. Unfortunately those that came behind me try hard to break the PQ that I built. They like to add filters to the feeder data and it makes the PQ big mad!!

[@notesfromleisa-land]

@@ItsjustmeAR Perhaps you can educate downstream users to make their own PQ as a reference to the one that you created that did the heavy lifting, so they can then apply their needful filtering (if that is practicable) on the data that has been expertly conditioned by you.

[@mirwansiregar]

You are a valuable guru for Excel Learners. Wish you get a high paid from KZbin for your precious contents...Thanks Mynda

[@MyOnlineTrainingHub]

Thanks for your support!

[@jamiereife5581]

I discovered PQ two years ago. Thank God I did. I am controller over 73 companies. I must create a combined financial statement for all of the companies. With PQ combining the data take just a few minutes. As you can imagine, it used to take a VERY long time.

[@MyOnlineTrainingHub]

Wow, 73 companies! That's impressive and no doubt impossible to do on your own without Power Query.

[@jamiereife5581]

@@MyOnlineTrainingHub no, it’s possible. I have done it but it takes a very long time and the patience of Job 😂

[@GlobalAINewsInsights878]

@@MyOnlineTrainingHub Your Channel Just Found Me and I am SO GLAD it did!!! I love Excel.

[@markfrank0924]

Wow, I have only a basic level of knowledge in Excel, but man, am I impressed. I had no idea so much could be done. I understood much of this lesson even though I could not complete the project alone. I want to learn more and become proficient in Excel. A basic class will suffice for the time being. I am very impressed with you, and now that I understand Excel, I am even more impressed with what can be done.

[@MyOnlineTrainingHub]

Glad it was helpful! You can get up to speed quickly with my courses here: www.myonlinetraininghub.com/courses

[@lilokwan]

thank you for this! my goal for this year is to learn PQ & BI and basically just level up on my excel skills to save more time in terms of work. You are one of my favorite guru so far, thank you! :)

[@MyOnlineTrainingHub]

Wonderful to hear! Keep in mind that to use Power BI you also need Power Pivot skills. Good luck with it. Power BI is an amazing tool. Check out this video to get started: kzbin.info/www/bejne/nYDWaHh5YquYmKc

[@notesfromleisa-land]

Consider taking a course. It is a small dollar investment that will give you a structured learning approach to gain confidence and efficiencies.

[@s3cr3tpassword]

I only care about increasing my efficiency not the company’s. Been saving so much time and giving myself back so much freedom.

[@MyOnlineTrainingHub]

Great to hear you’re reclaiming your time.

[@kylelane630]

Love this! I've just done step one, into preparing for this phase. I have taken a monthly scorecard that was complied all manually, and took 5 days! I have now built an interactive dashboard, that just needs the data adding into the background data table worksheet, which is still currently done manually. Whilst this part only takes 15 minutes to type in, it is at risk of error, and would need a peer review to verify accuracy (additional time wasted there). So, phase 2 will be to export a CSV from there database (Ideagen), and then set up a Power Query (or, potentially export direct from the Ideagen database.

[@MyOnlineTrainingHub]

Great result! Congratulations on your success with these tools. I'm sure you're the hero of the office 😇

[@courtneysavage7845]

I understood like 97% of this. I can't believe I found something I can learn and Im so fascinated by this. Like I be wanting to learn it so hard cause I never had a passion for a thing. It's achievable

[@MyOnlineTrainingHub]

That's great to hear! If you want to get up to speed quickly, please consider my courses: 👩‍🏫 Power Query course: bit.ly/powerquery240319 👩‍🏫 Power Pivot & DAX course: bit.ly/powerpivot240319 👩‍🏫 Excel Dashboards course: bit.ly/dashboards240319 💡Tip: Get all 3 courses in a discounted bundle from the Dashboard course page.

[@Hortster]

Nice tutorial, the only additional step I would do is to also name your Charts to make them easier to identify.

[@MyOnlineTrainingHub]

Cheers! Naming objects is a great idea 👍

[@pjdub22]

What a great demo! Thank you so much. One thing that tripped me up for a bit was the necessitty to copy the dimension tables from your demo file into my own workbook when recreating the data model and dashboard. Going to check out your courses.

[@MyOnlineTrainingHub]

Thank you! Great to hear you gave it a go yourself. I look forward to teaching you more in my comprehensive courses.

[@techwg]

I love learning new Excel stuff and you are a good teacher. But there are a lot of business out there who aren't super ultra large corporations who would see you being able to get stuff done quicker and move to curtail your working hours because the company is spending too much money on you for the amount of things you get done. Could backfire. Still, I would rather learn so I can make decisions on my own as to how I do things, when and why etc.

[@MyOnlineTrainingHub]

I don't doubt this, but with these skills you're better positioned to find a company that values you than one who is only focused on their bottom line.

[@BoraHorzaGobuchul]

Thank you. There's always a risk of automating yourself out of your job :) You did touch on this topic but what you said is dependent on your boss thinking forward, which not all of them do.

[@MyOnlineTrainingHub]

Absolutely! Of course, with more skills comes more options for getting a new job with a boss who is forward thinking.

[@irisk.fragoso4638]

You are awesome!! I love Excel, and your videos are exactly what I need. You speak clearly, explain the features, provide simple and examples at a steady pace. I have watched several videos and eventually stop them b/c the trainer's voice is not clear and/or boring. THANK YOU! THANK YOU! and yes, I have subscribed :) have a great day, -i

[@MyOnlineTrainingHub]

Aw, thanks so much for your kind words! It's sincerely appreciated 😊

[@WaqasAhmad-fg8yq]

Love you & this series, Could you please make a detailed video on POWER QUERY & POWER PIVOTS, I know there are alot of resources out here but you are the best, Support & Love!!

[@MyOnlineTrainingHub]

Great to hear! If you want to get your Power Query and Power Pivot skills up to speed quickly, I recommend you take my courses (links below) because if you rely on KZbin, you are bound to miss important details: www.myonlinetraininghub.com/excel-power-query-course www.myonlinetraininghub.com/power-pivot-course

[@IRFANKHANSIRGUROAH-h3k]

i am big fan of your and always follow you video, I have great respect for you and learn many things from you - you are amazing and darling, the way you teach is really superb

[@MyOnlineTrainingHub]

Thank you so much 😀

[@jihadalbustanji3760]

Pinnacle of professionalism and innovation

[@MyOnlineTrainingHub]

Thanks for watching 🙏😊

[@roywilson9580]

Thanks for the interesting video. I understand why your didn't go into using the M language to streamline your power pivot queries and spend time on producing all of the metrics used with DAX as this is a video meant to be an introduction to the basic ideas. A couple of things I think should have been included in the video is the production of a date table to enhance the performance of DateTime functions, the datamodel can even produce a basic date table automatically, I would have also liked to see fields in the main table that should be chosen from the DIM table hidden from the client as these things are pretty basic requirements for efficient use of larger datasets.

[@MyOnlineTrainingHub]

Thanks for watching and your tips, Roy! There's absolutely more to learn with these tools which I cover in detail in my courses.

[@GEXDataFinance]

Excelent! Excel is a useful tool nowadays. in fact, it is a must to skill up in this era!

[@gbadamosirilwan8628]

Whoa!! This has increased my efficiency greatly has I can now do efficiently what too my days within 10 to 20 minutes. Thanks a lot, God blessed you. What I have another question. What about if I have multiple excel worksheet and workbook, how can I combine it into one for analysis, please can you do a tutorial about that also. Thank a lot. Waiting for your response ma.

[@MyOnlineTrainingHub]

Awesome to hear! This video covers importing data from multiple worksheets: kzbin.info/www/bejne/qX26ZIGYmqx3r5o

[@gbadamosirilwan8628]

Whoa!! Thanks a lot for this. God bless you.

[@mikee.5158]

It’s a stretch to say cutting time has a direct 1:1 impact on company expenses. I agree that the one thing that people whose job is Excel heavy can do to be a rock star is focus on efficiency - not only their own but also the user of anything they produce.

[@notesfromleisa-land]

It's not a stretch at all. As a consultant, I see many inefficient ways of grabbing, presenting and uploading data into accounting systems. I have developed several models that reduced time exponentially. Saved money through reduced staff time and improved accuracy.

[@MyOnlineTrainingHub]

As a cost management accountant in a previous life, it's not a stretch at all. Everything you do has a knock-on effect. With your free time you can now work on tasks/projects that haven't been tackled because you don't have the budget for extra staff. Or you can take on tasks others were doing, enabling you to save headcount. Or you can work on other tasks that generate income.

[@emmanuelle8032]

How cool is that ... watching my own comment on your video ! 😃 I can definitely attest to the time savings of using all the features that Excel can provide. But to do this, people have to watch your channel, keep on learning and practicing! 😜 Thanks again for the superb work you're sharing.

[@MyOnlineTrainingHub]

😂 too funny! Appreciate your support 🥰

[@aprashant1048]

Thanks for the video. In the state list (8:43 into the video), was wondering the need to have Oklahoma 3 times - C011, C013, and C015.

[@MyOnlineTrainingHub]

C011, C013 and C015 are different customers that all happen to live in Oklahoma. This table is used to lookup the customer number and then return the state they live in, so yes it needs to be there multiple times.

[@Anthony50009]

Really valuable content. Glad I watched a second time to work through the example using the sample data to really get familiar with how slick a solution this is. Thank you!

[@MyOnlineTrainingHub]

Great to hear you gave it a go!

[@HandelMcHandel]

Wow Mynda that was IMPRESIVE! Love your videos

[@MyOnlineTrainingHub]

Thanks so much!!

[@dougmphilly]

my PQ analysis is now achieving 90+% success rate getting discounts for early payments where before, they may get 10%. they all think its magic. :)

[@MyOnlineTrainingHub]

Wow! Awesome to hear, Doug 👏

[@dougmphilly]

@@MyOnlineTrainingHub i just can't believe how many people in finance don't want to learn anything since the forward slash command from lotus 1-2-3. AI will make them redundant quick so they better get on the stick.

[@MyOnlineTrainingHub]

LOL, I remember the old forward slash commands from Lotus 1-2-3 😁

[@estebanpablohernandez5298]

I used to with Excel until 2016. I was of the 1% top. ... I haven't use PQ, we used to do everything with VBA.

[@MyOnlineTrainingHub]

Yeah, VBA used to be the go to tool for automation, but now it's easier to use Power Query to automate gathering and cleaning of data.

[@CharlesDeBarros]

As always, you are SENSATIONAL! Thank you!

[@MyOnlineTrainingHub]

Thanks so much, Charles!

[@GeertDelmulle]

This video was not fast paced at all. Thanks Mynda. BTW: thanks for the map chart trick - I didn’t know that one. Good stuff, not difficult at all. Thumbs up! :-)

[@MyOnlineTrainingHub]

Great to hear, Geert! Have fun with the map charts 😊

[@ssj4naka]

I know how to do everything in this video. What positions/roles should I be searching for on LinkedIn, Indeed, or Upwork? Have had no luck looking for analyst positions on Indeed and LinkedIn for months now...

[@MyOnlineTrainingHub]

The key with these platforms is to build up a profile and ratings so that you have some credibility. As a result, I would apply for anything you think you can do, and price yourself very competitively to land the job. Once you have some ratings and a high ranking profile, then you can start to increase your prices and be more picky about the type of work you do.

[@daviddiazsanchez7292]

Great Content! But there is a mistake in the calculation shown in the Days to Ship column, when you used Power Query. The difference between 01/01/2021 and 03/01/2021 is 59 days. Not 2 days

[@MyOnlineTrainingHub]

My dates are dd/mm/yyyy 😉

[@nour-eddineoumakhlouf5296]

I also like your animations. You are not far from 1 M subscribers . Good luck

[@MyOnlineTrainingHub]

Thank you so much 😀

[@michaelkoster8412]

This was a very nice overview! Thank you.

[@MyOnlineTrainingHub]

Glad you enjoyed it! Thanks for watching 😊

[@Kiaoranz]

I am at the beginner level of using Excel. One day I would like to use Excel in advanced level.

[@MyOnlineTrainingHub]

Great to hear! I hope you find my videos helpful. If you want to get up to speed quickly, please consider my courses: www.myonlinetraininghub.com/courses

[@yourmaineguy1bangor28]

Thank you Mynda - I found your content a few years ago and everything I have seen is top notch. I've just scratched the surface with power query, experimenting with some public data sets. Where I get stuck is inconsistencies with how source data was entered, for example information that should be multiple columns becomes grouped into a single without rhyme or reason. This makes splitting columns ineffective. Is this a topic addressed in your course?

[@MyOnlineTrainingHub]

Great to hear you've found my videos helpful! I cover splitting columns in my Power Query course, yes. And if your specific scenario isn't covered, we provide support to our students so you can reach out and get help.

[@chahineatallah2636]

Great video , many people underestimate the power of excel

[@MyOnlineTrainingHub]

Very true! Thanks for watching 🥰

[@mogarrett3045]

Mynda your tutorials are awesome magical to me....thank you so much Mo

[@MyOnlineTrainingHub]

Thanks so much, Mo 🥰

[@francishubertovasquez2139]

You simply relieved my overwhelming rage to those irrelevant irritants around me, you're like a treatment of some sort of a pacifier type. Thanks ma'am. And you're a look alike of someone I remember. Just mentioning that.

[@MyOnlineTrainingHub]

Glad you enjoyed my video.

[@reversley]

This was such a useful and well explained video, so easy to understand 🙏

[@MyOnlineTrainingHub]

Glad you think so! 🙏

[@adhamdodzy2855]

Really impressive ,thanks for sharing the file data

[@MyOnlineTrainingHub]

🙏 glad you found it helpful 😊

[@Rice0987]

Also i dont like comma as separator, cause it just hard to read of sentence of decimal numbers using comma in both variants: 1,2, 25,3, 5,12, 4,48. When it MUCH better to use DOT ONLY for decimal separator:1.2, 25.3, 5.12, 4.48. This habit gave AutoCAD. Thank you Autodesk for ordering my decimal numbers writing. :)

[@MyOnlineTrainingHub]

If you're in a region where the dot isn't used for decimal places then that's ok, but I wouldn't recommend it otherwise.

[@Mark-Bench]

great Video to understand how to easily combine data. i tried the map with simple data on Europe sales, but Bing couldn't render more then 50% correctly, didn't even find Germany and blanked it out

[@MyOnlineTrainingHub]

The map charts are a bit hit and miss. Need to label the columns in a particular way for it to play nice.

[@furtim1]

This is awesome. What would happen if the 2024 file added a new salesperson or lost one? What about a changed category name in the 2024 file?

[@MyOnlineTrainingHub]

You can make those changes and everything will update accordingly without having to edit the query or report.

[@TexasOverland]

Great instruction! Can you explain why the sales map chart is so dim at the very end? Looks like an error, but I think I’m just missing something

[@MyOnlineTrainingHub]

The map chart uses a color scale with the lower values in the paler color. You can change the color scale to use a different color for lower values rather than paler shades of the same color.

[@DarrenButton]

Really enjoyed this video and it made me revisit my dasbboards and they are now much better. Keep up the great videos!

[@MyOnlineTrainingHub]

Wow, that's awesome to hear, Darren!

[@erika_tech990]

You are magician. Thanks for this tips 🎉

[@MyOnlineTrainingHub]

Glad you enjoyed my video 🙏

[@frameworkcc2005]

Thank you so much for the video, it is really amazing. I have one issue after cleanning the data in power quary, I incorrectly chose close and upload to power pivot, I go back to power quary, but after that I dont have " Close and Load to" , it is gray, and I only have " Close and Load". How can I find the " Close and load to " functions? Thank you.

[@MyOnlineTrainingHub]

Great to hear and well done for trying it yourself. You can access Close & Load To from the Queries and connections pane (Data tab of the ribbon) > right-click the query you want to edit the load settings for.

[@joncue0304]

Thanks for the video. I use Excel, Access, and MySQL pretty regularly. In my experience setting up all the data, relationships, etc is far easier in a database (not to mention I can easily make it a standalone application). I started using Excel for a lot of the functionality that I'd typically get from a database, even though it takes far longer, just because most people don't really understand relational databases and I can make things "prettier" in Excel. Is there any other advantage for using Excel rather than just using a database where I can easily create queries, reports, etc really quickly?

[@MyOnlineTrainingHub]

If you can store your data in a database, then by all means do so. I would still use Power Query to connect to Access and bring the data into the data model/Power Pivot. The relationships you set up in Access will automatically come across, then you can create your reports in Excel, which are much nicer than Access. However, if you don't need charts, and your reports in Access are adequate, then stick with that. If you ever find yourself dealing with unstructured data, then Power Query will be a lifesaver.

[@badshanoordeen9300]

For visualisation (your third suggestion), is it better/alternative POWER BI?

[@MyOnlineTrainingHub]

An alternative is Power BI, but keep in mind that not all companies have the resources and budget for Power BI, so also knowing data visualisation in Excel is beneficial.

[@WrestlingInYourHouse]

Oh Mami - yowiewowie, this is amazing - thank you for enlightening us !

[@MyOnlineTrainingHub]

My pleasure!

[@cablegurl328]

Hi, I love the Power Query overview. Now, I'm trying to do the same with real data and trying to connect my org chart to tie into my nps queries and I am missing a step or don't know how to incorporate my org chart into my original query.

[@MyOnlineTrainingHub]

Hard to help without knowing how your data is structured. 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

[@Netryon]

These skills would help me to find a value of an event for every choir member if their studies yearly costs 3000 to 5000 or even up to 9000 for some students. Unknowns are current students in the event and their exact value - I may not know every faculty and their student only myself.

[@MyOnlineTrainingHub]

Not sure what you mean, but 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

[@Netryon]

@@MyOnlineTrainingHub I meant eu parliament

[@williamthatsmyname]

Very well presented and easy to understand.

[@MyOnlineTrainingHub]

Glad you think so! 🥰

[@DatawithHimanshu]

So much to learn as usual from your awesome contents. Thank you so much.

[@MyOnlineTrainingHub]

So nice of you 🙏😊

[@aiasaiascon3894]

What I find hard sometimes is to Define the process I need in order to have PowerQuery work on a Repeatable way for me. But that is obviously a Thinking process issue or a process design issue and not a missing knowledge part of PowerQuery....

[@MyOnlineTrainingHub]

Yes, and as you become more experienced with Power Query it will be easy for you to define your processes to maximise efficiency.

[@intelliGENeration]

Companies let you go ESPECIALLY when you fix and automate everything for them... then they hire low budged data entry people at 1/3 your cost. Especially when your boss sees your ability to automate his/her job too! 😁

[@MyOnlineTrainingHub]

Most companies don’t behave like that. At least with these skills you can more easily find yourself a company that values you.

[@shadrackdeogratius6760]

​@@MyOnlineTrainingHubMy mom come and teach me😅😅😅

[@hammadurrehman4262]

very much informative and skill improving video. Thanks

[@MyOnlineTrainingHub]

Glad you liked it!

[@trietluong8144]

Thanks much for detail guidance. It is a great lesson.

[@MyOnlineTrainingHub]

Glad you found it helpful!

[@francishubertovasquez2139]

Nice advice for a diplomatic woman. I the Caesar King shall prolong a bit my patience and restore and activate the systems deactivated. Let it be

[@IamTheReaper911]

Brilliant!! Man, I love your videos

[@MyOnlineTrainingHub]

😁 thanks so much!

[@HamboubAbdellahi]

I like it waw , verry impressive and clearly,❤️❤️ thanx so much .

[@MyOnlineTrainingHub]

Thank you! 😃

[@sumis8096]

This was great! Thank you so much!

[@MyOnlineTrainingHub]

Glad you enjoyed it! 🙏

[@Rice0987]

I've started using PQ for my own effectiveness to make my routine more easy, but my company counts it just ok...

[@furtim1]

I hear you. One of my prior jobs had everybody individually read through 8-14 pages of calendared hearing issued by the county every week for any of our client's names (which were like 100+). Besides being tedious, I was scared I would miss one or not recognize some name (fairly new to the company at this point). I highlighted and copied the entire contents of the pdf into Excel and wrote a code that would search it for the contents of a list of clients and remove all the data that wasn't a match. This turned an error prone 10-minute process that had to be done every Monday into an errorless 10 second process that could be done at any convenient moment. When I showed it to my boss, he was dismissive and insinuated that I was just lazy. He insisted on doing it manually and told me to do the same. Not much incentive there.

[@MyOnlineTrainingHub]

Great to hear you're making use of Power Query.

[@km_mamiao]

Big​ Thank​ from​ Thai​land.

[@MyOnlineTrainingHub]

You're welcome!

[@JohnOji-o8z]

Excellent !!! Thank you so much. I am currently using Excel 2021, and I am encountering an issue with Power Query. When I subtract the order date (01/01/2021) from the shipping date (03/01/2021), the result is 59 days instead of the expected 2 days. Despite following the standard steps for calculating the date difference, I consistently receive incorrect and significantly inflated figures. Could someone please provide guidance on resolving this issue?

[@MyOnlineTrainingHub]

This will be a locale issue: kzbin.info/www/bejne/h3zKhGaep9egrNk

[@Justmestudying]

As a newbie wanting to learn excel 365 by buying microsoft 365 subscription, where do i start? Can u pls link me to a beginner video and intermediate. Thank u

[@MyOnlineTrainingHub]

You can get up and running with my free courses: www.myonlinetraininghub.com/free-registration

[@susansinha6509]

This is awesome, but can one of you please provide a solution because for me the date option is blurred out and I cannot do anything

[@MyOnlineTrainingHub]

What is the time stamp of the 'date option' you're referring to?

[@philipamah1]

This is just so amazing

[@MyOnlineTrainingHub]

Glad it was helpful 😊

[@stafupes1926]

Can you please tell me how to select multiple on slicers or clear selection once you remove headers?

[@MyOnlineTrainingHub]

Hold SHIFT to select multiple contiguous buttons, hold CTRL to select non-contiguous buttons. Clear selection by selecting first button > hold SHIFT > select last button.

[@financnifitness2583]

Hi, excellent video, but could you explain how did ou get to have the blue boxes? Cannot find it out where did you click to obtain the data:)

[@MyOnlineTrainingHub]

The data in the blue tables is in the Excel file you can download from the file in the video description. In that file, they're on the "Dimension Tables" sheet.

[@power-reconcile]

Very helpful, thanks for sharing!

[@MyOnlineTrainingHub]

Glad it was helpful!

[@ExcelPro-]

Very Very Very Goooooood

[@MyOnlineTrainingHub]

Thanks so much!

[@theimperfectsinger623]

Hello, genuine question. Why not use PowerBI? What's the difference b/w these two processes?

[@MyOnlineTrainingHub]

Great question. Check out this video comparison of the two tools: kzbin.info/www/bejne/Zp-kgmqdhbSSbLs

[@DickvanderVelde]

Wondering if the map trick will work if a new item is added. For example when a new state is added or removed from the data, do you have to manually update the ranges each time? Wouldn’t it be possible to use named ranges?

[@MyOnlineTrainingHub]

You can just extend the range being referenced to include some blank rows to allow for growth. The map chart will just ignore them until they contain data.

[@PK-cj1pg]

Always amazing!

[@MyOnlineTrainingHub]

Thank you! Cheers!

[@russskinner5715]

Inspiring stuff. Thanks for all your content.

[@MyOnlineTrainingHub]

Glad you enjoyed it!

[@lorenzoladejobi8701]

Excellent video as always!

[@MyOnlineTrainingHub]

Thanks so much 🥰

[@ejazali4465]

Awesome learning video 👏

[@MyOnlineTrainingHub]

Thank you 🤗

[@jambaraz7641]

And again it was superb.

[@MyOnlineTrainingHub]

Thanks so much!

[@marketglance8278]

Can Tableau do all of the same stuff, is it worth learning how to do it in excel? I don't understand where the overlap is between Tableau/Power BI vs Excel. Understanding both is probably best.

[@MyOnlineTrainingHub]

If your company is happy to pay for Power BI/Tableau licenses then I'd do my reporting in them for the most part, but Excel skills will also be essential because it offers more flexibility than those apps for ad-hoc analysis and modeling etc. Personally, I think it's better to go down the Power BI path because the Power Query and Power Pivot skills are transferrable between Excel and Power BI and Power BI is the leading BI tool according to Gartner.

[@kiranphadke4494]

08:39. Hi Mynda. Thank you for your knowledge been share to us. Can you tell me where can I find this sheet data?

[@MyOnlineTrainingHub]

It's in the file you can download from the video desctiption.

[@daveh4208]

Do you have a video on how to set up power query? Right from the start, after selecting the two date columns, add a column, then everything in the data & time section 'grays out' and I can't select the 'date' to get to the subtract option. When I don't select any columns, date & time are available, but when I select date, the only drop down option that isn't grayed out is 'parse.'

[@MyOnlineTrainingHub]

See my reply to your previous comment. If you're still stuck, post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@mmhuq3]

Thank you

[@MyOnlineTrainingHub]

You're welcome 😊

[@tammimayson8059]

Thanks for the great info! I create dashboards for clients with their sales data, but I need to email it to them. How will a document like the one you're using work if it's sent to another computer and Power Query can't find the folder that the data is in?

[@MyOnlineTrainingHub]

If the user doesn't have access to the folder location then they can't refresh the queries, but the report will still display the data and they can use the slicers. They just can't update/refresh the queries, but this is no different to how you currently do things.

[@tammimayson8059]

Thanks@@MyOnlineTrainingHub 😀 I really enjoy your videos

[@AhmedSalah-rn8iz]

soo value video, my respect.

[@MyOnlineTrainingHub]

Glad it was helpful 😊

[@AhmedSalah-rn8iz]

@@MyOnlineTrainingHub thank you

[@mckeenondata]

Fantastic video.

[@MyOnlineTrainingHub]

Thank you very much!

[@LifeIsLife1978]

In real world no one is need it. Learn how you can save the time to others with excel eg speed up raport process or automate some boring task.

[@kossiviaglee2997]

Thank you!

[@MyOnlineTrainingHub]

You're welcome!

[@kouakouvalerekouassi673]

Excellent! I realy appreciate, Thank you 10/10

[@MyOnlineTrainingHub]

So glad you liked it! 🥰

[@joseluisd.arguelles6066]

can you use power query to choose which products are good for new marketplace expansion?

[@MyOnlineTrainingHub]

Power Query is a data gathering and cleaning tool. You’d have to then analyse the data, which you could use Power Pivot for.

[@joseluisd.arguelles6066]

@@MyOnlineTrainingHub thank you

[@BossCrunk]

I wish you would tell us how to prevent embedded workbooks (in Word documents) from mysteriously turning into un-editable pictures. MS still hasn't solved the problem, nor do they seem willing to address it.

[@andrewdove342]

my Excel is not recognising the 2 date columns as dates in the CSV and in power query, in the beginning , combine and transform steps where you add column to subtract dates. This is an issue im trying to overcome often, possibly because of my regional settings? Trying to change the column data type to "date" in power query, still doesn't convert from text to a date

[@MyOnlineTrainingHub]

It'll be a locale issue. See this video for how to deal with dates that are in a different format to your locale: kzbin.info/www/bejne/h3zKhGaep9egrNk

[@andrewdove342]

@@MyOnlineTrainingHub Thanks so much I will watch this. In the meantime I did change my regional settings in Windows to UK, and it now formats the dates in the CSV as dates (right alligned as serial numbers), so that fixed the problem for now. Enjoying your content thoroughly !! Thanks!

[@bigbikebelgian8958]

These tools are fantastic, however, but what I run in to is that the path to the raw data only works on 1 computer to refresh the data, especially if you draw the raw data files from Onedrive. When switching to another computer, the path is invalid.... Is there a solution for that?

[@MyOnlineTrainingHub]

If your files are on OneDrive then switching to another computer doesn't matter, as long as the user on that computer has permission to see the file on OneDrive. I wonder if you'd used a file path to your hard drive that's synced to OneDrive.

[@bigbikebelgian8958]

@@MyOnlineTrainingHub yes indeed a file path to a HD folder synched to Onedrive...

[@ibrahim82649]

This is so nice

[@MyOnlineTrainingHub]

Thanks so much!

[@Reebert02]

For the first section (Import/Transform), the dates imported as text (is it because they aren't formatted as dates in the source file?). When I converted them to dates, the columns had a 55% error rate because they're in a UK format and I'm in the US. Converting them by right-clicking the column > Change Type > Locale didn't work. Neither did changing the Regional Settings. Did anyone else have this issue? The only way I know how to correct it is by going into the source file and creating formulas to split, then concatenate them. Is there a better way?

[@MyOnlineTrainingHub]

You need to first remove the Changed Type step before applying the change type > using locale setting. See this video for the correct settings for your region: kzbin.info/www/bejne/h3zKhGaep9egrNk

[@Reebert02]

@@MyOnlineTrainingHub Fantastic! Thanks for everything you do!

[@OliviaValdez-b9i]

HI! 10:11 when you connect "relationships" make connections between data sets, what is the purpose of connecting the data sets? is this effectively creating the data model? :/

[@MyOnlineTrainingHub]

Technically, the data model can be a single table. The relationships between the tables enable you to filter your data based on fields in the related tables. For example, we can summarise the sales by the Category field in the CategoryDim table. You couldn't do this without the relationship between those two tables because the 'Categfory' field doesn't exist in the SalesData table.

[@hawarihamdan1922]

Hi - thanks for the video - when I select ship date cloumn and hold shift down and select order date the Date icon become inactive and not able to open the down arrow to select any thing - can you help?

[@MyOnlineTrainingHub]

Sounds like the date columns aren't set to 'Date' data types. You might have a locale issue: kzbin.info/www/bejne/h3zKhGaep9egrNk

[@hawarihamdan1922]

@@MyOnlineTrainingHub Thanks - that help me alot - and now the date icon open - but I check the quality of the two cloumn have errors - please help to fix

[@smc742]

hi thanks for the content just one question, in the 9.05 where do i get that second table in blue ? as i dont have it in the extracted file thanks

[@MyOnlineTrainingHub]

The tables are in the Excel file included in the download.

[@khalednady5831]

Awesome.. thanks alot

[@MyOnlineTrainingHub]

Most welcome! 🙏😊