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
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?
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.
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 ❤
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
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.
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
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
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.
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
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.
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.
@@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.
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
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.
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.
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 ❤
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
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❤
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
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 ?
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
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
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.
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 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.
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 In case anyone is wondering how, in the developer tab, click on tools, then select VBA Project Properties, then Protection, and enter your password.
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 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?
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.