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.

Anyone can refer me for RPA profile

I guess I’m officially being off boarded team doesn’t care no one has said anything … I’m a ball of nerves thankfully my old company wants me back — feeling so sad and angry and just incredibly nervous

I work part time for a startup for equity and am attending an event on behalf of the startup. I’ve only been here a few months and asked multiple times to have a prep meeting with my boss. He instead sent me a 15 page document outlining 40 questions I should be able to answer the day before the event.
I’m so incredibly stressed as I don’t want to show up unprepared and make myself look bad. Idk how to make light of this situation at this point

Thoughts on GP Bullhound?

Hi Fishes !! I am searching opportunities in Financial Planning and Analysis role. If you can let me know or refer me ? YOE 7.5 years Thank you in advance !!

Ibegin is not accessible …seems the site is in maintenance, any one facing issue right now ?

Hey all,

I’m trying to switch over to an FP&A role from a wealth management analyst role. Has anyone had experience doing so, and does anyone have any referrals? Thank you!

What is your current salary and are you happy with that ?

Can you recommend any resources to gather data on risk ratings etc for benchmarking? Particularly interested in sector breakdowns and publicly available sources are scarce. Thank you!

Interviewing for a Practice Manager position, what Level should I expect (L6/7/8/9?) Also, any interview prep advice?

How should a future CM looking for their first job build their resume?

The most interesting research topic you've come across....?

I’m recently finished my PhD and the transition to full time work has been overwhelming. How was the transition for you?

Recently learned that the whole “humans only use 10% of their brain” thing is not true at all. What are some other common science misconceptions?

Will be in Dallas for work next week, any recommendations (must see, restaurants, tours or shows)?

If your not ready due to career change, etc but interested in getting an MBA, is it better to withdraw application or pay non refundable deposit and defer? Any advice would be great!

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

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

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!

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

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?

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

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?

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?

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Any book recommendations on excel modeling for real world business applications?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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