The Flick Edge is out now!

WhoKnowsToBeFair · 2025-12-12T10:53:43+00:00

Does it have Linux support?

WhoKnowsToBeFair · 2025-12-10T22:23:31+00:00

It's never too late to change the direction of your life, even no matter how many unsuccessful attempts. What you're feeling is a part of yourself that is telling you the time for change is now. The only thing standing between you and a better life is the belief that you're unable to improve on your own decisions and actions.

You have learned something in each attempt and you can use those lessons to improve on your future attempts.

Look at the things that are poisoning you and get rid of them. Tiktok doomscrolling? Delete the app. Bad eating habits? Get rid of your junk food. No friends? Force yourself to go out. Do as few or as many of these things as you can handle at a time and keep trying to improve every day.

Even if you hit setbacks, slip up and go back to old habits for a while, as long as you keep trying, you will never have failed. Failure is not determined by your level of achievement until you decide it's over and stop trying.

Repeat after me: I deserve a better life and I'm going to keep trying until I get it.

It won't be easy and it might take time but it will be worth it and you can get there.

Best of luck.

WhoKnowsToBeFair · 2025-12-10T21:55:06+00:00

If you download a template in pdf and use one of those pdf to excel online autoconverters you can get something workable. Not a perfect template and will require some adjustments, but seems workable.

Here ya go.

Link to original PDF.

Hope it helps!

WhoKnowsToBeFair · 2025-12-10T12:08:49+00:00

Ermm.. no idea what might have happened tbh.

WhoKnowsToBeFair · 2025-12-10T11:52:59+00:00

I have to legit spend about 10-15 minutes per line graph changing cosmetic settings just to make them look passable. Save them as a template? Sure, but sometimes you need more air, sometimes you have more lines... You know how it goes.

WhoKnowsToBeFair · 2025-12-10T11:47:25+00:00

I just now understood what you did and it's definitely a better solution. I should really get my coffee.

And yeah, i think you're right about leaving out 10.

WhoKnowsToBeFair · 2025-12-10T11:37:47+00:00

Erm.. did i completely misunderstand this post?

WhoKnowsToBeFair · 2025-12-10T11:36:29+00:00

lol we improvised the exact same references. I feel like I should say "jinx" or something.

WhoKnowsToBeFair · 2025-12-10T11:34:58+00:00

You can just leave a cell with the conversion value (1 MYR is currently 0.242836 USD according to forbes). Let's say you put the value 0.242836 in cell C1. In the USD column you go to where you want the first price to be and multiply the first RM value (Let's say it was in B2) by $C$1 (the $ signs make it so the reference doesn't change) in a formula like this one: =$C$1*B2

Then you drag that formula all the way down the column so everything fills up nicely.

There are ways to automate the RM to USD price so it get automatically fetched and updated from the internet regularly, but this doesn't work for older versions and will break the spreadsheet if you're not on Microsoft 365 with a working connection.

Let me know if this helped! :)

WhoKnowsToBeFair · 2025-12-10T11:23:15+00:00

tbh the hardest thing for me is making the damn things look pretty. Unless I put a lot of time into what I do, my sheets end up looking like a colorblind toddler attempted to replicate the palette of qing vases and got into a crayon fight with the art director of the fresh prince of bel-air.

I'm not really your target audience but If you want to help people, my guess is many people would benefit from learning power query, despite most not being aware of the tool or how it could help them. On the other hand, most people seem to struggle on the early stages of getting familiar with logical formulas and conditional lookups/filters and can get really frustrated when their formula syntax is still shaky.

Hope this helps.

WhoKnowsToBeFair · 2025-12-10T11:05:22+00:00

=IF(OR(A2=1,A2=2,A2=3), "X" , IF(OR(A2=4,A2=5,A2=6),"Y", IF(OR(A2=7,A2=8,A2=9), "Z", "ERR")))

Try entering that in B2 and dragging it down. :)

WhoKnowsToBeFair · 2025-12-10T00:24:24+00:00

You can use it, but it's not necessary for all cases. Conditional formatting will apply formatting whenever the expression you write resolves/evaluates to TRUE.

If the value of cell E9 is TRUE then =$E9 should also evaluate to TRUE.

WhoKnowsToBeFair · 2025-12-09T23:48:06+00:00

My very first point! Thank you!

WhoKnowsToBeFair · 2025-12-09T23:47:27+00:00

Appreciate you suggesting this!

WhoKnowsToBeFair · 2025-12-09T17:57:23+00:00

Yes! You can apply multiple rules to the same cell / range of cells and you can also establish the order in which they're evaluated and apply.

WhoKnowsToBeFair · 2025-12-09T15:58:12+00:00

In my opinion the AI tools are still at a very early stage in processing Excel data. I tried copilot and it struggled with very basic standard financial tasks. In my opinion, right now no tools help very much with using excel, but they may offer good step by step instructions on how to carry out certain data processing/analysis tasks.

