No matter how fancy the tools are out there, for like 99% of all jobs Excel is always first choice (and correct choice lol). I've never even seen Access…seems like a waste of software honestly.

Post Photo
likeuplifting
Posting as :
works at
You are currently posting as works at

You’re not the target audience. If your company were to ever decide to pursue advanced analytics you’d have data engineers stressing out how to deal with the mess of all the spreadsheets you create

like

Access was/is very unforgiving. If you boo-boo & delete something - it's gone FOREVER!

I agree with you OP. I have never used any other program than Excel and probably only would if I was forced hahah. I am a big time spreadsheet girly and absolutely love how easy Excel is once you learn all the little tricks and tips. Its definitely my first choice.

Excel is my go to. Access is better in certain use cases.

Excel can’t house a database though - it’s great for running analytics on extracted data

I’ve seen access used in retail banking. You have massive datasets(talking in 100’s of millions of lines) and millions new lines coming in each day. Access is pretty helpful for managing these to give analytics teams their db source for dashboards etc

As a civil engineer, excel is my favourite when it comes to construction materials calculations. I never had enough of excel spreadsheet...

Related Posts

Having trouble opening a new bank acc (eg Marcus by GS, Ally) as I‘ve only been in US for a few months and have no credit history. Any international fish have tips to circumvent?

I survived the cull and consider myself lucky for that.

Anyone who hasn't, please post here with your background and industry alignment.

I'm sure many others on here would be willing to put you in touch with personal contacts to help you get back in employment.

Now more than ever, remember that this too shall pass.

like

Anyone get their covid booster shot in 3rd trimester? My ob recommended it but I’m unsure if I should get it now or wait until after delivery.

like

What is the average bonus and hike rate?
Team: Model Validation (Credit Risk)

like
like

Hi Fishes & Sharks,

What will be the in-hand salary? Please guide.

Post Photo
like

Thoughts on Digitas ATL?

like
like

Since it was covered by SNL yesterday, I’m looking for suggestions that can make me feel better in the absence WH press briefing. Any suggestions please

like

Hi,

What is the salary range of a Technical Writer with 5.6 years of experience?

Thanks in advance.

like

Any Alaska Airlines challenges going on now? Or do they match status?

like

Anyone working in Xoriant private solutions ltd. in Hitachi project? Need few info.

like

Hi Fishes,

Does anyone have worked at Vivid Economics or know about the company? There's very limited information/reviews about it. I was wondering if anyone could give me some insights, eg. the culture, people, the benefits, etc. Much appreciated!

like

I got offer as Associate (Technology) from pwc. Can I extend my joining date for 3-4 weeks?

like

Hey guys… I’m a case worker in child safety and I’m someone who loves being outdoors/dies at a desk all day. I’m hoping to organise that at least once a week I can go to a cafe and catch up on all my case notes that need to go into the system.
So far the only reason I’ve been told no is that “if you do then everyone will want to and then no one will be in the office” … how can I convince them that I work better out of the office and get this freedom & mental break for myself?

like

I have been recently selected in Virtusa and in the compensation there are components like Internet reimbursement, LTA, food reimbursement.
Could anybody please help me to understand will these components be paid out to me monthly or will be only provided if i submit the proofs for the particulars.
Also is the food reimbursement offered in the form of monthly Sodexo coupons?

What companies take their in-house brand and marketing teams most seriously? And by that, I mean C-Suite respecting their leadership and placing high expectations on them.

like

Are people called to chennai once every month especially SBA's @Tiger analytics? Or is it a permanent wfh for now?

Are you going to year end Christmas party?

like

Additional Posts in Excel Genius

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

likehelpful

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

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

like

Would anyone be willing to teach me vlookup?

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.

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

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?

likehelpful

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

like

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?

like

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

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

Anyone know what these badges are?

Post Photo
likefunny

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 🙏

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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