Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

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

60% Excel, 20% back-of-napkin/high level, and 20% between PowerBI and Tableau.

like

My analysis are derived from a combination of Excel, Excel VBA, SQL (for data warehouse exports and VBA automated queries in Excel), PowerBI, Cognos, and PRISM.

like

At my prior jobs it was 95% Excel 5% Access. Now it's 45/45 alteryx/tableau and 10% Excel.

like

Loooove Alteryx but really need to start incorporating it more. Excel is the workhorse just because it’s so familiar.

like

60% Excel, 30% Python/Panda (to clean and prepare data pulled from data WH. 10% SQL.

like

Excel + Crystal Ball 90%, R 10%

funny

Easily 90% excel. Probably 5% sql 5% internal system

Day to day work on Excel but big data is with pwerbi

Mine was 100% excel in deloitte tax

60% sql, 20% python, 10% R, 10% excel

100% Excel and VBA - Have a few paid excel add ins though

60% excel 40% alteryx

80% Excel, 10% PowerPoint/ Outlook, 10% Tableau

100%

95% PowerBI the rest Excel; don’t use Tableau much... data engine not as strong as pbi, and the ability to model/transform the data in the data query of pbi is unmatched

Related Posts

Howdy, how many people do we have in this bowl? Like this!

like

Thoughts on Baker McKenzie’s privacy group?

like

Guys, do you prefer your lady counterparts with a.) a natural face b.) natural makeup c.) glammed up

like

Who works on Juul now?

like

What do you think is the best diversity initiative in London?

Any Chicago F to meet up?

like

Does IT companies fake job roles like they show development role while attending interview but after joining they give support.Why they don't hire separately for support?Is this because nobody wants to work in support they make job description attractive to make employees join?

Looking for advice....I work in a school with very low ESL population and those that are ELL are English speakers. I have had a couple newcomers over the years, but mostly in the lower grades. Just got my first and only 5th grade, non-English speaker. Would love some ideas on how to best server her. I am one teacher and currently only here 4 days a week. I have 35 other students.

like

Hi Fishes ,

My lwd is on 10 th june, but i want to submit my laptop on 6th June by visiting the DC. What cand when can I tell my manager about this ? How to convince him ? And i am connecting through scvpn to vdi, is there any way I can connect with my personal laptop?

like

Any data science openings with immediate requirement for python/ml/model building?

like

Is corona in the Tysons KMPG building?

like

How often do you see your significant other when you’re dating as an official couple?

like

Any karaoke places open tn?

upliftingfunny

Wipro Hi fishers, need a suggestion urgently. My wife Joined Wipro on 12th of Jan 2022 but till now didn't got any project. Stream is SAP Functional. Now she's holding an offer letter from Cognizant with a good package but problem is need to join by 19th of April. Is there any way to give spot resignation in Wipro? She's currently on bench.

like

Anyone know of any startup/firm looking for junior developers in nyc? I’m losing my dev skills in ACN and I want to look for other opportunities that’ll enable me to learn more software development.

like

Can someone suggest good consultancy for PR and other process in India (Chennai) ?

like

Marianos or Whole Foods?

like

Can someone help me understand the purpose of why an LLC would have one lower tier smllc who also owns another smllc. The single member of the two lower entities is the same person? So like why the need to pass the income three times to yourself? All entities are domestic.

likesmart

Anybody have some good leads on housing in NOVA?

like

Have an offer with CoStar Group in DC. Also interviewing with Northrop Grumman. As someone who is exiting consulting for better work-life balance & lower stress, which company would be better to exit to?

like

Additional Posts in Excel Genius

I’ve got some lookups to do but inconsistent unique identifiers (names with Bob G01 vs Bob G1). More experienced fish, what’s the best way to perform look ups with this kind of unclean data? Got a few

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

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

When you F2 a cell to display cell references. Is there a way to navigate to that cell reference quickly without having to scroll and find the highlighted reference cell?

Thank you

like

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

like

Not sure where this post belongs because I don’t think it’s an excel solution, but I want to be able to pull data from various direct datafeeds (and be able to pull in reports from say excel as well).

Once I get all the data in the same place I want to make sure all the data looks the same before I begin manipulating it (consolidating/mapping fields essentially)

What’s the right software to do this? Is it as simple as having direct feeds integrated with Access or is it something else entirely?

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

This isn’t exactly an excel question, but is there a way to clear the “last modified by” history on an excel document in SharePoint? Accidentally opened a file i shouldn’t have.

likefunny

Is there a way to add 3+ criterias into a vlookup and if there are multiple results, to list them in different cells?

like

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

likefunny

Would you rather use Excel versus CRM to store data and manage records? If so, why?

like

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

like

I truly appreciate this group.

Post Photo
likefunny

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)

Best way to learn Spotfire? Just watch YouTube videos?

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

Anyone have a easy formula to turn “2 years 6 months” into 2.5? Thanks!

Hey guys, did you ever encounter the following problem & know a solution:
Whenever I reference another tab in any given formula in my model, XLS first calculates everything as it should be. However directly afterwards (or sometimes only after saving) the formula vanishes and only the resulting value is left. Hence, all automation etc in the xls does not work.

Any ideas what's happening and how I can solve it without rebuilding the whole model?

like

Need help tabulating survey results. Each row is a respondent, but the question asks “choose all that apply” resulting in several columns associated with that one question. How can I get a distribution for which answers were chosen among the top 3?

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

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