What should a new associate know for Excel?

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

Pretty much no one expects new staff to know anything past adding and subtracting on Excel, but it's good if you want to have some knowledge before starting. Basic formulas like SUMIF/COUNTIF, VLOOKUP, and generic IF( ) conditions are helpful down the road. Absolutely none of my staff know INDEX(MATCH,MATCH) and don't seem to want to learn anything new, but I would suggest you learn it as it's a powerful formula that you could do a lot with. I also don't know what firm's tools you have at your disposal but if you're starting at a midsize or a small firm, Excel will likely be your best friend if you know how to utilize its features. If you're a keyboard person, you may want to set up your Quick Access ribbon for easier access to functions you use often (like special paste options) and learn other shortcuts.
Tip: Any time I learn a new formula that took me a while to understand, I write it down in my OneNote with an explanation for future-me for when I have to use it again.

like

I'd be a millionaire if I got a dollar for every time I used SUMIFS or XLOOKUP

like

I havent used XLookup yet? Just Vlookup and Hlookup. Wow what's Xlookup used for ?

Related Posts

Anyone in the Houston area?

like

Hi all
Is it possible to change a client In a month if you don’t like work culture . ?

like

Hey Logistics/Supply Chain Folks! 2021 was full of challenges in virtually every facet of the supply chain. What gives you all optimism for 2022?

For me it is how agile cross-functional teams with archaic tendencies have had to be to overcome! I hope that continues into 2022

like

How do i start investing in stocks? Any tips/sites or apps?

Urgent advice needed! Need to choose between two offers
Nokia or JPMC? Location Bangalore and Same pay offered from both work experience 8yrs

Can anyone please help me to figure out how much is fixed and how much variable?

Post Photo
like

Hello fishes

I am currently working as a SCM analyst for auto company. I now have a offer from a company for role of IT systems analyst. The JD is like I will be designing information systems that are appropriate for user needs. The user here are the production plants.

I want to know if this will be a wise move from my end who solely has been on the SCM side.

Any advice team?
YOE 6
Tech stack :
Inventory mgmt,
MRP/MPS,
SQL

like

Your most positive customer interaction?

like

Gaming the Game Has Become the Game

Remember taking Office Politics 101? Nope, no one offers it. Yet, they can steer your assignments , raises & satisfaction. Even your sanity. How do you deal w/ it?

like

Hi Fishers,

43 days has passed in PDP with Timeline for me and there are still no projects avaliable on TMP based on my current skill set. I am upskilling my self as my Home manager asked me but this long period on PDP with Timeline is really making me nervous.
Should I be prepared for the worst and start looking for job change?
Anyone faced such an situation please suggest.
Thanks in Advance!

Post Photo
like

Is anyone from McKinsey or Bain available for a quick chat? I’m looking to change geography and my best bet might be with a different company. I’m currently a consultant at BCG

like

Hi all,

i got a call today after accepting the offer that there is an automation drive happening in infosys and they want me to enrol to that. should I attend it? it's over the weekend. anyone got such a call. please let me know

Does your company have a Asian professional group? Since we are still in covid mode. What are you doing for the professional development classes / events. So we have done, Ask the recruiter, fireside chats w executive mgmt, events w Naaap and ascend. With everyone still working from home ppl are not engaged and it is harder for networking.
Let me know what other thing ppl are doing to drive engagement ?

What’s a minimal but profitable strategy you’ve made since starting your coaching business?

like

I am a creative designer/animator with a leading medical tech company with 6 yrs exp and based in NY. Currently looking for new roles because of relocation requirement at my current role. Any tips or referrals would be really appreciated. TIA!

like

Hearing startups call themselves a “rocket ship” is more annoying than people chewing with their mouth open.

likefunnyuplifting

Looking for senior Salesforce developers/architects in the US! Joined my previous mentor in starting a new Salesforce practice. Company is based in SF but we’re ok with folks working remotely. Might require some travel once it’s safe again but not anytime soon. Good opportunity to be actively involved in building something from nothing

like

My company will be looking for a chemical product manager soon.

like

Looking for a tax strategist. Located in Summit/Eagle County a plus!

like

Additional Posts in Tax Technology

Want to brush up on SQL and Alteryx on my own and I am in the market for a new laptop. Any recommendations on a laptop can can run these programs smoothly?

like

Hi 👋 Nice to have this bowl here! I’m a CPA with 5 years experience in tax who recently realized that I can’t stand doing compliance anymore. Decided to get my masters in CIS and Data Analytics to pivot into tax tech originally but I am afraid I won’t use all my newly learned skills if I stick with tax technology in Big4. Do you code at all in tax tech? Or is it lostly macros and Alteryx?

like

What are some of the best exit opps you all have seen from tax tech?

like

A bowl for all things tax technology

likesmart

Anyone have a good XML viewer/editor that has a grid view? I’m trying to mass review and update tool names and annotations for a number of very large Alteryx workflows. I think an xml editor with a grid view will do what I need but I’m also open to other suggestions if you have them.

like

Anyone use python in big 4 tax? If so, what are some practical uses?

like

How does one try to learn Altyrx with no experience and no (current) access to it? I work at a small firm and am going crazy with so many inefficiencies in repetitive tasks occupying myself and my staffs time. I’d like to self learn and try to come up with concrete solutions to pitch to the partners but want to know what I’m talking about before I do. Any thoughts & suggestions are welcomed.

like

What softwares do you guys use ?

Hellooooo folks

What have you guys automated in your tax teams?

And where do you think automation will take place going forward in your team's?

For my team I know we are trying to automate payroll tax returns. Anyone has similar ideas like that in your respective firms?

like

How can I pivot into indirect tax technology as a indirect tax advisor? Should I get some certification in using some of the tools or just find a job in that space and learn on the go?

like

Which RPA should I learn? Uipath or blue or automation everywhere ?

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