r/excel • • 8h ago

Discussion Excel and AI in professional world

16 Upvotes

Hello everyone,

I’ve been interested in Excel for a while now, but I’m starting to wonder whether the time I’m spending on it is worthwhile. With the advances in AI, are Excel skills still valued in the workplace? I’m thinking in particular of sectors such as finance and data analysis


r/excel • • 21h ago

unsolved how do I get rid of this extra space to the very left of row headings (i.e., 1 2 3 4 5)?

0 Upvotes

For some reason I now have space to the left of the row headers and above the column headers

i can of course change the column or row heights but I want that 1 2 3 4 5 etc to move closer to the left part of the worksheet where it was before

any idea how to get rid of it?


r/excel • • 8h ago

Waiting on OP How to fix a graphic issue that looks like this

1 Upvotes

I was in the middle of making graphs in my excel and suddenly it just dissapears all of the sudden. Is this normal? Is there any way of fixing such occurace? It may have been a misclick of buttons but im not entirely sure of what could have caused this to happen

dissapeared excel in some of the sheets
my excel problem in which the graphs just doesn't show and when i switch sheets it just completely dissapears untill i close and open excel again

I would very much appreceate any sort of response towards fixing my problem, thank you


r/excel • • 14h ago

Discussion Niche Trendline Options Please!

1 Upvotes

I really think there should be more options for trendlines, specifically an option to set trendlines between separate data points / end trendlines earlier. I've had to do this in so many of my labs and I'm sure it probably has uses outside of science. Unless I guess you count all data as science. But you get what I mean. It especially sucks when I'm completing a part of my assignment and I already made the graph and the trendline and like everything else and then I have to delete half of it and do a weird trick. Sure that's completely my fault but sometimes it's nice to account for big stupid idiots like myself, there are many of us out there.

I know there's that pretty simple workaround where you just make a new line with the range you want to include and make that the trend line. But, that doesn't fix your problem if you need to use any of the trendline features like say adding the equation, then you have to make a new trendline just for that and then make it invisible. This is a very minor complain,t I just wanted to see if anyone else agrees or has had the same thought.


r/excel • • 3h ago

unsolved File remade itself and deleted data after sharing it with someone.

2 Upvotes

A few weeks ago I had a file (on excel) which I shared with someone because they wanted the file template for uni. Then, right after, when I went back to my excel multiple rows of data had been deleted and the file thought that it was made at the time it was shared. I tried to look for older versions through one drive but there were none. I have never been able to recover this data and only still had it because of a screenshot I took.

Has anyone else ever had this problem and if so is there a way to prevent it from happening again or even getting the file back, because it really freaked me out and would have cost me part of my grade had I lost it.

Any help would be appreciated thank you!


r/excel • • 12h ago

unsolved Excel is automatically converting my cells to subscript

2 Upvotes

I have an issue where excellent is automatically converting my cells to subscript.

If I type 'tval =' into a cell and hit enter, it will automatically convert the cell toright justified and 't(val) =' where all bracketed text is subscript.

I have tried turning off all auto format options to no avail.

This is a clean install of miscosoft Excel as of today. I have had no prior issues with Excel doing this, and it does not do the same autoformatting on the browser version. This is only on the desktop version.

When I try and remove the subscript, it automatically converts it again.

Each conversion to subscript removes my ability to control Z and wipes my change history.

I need a specific subset of letters subscript, and I can not get it to work as it constantly re-formats it back to its automatic format.


r/excel • • 23h ago

Discussion After LET, I tried LAMBDA - here is a reusable formula I made

80 Upvotes

I made a little reusable function for adding tax, and saved it in Name Manager as TaxCalc:

=LAMBDA(amount, amount*1.08)

Then in a cell I can just type:

=TaxCalc(100)

It returns 108, and I can reuse it anywhere without copying the formula around.

I am still learning this one, so what do you actually use LAMBDA for? Is it worth it for one-off calculations, or only when you reuse the same logic a lot?

I looked up what Lambda meant and why it is used for this purpose and the answer was quite interesting:

Lambda is the Greek letter λ, and the name comes from maths, not from Excel.

In the 1930s, a mathematician named Alonzo Church invented a system called lambda calculus. It was a way to describe computation using only functions, before modern computers existed.

In that system, λ was the symbol used to say "here is a function". So λx. x+1 meant "a function that takes x and returns x plus 1". The λ was just notation for "make a function".

