r/excel • • 9h ago

Discussion Excel and AI in professional world

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

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

4 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 • • 1d ago

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

81 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 • • 1d ago

Novelty Film made entirely in Excel...

76 Upvotes

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

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


r/excel • • 12h ago

unsolved Formula to generate a rolling list for task allocation

6 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 • • 16h 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?

11 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?


r/excel • • 8h 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 • • 13h 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 • • 10h 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 • • 1d ago

Discussion I just learned about LET and it cleaned up this formula - what else do you use it for?

342 Upvotes

I have been writing long formulas that repeat the same calculation over and over, and I just found LET.

Before, I had this to work out a bonus based on a total:

=IF(SUM(A2:A10)>1000, SUM(A2:A10)_0.1, SUM(A2:A10)_0.05)

SUM(A2:A10) is in there three times, which makes it hard to read and easy to break if I change the range in one place and not the others.

With LET, you name the calculation once, then use the name:

=LET(total, SUM(A2:A10), IF(total>1000, total_0.1, total_0.05))

total is just a name I picked. LET lets you define as many names as you want, then use them in the final calculation at the end.

It works in Microsoft 365 and Excel 2021 and later. Older versions will show a #NAME? error.

What do you use LET for? I am curious what a good second example is, especially with FILTER or XLOOKUP where the same lookup gets repeated.


r/excel • • 16h 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 • • 22h ago

solved Referencing cell values across multiple sheets

2 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 • • 1d ago

Waiting on OP Trying to link a drop down list of employees with different info from the same work sheet

8 Upvotes

Hey everyone,

I’ve been trying to figure out how to link a drop down list of names with specific info from the same worksheet. It is going to be a chart with a list of absences, sick time, etc so we can track things easier.

I’ve been reading about how to link it to a master table but the problem is the master table is what I’m trying to bring up when I click each name in the drop down within the same table.

For example, if I click on one person’s name in the drop down, I want it to pull up the specific info I typed for that employee previously within that same worksheet.

So if I put a 2 in the absence row for John Doe when I have his name clicked in the drop down, then I click another employees name that I typed 3 absences previously I want a 3 to appear in the absence row. Then if I click back to John Doe, I want the 2 to repopulate in the absence row.

Sorry if this is long winded but hopefully the example helps make more sense of what I’m trying to do

Thank you for any help you can give me


r/excel • • 1d ago

solved How to paste data from another sheet into filtered cell? (Yes, again...)

9 Upvotes

Hello everyone,

This is our usual “How to paste data from another sheet into filtered cell?”

 

WHAT I HAVE

I have a lot of txt files which must alternate between a line in French and a line in English.

I think Excel is the best tool to work with that, but maybe I’m making a mistake.

 

So, I have a very simple situation:

In Sheet1I have:

A first column called “LANGUAGE” with two types: FR and ENG.

A second column called “TEXT” with a sentence in its respective language.

 

In Sheet2 I have the translation.

 

WHAT I DO

  1. I filter the cell I need on Sheet1
  2. I select only the visible cell on Sheet1

(Home --> Find and Select --> Go to special --> Tick "Visible Cells Only")

  1. I copy my data from Sheet2

  2. I paste dateSheet2 on the filtered cells into Sheet1

 

PROBLEM

Only the first line is paste over and over.

And the second line is still paste into the unfiltered cells.

 

What am I doing wrong?

Do I need to use a VLOOKUP or VBA function?

Should I use something else than Excel ?

 

Thanks !

EDIT:

Indeed, the simplest solution is to add a helper column and using sort by LANGUAGE or HELPER depending on the case!

Thanks to everybody!


r/excel • • 1d ago

Waiting on OP Sheet for pulling filter sizes and quantities

2 Upvotes

Hello everyone, I’m an industrial HVAC technician who has a lot of areas with a lot of filters. I need a way to categorize the filter sizes and quantities with corresponding areas and be able to quickly input which areas I changed filters at and have the output be the filters I changed and how many I changed.

For example:

Say I have 3 areas, Area A, B, and C. Area A has 3 20x20s and 2 24x24s. Area B has 6 20x20s and 6 16x25s. Area C has 4 16x20s and 2 16x25s.

Lets say I went to Area A and B that day but don’t want to add up the filter sizes and quantities. I would put in “Area A” and Area B” and the excel sheet would
output 9 20x20s, 2 24x24s, and 6 16x20s.

How would I set that up?


r/excel • • 1d ago

solved Difficulty exporting paginated web page to single excel worksheet

2 Upvotes

I'm trying to export data from a web page into a single excel worksheet so that I can do various sort functions to view the data a bit more easily. There is something like 27 pages with 200 entries each. I've tried the suggested power query that pops up when I google this question, but I can't get it to work for some reason. I'm wondering if someone who knows excel better than I do can help me out and provide some kind of step by step guide. Many thanks in advance to whichever one of you wizards can solve this!

Some more info, the URL is of the page number type... "page=x"


r/excel • • 1d ago

