r/excel • • 18h ago

Game I made an excel style game for you. Play in browser, free, no signup

24 Upvotes

I made this fun little game where you have to hit a certain target each quarter. Or you'll get fired. It's a strategy/RNG game where you try to figure out different synergies to be able to hit the target. Don't play if you have anything productive to do!

https://gamesgamestudio.itch.io/excel-roguelite


r/excel • • 8h ago

Discussion Learning Excel through Google Sheets – is that normal?

18 Upvotes

I recently bought an Excel course, but the instructors said we'll be doing all the lessons and exercises in Google Sheets because the two programs are supposedly 95% identical.

I'm curious if that's really the case. What do you guys think?


r/excel • • 18h ago

Plugin Python embedded in Excel

10 Upvotes

Hi All,

This weekend for a bit of fun I built a free / source-available Excel add-in which hosts it's own Python runtime.

You can find a feature runtime and installation guide on the website:

https://sancarn.github.io/xll-python/index.html

fork it here: https://github.com/sancarn/xll-python

But here's an overview:

  • You can write user defined functions which execute like formula.
  • Returning a generator will make the result update every time it yield's a result.
  • You can write macros (e.g. reading / writing CSVs/databases from disk etc.)
  • There's an in-built IDE
  • You can debug formula in the IDE
  • There's a console/REPL where you can experiment with the available runtime
  • There's a package manager where you can install pip packages
  • There's a compiler so you can compile your own scripts into standalone .xll addins.

Hope you find this helpful! ~Sancarn

Edit: This project is AI:X. All code written by Astra & Sol 6.2; albeit with a lot of steering.


r/excel • • 14h ago

unsolved Make Graph Lines Automatically Change Color Based on Series Values

6 Upvotes

I have a set of graphs that automatically update to reflect the last 6 weeks of data. These measure performance in terms of success rate, and all have a set target percentage that we want to hit/exceed. Currently the lines are all constant colors, but I would like to have the lines of each graph change color to show if they are meeting target or not for that week of data.

I could see this being presented 2 ways:

- If the value is below target, that entire line segment (last value to current value) turns red. If above, the entire line segment is green.

- Any part of the line that is below the target line turns red.

What is the best way to automate this in Excel 365? Obviously I could just manually change the color of the line segment, but I feel like there has to be a better way. I briefly messed around with gradient lines, but could not find a way to make the cutoffs automatically update as data changed. I also considered creating dummy columns to split the data into 2 series, 1 red and 1 green, but that was not displaying how I wanted, and the lines were not connecting.


r/excel • • 21h ago

Weekly Recap This Week's /r/Excel Recap for the week of November 14 - November 20, 2026

4 Upvotes

Saturday, November 14 - Friday, November 20, 2026

Top 5 Posts

scorecommentstitle & link
30573 comments[Discussion] I just learned about LET and it cleaned up this formula - what else do you use it for?
8429 comments[Discussion] After LET, I tried LAMBDA - here is a reusable formula I made
8120 comments[unsolved] what's this new green dots thing on excel?
7513 comments[Novelty] Film made entirely in Excel...
5668 comments[unsolved] How does copying in Excel actually work?

 

Unsolved Posts

scorecommentstitle & link
2428 comments[unsolved] How to prevent Powerquery from re-downloading an excel file used as a source over and over?
1823 comments[unsolved] Data entry in shared files horribly built
1215 comments[unsolved] Best Excel architecture for configuration control: 1 Master + 49 Sub-Packages tabs
1212 comments[unsolved] Weird New Options Around Column/Rows
109 comments[unsolved] Getting constant "Circular reference" warnings

 

Top 5 Comments

scorecomment
316/u/gerard4156 said Braille
148/u/PedroFPardo said Excel’s clipboard doesn’t work like the normal Windows clipboard. If you type something somewhere else in the document after pressing Ctrl+C, Excel will forget what you were copying, and to show this,...
108/u/Shahfluffers said I typically use LET when I have truly gnarly multi "if-else" formulas. Which tends to happen when calculating budgetary/payroll/benefit stuff. Example: - LET(rate01,C50,benefitName,A50,benefitAp...
90/u/CIP_In_Peace said You get more value out of Excel with AI if you know very well what Excel can do. So yes there is a need, but not as much as there maybe once was.
79/u/SolverMax said Wait until you find out about new lines (ALT+Enter) and indents (Space). =LET( _data, A2:A10, _threshold, C1, _rate1, C2, _rate2, C3, _total, SUM...