Is there a good tutorial out there to automate creating pivot tables and then creating a PowerPoint pres with those pivots? Trying to do with with macros and the syntax is really giving me a hard time.

likehelpful
Posting as :
works at
You are currently posting as works at

Related Posts

How many IT companies are ending WFH?
PS- walmart is asking to come to ofc for sprint ceremonies

like

Need 11likes to enable dm. Please support.

likesmart

Wow. Just took AUD and the sims were brutal 😞

like

So which is right? I got an job offer at a public company today that comes with stock options. They said the value would be $5000 but when reading the offer letter they gave a specific number of shares. Now those shares multiplied by the current stock price is about $10,000.

Sso am I getting 5k or what?

like

Some Business Intelligence/Analyst roles are very data heavy. I wonder why these roles do not have the term “data” in them, and wonder if it’s to keep the salary lower than it should be. I have colleagues doing intense data science tasks as BI Analysts, and can’t help but feel indignant on their behalf because when hearing their job title, one would underestimate their technical ability.

likesmart

DC peeps- Where have you exited to that isn’t billable hours or government?

like

Wanting to exit within a few months and am about to be asked put on a large project being the PM ( with little experience) I have great utilization not sure if I should wait for another project with less responsibility so I can also focus on interviewing anyone in this boat

like

I come from a pure healthcare background and have minimal finance skills/experience. Want to eventually get in healthcare investing in a MM PE fund.

Is there anyway that I can start to make moves on this, while at my Big 4? Who are the best types of folks to reach out to at my Big 4?

Anything I should get smart on? Websites, podcasts, books to read?

like

What is the salary of a sap mm consultant with 4 years experience

Hello fishes

Please help me out below are my details
YOE: 10
CCTC: 9.5
Skill: SAP FICO/HANA

If feel it is very low package. I did certification in SAP CFIN so how is the market for CFIN
Any suggestions

Thanks
here

Left Accenture 10 years ago... can someone remind me what the ESPP offering period(s) were and when stock was purchased? Was it 1 or 2 offering periods per year? And what were the months of each?

like

I need your advice!
I was contacted via LI by an internal recruiter for a position. After 1st screening, the 3 step interview (skills check>head of department>team) started. 1st round went well, 2nd round was with unprepared substitute bc the boss was on
Vacation. I was told there might be another round bc the chief might wanna see me.
2 days later I now receive a follow up from my recruiter asking how the interview went and how I feel?
??? No internal communication? How should I take this?

like

What's a good salary for 4.5 years of experience as a Big Data Engineer (Azure/PySpark/Databricks) in the Amsterdam/Utrecht area?

In talks with recruiters and I feel like I'm being low balled.

So Dragonflight, anyone took days off?

like

Hi folks,

Anyone here who is CIS-HR certified.
I need dumps for exam preparation.
Please reply to this post.

Hi All

I have received this email from Amazon for an online assessment. Can you all please help me understand what all is asked in these assessments? Amazon Web Services Amazon Amazon India

Post Photo
like

Is EY SaT or Deloitte M&A better in the Bay Area?

like

You couldn't pay me enough to wear any kind of smartwatch. I mean dear god, big brother (shout out to my director) ruins my life enough via my phone, can't imagine having him stalking me on my watch.

like

What are everyone's thoughts on the link between performance and reward? Will this continue in the future? Has anyone moved away from ratings and if so how does it work? 🤔

like

What is the best CX product to sell at Oracle currently? Which one has the highest potential for growth?

like

Additional Posts in Excel Genius

Does anyone have experience setting up automated queries on Excel for Mac? I am trying to automate a paid search pacing document but am running into an issue with the Excel Power Query not being able to log in to Search Ads 360.

like

I am trying to do a sumif formula for values that fall with specific dates. It worked for all but one of my cases. Not sure what I am doing wrong. Every other case worked. For some reason it’s adding more than it should. When I move the sum range up one it resolves the issue but that throws everything else off. Any help would be appreciated

like

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

like

Not really excel - trying to convert a “text formula” result into a number result but I’m stuck

IF (AND(Monthly_Unique_Visitors__c  >= 0, Monthly_Unique_Visitors__c <= 50000), "-50",
IF (AND(Monthly_Unique_Visitors__c  >= 50001, Monthly_Unique_Visitors__c  <= 100000), "-20",
IF (AND(Monthly_Unique_Visitors__c  >= 100001, Monthly_Unique_Visitors__c  <= 250000), "0",
IF (AND(Monthly_Unique_Visitors__c  >= 250001, Monthly_Unique_Visitors__c  <= 500000), "7.5",
IF (AND(Monthly_Unique_Visitors__c

like

Formula to convert the date on the left to the date on the right? I’ve been using text to columns then concatenation but I feel there must be a better way...thoughts? Thanks!

Post Photo
likehelpful

Does anyone use XLOOKUP over Index Match? Why /why not?

like

Hi guys!

I need help with something: I recently started using xlookup in excel to automate recurring tasks (accounting) but I have found that my peers and supervisors have difficulties understanding how the numbers are pulled, which makes their understanding of the files difficult.

What would be the best way to convert the result of an xlookup cell to a reference to the found cell?

Is there any way that could be applied to all the xlookups in an excel file?

Thanks in advance!!

like

Mac iWork Numbers question: is there a GPS co-ordinates function? Looking to pull location information & calculate distances between locations in the sheet.

like

Best way to learn Spotfire? Just watch YouTube videos?

why is index match superior to vlookup?

likefunny

Is there a better tool than than Excel for making models? What do you use?

like

Is there a trick to analyzing more than 1MM rows in excel?

likefunny

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

like

If I’m creating a comp set and a row of numbers will not adjust the number of decimals no matter how many times I adjust it in the “format cells” window, what could be the reason for this and how can I get around it

like

Had an interesting issue this past week. Batch of client data looked normal in Excel, but when imported into our analysis software that we use for larger data sets and their manipulation (cont.)

Best way to pick up LBO modeling? Recommended resources, tips, tricks are appreciated

like

Is there a way to easily create all the permutations of 315 possible combinations of numbers in excel?

like

Public schools use Google for everything. So they use Microsoft Office as little as possible. Even Office 365 isn’t used much. I teach an exploratory class to 8th graders for Google docs and sheets since the school tech doesn’t support the educational MS Office 365. I like the MS Office desktop version because it does so much more than 365. I relate how Google does things similar to MS Office but not to the level that Office does.
Do businesses use Google docs, sheets, & the rest for anything?

like

How does an interest bearing equity instrument affect the equity value? For example, If the coupon on the equity instrument is say 16% and the Equity IRR of the project funded with this equity is 15% and I were to discount the FCFE at 12%, should this give me a negative value?

like

I have a spreadsheet that pulls data from rest APIs into power query. Is there anyway to make this sheet work for people on Mac?

likefunny

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal