As a beginner in Excel I have few questions,
How to learn Excel ?
What type of Excel skills require to get into this field (as Intern) ?
How do I Crack interview ?

I have a spreadsheet that has location, number of hourly people and then number of salary at each location. How can I create a pivot table that will tell me sum of salary and sum of hourly by location… more

For those of you who work in some kind of sales management position, what are your most used formulas and functions in excel?

I'm learning to use Pivot Table. Can anyone point me toward the best and most affordable learning resource?

We have about 80 locations within our company and we have both hourly and salary employees. How can I have the pivot table give me a count of both salaried and hourly employees at each location?

Pretty new in my current role, about 3 months, and wanted to clean up some our large data spreadsheet. I heard python integration can help do this with a script but I’ve never used it and don’t know w… more

I'm a current federal worker with over 16 years of analytical experience. Looking for a part time remote job doing Data Entry, to give me something to fall back on during our reduction in force. Any suggestions? Thanks!<… more

Actively seeking Business Analyst or Data Analyst full-time roles. Skilled in Power BI, SQL, DAX, Data Modeling, Data Visualization, and cross-functional collaboration with experience in Healthcare, L… more

Hi. I need some power query help. I’m importing data from a 100 page PDF file. Power query views the PDF as 100 different tables each with four columns. I want to append all of these tables into one. … more

Collective Brain: recently joined a new company and the intercompany is a real mess. Lots of entities are out of balance.

For context it's ~100 entities. So the IC matrix is huge and not particularly easy to read, as in m… more

I joined this group to learn how to use excel. I've tried many tutorials but I still can't grasp it. Does anyone care to teach me step by step? I would be so grateful for the time taken to tea… more

I joined this group to learn how to use excel. I've tried many tutorials but I still can't grasp it.

Sad waste of ability.

What is the best way to create a list of data from chunky, randomly spaced cells?
Example:
Supplier# PO #
Receiver# item quantity amount

Except there are a ton of random empty cells and some of these chunks o… more

Anyone can point me in the direction of a template for generating skus based on date, plus a few parameters ex. Category, sub category etc

I never knew that my city’s Library has classes for excel. I am so thankful because I need to update my skills in this. I wished I would have learned this earlier on.

I have a TB that came in as a table. Column A is the account number and the sub account is a top row, with the value for each account: sub account in the table. I’m great at excel…just not sure what f… more

Why do all new interns/ new joiners think that Chatgpt is the solution to everything?

How about trying to learn the fundamentals.

I am an Excel genius with years of experience in creating dynamic spreadsheets, automating workflows, and solving complex data challenges. My expertise ensures that businesses can streamline their processes, save time, and make data-driven de… more

Told my supervisor I wanted to share some Excel functions with my team in our meeting today but now regretting it because they probably don't want to learn more efficient ways. Some people are jus… more

Hello. When creating a google form, and responses go into google sheet. Can that response be automated to upload into another application? Trying to eliminate waste of manually entering in another app… more

@payHeng

Hey number crunchers! Ever feel like Excel's MIN, MAX, and AVERAGE functions are the wallflowers at the spreadsheet party? Well, I made a video giving them their moment in the spotlight—jokes, puns, a… more

Hi Everyone, I work extensively with large Excel files and often face delays due to network performance. I’m currently using Microsoft® Excel® for Microsoft 365 MSO 64-bit. Is there a better version o… more

Noob question. I’ve inherited a Cap Table for Partners that have a preferred return component. What’s the difference between calculating quarterly preferred return as
Capital Balance * Rate/4 Or

Capi… more

Honest question - how can you read a pivot table that's not in classic layout? It's so much better than the default!

Novice Q: Looking to improve my skills on Excel (think basic fomulas, vlookups, setting up budget tables - things of that nature) and would love to know what recommendations anyone has in mind?

Alright formula pros, I need excel to filter if a date is farther than six months in the future. I'm thinking I need a column to mark these rows. What formula do I need? Looking for the most effic… more

Accountants and finance people in the bowl, what functions/formulas do you think are most important to know in your job?

Hello brilliant minds, first …. apologies if this has been addressed before (I looked but don’t think I saw this)… is there an easy way to transfer info from a Word document into an Excel spreadsheet?… more

I need to inventory one off parts and multiples of the same item. Currently - there is no way to scan the bar codes. I’d like to be able to type in a part/serial number and have the spreadsheet either… more