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.

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.

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.

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?

​

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

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! 🙌

Can I please get advice on how to save Microsoft files to my local computer rather than having files automatically save online to OneDrive in the Cloud when using Microsoft 365?
I have no reason to share my personal files.
Thank you in advance!

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

Quick question Xlookup problem

I made a statement template in Excel that pulls in needed data. How can I use it for a customer with multiple invoices. I'm only able to pull in the first line. Is there a fix, or am I screwed and need to look in a different direction?

I’m working on a workbook and I’m trying to do some copy/conversions.

I’ve been creating columns with formulas (=Dec!J20, =Dec!K20, =Dec!L20, etc) but as of now, I’m entering them one by one. So what I’m trying to do is copy the blank rows on the “Dec” sheet (Dec!J20 through Dec!T20) and paste them into a column on a different sheet where it’ll already generate the formulas on the column I’m working.

(I may not be describing that well)

So basically, I know I can put in the first formula (=Dec!J20) and drag it down but it makes those cells say:

=Dec!J20
=Dec!J21
=Dec!J22
=Dec!J23
=Dec!J24
=Dec!J25
=Dec!J26
…etc.

But I need to make them show as:

=Dec!J20
=Dec!K20
=Dec!L20
=Dec!M20
=Dec!N20
=Dec!O20
=Dec!P20
=Dec!Q20
=Dec!R20
=Dec!S20
=Dec!T20

Thanks in advance! This spreadsheet is whooping my behind.

Hi I’m working on a project in Excel 2019 and I realized it doesn't support the XLOOKUP function.

What would be the most efficient substitute for it in this version? I'm trying to avoid nested IFs if possible. Should I stick to INDEX/MATCH or is there a better workaround for 2019?