What are your top 3 (or even 1 please) Excel functions that you would definitely recommend people to learn?
I'm trying to setup a learning for new hires on my team (I'm not at BCG anymore, too lazy to change my Fishbowl label) so would appreciate some insights from the gurus here
Thanks for your thoughts 🙏

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

Sumifs, filter, index/match

like

Power query

like

X lookup

like

Pivot tables, lookup, Sumifs, unique

like

Exactly this. And subtotal

Filter, unique, index/match

like

LET

like

There’s a financial modeling world cup. They publish some sample cases with solutions that they can practice with:

https://www.fmworldcup.com/sample-cases/

like

I use advance filter to sort through 7000+ lines of data by filtering out two or three combinations. "Excel is Fun" on YouTube has some great videos on it.

like

Pivot tables, pivot charts, slicers, lookups, filters, delimiting (text to columns)

like

Pivot tables, v-lookups and slicers

like

Without a doubt Index and match. Cant live Without them

like

I learned it here, but the New Window feature. Makes life so much easier when you have a very tabbed workbook and want to compare info on 2 tabs. (Bonus info, you can do it with PPT and word as well to be in the document is 2 different places) 🤯

like

Thanks all!!!
I feel grateful for the recommendations :)

Pivot tables, sumifs, simple macros

Related Posts

Has anyone taken/ hold Snow CIS-Risk & Compliance cert? If so, what was ROI for your career (exam $, study hrs, career uplift/branding)? Looking to take a CIS cert soon and debating between 2 CIS exam I have competencies in (CSA, CIS).

helpful

Non-engineering Googlers, how has your career and salary progression been since you joined?

like

I’ve been doing change management and communication for many years with DEI experience on the side. How do I tell my DEI story to transition to a DEI career? How do I decide what level I should apply for?

like

Hi fishes,
I am currently working as Branch Manager (scale-2 officer) in one of the leading public sector banks and have 5 yr experience in core banking. I am having 2.5 years experience in the IT sector on vision plus as a software engineer (before joining the bank). I have knowledge of core banking as well as good knowledge of banking tools like finacle, caps, imac etc. I want to switch to private financial institutions.
Any suggestions about such institutions and the domain for I can apply

Anyone works for Humana um administrative/support . Would like to know salary,day to day job duties. Any advancement opportunities?

like

Hi Fishes,
I belong to construction industry with PGDM from NICMAR in Advance Construction Management having expirence of 2yrs. I want to know how can I boom my career even after so much of higher education and expirence industry has slow career growth and toxic work culture. Iam not getting how to move further with such underpaid industry even sometime I get the thoughts for switching the career with data science which again needs time and money investment please suggest DS scope for Civil eng

like
like

Hi! If anyone has experience going from Transaction advisory Services to IB please DM me.

like

Hi fishes,
Current I am interviewing for role of data scientist/ data analyst at Genpact. Can anyone give more clarity about organization environment and if it is good to start career in data at Genpact.

like

Im 21, recently got a project manager job in a big media group, I still have about one year to do in my degree. Where would you recommend I take my career next, what would be the logical next jobs I could explore in that field?

like

Any nurses here not have hospital experience? I work as a community nurse and have previous experience in an assisted living and clinic. I don’t have much interest in going to the hospital. Been a nurse for about 9 years. Started out as LPN and now I have small children and enjoy my flexibility. Any regrets for those that never did the hospital ?

like

I'm a Communications major and a Management major. I have a Marketing concentration and a System Information & Business Analytics concentration. I accomplished this in 4 years and will be graduating this semester.

I have experience working as a Business developer and account executive at a start up company in the robotics industry.

Questions:
What type of job should I be looking for?

What type of certifications should i be looking at?

Any over all advice in to my career path is welcomed.

like