That idea stuck in programming. In Python, JavaScript, and a lot of other languages, a "lambda" is an anonymous function, a function you define on the spot without giving it a permanent name in code.

Excel borrowed the same term. LAMBDA lets you define a function right in a formula, with parameters and a calculation, instead of writing the same logic over and over in cells. When you save it in Name Manager as TaxCalc or FACT, you are just giving that anonymous function a name so you can call it later.

So the name is a nod to Church's λ, and it basically means "a function you define here, on the fly".


r/excel • • 21h ago

solved Referencing cell values across multiple sheets

3 Upvotes

I am using excel for budget tracking. For each month, I create a new sheet (Nov, Dec, etc) that I copy from a "Template" sheet. I then have an additional independent sheet for tracking my credit cards. Using the credit card sheet, I'm able to calculate my interest charge based on my credit card balance.

What I don't know how to do:

  1. If I put a credit charge on my NOV sheet, I want it to update the balance on my Credit sheet too, but I copy/make a new sheet every month, so the reference cell wouldn't stay the same.

    • How to tie in my other sheets to update my credit card balance on my credit sheet, when I use a new "monthly" sheet (copied from template)? To create the formula it wants to reference a specific cell (NOV!G2) which of course will only work for November, unless I manually update this every month. Is this the only/best way?
    • I'd want it then to circle back and update values on the template/monthly sheet.

      • Spend in "November" updates "Credit" sheet, which updates "November" sheet with new balance (including updated interest based on balance, see next).
  2. When I try to reference the amount after interest into another sheet, it shows up as 0:
  • I used simple interest formula: =-FV(0,H2,(B2*D2),B2) = 100. But when I try to reference that total value after the formula (100) into any other sheet, it says 0. I can paste as value, but that won't update based on any changes from my "credit" sheet. I seem unable to just reflect the cell "as it is" with the formula calculation on my "Credit" sheet.

So what I have: Total credit card balance with interest creating "new total" on my credit sheet. But I can't get "new total" to populate on other sheets, because it references the formula on my credit sheet.

And, how can I get my credit sheet to update based on spending, and back into, sheets of various names?

(hopefully I explained this well enough)


r/excel • • 23h ago

Novelty Film made entirely in Excel...

72 Upvotes

I came across this and thought it was interesting, if it is true:

https://vimeo.com/1241981102?fl=pl&fe=sh


r/excel • • 7h ago

Waiting on OP Using Upslide together with openpyxl wb manipulation

2 Upvotes

At my job, we use Upslide to automatically update charts in powerpoint that come from a datamodel in excel. This datamodel is built with a tool that uses Openpyxl. Because Openpyxl 'rebuilds' the xlsx file and skips all components it doesn't recognise, the Upslide links between powerpoint and the and the excel are lost. This happens when we update a datamodel with new data. Manually reconstructing the links each time costs a lot of time.

Does anyone have a solution to not have to reconstruct the links, while also keep using openpyxl?

Other python packages for excel don't seem to fit in our case (such as xlwings)


r/excel • • 10h ago

unsolved Formula to generate a rolling list for task allocation

7 Upvotes

Hi everyone,

As a starting point I'd say I'm better than average at excel but certainly a long way from being good at it.

At work I'm in charge of maintaining our spreadsheets which show the tasks we've been allocated. Ideally I'd like to create a formula to show who's next on the list to get a task.

For one of our teams I was able to do this fairly easily using a lookup formula to show who last received a task and an IF string to pick the next person - If person A was last allocated, Person B, if person B was last allocated, Person C and so on before it loops back around to Person A.

The difficulty I have is the second team is bigger and the task allocation needs to reflect working pattern - i.e. one person needs 80% of what a 'full' allocation would be.

Is there a better way to do this, or is the IF string the best way to go?

There are 10 people in the team and 2 of them have non-standard working patterns. I think I worked it out that the IF formula would have to have around 50 conditions to capture everything.

I hope this is enough info but if there's anything else that would be helpful please let me know.


r/excel • • 15h ago

unsolved Can I have a symbol (with a number) in one of my cells and have another cell use that cell for a formula?

8 Upvotes

I have a column for a time A and another column for time B. Basically, I am finding the duration between the 2 time points. What I did was subtract the latter from the former. My problem is some of the data are only an approximate, so I would like to use the symbol '≈.'

I would like to be precise so I can see which data are an approximate only. But as seen in the screenshot, the formula shows an error. How can I continue with this formula?