r/MicrosoftExcel • • 8d ago

AI’s impact on data visualization & decision-making (dashboard/BI tool users, 18+)

Thumbnail
reddit.com
1 Upvotes

r/MicrosoftExcel • • 9d ago

help with putting an equation in

Thumbnail
gallery
3 Upvotes

hi i was wondering if yall could help me understand how to put this equation into excel, it gives me an error every time i try and i have no idea why, i tried to ask my teacher but he didnt respond and he really hasnt taught me anything in the whole class


r/MicrosoftExcel • • 18d ago

Excel Selected Cell Randomly Moves Up When Switching Between Windows (Windows 11)

2 Upvotes

I've noticed a strange issue with Excel over the past week or so (posting this on October 30, 2026), and I'm wondering if anyone else has experienced something similar.

I'm using Excel on Windows 11. While working in a spreadsheet, I'll have a particular cell selected. If I switch to another application or window, leaving Excel running in the background, I've noticed that when I return to Excel, the selected cell has somehow moved upward by several rows.

It seems to move up approximately 5 rows, although I think the number varies. From what I've observed, the selected cell generally stays in the same column, but the row changes.

It's a relatively minor issue, but it's annoying because I lose my place in the spreadsheet and have to figure out which cell I was originally working on.

I don't recall experiencing this behavior before about a week ago. I'm not sure whether it's related to a recent Excel or Windows 11 update or something else.

Has anyone else experienced this? Is there a setting or known issue that could be causing the selected cell to move on its own when switching between applications?

Thanks in advance for any help!


r/MicrosoftExcel • • 21d ago

I turned Excel practice into detective cases

2 Upvotes

About five months ago I launched QueryCase, originally as a way to make learning SQL a bit more fun by turning lessons into detective cases. Based on personal experience, I always found learning SQL outdated and very textbook heavy.

From the SQL course:

  • 2,500+ people have signed up, across 117 countries

  • About 70,000 queries written and graded

  • Over 17,500 cases, drills and exams solved

  • 500+ people have passed the free Rookie exam and earned the certificate.

One thing I didn’t expect was how many people kept asking:

“Could you do this for Excel too?”

A lot of people learning SQL were also learning Excel for data analyst roles, so over the last couple of months I ended up building an entire browser-based Excel course that runs solely in browser without the need of paying for Excel.

The idea is basically the same: rather than watching someone use Excel in a video and trying to copy them, you’re given a spreadsheet, a problem to solve, and your work is checked automatically.

There are currently 57 Excel cases, covering things like:

  • formulas and cell references

  • IF / logical functions

  • lookups including XLOOKUP

  • SUMIFS / COUNTIFS

  • cleaning and working with data

  • pivot tables

  • progressively harder business-style problems

Everything runs directly in the browser, so there’s nothing to download or configure.

So far people have completed 2,500+ Excel cases, which has been really cool to see considering Excel wasn’t even part of the original plan for QueryCase.

I’ve also structured it into ranks, with the first rank completely free and an exam + certificate at the end.

I’m posting here mainly because I’d really like feedback from people who actually use Excel regularly.

Are there any functions, concepts, or types of real-world Excel tasks you think are poorly taught by most courses? I’d especially love ideas around the point where someone goes from “I know Excel formulas” to “I could actually use Excel confidently in a job.”

If anyone wants to try it and tear it apart, it’s QueryCase, the first Excel section and certificate is completely free.

Cheers 😄


r/MicrosoftExcel • • Oct 12 '26

Looking for advice on leveraging AI for Excel in a price-sensitive, third-world country

4 Upvotes

I work for a training company in a price-sensitive, third-world country and have been conducting training in MS Excel for close to 2 decades. My company has asked me to design Excel training that teaches how to use AI to improve productivity. Ethical considerations aside, it’s something I have been thinking about for a while.

The main roadblock I see is the average purchasing power of participants in our market. Right now the cheapest Copilot plan is USD 99.99/yr for MS 365 Personal. The cheapest plan for Business or Enterprise is USD 18/user/month for MS 365 Copilot Business (billed at USD 216/user/year). I’ve been casually speaking with the participants in training sessions and most are happy with the free chatbot versions of Copilot/ChatGPT/Gemini that almost no one would upgrade to a paid subscription to integrate AI with Excel - they describe their problem to the AI, send screenshots or upload files and then try and implement the solution that’s returned. 

It’s similar in the business/enterprise context. Larger organisations may have paid for AI subscriptions for their employees but those are few in number. Most businesses in this market are classified as Small-Medium-Enterprises (SMEs) and feedback from participants is that their management would not approve of the cost.

It’s worth mentioning that my training company does not provide computers instead requiring participants to bring their own laptops with valid Excel licences (we standardize things as much as possible e.g. Windows only, no tablets etc…) This means if we design a training that requires a paid Copilot subscription, then it is up to the participants to buy it for themselves which I don’t think many will.

After speaking with management, they are open to designing a training that uses the free AI chatbots. I’m fine with that but don’t know how much value that would add to what people are already doing. I’m quite sure this strategy is management trying to revive Excel training which used to be top-sellers (demand fell off since COVID) and they see other Excel training incorporating AI so want to follow suit.

So right now the most viable option is to create training that uses free AI chatbots. But I’d like to hear the opinions of others on the sub - what other options do you see for a price-sensitive, third-world market?

And yes, I did ask AI how Excel users can leverage AI without paying for expensive subscriptions and it basically said “use the free chatbots”.


r/MicrosoftExcel • • Oct 07 '26

Excel Dashboard Design Tips – Glassmorphism, Dark Mode, Custom Slicers & Dynamic Summaries

Thumbnail
reddit.com
1 Upvotes

r/MicrosoftExcel • • Sep 24 '26

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

Thumbnail
reddit.com
1 Upvotes

r/MicrosoftExcel • • Sep 22 '26

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 • • Sep 19 '26

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 • • Sep 16 '26

What is this group of numbers called in excel?

Post image
3 Upvotes

r/MicrosoftExcel • • Sep 12 '26

What Excel shortcut do you use the most for accounting?

Thumbnail reddit.com
1 Upvotes

r/MicrosoftExcel • • Sep 10 '26

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

Thumbnail reddit.com
1 Upvotes

r/MicrosoftExcel • • Sep 07 '26

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

Thumbnail
gallery
5 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 reddit.com
2 Upvotes

r/MicrosoftExcel • • Jul 12 '26

excel keeps asking me to login to view file

4 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 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 reddit.com
2 Upvotes

r/MicrosoftExcel • • Jun 25 '26

Newbie here. How can i make this work?

Post image
6 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
reddit.com
2 Upvotes

r/MicrosoftExcel • • Jun 06 '26

Using VLOOKUP to clean up bank export data

Thumbnail reddit.com
2 Upvotes