r/MicrosoftExcel • • Jan 28 '26 Mindblown

Day 6/30 inventory tracking in excel

34 Upvotes

r/MicrosoftExcel • • Dec 10 '25

(Excel/Word) Offline classes OR self learning through AI and Youtube

Post image
21 Upvotes

Hello everyone. I have around 15-day of free time in which I want to learn Excel and Word skills (basic Office ready things) I know few things here and there so newbie. Is it possible to learn both in just 15 days. I am free all day!!

Which option is best for me?

  1. Joining an offline class near my home

  2. Learning on my own through practice + guidance from AI tools. I have decade old computer with MS office 2016.

Which method gives faster and more practical results? Is offline classes really worth money and time? Any technique, free courses, or YouTube Channel name would be helpful. Thanks.


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 • • Dec 08 '25

New to Excel, looking for advice from the pros

18 Upvotes

Hi everyone. I’m in my 3rd year of college and recently decided to take Excel seriously. I know the basics, but now I want to sharpen my skills and learn it properly from the ground up.

Some of my friends keep saying AI will replace everything, so as a Gen-Z student I’m a bit confused. I wanted to ask the community: do you use any AI tools to help with Excel? If yes, which ones actually help, and what are some things AI still can’t do well in Excel?

Any advice, resources, or personal experiences would mean a lot. Thanks, and sorry if this sounds like a beginner question.


r/MicrosoftExcel • • Nov 20 '25

My complete stack for financial modeling that saves 15 hours weekly

16 Upvotes

I see a lot of tool posts where people list software they installed once. Here's what I genuinely use every single day for financial work and why finance specific tools beat generic ones.

Core applications: Microsoft 365 excel because I need the modern formula engine and cloud sync. Can't use older versions anymore after getting used to xlookup and dynamic arrays.

Automation layer: Endex for repetitive model building and data extraction from filings. Built specifically for finance so it understands financial statements and modeling conventions. Generic AI tools like copilot don't get this context. Power query for complex data transformations that repeat regularly.

Data sources: FactSet for market data and comps when I need institutional quality information. Yahoo finance api for quick price pulls. SEC edgar for company filings and detailed disclosures.

Productivity tools: Excel camera tool for linking live images across workbooks. Custom keyboard shortcuts using autohotkey. Named ranges for everything important so formulas stay readable.

Quality control: Xlookup with iferror for robust lookups. Conditional formatting to flag errors and outliers. Custom validation rules to prevent bad inputs.

Collaboration: Office 365 co authoring for models multiple people work on. OneDrive for version history. Teams for deal communication.

The key difference between finance specific ai and generic ai is understanding context. I tried microsoft copilot for excel and it was useless. Suggested wrong formulas because it doesn't know finance conventions.

Endex knows what dcf models should look like. Understands financial statement relationships. Can pull data from sec filings properly. That's why specialized tools beat generic ones for professional work.


r/MicrosoftExcel • • Jan 24 '26 Mindblown

Day 2/30 text split () in excel

15 Upvotes

r/MicrosoftExcel • • Nov 28 '25

I'm here for honest feedback—please don't be like ChatGPT giving me compliments for drinking water... haha

15 Upvotes

Hey everyone,

So I'm in my 4th year of college, and something happened two days ago that got me thinking.

I was chatting with my senior who's working now, and man, I had no idea how much people use Excel at work. Like, he uses it for literally everything—even designing websites! I was pretty surprised.

On my way back to my room, I kept thinking about this. So many people use Excel every day—corporate folks, small businesses, everyone. I started googling around and found these tools like Formula Bot where you describe what you need and it gives you the formula. Pretty cool, but you still have to manually apply it to your sheet.

Then I thought—what if there was something where you just upload your Excel file, type what you want done, and get the updated file back? Like, no copying formulas or doing manual work.


r/MicrosoftExcel • • Dec 27 '25

How to check if my Windows is original & can I use Excel 2024 for free?

14 Upvotes

Hi everyone,

I have an HP laptop (Windows installed already). I want to check whether my Windows is original / genuine or not.

Also I want to use Microsoft Excel 2024, but I don’t want to buy it right now. Is there any legal way to use Excel 2024 for free on original Windows? If yes, please guide me step by step.

Thanks in advance 🙏


r/MicrosoftExcel • • May 11 '26

Is there a way to remove copilot icon from bottom right? I know i can dock it to the side but i want it completely gone from my sight.

Post image
13 Upvotes

Microsoft is shoving AI in my face and i hate it.


r/MicrosoftExcel • • Apr 30 '26

Project Management Excel?

12 Upvotes

