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

I am not in account but would love to have a more comprehensive take away from meetings particularly client feedback verbalized. How do you account folks do it? Tips and tricks? Thank you!

How much do you guys think average 4 year college cost will be in 20 years?

Currently work at Moody’s as a credit analyst trying to figure out what are good exit ops, if anyone has any advice please let me know, feeling pretty stuck right now

Considering going into Finance Technology roles within big4. I have have >3 years background from deloitte doing Tax Technology. Can anyone speak to these finance technology role &/or give referral?
PS left deloitte about a year ago and have done finance related work for <1 year

Have you ever walked out of a job with no notice?

I desperately need help/guidance from someone, I tried going to some therapists but they just emphasize antidepressants.

Below are my thoughts rn: Man, I’m 28 and such a bum. I work a job I hate, I have no social circle. I have never had a gf. All these things are so challenging because I’m autistic. I can’t change that. What’s the point of living when society treats ppl like me like I don’t matter. Maybe I should just take a bunch of sleeping pills so I don’t have to deal with life anymore.

Just found out that my favorite aunt, who claimed I was her “favorite” niece, chose to leave all her valuables to her other two nieces who never visited or called her once in the last ten years. My aunt passed away suffering from cancer last year and didn’t have her own kids. I was there by her side throughout her battle. I still wish I had done more, made her life easier. I probably sound petty, but a part of me is forcing me to re-evaluate every interaction I ever had with her.

I’m hoping my anti-depressants will help give me a kick to start looking for a new job. I honestly don’t have anything else left and I’m still sad.

If anyone has a summary of the green book highlights please forward to me. Thank you

Never invested before…can y’all share resources (podcasts, books, favorite news outlets, etc.) so I can educate myself and get started

There are few things greater than sitting at home taking conference calls in nothing but your boxers and tube socks.

AST still rallying despite just over 150 watchers on StockTwits and pretty low social media coverage... tends to get spiked down after a run, so might want to wait, but something’s up

Looking for a Job change, currently working as a business analyst having 8 YOE, NP 3 months.

Any M or SM please DM me.

Free to discuss on opportunity.

Hi Fishes, Can anyone throw a light about Genpact Pharma/lifesciences analytics practice in India-Bangalore. Considering for a potential opportunity, I have 9 years exp.
- How is the culture, wlb, and growth curve?
- About year on year hikes
- leadership team focus on mid tier's growth.
Genpact Genpact Headstrong

Accenture Deloitte Axtria IQVIA ZS Associates

Anyone have any good contacts at ARC? I’ve been trying to get in with no response ( account management)

I made a mistake at work yesterday and my boss was being super mean about it. How do I move past this?

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!

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?

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Would anyone be willing to teach me vlookup?

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

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?

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

How do you fix microsoft excel cannot paste data error?

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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!

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

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 have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

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 🙏

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

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.

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

Still don't have xlookup. #fomo

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