Видео

Glad it helped!

Thanks, glad you found it helpful

You're very welcome!

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.

Sorry to hear that can you give me any more details as to what went wrong so I can help you troubleshoot ?

Glad it was helpful!

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

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

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.

Glad it was helpful!

Thanks. Hoping to get publishing again in the next few weeks

Sadly it’s just good lighting Stephen!! (It’s like virtual Botox) But thanks anyway

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

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.

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

@@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.

Glad you like it!

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

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!

Glad you liked it!

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? 😀

@@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.

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

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?

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 🤣

Thanks Colette, really enjoying the process at the moment.

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.

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

@@excelgoat Now that I know about them, I'll definitely join you in spreading the word!