I am just getting started with a new company so I don't want to commit to a specific PM software until I get a feel for the team. We are also a very small team (5 people), so I think an Excel spreadsheet will suit us fine in the meantime. I am looking for a template that includes a dashboard, project sheet, tasks sheet, Kanban, Gantt, and individual tabs for employees to track their own projects/tasks. And of course, I want each sheet to automatically update when projects/task are added or modified (this is what I am struggling with as I have tried to build it out on my own). We categorize projects by product and State (we are in the US). I am willing to purchase a template, but I can't seem to find anything with everything I want (I don't want to track budget either). Also, I am open to suggestions on what I should be using. Thank you!


r/MicrosoftExcel • • Mar 08 '26

Please recommend good reference books to learn Microsoft Excel for advanced level. Also, please suggest which version of Excel is used by organizations & individuals world wide.

12 Upvotes

r/MicrosoftExcel • • Jan 28 '25

Living the Dream

Post image
12 Upvotes

r/MicrosoftExcel • • Mar 18 '26

Newbie student in Excel trying to learn it

11 Upvotes

Hello guys, I am a freshman majoring in finance. And I heard a lot of stuff that Excel is foundation of Finance, everybody tells that excel is the most important skill in finance industry, however I was considering to develop this skill within related subjects - like there are classes which are only about excel in my degree progress, but I don't want to wait untill those classes happen. So I decided to learn Excel(Financial Modeling) from zero by myself. I don't have any prior experience in Excel.

Could you please give me tips or just study guide how should I start and which topics should I cover. Is it better learning it via LinkedIn courses or YouTube channel, and after those theories where to apply these theories to practice, consequently learning it fully. I don't have opportunity to find an interrelated job or experience, because I don't have firstl valuable resume or skills. So I want to start with the Excel - upgrade it very advanced in several months, and then try to make some experience with excel


r/MicrosoftExcel • • Feb 12 '26

Calculation help

11 Upvotes

I need a formula to subtract a field of birth dates to calculate the persons age as of the current date? Do I need to put the dates in a certain formate to get this to work. I have never been to sharpe in math. Please help if you can.

Lost


r/MicrosoftExcel • • Jan 09 '25

Nothing excels like excel

Post image
11 Upvotes

r/MicrosoftExcel • • Jan 27 '26 Mindblown

Day 5/30 sum of sales in Seconds

10 Upvotes

r/MicrosoftExcel • • Jan 25 '26 Mindblown

Day 3/30 - conditional formatting in excel

9 Upvotes

r/MicrosoftExcel • • Jan 21 '26

I'm trying to recreate this hacked together Google Sheets chart as a sunburst in Excel

Post image
9 Upvotes

r/MicrosoftExcel • • Dec 02 '25

Excel newb.

9 Upvotes

Im trying to learn excel so I can make a spreadsheet that tracks my snow removal accounts. Im not sure if what I want to do is possible. Currently I have each customer's name and addresss across the top. The date of each snow will be listed along the left side. I would like to be able to put an X under each customer 's name after every snow, showing that their lot has been cleared. At the bottom of the sheet, I would like to keep a running balance of how much they are charged. Im not sure how to do that or if its possible without just putting in the amount in each cell and creating a formula adding each cell. Any help?


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 • • Jan 21 '26 Mindblown

This is not an promotion ... I kinda

8 Upvotes

Hi everybody actually I have tried many Llm to ease my excel work. Most of them are pretty good for basic and mediocure tasks. But they eat lot of tokens and yes there is copilot as well. So I was trying to build my own product and train and trying to make more accurate model and train it... But there is only one problem I'm still 20 year. And honestly I don't have money to spend on marketing and developers so I'm making this while studying so I need your help just try this and give me feedback eventually it will help our community if we could make something better.


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 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 • • May 02 '26

Qualification Routes

7 Upvotes

People who have got their Expert qualifications, how have you learned? I have been using Excel consistently for about two years, nothing high level but I have a good grasp on formulas (Ifs, XLookup, Index match, etc) and have touched on Macros for very basic automation and would love to further my experience. Is hiring a tutor the way to go or is there any other alternatives you would recommend? Thanks :)


r/MicrosoftExcel • • Dec 11 '25

Excel newb trying to make my life easier

7 Upvotes

I’ve been trying to make my spreadsheet that tracks my hours make more sense. I work two jobs, one of which requires 5% of my hours to be supervised by my boss every month to keep my job. I also track my hourly rate to predict my pay checks. I’ve been trying to figure out if there is a way to have excel track my call out rate as well. My monthly call out rate needs to be above 80% every month. But I’m not sure if something like that is even possible in excel. Maybe one of the pros could help me out? please message me and let me know if you can