r/MicrosoftExcel • u/madalenafortunato • 8d ago
AI’s impact on data visualization & decision-making (dashboard/BI tool users, 18+)
r/MicrosoftExcel • u/madalenafortunato • 8d ago
r/MicrosoftExcel • u/logindumb333 • 9d ago
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 • u/-SpaghettiCat- • 18d ago
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 • u/conor-robertson • 21d ago
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 • u/friendlytoss • Oct 12 '26
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 • u/TermRemarkable665 • Oct 07 '26
r/MicrosoftExcel • u/TermRemarkable665 • Sep 24 '26
r/MicrosoftExcel • u/schmij16 • Sep 22 '26
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 • u/hanners_7 • Sep 19 '26
r/MicrosoftExcel • u/PresidentofBaddies • Sep 16 '26
r/MicrosoftExcel • u/browndusky • Sep 12 '26
r/MicrosoftExcel • u/SelfMan_sk • Sep 10 '26
r/MicrosoftExcel • u/Dweebsmcbeebs • Sep 07 '26
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
Separate the “tops” and “bottoms” but still have them in one table
Make a graph in excel with the proper data range (0 to -300 or -510)
Calculate and add a line of best fit to the graph
Change the color for part 2 of the question
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 • u/BookPurrson • Aug 21 '26
r/MicrosoftExcel • u/Dry_Arrival3518 • Jul 12 '26
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 • u/PeasantCody • Jul 02 '26
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 • u/fabtec-lazer • Jun 30 '26
r/MicrosoftExcel • u/ledfwil1 • Jun 23 '26
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 • u/Fun_Trash_123 • Jun 12 '26
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 • u/msclayton77 • Jun 06 '26