EY trying to move away from Excel . Think it’s possible? Want to see it happen?

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

Man I love Excel. I can't imagine life without it

like

I’m a big fan of alteryx for data manipulation - infinitely more powerful than excel and leaves a definitive trail from source files to output. Anaplan looks pretty interesting, but I haven’t used it yet

likehelpful

We left excel and moved on to bigger and better. Found the limitations of excel too.

likehelpful

It can take data from basically any common format and output it in any common format - excel, csv, access and a host of others. Easily can have it pulling data from live databases, systems, shared servers etc. In terms of being dynamic - it’s extremely flexible once you learn the tools and formula language. It can handle infinitely more data than excel - like no issues applying 60 columns of complex logic formulas to 10m+ rows of raw data. I find it most useful in situations where I need to marry together a lot of disparate datasets and know going into the exercise that it will be a trial and error process or know that I’m going to need to heavily manipulate a dataset to get it structured the way I need to to analyze it and know that I will need to update my work for additional months, quarters, years etc. The beauty of alteryx is that every step of manipulation is preserved in your workflow so you can easily change assumption 50 of 100 without loosing significant time redoing steps 1-49 and 51-100 or can easily process a new data set through an existing workflow if you need to add another month or years worth of data later in the project.

likehelpful

Heard great things about alteryx! How does it receive data though? Does it import excel files? Link to databases? How dynamic is it?

like

Is it programmable? E.g VBA gives us the ability to automate tasks in Excel

like

What does pwc use if not excel?

like

What are they using if not excel?

Currently Excel, in the future, there are talks of eliminating Excel and moving towards cloud based programs.

Bigger than Excel aye? Pretty impressive. Did PWC develop something internally?

@EY OP use uipath to automate. Plus you learn that and can automate almost anything

Related Posts

What are your excuses to leave your current job early for an interview at another agency?

Anybody working at Designit ? I got an offer from designit, there are less reviews about designit. Would like to know the work culture and other details as it is part of wipro.

like

I am a Strategic Sourcing Manager with 7 YOE in both direct and indirect spend across various industries (Life sciences, IT and Insurance) I have been offered a role with Fidelity for 13 lpa + 1.5 variable. Offer seems better than the national average for similar roles but I feel I would be underpaid based on the current market, my skills and value I will be bringing to the table. Any suggestions for offer negotiations?

like

Anyone with experience working at Endpoint Closing? Wondering what the culture is like

like

Anyone know any biotechs/Pharma (ideally oncology-focused) that are looking for a VP (or even SD for the right TC) of BD/CorpDev and allowing for remote/travel models (if not Boston-based) or at least a Boston-based hybrid model? I know someone with good biotech/Pharma BD&L experience that is looking for a new role given the current biotech layoff scene. Feel free to share any company names with open roles or DM, if preferred.

like

Hello Guys,

I have an offer from Cognizant for 29lpa with a JB of 1.75l on top . I am about to get the offers from timesinternet and LTI.


Can someone suggest which will be a better opportunity for me.

Also how much should I ask for to Timesinternet.

Had communicated with LTI for 33lpa fixed.

like

Has anyone come to you for help?

Remember that these people asked Allah first, and Allah gave them your address for you to help them.

like

Anyone connect me to a good golf instructor in Naperville, IL?

like

Does anyone need a zero trust architecture environment mandated by the federal government. I can help.

like

Favorite group fitness in philly?

I have booked my h1b visa appointment in sept. Does my visa date effect due to travel ban until dec 31st . I am hoping I could get stamping done and enter US after travel ban gets lifted.

likehelpful

Hi Sharks, I am finding oppurtunity in Mindtree for the Role of Incident Management. Please help me Mindtree

Please advise,
Which company should I select, wlb and long term growth
KPMG GS - 14LPA fixed+ 20% variable
EY INDIA - 12 LPA fixed + 20% variable
NatWest - 18 LPA fixed

like

Hai all,
Do we get any relocation benefit if moving within the current City?
TIA

How is Mphasis DXC Hi-tech division ?

like

I’m looking into starting a career in biochemistry. Have graduated a few months ago with a bachelor and it has been quite hard finding and landing something that aligns with me. Does anyone have any leads, tips or knows places that are looking to hire ? Would be greatly appreciated 😁

like

Job Opportunities at Indium Software

Post Photo
like

Has anyone made a big bet to try to attempt to retire early? It seems like everyone in this bowl focuses on traditional, conservative investing. Going that route I’m gonna be a wage slave all my life

like

When HR/recruiter says X-Y range or Y is the highest they can go, is it actually true? Is “signing bonus” a real thing (read online but never practically saw this)?

like

Additional Posts in Excel Genius

I have some data extracted from SAP and though the size is not relatively high lets say about 45000 line items. My excel keeps crashing anything i do with it 🙄! Any clue why it is happening ?

like

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.

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

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

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

like

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.

like

How do I create a formula that creates a “cutoff”? For example, let’s say I have 1000 hours. I have a list of activities in a tab that take up 15,20,50 hours etc. I want to highlight the cutoff as soon as that 1000 hour limit is reached.

like

Each country has multiple txns. Some complete, some not. What formula should I use to say if Indonesia has ANY “not complete” then show me the term “not done”. Tried IF(Index Match) but only (cont.)

Post Photo
like

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

like

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

like

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

like

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

likehelpful

I have 1 sheet with names and sheet 2 with a large list of names that may or may not be those names - which also have corresponding unique identity numbers. How do I easily match the names with the same names and keep the unique identity numbers for importing later?

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.

like

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

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

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.

like

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?

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

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