If I get laid off, I have a previous colleague that started a cybersecurity company. I would love to get involved on the business side of it. Any pointers on skills that are attractive in this realm for a startup? Would be mostly (if not all) federal defense contracting clients. I’m currently in Deloitte’s cyber risk practice but my background and passion is in accounting and finance, and business operations. Graduated in 2017 so still early career.

like

Guy,

How can I get into Microsoft without an MBA in a Program manager role?

I am currently an Associate Product Manager. Overall Exp 4yrs.

Is it possible to get in or MBA is a must...

helpful

After every busy season, I think about leaving public accounting and/or the firm. I have 5+ years in tax. Anyone switch to audit/consulting from tax? Two busy seasons a year, with barely anytime to chill in between is exhausting. Anyone in private looking to hire someone with a background in federal tax?

like

Hi Fishes,

Currently I am working as senior software engineer in a product base company. My tech stacks are React, Redux, Node, AWS and Graphql. I am thinking to switch the carrier in Block Chain or Data Science. Will it be a good decision to make the shift.

Total experience is 5 years.

If it's okay to shift. Could you please help me with the steps for preparation? I will really appreciate the help.

Thanks a lot.

like

Is RPA a bubble and will soon fade away? How much valuable is it as a skill set?

Is being a journalist a financially stable career?

likehelpful

Hi,

Wanted to check if there are any L5 opportunities available in Operation role or not. I am working in Amazon since last 3+ years with at same L4 role. Want to grow now

like

More Posts

Career pivot into consulting? I've always been in a non client serving role and I just want that opportunity? Even completed an MBA and no luck. Too much experience in one area that am no longer interested on.

like
like

What’s the common process for when a client offering you a job at the end of the project? Do you still have to go through interviews and stuffs like a normal application or the client would just send you an offer?
The client asked me to join their team, we talked about the position (no specific comp yet), and they asked for my resume. Just want to know what the common process is like in this situation, TIA.

likehelpful

Hi all, looking for a job change. Currently working as a group lead. I have 10nyeara of experience. Preferred location is hyderabad or visakhapatnam

like

After LWD , In how many days FIS will do my FNF settlement and will provide Relieving letter ??

I have returned my Joining Bonus with gst already before LWD as they requested.

Kindly tell whoever has left.

like

Hi, I am bringing together a team through a reorg any suggestions on how to bring a new team together remotely?

like

Hi team,

I left wipro and joined new company a month before. In new company's form 11 ita asking whether you have been part of epf and eps in last organization?
Epf i am sure i need to give yes. But what do i need to give for Eps? I am aware that wipro contributed 8.33% of pf to eps. Can i transfer that too?

like

Accenture hiring process? How long does it take from start to offer? Accenture

like

Has anyone relocated their pet from India to australia

like

Hi Fishes,
How long does it take to release offer letter from HSBC. I already have given HR round and submitted documents for background verification.

like

How much annual hike of Tiger Analytics for Senior Software Engineers - (Data Engineer). I have cleared interview round. I was offered SSE. On Monday, There is a salary negotiation round. It really helps if you share the max budget of this position. Tiger Analytics

How often do you cry at your job? I cry usually one day a week triggered by stress/overwhelm but want to know if this is a typical response

like

Anyone at ZS willing to chat about a SIPA role? A recruiter reached out to me.

like

Hi Target folks, can anyone refer me for senior data scientist role?
Thanks

Does anyone have suggestions for a talented DP who’s looking to get repped but having a hard time getting responses?

like

EY leave department hasn’t been the most helpful with the exact details around maternity leave - so just wondering for any EY mamas - how do we initiate getting the two weeks before due date off? Just a doctors note or ??? Thank you!!

like

I am moving to Bangalore the next weekend, by 17th July. Seems there is a slight increase in covid cases, would it be better to come now or should I ask my manager to come to office after some weeks once everything seems fine?

like
like

Additional Posts in Excel Genius

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Anyone know what these badges are?

Post Photo
likefunny

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

like

Still don't have xlookup. #fomo

like

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

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.

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

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

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

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

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

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

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

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

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