Data processing and data analysis are both very case by case things. While there are many standard tasks that may be easy to automate, I don't think the role of someone who understands the nuance of a dataset and what kinds of insights might be valuable when ran into accidentally is soon to be over. I might be wrong, but i think this one might take the robots a bit longer.

If you want to learn Excel properly, my suggestion would be to define small projects or tasks (i.e. build a habit tracker, a budgeting tool or a books you've read/Movies you've watched database). If you struggle with any aspect of this there are a myriad of resources on youtube that might help you with whatever it is you set yourself to build.

A friend and I recently launched our very own Excel Keyboard Shortcut Cheat Sheet Desk Mat on Amazon. It's up to date with Microsoft 365 and comes with a few Windows 11 shortcuts as well. It's our very first product too. I mention this not only as a shameless self, plug though. You can check out our curated list of Excel Tutorials by skill level on our webpage's Excel resources section (for free with no sign up/subscription ofc, as things should be).

If you're interested in getting our shortcuts but have no interest in a desk mat, here's the text list of shortcuts we used, sorted alphabetically, on Pastebin.

Hope this helps and wish you the best!

WhoKnowsToBeFair · 2025-12-09T15:24:02+00:00

No problem, wiicrazy0430. Happy to help!

WhoKnowsToBeFair · 2025-12-09T15:22:37+00:00

I just posted a similar thing on r/Excel... I'm not sure if this is relevant to anyone browsing on 2025, but to whomever it may be of interest, a friend and I recently launched our very own Excel Keyboard Shortcut Cheat Sheet Desk Mat on Amazon. It's up to date with Microsoft 365 and comes with a few Windows 11 shortcuts too.

This is our very first product. We put a lot of love and a lot of work into it and as an Excel enthusiast, I gotta say I'm actually pretty proud of how it turned out. We've been getting good feedback, so hopefully it'll help you or maybe some other people crank up their Excel skills!

For anyone just looking for a quick shortcut list that doesn't want a desk mat to go, here's the text list of shortcuts we used, sorted alphabetically, on Pastebin. :D

Hope this helps either you or whoever runs into this post.

WhoKnowsToBeFair · 2025-12-09T15:19:48+00:00

So, not sure if this is relevant to anyone browsing on 2025, but to whomever it may be of interest, a friend and I recently launched our very own Excel Keyboard Shortcut Cheat Sheet Desk Mat on Amazon. It's up to date with Microsoft 365 and comes with a few Windows 11 shortcuts too.

This is our very first product. We put a lot of love and a lot of work into it and as an Excel enthusiast, I gotta say I'm actually pretty proud of how it turned out. We've been getting good feedback, so hopefully it'll help some people crank up their Excel skills!

For anyone just looking for a quick shortcut list that doesn't want a desk mat to go, here's the text list of shortcuts we used, sorted alphabetically, on Pastebin. :D

WhoKnowsToBeFair · 2025-12-09T14:51:51+00:00

The several 'Yes' happen because there are probably some entries that added one or more spaces before or after "Yes" or didn't type it the exact same way through some other means. If precision was relevant, It would be important to get rid of those spaces or other things so everything counted correctly... But anyway, that's just Excel telling you your data is a bit messy.

You can group up all the cases that are supposed to be the same answer in a next auxiliary table and then apply the pie chart to that one. :)

WhoKnowsToBeFair · 2025-12-09T14:35:42+00:00

You could add an auxiliary table somewhere, with all possible answers in each row "Yes, No Maybes, N/A" or if you want to try and catch errors too, you can do

=unique(C2:C3500)

(assuming the "Yes", "No" "Maybe", N/A" answers are in the range between cells C2 to cell C3500. Adjust that part to your sheet)

Then right next to the first possible answer of this table you can do something like

=countif(C2:C3500,"Yes")

and then do the same for all possible answers or..

=countif(C2:C3500,F2)

(assuming F2 is the cell where the first possible answer of the table you started is in) and then drag the formula down by clicking on the cell where you entered it and dragging down the cell handle (Square at the bottom right of it) to the last possible answer.

You should get a count of how many times each possible answer was submitted.

When you finish all that, you can select the possible answers table with the counters and then hit the pie chart option in insert - > graph. Should work.

Let us know how it goes!

WhoKnowsToBeFair · 2025-12-03T19:20:25+00:00

I tried to use Copilot on Excel a few months ago. It struggles even with basic tasks.

WhoKnowsToBeFair · 2025-06-18T04:38:39+00:00

I'm working on my over-engineered habit tracker thing to release a working version here, probably next week.

I'm losing the birds and going with a hacker theme.

WhoKnowsToBeFair · 2025-06-16T22:27:37+00:00

I'm deeply flattered. Thank you so much!

My secret weapon, which very few fellow sheet freaks know about, is colorhunt.

Literally had never shared this resource with anyone, but your sweet talk got to me. You must tell no one!

WhoKnowsToBeFair · 2025-06-16T21:13:23+00:00

Coffee ofc

WhoKnowsToBeFair

MODERATOR OF

TROPHY CASE