unfortunately after i change the file to zip i get an "invalid". it doesnt show extraction. whats going on?
@excelgoat3 ай бұрын
Are you sure you have windows explorer set to show file extensions. Hard to know without seeing it but it’s possible the file is now named .zip.xlsx rather than the .xlsx being removed and replaced.
@stevielopezmua3 ай бұрын
You know I'm pretty good at following directions but when I did this step by step it didn't work :( We need to zoom!
@excelgoat3 ай бұрын
Sorry to hear that can you give me any more details as to what went wrong so I can help you troubleshoot ?
@pupuu.kidsfriendlyshow4 ай бұрын
Super easy to follow. Thank you!
@excelgoat4 ай бұрын
Glad it was helpful!
@Evil56395 ай бұрын
This does not work for excel protected workbooks, only protecting elements in a worksheet.
@excelgoat5 ай бұрын
I’m not sure what you mean? There are two types of protection evidenced in this video one of them being workbook protection which isn’t just sheet elements but includes workbook level protection like unhiding sheets etc. Both unlockable and the different methods shown in this video. Please explain more
@hafizsanee89296 ай бұрын
I had done this, but when change the dropdown list (D3), the vlookup data (D5, D7 & D9) didnt change.. it only will change when i click to D3 formula and refresh it.. am i doing anything wrong?
@excelgoat6 ай бұрын
Hi, it sounds like your calculations are turned off in Excel. If you click on formulas in the top bar and then calculation options it should be set to automatic
@shoppersdream6 ай бұрын
Nice, thanks!
@paryadasineh19296 ай бұрын
Thanks for this helpful video, it works well 👍🏻
@pamelalammersen67227 ай бұрын
This is not working for my .xls workbook that is encrypted with a password I dont remember. The steps are clear and I have been able to do things like this before, but …when I renamed the file to .zip and double click the zipped file, I get an error saying the file is not valid, If I go to my 7zip folder and double click from there, I don’t see any file content. It looks like the data is just the encryption files.. What am I doing wrong? Please :-) t: [6]DataSpaces D Encryptedpackage C) Encryptionlnfo Many Thanks for your time :-)
@excelgoat7 ай бұрын
Hi Pamela, sorry you’re struggling with this. Gonna be hard to work out without seeing it but a few questions came to mind. Depending on which version of windows you are on can I just check you’ve got the option ticked (or unticked) to show file types in windows explorer. I’ve seen it before where it looks like a file has been renamed but it’s actually called… for example workbook.zip.xls so it hasn’t actually changed format it’s just the name that has changed so that would be my first thought. Before trying to unzip it can you confirm the icon itself changed, if it’s still showing an excel icon (or something else) id say it’s definitely not become a zip yet. Other things to try would be adding a password to a copy of another existing workbook (take a backup of course) and try an xlsm or xlsx if you can before confirming if it’s the xls format that’s the problem. If you don’t have the option for xlsm or xlsx then there used to be an excel addin which worked on older versions of excel and definitely worked for xls previously might be worth trying to find that but years since I’ve used it. The other thing it could be and I notice you mention encryption is im not sure this method works to unlock an encrypted workbook. It works for worksheet, workbook encryption (applied from the top menu) but not … as far as I know with the encrypt with password method.
@andymarten69477 ай бұрын
Useful, thank you
@excelgoat7 ай бұрын
Glad it was helpful!
@bakani22189 ай бұрын
Thank you
@azrobbins019 ай бұрын
Love your channel, mr. goat!
@hossainyead63419 ай бұрын
good one
@idemy855410 ай бұрын
amazing bro keep it up
@excelgoat10 ай бұрын
Thanks. Hoping to get publishing again in the next few weeks
@stephenpritchett3111 ай бұрын
And such a handsome host too !
@excelgoat11 ай бұрын
Sadly it’s just good lighting Stephen!! (It’s like virtual Botox) But thanks anyway
@joao_aguiar_ferreira11 ай бұрын
Excelent, very nice. But, if you select two months (or more), the selection of the title will not shown both months.
@excelgoat11 ай бұрын
Hi, yes that’s correct I’ve tried to keep it simple for this tutorial and for most cases where a single selection is required. Making it dynamic for multiple selections is possible you could do it in a few different ways. For example, an if statement that looks for the pivot to show “(multiple selections)” and if it did a further you could then point a textjoin formula at another pivot which gave you those individual selections to return “for February, March and April” for example. Hope that helps
@snapperhead6256 Жыл бұрын
Very helpfu, thank you.🙏
@azrobbins01 Жыл бұрын
Great Tutorial! The problem I have is when my data does not follow predictable patterns, and I end up having to nest 10-20 IF formulas to account for all the possibilities, and my formulas get to be pages long. This makes finding errors in my formulas a real pain and I end up having to paste them into Notepad++ to highlight matching brackets and such.
@excelgoat Жыл бұрын
Yeah I feel your pain!. In environments where you have control over the input at that point it’s definitely best starting back at the point of capture and building in some validation or automation to ultimately reduce the post cleanse although I appreciate that’s often not a possibility if the data is coming from a third party source.
@lydethful Жыл бұрын
Is this the last lesson? No 22?
@excelgoat Жыл бұрын
Hi Lydethful yes it’s the last lesson in the Beginner course I did but hopefully you’ve now found the other videos on the channel I’m currently trying to release one per week, good to have you on board
@lydethful Жыл бұрын
@@excelgoat Thanks. I've been using Excel for more than 10 years but still gain some new knowledge from your videos. Keep up the good works.
@lydethful Жыл бұрын
A life saver!
@robbw4264 Жыл бұрын
Amazing! I've never seen the BUILD formula before. I can definitely use that one. Thanks from Vancouver 🇨🇦 !!
@excelgoat Жыл бұрын
Glad you like it!
@robbw4264 Жыл бұрын
Thanks for this tutorial! It was exactly what I was looking for. I found a million and one videos on how to create and use slicers but couldn't find anything on how to redesign their appearances. Very easy to follow and appreciate you showing the impact of your selections and you worked thru this. Much appreciated !!!
@excelgoat Жыл бұрын
Thanks, it’s great to hear a video was useful. If there are any other topics you’re looking for feel free to comment back as I’m always on the lookout for video ideas
@azrobbins01 Жыл бұрын
When you get to the vlookup formula, how will you deal with duplicate values, for example if there were 2 titles with the same gross value?
@excelgoat Жыл бұрын
I’ve found the best way to do this is to either add a helper column in your dataset or slightly modify the existing column of values that lives in your data set. To do this I use the row formula =row() to obtain the row number I then multiply this by something like 0.00000001 to get an insignificant but completely unique decimal and I add this onto each cell of the value column. This ensures we have completely unique values and presenting it without that level of decimals showing means it makes absolutely no difference to the visual output Another alternative is to use a pivot table and set a values filter on the first column of labels and choose top 3 “by” the value column in that filters option. Then you would include the label in the rows part of the pivot the values column in values which should handle the duplicates. I.e if you had a bottom three that were all zeros it would pick these out but give you three different labels in the other column Hope this helps!
@azrobbins01 Жыл бұрын
Great Tutorial! Thanks!
@azrobbins01 Жыл бұрын
Another excellent tutorial! Thanks!
@excelgoat Жыл бұрын
Glad you liked it!
@azrobbins01 Жыл бұрын
Great tutorial!
@azrobbins01 Жыл бұрын
Love the videos!
@azrobbins01 Жыл бұрын
Great Video! Keep them coming!
@azrobbins01 Жыл бұрын
Excellent and informative video! I know Excel is in your name, but do you also make any other useful tutorials? I feel like you could speak on any number of other topics and share some useful knowledge in an easy to understand way.
@excelgoat Жыл бұрын
Thanks AZ, really appreciate the feedback that’s a massive compliment. At the moment I’ve got my work cut out with a long list of topics in this area but maybe in the future I’d consider other things. Anything you had in mind? 😀
@azrobbins01 Жыл бұрын
@@excelgoat Nothing in particular. Great tutorial videos require that you have both the expertise in the field, and also the ability to explain the concepts in an easy to understand way. If you had any other areas of expertise, I am sure you could make great videos on other topics as well. Games, maths, science, programming, etc. I was just wondering if you had any plans to go into other subjects in the future.
@digedag7480 Жыл бұрын
I love you kind of style! I subscribed months ago but only today took the Saturday to watch all your lessons to learn more about Excel. I use Excel regularly and love it but I’m self-taught. So I can always learn more; and I learned quite some things and you are right: the slicer is amazing! Thank you very much for your content. Greetings from Germany.
@excelgoat Жыл бұрын
Thanks digedag that means a lot and glad you enjoyed the videos. I’ve been off the scene for a while but hoping to start releasing some new stuff in the next few months
@HikewithEli Жыл бұрын
Brilliant content 👌
@melihunal9873 Жыл бұрын
hi thanks , but if i click on "change chart type" - window on 0:34 is not appearing, just a popup select box is showing up. Can you help me please?
@excelgoat Жыл бұрын
Hi, sorry to hear it’s not working in the right way I’ll do my best to help but might take us a few goes. Can you give a bit more detail on what the pop up select box you mention looks like, I don’t think screenshots can be attached to comments but that would be ideal. Is it a bar chart you are clicking on that has some data already in it (similar to my example)? Also do you know which version of Excel/Office you have please?
@ThePoxun2 жыл бұрын
At my workplace there is often an incorrect pattern used where if people want to do ANY maths function they stick it in a SUM... that is they would write =SUM(A3+A4/A7). While it will still give the correct answer the redundancy of it drives me crazy 😐
@excelgoat2 жыл бұрын
Haha yeah I know exactly what you mean. As you say it gives the right answer but “not” for the reasons they think. There is one growing use supporting the “use sum for all” debate and that’s where the new #spill error arrives unexpectedly, often creating errors in previously working spreadsheets of many years. Encasing the calculation in =sum in some of these scenarios can be a quick workaround where the cause of the error is not clear and in the case of your colleagues they likely haven’t stumbled on #spill as frequently as everything is in =sum 🤣
@colettenewell46342 жыл бұрын
Your instructions are excellent. Very clear and concise. I hope you get more subscribers as an incentive to keep going
@excelgoat2 жыл бұрын
Thanks Colette, really enjoying the process at the moment.
@colettenewell46342 жыл бұрын
Excellent series so far.
@excelgoat2 жыл бұрын
Thanks Colette, glad you’re still enjoying it. That’s it for course one, I’m going to change it up a bit in the next series of videos so I’m keen to get your thoughts when those are released.
@cyclopsboi2 жыл бұрын
you could also use the Format Painter to apply the copied format without having to paste special
@dakmen2 жыл бұрын
nothing to do with insights . just a sentence on insight
@colettenewell46342 жыл бұрын
As a number cruncher i hated the ‘make it pretty’ for the customer aspect of my job. To me it was a waste of time from doing the ‘real’ analysis work. But with your techniques looks like it’s pretty fast and easy and improves the experience.
@Merione2 жыл бұрын
How did I never learn of this feature? It's awesome! I'll definitely play around with it!
@excelgoat2 жыл бұрын
They truly are awesome. In fact there is only one problem with Slicers in Excel and that is that hardly anybody knows about them. I've made it my life mission to tell as many people as I can about them :), hope you join me on my mission
@Merione2 жыл бұрын
@@excelgoat Now that I know about them, I'll definitely join you in spreading the word!
@colettenewell46342 жыл бұрын
I’m going to say that game changers in excel were pivot tables, vlookup, remove duplicates, maybe text to columns. But slicers do enhance the filter experience so for end users that might be more important. Good module
@excelgoat2 жыл бұрын
Totally agree with you on Pivot Tables, however, Pivot Tables when combined with Slicers go up another level as do lots of other features when we use a Slicer on them. As for Vlookup I used to love it too... until I found Index Match, and now I would never go back. I will be doing a video on this exact topic very soon
@colettenewell46342 жыл бұрын
Taught me something new snd I’m looking forward to slicers. They appeared when i took a short respite from work and then showed up in my reports that my colleagues looked after while i was gone. I never really got the hang of them.
@excelgoat2 жыл бұрын
Thanks Colette, Glad it’s working for you, I’m looking forward to releasing the slicers lesson, they are my favourite tool by far.
@colettenewell46342 жыл бұрын
I think your content is excellent. Short focussed videos prevent confusion and enhance learning. Keep up the great work.
@excelgoat2 жыл бұрын
Thank you so much Colette, this is really nice to hear
@colettenewell46342 жыл бұрын
My experience from 40 years of reporting is that writing over your data to clean it often isn’t the best option. Creating a secondary data element with revised data is a better way to go. I take your point that to properly link all the records for walt disney they all need to be the same, but it’s possible that the original data would be used for lookup purposes or linking purposes but would have disappeared if written over. I know you are just starting a beginner course and probably don’t want to complicate your instruction but this habit is easy to set and hard to break for people who don’t understand the value of their data or how it fits in their business process. I’m an old hand at excel but I’m enjoying your course so far. Hoping as you get farther along i might pick up some hints. Heard about you from Simon at Cracking the Cryptic
@excelgoat2 жыл бұрын
Hi Colette, thanks for your feedback, I would definitely agree in most cases and would certainly always recommend keeping a copy of the original. As you say I was trying to keep it simple and avoid people leaving formulas live on larger datasets which can bloat the file and make it a pain to use if the formulas are poorly designed or inefficient. As I make more videos the general plan of attack I'll be promoting focuses on designing out the error at the capture stage in turn controlling the inputs and ensuring there is less need for cleansing as a middle step prior to analysis. I'll do this through tips on data validation through things like drop downs (derived from approved master data lists held externally to the file). Alternatively where the data source is inherited as such, and contains errors I would normally build a compliance type metric which supports the core outputs referencing them vs approved items and giving a data integrity score which informs as the reliability of the core indicator. Using the Walt Disney example again we could either a) Cleanse Manually (In these cases and when we get onto VBA I usually build a live change tracker in using cell based events which capture the before and after values in a cell and timestamp the changes) b) Design out the error through validated input forms or better still from a source that is integrated into a capture source if Excel is not the source c) Hold an agreed list of Studios and check that the items exist vs this list. In this case, those spelt or formatted incorrectly could shape part of the Error side of our adherence metric and the initial data may be flagged as 20% valid, prompting someone to cleanse at source or where necessary add additional studios to the approved list. We could then from a reporting perspective choose to include or exclude the flagged items and to make that choice clear in the labeling of the output As you'll know with your experience there's often no wrong or right way, it's great to get feedback like yours as it prompts thought and discussion and I hadn't considered the habit element as in the wider approach it wouldn't normally come up but will definitely be in my head now as I make new content so this was helpful thanks
@Grumpy_Granddad2 жыл бұрын
Am I going doolally --- no answer needed --- keep it to yourself --- I can't find the example spreadsheet anywhere on the course pages ?
@excelgoat2 жыл бұрын
Hi Geof, the website is a bit work in progress for now so apologies it’s not the easiest to navigate. I made a change last night which should now make the download accessible. In the course of you click on the materials tab it should now take you to a new page where the link text will automatically download the file. Hope this helps
@Grumpy_Granddad2 жыл бұрын
@@excelgoat EXCELent - worked a treat - I have nearly worked through the 21 course one lessons (never a bad thing to remind the basics) and am very much looking forward to further courses -- will you be covering data scraping - power query - Power BI and more in the future?
@Grumpy_Granddad2 жыл бұрын
I could KISS you --- Keep It Simple (I'm) Stupid -- used to work for me when I was in the world of paid empoyment
@excelgoat2 жыл бұрын
Haha, why have a single workbook with 2 structured tabs when you can spread it across 5 workbooks with 50 tabs each and all of the people that know how those work left the company years ago 😉
@craftsmanwoodturner2 жыл бұрын
Hi Dave - Simon sent me. Nice introductory video, but it dives straight in to content, with no context at all. Can I suggest you record a Lesson 0, to introduce yourself and explain what you plan to cover in course 1?
@excelgoat2 жыл бұрын
Hi Richard, thanks for the feedback there is a video called course 1 introduction which is the precursor to lesson 1 but I wasn’t sure how to name it effectively to make it clear it’s part of the course. Your comment suggests I haven’t quite got it right and others will likely have the same issue so I’ll have a bit of a rethink on that , thanks for pointing it out. Here’s the link if you want to have a watch kzbin.info/www/bejne/ZnWonZ6ba6Z-j7s