Help! What are some good automation/AI tools that integrate with Excel?

New client requires every chart to be in native Excel. I'm used to having our Analytics team make Tableau dashboards. Can anyone recommend a tool (we can spend $$ on a tool if it will save time) that uses automation or AI to streamline?

I have the data and I know what kind of chart I want and what filters/slicers I want, but I don't want to have to manually do like 35 of these painstakingly.

Thanks!

Need to get precheck/global entry. Should i get a credit card that covers this and cancel in a year, or should i pay it myself?

Any thoughts on the IP litigation outlook in Atlanta and/or Charlotte? Looking to move but I’m not sure of the workload there. I predominately focus on patent infringement at my current firm.

Hello Guys,

Need to know one thing urgently. Have attended lateral TCS interview and cleared TR and MR..But got to know in the MR round that my preferred base location they cant provide..So went ahead with it. HR discussion yet to happen.. In the meanwhile got another interview scheduled tomorrow frm TCS whose talent acquisition person told its a pan india location and any location can be provided...

Can anyone please let me know If I sit for the interview tomorrow will it cause any issue/not?

Hi ,

Can anyone suggest about fitment round .

Hello people!

It’s been a good journey ever since I started to work with a team where our major goal is implementing digital banking solutions. But Im part of business team and not product team. Now I’m more interested in the digital products and have enrolled my self for this UI/UX designer course as I want to change my career trajectory and don’t want to work as key relationships manager in the business team anymore. Can anyone share their experience and feedback, what more I need to do ??

Currently being recruited for Alvarez & Marsal (Dubai or Riyadh). I’ve checked with my irl network and no one has worked with them before. Anyone here working with or for them who wouldn’t mind answering a few questions related to my proposed function; Strategy & Implementation?

Hey Guys,
What is the full form of AVP role in Credit Suisse
I applied for DevOps engineer - AVP
Please provide some insights!🥺

Anyone gain weight from Paxil?

Should all the on-site interviews have a feedback of "hire/ strong hire" in order to proceed to HC?
What if one of rounds was not up to the mark?

my stress level peaks when there is so much work to do and the filing day is only 2 weeks away 🙃

Any good books to read this winter break? On leadership, digital, or any autobiographies?

After IJ grants asylum. What’s the next step for applicant to obtain documents to prove status?

How many deals (M&A) is appropriate for a first year attorney? I'm wondering if I should be challenged more and worried I'm not excelling enough. I don't like having idle time, and feel like I grow more effectively with ongoing challenges. Not experiencing that now

Looking for remote entry level business analyst positions! If you or anyone you know is hiring, please let me know.

How’s the dating scene in Austin? Any advice for a single 30 yr old Male who recently moved here?

I've heard a couple of things about how the partner pension amount @ PwC is determined, both similar in approach.

Both calculations I have heard of result in an annuity paid until death, at which point a surviving spouse (if any) receives the annuity.

The first calculation I have heard is that you get 80% of your highest earning year as a partner (e.g. If your best year was $1M, you'd get $800k as an annuity).

The second calculation I have heard is that they look at your three highest earning years as a partner, and take the second highest and you get 100% of that. (e.g if your three highest earning years were $1M, $800k, and $1.2M, you'd receive $1M as an annuity).

Is ANY of this true, or just all rumor? Any PwC partners that can chime in and explain the pension plan fact for fact? Perhaps with sample numbers?

Is Deloitte Touche Tohmatsu India LLP same as Deloitte India. I have joining in January. Why is everyone so sceptical about the company?

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?

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

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.

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?

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

How do I compare two sheets to make sure they are identical?

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

How do you fix microsoft excel cannot paste data error?

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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!

Would anyone be willing to teach me vlookup?

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

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?

Still don't have xlookup. #fomo

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.

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

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.