Excel Genius

Can anyone suggest a good VLOOKUP tutorial? I need to learn it asap 😂😂

Has anyone who works heavily with spreadsheets/data analysis bought those dual laptop screen extenders? Looking at Xebec and wondering if it’s worth the cost for the extra real estate when not using m… more

Need help with a formula. Cell L5 currently has a DIV/0 error, and if I use the formula IFERROR(L5,I5), the formula returns the value in cell I5. But, when I change the formula to IF(OR(ISERROR(L5),L5… more

Does anyone know if I can conditional format a cell for containing a given formula? Trying to design an excel “class” where I highlight a cell correct if you use the formula you are supposed to.

Today I found the "Pie Explosion" button in excel and I laughed way too long. I thought I would share that.

I have a row in the pivot table, say Part description, and Sum of Spend as a value. I sorted this value from largest to smallest. Then I added another row, Part number. The sorting went away, and now … more

Excel vs Power BI. When does it make sense to use the latter, if ever? I have spent my career using excel, but my some people in my company are starting to talk about PowerBI. Thoughts?

I use SUM(FILTER()) instead of SUMIFS, AMA

Any Excel training for those new to Consulting?

Neither

Lost a file off of the excel desktop app on a 2017 Mac while trying to upload to my one drive (should have been auto saving since I’ve been working on it for a couple of days). Was in the process of s… more

XLOOKUP v/s VLOOKUP

Trying to return a future weekday (Wednesday) in 2 weeks when A1 = reference date. I used =A1+14-WEEKDAY(A1+14-4). It works in all cases EXCEPT when the reference date in A1 is also a Wednesday. If th… more

What’s the best program to make high quality small-sized PDFs with data from Excel?

I’m updating our 2024 price guides and hate how excel renders fonts into PDFs, they look horrible. Plus, excel can’t … more

Does anybody know if power query can slow down a workbook? I know it can slow it down while it is refreshing. But can it affect it while it is latent? The query I have is fairly complex compared to my… more

I was interviewing with a private equity focus consulting firm but failed the mode test. They asked all kinds of matching functions. What functions do I need to know in order to excel?

Would anyone be willing to do a timed excel case study for me? Will be in meetings during the allocated time slot. Willing to pay as well!

I have a power pivot that does not include a primary key (no row or value is completely unique, they all include duplicates). A previous user had used a Concatenate to combine multiple fields and crea… more

I want to make a formula that will let me count 2 different things: count if C1:C50 is “yes” AND counta F1:F50. For some reason this was only doing the counta when I input the formula. Can someone bet… more

Anyone knows how to use goal seek function that can be used on a column? Or a formula that would do the same job?

I want to combine two cells (containing texts) into two different rows within one cell. Does anyone know the formula to do this?

Looking for recommendations on how I could replace a pdf in one file so that power query can replace the table on excel. And when I replace the pdf, it refreshes with new values.
Any recommended video… more

I am trying to get a cell to show up as a gradient based on the number it contains. For example. If the number in K31 is less than or equal to 50, I want the cell to be red; 75, yellow; greater than o… more

Linked cells don't dynamically update when I change row positions in the original (link-from) sheet. What formula should I use?

Looking to hire someone for an excel/ppt case study. Any recs?

How do you deal with a limit of only 1 million rows in a worksheet or workbook? I have 5-7 million rows which I need to import from excel to a database

I went to google, YouTube and have had no luck. I’m trying to pull the text with the most occurrences to display in box automatically based on the raw data. The formula I’m using is =index(d2:d1048576… more

Does anybody have it happen where every so often the pointer in Excel becomes decalibrated? You click into a cell with your pointer, and then another cell is selected. It could be like 10 cells away. … more

Having issues with blank rows being added below last row, making 75+ blank pages in a pdf after looping through sheets and moving data using vba. No formula/test I have tried believes there is any dat… more

Not primarily related to Excel, gut maybe you can help. Need to extract pdf data into an Excel sheet, structure is always the same, I.e. Headline in column A, first sentence in column B, next paragraph im c… more

Any recommendations or ideas for a “spreadsheet control” to make sure in a forecast file the numbers rolled over (which get hard coded by a macro) all are correct, as in the sums all sum correctly etc… more