In need of cool Excel project ideas to practice my skills. Something more interesting than the usual budget trackers, please!

How much do you put into TSP?

*KGS*
Any insights on this years appraisal ?
Service line : CH

Is a side-venture of real estate (buying of rental property) noteworthy in the application process? In terms of extra curriculars...

Is BNY strictly following hybrid model currently? How many days in a week or month are compulsory to WFO.? Asking i I will be a new joinee in few days

Hi Fishes,
I hold 8 years experience in Wealth management, financial advisory in Banking. My current salary is fixed 9 lpa and variable 10 lap. Currently I am negotiating salary with one of the Big 4 firms. Can anyone tell me how much hike should I quote as fixed and variable ??

Michael Cohen, in a court room, under oath, stated that the President directed him to commit a federal crime.

You really can’t spin this one.

Can anyone provide some guidance to taking the CFE? As in which membership option to choose from followed by when exactly can we take the exam, if the entire amount is reimbursed or not? Just a generic timeline and additional required info. Don’t want to sign up yet if the exam dates are not flexible. Thank you.

Anyone join jp morgan Bangalore on sept 20th for the Asset and wealth management LOB

Who wants to be a millionaire?

Hi everybody.
Right now I’m working as a junior product engineer in Amsterdam. From januari on I’ll be a medior product engineer. And now I’m in the middle of negotiating about my salary increase. The salary that I’m being offered feels low (41.5k).
Is there an other product engineer that could tell me if my gut feeling is right or not? Thanks in advance!

Just received an offer with expected / standard salary for role but no signing or relocation bonus. They know I don’t have any other offers which is why I assume they didn’t offer any signing bonus - do I have any chance of getting one without “leverage”?

Any tips on recruiters in Tokyo? I’m finding it hard to come across someone

What can you do if you’re getting interviewed by the same person who didn’t choose you in the first place?
Context: I applied for a position a while back and got interviewed, but didn’t go to the next round. I found the same position open again a month later at a different location and applied. Almost immediately, I was called for an interview, but with the same interviewer. What does this mean? Is this going to get awkward?

I joined in Feb. When will I get my first appraisal in ericsson

I am a Management Information Systems grad student from University of Memphis, with a cumulative experience of 5 years ( 2years - Quality Data Analyst, 3years - Human Resource Co-Ordinator). I'm looking out for Summer Intern'22 in and around companies in Memphis and Nashville, specifically looking for recommendations for applied positions in FedEx. Any leads will be graciously appreciated.

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

Still don't have xlookup. #fomo

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?