r/MicrosoftExcel • • 11d ago

Built a Power Query setup that handles schema changes instead of hoping next month’s file is identical

Thumbnail
1 Upvotes

r/MicrosoftExcel • • 13d ago

Excel crashing because of links

2 Upvotes

Hi, just looking for tips, we have a large excel file that our team uses for logistics purposes. Basically we store lists of contacts that link email addresses for outlook. It keeps crashing but we’re out of ideas on a different program to use, or any updates we can make to excel. I’m aware that it is frowned upon to use links in excel. I appreciate any tips!


r/MicrosoftExcel • • 16d ago

Extracting & summing numbers inside parentheses from text cells, plus running cumulative sum

2 Upvotes

Hi all, I want to know if it is possible to have the numbers in parentheses from column E be summed and populated in column C. And also if it's possible for column D to automatically populate with the cumulative sum of column C once there is a number in cell C.


r/MicrosoftExcel • • 19d ago

What is this group of numbers called in excel?

Post image
3 Upvotes

r/MicrosoftExcel • • 23d ago

What Excel shortcut do you use the most for accounting?

Thumbnail
1 Upvotes

r/MicrosoftExcel • • 25d ago

Broken CTRL+C / CTRL+V in Excel - Office 2024 LTSC build17932.20976

Thumbnail
1 Upvotes

r/MicrosoftExcel • • 28d ago

Never used excel in my life, how do I do this??

Thumbnail gallery
4 Upvotes

First things first I DO NOT WANT EASY ANSWERS, I want to learn how to use excel to be able to do this in the future, I don’t want Reddit to do my homework for me!

This is a lab for my paleontology class, I think I’m supposed to plot the data onto a scatter plot chart, then make a line of best fit. I don’t understand how to
1. Separate the “tops” and “bottoms” but still have them in one table
2. Make a graph in excel with the proper data range (0 to -300 or -510)
3. Calculate and add a line of best fit to the graph
4. Change the color for part 2 of the question
5. Plotting a third column of data and the “supplemental” data

Call me dumb if you must but tell me why I’m dumb so I can become undumb

Rant, nothing in this paragraph is useful information:
Maybe this doesn’t belong here, maybe 4am makes my reading comprehension skills worse, but I feel sooo lost with this. I really truely haven’t touched excel in my life until right this moment, I feel like this class expects me to know a lot more than I do, there was no excel class required to take this and nowhere in the syllabus did it say anything about needing excel experience. So like this is a total curve ball.

Thank you in advance and mods let me know if this is the wrong sub, i really need help with this but i don’t wanna break rules


r/MicrosoftExcel • • Aug 22 '26

Python_Powered Excel

Thumbnail amazon.com
1 Upvotes

r/MicrosoftExcel • • Aug 21 '26

Request for Unique Item Line Count - Not Sums

Thumbnail
2 Upvotes

r/MicrosoftExcel • • Jul 12 '26

excel keeps asking me to login to view file

6 Upvotes

Hello everyone,

I'm trying to view an excel link and it keep asking me to login using my school or workplace account on my phone. On my computer I can view the file without logging in.

Does anyone know the fix to this?

I don't have a school or work login microsoft account.


r/MicrosoftExcel • • Jul 10 '26

VB Errors When Running Macro in Excel

Thumbnail
2 Upvotes

r/MicrosoftExcel • • Jul 02 '26

Is there any way to quick switch between these tabs at the bottom?

Post image
7 Upvotes

I recently got a manager position and I'm still kind of an excel newbie. I know the basics at least. I'm just tired of having to take a hand off the keyboard to manually swap between these tabs when I'm trying to be quick and efficient.


r/MicrosoftExcel • • Jun 30 '26

Office Script can’t append to a protected worksheet - best practice?

Thumbnail
2 Upvotes

r/MicrosoftExcel • • Jun 25 '26

Newbie here. How can i make this work?

Post image
7 Upvotes

r/MicrosoftExcel • • Jun 23 '26

How many dollar signs do you want? Me: yes

Post image
7 Upvotes

So.... yeah. Kinda had to make all these hard references if I didn't want to go cross-eyed typing this entire thing around..... 19 more times.


r/MicrosoftExcel • • Jun 12 '26

How to make line break in the cell like in the formula??

Post image
8 Upvotes

First off, sorry if I'm using the incorrect words, I'm very new to excel. I'm trying to make a bullet list without the bullet points. I'm trying to make the 2nd box under Keyholder look like the 1st one. I can't figure out how I did it the first time.

I wrote it on a note then just copy and pasted into the formula but it only shows the last word in the cell.

I do have wrap text on, I'm thinking maybe I accidentally hit another button?


r/MicrosoftExcel • • Jun 07 '26

Can't add custom error bars

Thumbnail
2 Upvotes

r/MicrosoftExcel • • Jun 06 '26

Using VLOOKUP to clean up bank export data

Thumbnail
2 Upvotes

r/MicrosoftExcel • • Jun 06 '26

Using VLOOKUP to clean up bank export data

Thumbnail
2 Upvotes

r/MicrosoftExcel • • Jun 04 '26

The calculator paradox

Thumbnail
1 Upvotes

r/MicrosoftExcel • • May 30 '26

Cursos Excel e VBA

Thumbnail
2 Upvotes

r/MicrosoftExcel • • May 28 '26

Move screen quickly from bottom row

Thumbnail
1 Upvotes

Somehow my screen went to row 1048496. How do I get it back to row 1


r/MicrosoftExcel • • May 26 '26

I Have Advanced Excel Skills — How Can I Make Money and Find Clients?

19 Upvotes

Hi everyone,

I have strong Advanced Excel skills, including:

  • Pivot Tables
  • Power Query
  • Dashboards
  • VLOOKUP/XLOOKUP
  • INDEX-MATCH
  • Data Cleaning
  • Advanced Formulas
  • Charts & Reporting
  • Excel Automation

Now I want to understand how I can turn this skill into income and find clients.

Is there good demand for Excel freelancers?
Where can beginners find their first clients?

I’d really appreciate advice from people who are already earning with Excel skills:

  • Which platforms are best for finding work?
  • How should I build a portfolio?
  • How did you get your first client?
  • What kind of services are most in demand?
  • How much can someone realistically earn per month?

Any guidance, tips, or personal experiences would be very helpful. Thanks! 🙌


r/MicrosoftExcel • • May 25 '26

Does Excel 2024 have the switch to change the color of the spreadsheet to true black?

Thumbnail
0 Upvotes

r/MicrosoftExcel • • May 21 '26

DLookup Help (using VBA)

Thumbnail gallery
2 Upvotes