Excel Genius

Hi all, I need some help because I cannot figure this out for the life of me after trying multiple different solutions... Basically, I have a column titled "Date" What I'd like to do is pretty simple, count how many are th… more

Hi guys, I want to brush up my excel skills esp. Pivot tables, vlookups, index match etc for an upcoming interview. Is there a site where I can get sample dataset and follow along to practice these fu… more

I want to create an excel ribbon that will automate company-specific formatting tasks for me (specific highlighting colors, text/percentages/values font/size/decimal place, etc.). I want to share this… more

Every month I open the excel financial models and update the trailing 12 sheets for the properties I am working on. This consists of aligning the new T12 with the last months T12. Currently I use a T… more

Struggling with this one. I have two source worksheets I need to compare to generate a third. One is people and their multiple roles, second is multiple roles mapped to training requirements (some rol… more

Hi all,
I have a pivot table that has 14 rows and 5 columns of data. I want to show the data in each column as a % of the row total. When I select this option in the values field, it changes every valu… more

Being a Masters student with less than 1 year experience, a set of good projects, relevant courses ,technical knowledge and expertise , How to get an Entry level job for Data Analyst roles in the Stat… more

I have a report that lists all invoices paid for the last 1.5 years. It's a lot of data. Excel keeps crashing/stating there is an problem with the file and asking me if I want to fix it now or not… more

I have within advanced “ enable dray auto fill” and it’s still not working

Hi all,

I was wondering if it is possible in excel to analyse text and match it with each other?

With this I mean that I have 2 tables:
- Table 1: actions to take as a company to comply to regulations
- T… more

I need to fill out a Fillable pdf. Just one page and has over 100 entires. I have all the data I need in the same format in excel. How can I most efficiently transfer this from excel into the fillable… more

Hello all! I am learning more about SharePoint lists and excel and trying to see if I can make some things happen with files that were set up by a previous manager. We have an inventory coordinator … more

My data contains a list of names vertically (A2:A200) and a list of locations horizontally (B2:BC2). Each name has a value of “True” or “False” for each location indicating if the person has access to… more

What is the best way to convert a string, as in an actual word, into a numerical value in excel? Assigning a number to each letter won't work because there are more than 26 letters in the alphabet… more

I need to hire an intern to advance my team’s analytics but I don’t really know anything about analytics or D&A outside of my excel skills which end at index/match. I’m on a financial advising tea… more

Excel crashes when get data>from MS query. Any idea why? I ultimately want to import a .cub file stored locally. Any other way to do it?

Anyone here have experience with Rollstack? We're considering them to automate our business reviews and client QBRs.

Getting error for IRR calculation for a negative series of cash flows. Of the 5 cash flows, 3 are negative and 2 are positive. I was expecting IRR to be around -50% but the calculation is giving error… more

Excel geniuses, I need your help! To show a quick picture of how the quality is going in a call center, I always plot a scatter graph with the data and plot a trend line using Excel. But the VP is sti… more

IWTL more advanced Excel. I would consider myself intermediate right now, but unsure what new skills to attempt next and where to find good tutorials or lessons. Any suggestions?

I'm already very f… more

Hi all, I have a very basic question. Why every time I use iferror function, i.e. =iferror(A3<>0, “NA”), it always returns “FALSE” or “TRUE” in the cell, not returning “NA”? Did I miss something… more

Hey everyone, I have a CSV file with phone numbers that I want to transform from this - (456) 456-2332 to 4564562332. Completely removing the parentheses & dashes. None of the stuff I've tried… more

Hello, I am looking for a way to add a defined number (7) of row between every line that already contain information. Is it possible to do all my lines in one operation or even automate it withh some … more

Hi! I have two tables, each on a different tab. The row headers are facilities and are the same in each table. The column headers in table two are country approval names and facilities that have the … more

I am looking to create a rotating holiday call schedule, but taking into consideration the last 5 years of call. I already have the the last 5 years created, with the holidays as columns, the years as… more

If you're doing a lot of collaborating is there any reason to use excel over google sheets?

Power query headings:
I am trying to combine 10 tables in different tabs of an excel sheet using power query but the 10 tables have 3 types of headings

I tried to use power query to combine it, but it's not working because… more

Hi There!
I wonder if anyone could tell me where to find a list of companies that market their products or services to 60+ years of age. Also, how do I know which of these companies would be interested in pa… more

Any ideas?
trying to build an Excel sheet that has drop-downs for category (cars, trucks, plane), assembly/machine (Civic, Ram, Boeing), and autofills their unit price. Assembly/machine dropdown options depe… more

Starting a thread on backtesting with Excel as I muddle through it.

I have hourly order book snap shot data of an options chain on Bitcoin and Ethereum. I’ll be using this data to run back tests on spe… more

Trying to basically do a lookup from a list of tasks and pull them into a single cell of a calendar based on date. Cannot use an if function in conjunction with with a join text function or macros bec… more

Any way to find and replace ONLY superscripts?

Let's say I have 10 superscripts appearing throughout a spreadsheet and need reorder them. How would I look for superscript figures without returning normal figur… more

I have to skim through thousands of KPI rows (and the list keeps growing) and make sure all are unique. I can’t really use the duplicate function b/c i have to read through the descriptions and data p… more

How can I delimit a cell with multiple phrases in a field in excel? Without splitting up the phrases ?

Hi, looking for a template to calculate inventory needed and track quarterly sales.