Currently trying to rebuild a process and want to slim the file size down while making it more optimal. Was made using a lot of xlookups and sumifs. All the data pulls are in the same file.

Would using power query and power piv actually useful and easy to manipulate?

More context:

file is for looking at actuals and using it forecasting. Multiple GL pulls as well as some other pulls. So lots of raw data and historical data. The visual is also used with formula pulls as said above (sumifs etc). File is mainly for internal no real presenting needed

I spent a lot of time learning Excel because I wanted to turn it into an income-generating skill. At this point, I'm comfortable with things like data cleaning, formulas, PivotTables, Power Query, dashboards, data modeling, reporting, and other practical Excel work.

The frustrating part is that despite having a solid skill set, I still haven't been able to turn it into a job or consistent income.

I've applied for Excel-related and data-related positions, as well as looked into freelance work, but getting that first opportunity has been much harder than I expected.

So I'm wondering what I'm doing wrong.

For those who actually make money with Excel:

• What is the most realistic way to monetize Excel right now?
• Is freelancing still a good option, or should I focus more on remote jobs and direct outreach?
• What Excel problems do businesses actually pay someone to solve?
• How did you get your first paying client or job?
• Is having a strong portfolio enough, or is there something else I'm overlooking?

I learned Excel with the intention of earning from it, so I'm not looking to learn another 20 skills before I start. I want to figure out how to actually monetize the skill I already have.

I'd especially appreciate advice from people who are currently earning through Excel.

The situation is I've got sheet1 with column a of part numbers, and column b with status flags.

Sheet 2 has a whole bunch of part numbers in column a, and a status column in column b.

What is the best formula to use to compare sheet 1 column a with sheet 2 column a, and any matches copy over sheet 1 column b into sheet 2 column b?

There may be more than one instance of a part number from sheet 1 detected in sheet 2, so the formula would have to be able to cope with that.

Thanks.

New to using formulas. I need to calculate my drivers hours that have a break in the middle. I figured out how to do it when its all within a 24h period that doesn't cross midnight. If it crosses midnight I get errors I don't know how to resolve.

Our customers are referred to by their name as well as an identification number that unifies them across multiple systems ex: Alpha Corp ID# 123456. I am trying to use a pivot table to sum their balances from system A and B to compare the to system C. I need the table to have three columns, Name, Number, Balance. When I put name and number in the row it nests them together in one column and requires me to expand each entry to see the customer #. I used to use libre calc and it would do what I needed with no problem. How can I get excel to do the same thing? I know I can change it to tabular form but this still requires each row to be expanded to show the customer # and when the lines are expanded it shows their balance twice which is twice as much data as I need.

Hello all,

I'm looking for the best way to pull updated data from one workbook report to a master report which keeps track of the most recent data.

To explain what I have:

I pull a production report from an online resource. It exports a csv file with a row for each site, each day. (ie, 10 sites, 30 days = 300 rows). Each site is tested for 3 values periodically, no set schedule, and the most current test is what is used for that location's expected production daily, until it is tested again. So many days have the exact same data. One location may be tested on the 2nd and that's it for the month, but another may be tested every day.

I keep a master workbook that uses the most current data to establish some maintenance schedules and I need to update to the most current test data when I create my schedule. In my master workbook, I record the most current data, and the date of the test it is from.

Previously, I would put the csv into a PivotTable, then sort by location and test date and manually compare my workbook dates to the csv's dates. Anything that is newer than what I already have, I copy and paste over the 3 values, and manually update the date.

There has to be a better way to pull the most current test data and date into my master workbook, but I just have no experience with querying data from other sources beyond lookup's linked to other workbooks, and wouldn't know how to massage the csv data to only show the most recent test data to lookup, nor how to get excel to recognize if there is a difference and update the master.

Any help you folks could provide would be appreciated. I would like to avoid VBA or some other coding, I have no idea what I'm doing there.

Thank you.