solved Looking for advice about automated data set comparing

2 Upvotes

Hi, i have a friend i noticed cross referencing two data sets, so like a company name in both remains the same, but they are manually checking the following "serial number" in the next colum to make sure they are the same. was thinking this sounds like something you could automate with excel, but I dont really use it. basically wondering if there is a way. thanks in advanced (info is private so ai is a no go)


r/excel • • 22h 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 • • 1d ago

unsolved what's this new green dots thing on excel?

92 Upvotes

haven't seen this until today.. is this a new update? how can i disable it?


r/excel • • 1d ago

Waiting on OP How to preview macro-enabled Excel files?

5 Upvotes

The previewer in file explorer only shows a blank preview for macro-enabled Excel files, no warning message, just blank. I installed the latest Windows update where you can click on "Show preview anyway", but this only works for pdfs, not for macro-enabled Excel files. Does anyone know a solution for this?


r/excel • • 1d ago

Waiting on OP Excel Conditioning Format Rule Highlight with Curser

2 Upvotes

I set up conditional formatting so when I select a cell, it'll turn yellow. I want to select multiple cells and have it turn yellow.

This is the formula l'm using for my conditional rule
=AND(COLUMN()=CELL ("col"), ROW()=CELL("row"))

Is there a formula that can select more than one cell??
I then format to highlight yellow and bold


r/excel • • 2d ago

Discussion Built my first interactive Excel dashboard and would appreciate some feedback.

48 Upvotes

I'm currently working through a few excel courses and before I overload my brain with more information, I created this dashboard to practice what I have learnt so far.

I used a Superstore dataset I found on Kaggle, which came with the following business scenario:

"With growing demands and cut-throat competition in the market, a Superstore Giant is seeking your knowledge in understanding what works best for them. They would like to understand which products, regions, categories and customer segments they should target or avoid."

The dashboard includes:

  • PivotTables and PivotCharts
  • Slicers and a timeline
  • Dynamic KPI cards
  • Sales, profit and profit margin analysis
  • Historical performance trends

My goal is to develop my Excel skills further and eventually use them for real-world business analysis projects.

I'd appreciate constructive feedback on:

  1. Dashboard layout and readability
  2. Choice of charts and KPIs
  3. Functionality and user experience
  4. Any Excel best practices I might have overlooked

I'm still learning, so any suggestions would be appreciated.


r/excel • • 1d ago

solved Can't figure out why Excel data pack analysis won't work for a downloaded sheet originally from google docs

6 Upvotes

I downloaded a spreadsheet from google docs into MS Excel and have found I am unable to use the data analysis pack. I am continuously getting the error that there is non numerical data in my columns. I've checked for blanks or other oddities, column length, formatting the columns into numeric, different test (regression, descriptive, T), and different columns.

When I downloaded the sheet, I used the google doc conversion to MS Excel from the download options. (I also downloaded a second time just to check)

Is there an incompatibility between google sheets and MS Excel files or something else I am overlooking?

I'm a little hesitant to post the xlsx file as it company related data. If there's anything else I need to add, someone please let me know what it is.

Update:

I have tried the paste special Multiply, data validation to either whole number or decimal depending on the column, I have the labels box ticked, used the count formula and the read out on two separate is 0, and the columns do have a sum in the status bar. Unfortunately, I am still getting the same error when I try to run a regression test.

Second update:

I have done data validation on every part of the sheet. I still can't run a regression test.

Update:

I've had some success running VALUE() on the columns and am getting #VALUE! popping up in numerous seemingly random clusters, so I have made progress. I am going to have to set this aside for a bit but will update if I figure out what is causing the issue in the near future.

Setting to Solved for now

Thanks everyone for all your help in trying to work it out!


r/excel • • 2d ago

solved Best way to teach macros since you cannot undo?

31 Upvotes

I'm teaching a college level Excel class. On Friday I am teaching Macros. I am going to have two worksheets of the same data, and on worksheet 1 we will record a simply macro making visual edits (bold, coloring) and adding a graph on the data. Then on sheet 2 we will run the macro.

The problem is that if a student makes a mistake recording the macro, you cannot undo sheet 2 after running the macro. At that point, you cannot undo sheet 1 either.

Is there an easy way to be able to get back to 'fresh data' that doesn't involve VBA or having tons and tons of replicated worksheets? I'm pretty sure replicated worksheets will get confusing, and I am not sure how many worksheets they will need for a test and they may run out. I am also not sure I can trust them to keep replicating worksheets if they need to keep recording/running.

Thanks!

Solution: What I decided to do is record a macro called 'Paste' that would select the data in Sheet 1, open a new worksheet, paste the data into the worksheet, and alter column widths so some data was not #####. I stopped the recording. Then I hid sheet 1 so it is always available to copy from, and I am going to have students learn how to run a macro to create the sheet of data so they can always load up a fresh sheet.


r/excel • • 1d ago

solved Why does my graph not show anything?

2 Upvotes

i feel like i tried everything. why doesn't it show anything?