Pivot tables, nested formulas, conditional formatting. That's my bread and butter when it comes to Excel, and what I'd recommend beginners focus on. What about you?

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

Conditional formatting, XLOOKUPs, VBA, and Macros

like

Use more tables and memorize shortcuts.

Related Posts

Hello Technie's,
I am in a confused state of mind with my current situation & I can surely use some advice from you guys.
I'm working with a product company for almost 5+ yrs now & recently decided to separate from them for obvious compensation reasons.
I have multiple offers now with product/service based companies.
The top and the best offer I have is from a service based organization of almost 100% hike.
Now my company wants to retain me & offering me even higher. What should I do?

like

Chicago! What meetings near the loop should I hit?

Deloitte tax senior/manager peeps. I’m currently unhappy with the direction EY has gone in the last year plus fed up with the awful admin tech that ends up wasting time. There is a opening at Deloitte that interest me. Yes, I know generally all B4s are the same and a lot depends on your group/location but have a few questions: 1) are you generally happy with the tax leadership? 2) are you overall happy with the Deloitte’s leadership 3) is the admin tech, ie timesheet, scheduling tools, effic

like

Can we just take a moment to recognize how great of a human being Dolly Parton is. She knows how to do good with her wealth.

like

I am thinking of going for a role working as a digital manager for a high end/luxury client. I am currently working on a tech client, but craving a change. Good move or na?

like

How long did it take you to receive your first promotion? I have 3 years of work experience, currently at my 3rd agency, and third associate position. Four people on my brand team have been promoted (across levels and departments, but none in PM). I'm getting sick of being pumped up with empty praise if others are actually being rewarded with accolades.

like

Best ways to create a realistic, healthy work environment?

likehelpfulsmartupliftingfunny

Hi 👋
Here you get to know about different teams under Content Moderation and Community Operations all across India, in various organisations.
All gates are open , flood in with your questions and answers !

Non-PA ? - Are nest thermostats worth the $$? Why or why not?

like

Do any of you ever think about paying off your student loan in one go ?
Given that student loans in the UK is structured differently than the US (the higher you earn, the more you pay - gets written off after 30 years); at what salary range would you even consider paying it all off?

like

People who live with housemates / have a garden. Does it get noisy / do you find people in the garden earlier than (we) finish, that distract you from your work?

Also, living how is living next to a secondary school? Noise / traffic etc?

Thanks

like

Anyone from BCG Gamma who wouldn’t mind DM?

like

What are typical TCs for Associate and Senior Associate roles at small (under 200M AUM) in London and / or DACH?

like

Anyone from the states did a deployment here through work? Any advise on how to go about it?

like

“Who cares if it doesn’t work! You have to sell the vision!”

likefunnyuplifting

My office doesn’t have breakfast food and I am used to being WFH and making whole breakfast at home…any recommendations for healthy, quick options to make at the office?

like

What is your rating of capgemini out of 5.

Compensation:
Wlb :
Learning opportunities :
Yearly hike % :
Onsite opportunities :
Your location :

like

Anyone heard if Wizard of ads?

Really over this job, but company just started my GC application. I hear it takes about 2 years. Is the GC worth the wait? Does the time go by fast? Lol I feel stuck here & just tired. Send help

like

Found a good looking Herman Miller Aeron, used on CL. Worth the 400 bucks? Do not have a proper office chair at the moment

like

Additional Posts in Excel Genius

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)

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

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

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

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

What are your top Excel ninja tricks? Ones that few people know...

like

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

like

How do you fix microsoft excel cannot paste data error?

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

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

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

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

like

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

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

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

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

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

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

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