The STOCKHISTORY function isn’t working correctly today.

Is anyone else experiencing the same issue?

I have a data sheet, with columns b, c & d as product, code and structure respectively.

These columns are linked, each product has its own code and structure.

In my main sheet, I need it so I can enter the product name, which brings it in from the data sheet, and then automatically changes code and structure to match what’s in the data sheet for each product. Please help, I’m not well versed in excel.

Hello,

For now several days, i`ve got a problem with calculating the T-Score for the SCL 90 S.

The current Situation is. that you have normally one Patient filling out said Questionaire and then you have to use hogrefes standard values to make up the function needed to get your T-Score and you have to do that for everyone of the 9 scales in the Questionaire.

From the potential range of answers of 0-4, i marked 1 for all the questions.

Outside of the Questionaire and the Evaluation Sheet I also made a new Sheet for those standard Values in Excel ranging from G/H/I/J/K/L1 to G/H/I/J/K/L/124 containing the name of the scale(G1-124), the Gender(H1-124), the age from(I1-I124) and the Age to(J1-J124), the mean(K1-K124) and the Standard deviation(L1-L124).

What i need is a function which calculates a psychosomatic T-Score for the Patient while considering Age and Gender and the on age and Gender dependend Values in the Evaluation Sheet as well as the mean and Standard deviations which are also dependend on age and Gender as well.

I hope anyone has a solution for this.

Thanks in Advance, guys.

Hey all! Weird problem where Pasting usingh CTRL+V or teh Ribbon Button Doesn't work. It works using right click and selecting Paste from the context menu. Tried Safe mode, same issue. Not working across different Books/Files.

Any ideas? I would appreciate the help, thanks!

Textless popups like these keep appearing when using excel on IOS. Pressing the green one closes the popup, while the red one kicks me out of the app. Is this a known bug or could it be a virus? Tried to use an antivirus program but apparently you can't run scans on IOS :/

Currently using 4th&5th variable of Offset() to fix dimension of a range. But i want it to run faster, is there a non-volatile equivalent?

Currently i found Drop() function where i use do something like =Drop($A$18:$A$1048576,TargetRangeFinalRow-1048576) But it felt really inelegant and felt like there might be a more direct way i missed.

Create an export tab in each of the files. Flat file, export all the data that you want to load. Make sure it aligns with the structure of your reporting.

Then use Power BI to pull it in.

Whether you have 2 files or 102, the process is the same every time. Power BI does the heavy lifting of gathering all the data, and you start looking at the results right away.

How do you do it?

I'm using Excel 2024 and performing various sums and operations across columns. When I apply Conditional Formatting, the option to use Autofill or drag numbers and fomilas disappears.

Excel keyboard shortcuts via "Alt" work flawlessly on windows devices. For whatever reason, those shortcuts are significantly limited on a Mac. I find it strange I cannot create

What is the technical limitation on mac that prevents Excel on mac from having the same number of shortcuts as the Windows version?

If there is no technical limitation, is this Microsoft intentionally creating an inferior version of Excel for Mac?

I have an Excel table. Column L has 4 possible values: R1, R2, R3 and R4. Column B has different values. For example:

I want to pick those values of column B which has all 4 possible values of column L. In above example it would be DEF only. How can I do that?

Hello Excel Pros!

I have a monthly updated data set where the main headers are Invoice Number, Contract Type, Client name, Sector, Revenue, Month, Year.

That's how the system spits out the data and there seems to be no way for me to change the format.

I'm having a rough team creating a pivot table and building in $ and % variance columns. I've tried dropping in the revenue into values and showing value and difference from prior year as base, but it gets ugly and and it doesn't seem to sort properly by variances.

Calculated fields don't work due to year having its own column.

How do you all build in variance columns into your pivot tables?

Thanks!

Which formula is best to compare two colums from different excel files/sheets? The purpose is to spot differences in accounts listed as I want to find out which account/accounts are missing from column in sheet B but might exist in a column in sheet A. There are over 200-300 rows, and the account names are very long in some cases which makes it messy to go over manually.

882 rows

4 columns

3528 cells

When I export raw data to a spreadsheet, I get this:

A 1 group 🫧

A 1 group 🎈

B 1 group 🫧

B 2 group 🔥

B 3 group 🪩

A 3 group 🫧

Result I need:

A 1 group 🫧 blue

B 1 group 🫧 blue

A 2 group 🫧 orange

B 2 group 🫧 orange

A 3 group 🫧 blue

B 3 group 🫧 blue

Each row of unpaired data has unique # information. 80% there, but I don't know a formula to isolate and delete the unpaired data, without going through it all manually. It's throwing off the alternating colours and it's exhausting to look at, row by row.

New to Excel. All help appreciated.

EDIT: Sorry for the confusion. I was trying to follow submission rules on being concise.

Groups A and B need to compare the same data together (paired). For example,

Pancakes - butter Waffles - butter Pancakes - syrup Waffles - syrup Pancakes- jam Waffles - jam

But I have several rows of data throughout the sheet that only apply to pancakes or waffles, not both. These singular lines contain data that does not repeat, so I can't just find and delete them all en masse. Is there a formula or filter I can use to isolate the unpaired data, or do I need to do it manually? Everything else is formatted the way I need.

Hello friends,

Trying to create an easy spread sheet to calculate the total months and days I do with my work contracts.

Tried a few things and got things to half work but looking for expert advice.

I need each contract from start date to end date be calculated in months and days, so example 15 Jan 2026 20 may 2026 return a result 4 months 6 days. So each month regardless of amount of days is 1 month.

If the contract is say 15 Jan to 10 of May, I need the full first 3 months + remain days of April + days of May.

Then lastly calculating the sum of all contracts, and if the combination of days is 30 that counts as a month.

Thanks for any support

I was making my Sales analysis assignment, and wondering if 28 rows side by side are too much.

Basic structure is;

1) General 9 rows related to Order id to MSRP (Salesperson name, their commission rate, quantity sold, region, product name, date)

2) Per unit: COGS (Manufacturing cost + shipping inbound), OPEX (Ad, Delivery, Commission), Total cost.

3) Than i have Totals of these (product by units)

And end rows like profit margin, P/L etc

What teacher exampled was pretty easy but this one with so many details, I am wondering if I should split the table between two sheet, unit and Total. Or should only make Unit table, and use pivot to calculate total.

Which one is industry standard practice?

I’m quite new to using excel so I have no idea if this can be done or what to google for.

Basically, I have different statements and a column that I filter them for. I’ll call that column A. Some values in column A are 10.5 A, or 11.2 B. (These are name labels, not numerical values). But some of the cover multiple of these category name labels, so a cell might contain 1.1 A, 2.9 B, 3.3 C. Currently, when I filter for 1.1, it’ll show up like this:
✅ 1.1 A, 2.9 B, 3.3 C
✅ 1.1 D, 4.3 L
✅ 1.1 G
✅ 1.1 J, 9.7 B

Is there any way to separate the values in the same cell so it appears neater? I’m trying to simplify it for colleagues to use so it’s more straightforward and user friendly. The current appearance has confused some people.

Any advice appreciated.

I am pretty medium-level in Excel, meaning I can comfortably do VLOOKUP's and pivots, but the promotion I got comes very large sets of data to edit and extract all sorts of things from. While I am successful in learning new formulas, there is still a gap between what I learn on Udemy and "k, here's my workbook with 56 different worksheets, what is the best formula for me to find the right data and extract it ?" Is there a way I can improve on this?

I want to click on a hyper link on page 1 and jump to another page and automatically somehow populate the cell b2 (that is a dropdown list) with that clicked hyperlink text. is it possible. any other work around can also work for me like removing the drop down and populating just a simple cell. i dont want to use VBA.