Hey everyone! I love being part of this bowl. I often see easy questions and loveeee helping out, but I always add in my reco of trying ChatGPT too because it’s incredibly useful. Here are some ways I leverage it, and I’d love to hear your ideas too!

1. Formula Help
2. Data Analysis
3. Error Fixing
4. Macros
5. Conditional Formatting
6. Data Validation
7. Chart Creation
8. Workbook Organization
9. Data Import/Export
10. Keyboard Shortcuts

I can always provide more details too!

Has anyone here got relocation bonus from CitiusTech?
Can you please tell how much amount you got?

Any suggestions for creative recruiters in NYC? Looking for new CD-level opportunities 🤗

Hi fishes,

I'm looking for a switch into finance or marketing domain as I'm a Bcom graduate and did finance as major and minor as marketing. The current work is not what I wanted to do. Asking fishes refer me in their organisation. It would be helpful for me to make a switch in early career.

Thank you.

What prompted you to do a complete community overhaul? Did it pay off?

Where do you live, what is your title, what is your salary?

Include employer if you want.

UX Designer, Toronto. $73k CAD

What is the difference between NTT and NTT data?

Hey all,

What are some PE firms (likely mid-market) that specialise in doing Entertainment deals, especially in gaming hardware, software, solutions that underpin the value chains ?

Has anyone let their work performance suffer to get through the CPA? I can't commit my whole life to work right now and I am really falling behind.

Anyone who joined after March’22 who got the VPB letter?

What would be the expected salary in India for PhD in materials engineering with 4 years of experience?

Hey! I’m a Junior in college. I have a small family and was wondering what good jobs/companies were out there to get out of the restaurant/warehouse/call center pit. Any ideas? I’m interested in Tech (working on SEC +). Thanks!

Anyone know of available part-time (3-5 hours week) Salesforce Project Management gigs?

Why does Newark close tsa pre lanes? Terrible

I've never wanted to do a knee replacement so badly as during COVID

Anyone expecting layoffs due to COVID-19? There’s an indefinite hiring freeze and most promotions and have been paused. 👀

Any advice for Fla business that may have to let go of staff? 20-25 emp; furniture mftg. Don't practice employment and they can't afford lawyer that does. They want to comply with laws.

Looking to change practice area to employment law - tips?

Does anyone have information on Ogletree’s ClientTeam Counsel position? Billable requirement, salary, type of work?

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

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)?

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

How long did it take you to become good at excel? Like fast?

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?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

Best websites to get more of a handle on Excel as a beginner-intermediate?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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

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

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 trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

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..

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

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?

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 😭