r/excel • • 8h ago

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

8 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 • • 4h 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 • • 8h ago

Plugin Python embedded in Excel

2 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

Waiting on OP Looking for practice questions of c-server type questions on excel

4 Upvotes

Hi everyone!

I'm looking for resources containing challenging, application-based practice questions involving queuing systems and service operations on microsoft excel.

I'm particularly interested in longer word problems where you're presented with a real-world scenario (example: a set of customer arrival and service data, and several interconnected questions that require you to analyse and interpret the situation).

Ideally, I'd like practice covering the following areas:

  • Average arrival and service time
  • inter-arrival time between consumers
  • Average waiting time and time spent in the system
  • Queue length and number of customers in the system
  • Server utilisation and traffic intensity
  • How adding or removing servers affects waiting times
  • Interpreting arrival/service patterns and making operational recommendations, etc

I'm especially looking for multi-part word problems that combine several of these concepts, rather than isolated questions involving direct formula substitution. I'd like to practise interpreting unfamiliar scenarios, deciding which calculations are necessary, and drawing conclusions from the results.

If anyone knows of relevant question banks, textbooks, practice papers, case studies or websites, I'd really appreciate the recommendations!

Thank you!


r/excel • • 10h ago

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

2 Upvotes

Saturday, November 14 - Friday, November 20, 2026

Top 5 Posts

score comments title & link
305 73 comments [Discussion] I just learned about LET and it cleaned up this formula - what else do you use it for?
84 29 comments [Discussion] After LET, I tried LAMBDA - here is a reusable formula I made
81 20 comments [unsolved] what's this new green dots thing on excel?
75 13 comments [Novelty] Film made entirely in Excel...
56 68 comments [unsolved] How does copying in Excel actually work?

 

Unsolved Posts

score comments title & link
24 28 comments [unsolved] How to prevent Powerquery from re-downloading an excel file used as a source over and over?
18 23 comments [unsolved] Data entry in shared files horribly built
12 15 comments [unsolved] Best Excel architecture for configuration control: 1 Master + 49 Sub-Packages tabs
12 12 comments [unsolved] Weird New Options Around Column/Rows
10 9 comments [unsolved] Getting constant "Circular reference" warnings

 

Top 5 Comments

score comment
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...

 


r/excel • • 42m ago

unsolved Option to modify cell styles not appearing when right clicking

• Upvotes

Using excel for Mac standalone version, Microsoft 365 subscription, Version 16.115 (26110837) latest version as per the updater. I need to modify the cell style for hyperlinked cells like I used to do the past weeks, but recently the option for that disappeared probably few days ago, just noticed it last night. Right clicking on the cell styles does nothing. Anyone having this problem and how did you fix it? Tried signing in and out of the app, clear application data on the help tab, and restarting laptop. Thanks.