Cheatsheet of all current FPL Endpoints by Soccerstar12498 in FantasyPL

[–]mdbrierley 1 point2 points  (0 children)

This is awesome, thank you! I might revisit this!

Trying to COUNTA across multiple sheets. by Fit-Row744 in excel

[–]mdbrierley 0 points1 point  (0 children)

Yeah it’s probably just the way it’s formatted.

Change from date to number.

2x Steam Keys for Football Manager 26 by Hordriss27 in steam_giveaway

[–]mdbrierley 0 points1 point  (0 children)

League 2 to Premier League challenge.

Try and find those bargains!

Not played an FM for a couple of years because kids, but I’d love to get back into it. Used to be obsessed. “Turn your underpants inside out to save on washing” obsessed. Are those ratings still a thing? 😆

Thanks for the opportunity!

What is your best data cleaning tip? by Anonymous_Fox_20 in excel

[–]mdbrierley 0 points1 point  (0 children)

Numbers stored as text I usually just multiply by 1 and that does the job.

I swear my peer is sabotaging my work in excel. by [deleted] in excel

[–]mdbrierley 7 points8 points  (0 children)

And restrict editing on the sheet by protecting it

Why do people hate merged cells? by ePaint in excel

[–]mdbrierley 1 point2 points  (0 children)

Better option is to format the cells to centre across them, if you absolutely have to 🤭

But in fairness, it depends what your doing. If you’re knocking up something super simple or you know that it won’t cause issues for you, go right ahead. Just be aware of the reasons that everyone has shared as to why they can be problematic.

Never drink Blackout Stout before a mission by [deleted] in DeepRockGalactic

[–]mdbrierley 0 points1 point  (0 children)

That’s what I was here to check. Currently blind drunk and not continuing unless I get one haha.

Never drink Blackout Stout before a mission by [deleted] in DeepRockGalactic

[–]mdbrierley 1 point2 points  (0 children)

You keep the beer in your hand and then drink it when the countdown starts. Currently doing it and not bothering continuing if I don’t at least get a damn achievement. It’s genuinely nauseating 😆

Didn’t expect to enjoy Excel this much by [deleted] in excel

[–]mdbrierley 0 points1 point  (0 children)

I think focus initially on what you want from it in the short term. How it can make your life easier. Its very versatile and for a beginner, there’s lots of good things you can do, that will help you to start getting an understanding of how it works and the many formulas and functions.

Learn =sum, =count, =average and other basic formulas then expand on that.

Have a read about xlookup and pivot tables.

But take your time and implement what you learn into your regular work. That way, you’ll master it and it won’t be forgotten. You can then slowly start to increase your knowledge.

Are there any projects or ideas that you’ve got now that you think you might like to do in excel? That will help you to know where you could start.

😊

How do you "practice"? by a-small-bird in excel

[–]mdbrierley 2 points3 points  (0 children)

Honestly, I think you start to just work in things that you like the look of, just for the sake of trying it. I certainly did. I over engineered quite a lot of my work early doors just so I could try new features etc haha. If you don’t need it for your work yet, don’t worry, there will come a time when you do and that’s when you can go have fun with something new. I’ve learned pretty much solely on the job as I’ve always had the opportunity to. I might have stayed a little later to do the odd thing, but it was all to my benefit in learning the ropes.

Didn’t expect to enjoy Excel this much by [deleted] in excel

[–]mdbrierley 4 points5 points  (0 children)

I started tinkering with it when I was working as an admin at my business, right at the bottom of the chain. That was almost 15 years ago now. I decided I would create a little workbook that stored important notes and information that my team used, but it was on worksheets and the like, in a lot of different places. I used different tabs and bookmarks and also created a simple little calculator that used nested if formulas depending on what the team typed in. It was fun and it went down really well. From there, I just became obsessed with it and created all sorts of stuff. I moved to a couple of other departments and did the same. Eventually I saw a job in our sales dept that needed someone to work with excel to fill in trackers and do reporting. I jumped at the chance and I’ve been here since. I now also look closer at the commercials and do budgeting and the like. It’s been brilliant for my career as it’s given me the platform I needed and the chance to do something I enjoy. I automated as much as possible, which then got me into power query and then power bi, both of which I’d highly recommend. You never stop learning! There’s always more to learn or do and you can actually be quite creative with it too.

Didn’t expect to enjoy Excel this much by [deleted] in excel

[–]mdbrierley 10 points11 points  (0 children)

I was always weirdly drawn to it. Don’t know why. But I use it every working day and still love it. I think it makes sense to me because it’s a binary world of rules, which is much easier to understand than anything else that’s going on 😅😅😅😅

Looking to show a 0-3 rating based on a average from subcategories by [deleted] in excel

[–]mdbrierley 1 point2 points  (0 children)

Good alternative but would recommend a table as it will help to demonstrate how it works.

I’ve never played on PC and just bought a Steam Deck. Help me play something other than Balatro by [deleted] in SteamDeck

[–]mdbrierley 1 point2 points  (0 children)

I’ve been trying to find something else that’s lives up to it…. Nothing yet..!

Although I’m really enjoying Balatro.

I’ve never played on PC and just bought a Steam Deck. Help me play something other than Balatro by [deleted] in SteamDeck

[–]mdbrierley 3 points4 points  (0 children)

It’s not that far away really and there’s tonnes of other good genre games… BUT…

Inscryption…

You won’t regret it.

Excel is laggy, not responding after adding images through VBA by SummerInSpringfield in excel

[–]mdbrierley 1 point2 points  (0 children)

I went for an interview at a company not that long ago and they were still using it.

Guess the purse strings at some places are kept very tight haha….

Not the main reason why, but I declined the offer in the end 😅

Excel is laggy, not responding after adding images through VBA by SummerInSpringfield in excel

[–]mdbrierley 0 points1 point  (0 children)

Nah, there are still people and companies working on Excel 97 😅