For those of you who work in some kind of sales management position, what are your most used formulas and functions in excel?

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

All of them….

It varies but a lot of the basic ones

Related Posts

Hello Fishes,

Need 11 likes to enable Chat. Please help

like

What is the entry level salary of Senior Analyst?

like

I always thought of Oracle as the evil empire, but for real, what's it like working for them?

Found an attractive posting and I don't want to pass up something good over an opinion I formed as a high school linux geek.

like

Hi,
Anyone here working with
Jio IOT ?? How is the team culture,WLB and growth prospects?Jio

like
like

Need referral to BNP Paribas CIB
Can anyone help please

How is WLB in AMD?

like

How do you work on getting better at concepting & ideation, are there any tips or resources that can help not just creatives but advertising creatives as a whole come up with good ideation & concepts?

like

Anyone still play Pokémon Go?

like

Hello All,

One of my friend has some coupon for LinkedIn Premium subscription for 6 months at better discounted voucher...

If any one interested let me know...

like

Any insights on the London Big 4 bonus range for SM (tax)?

like

Can anyone give review about Honeywell for senior in leadership category.

How long does it take to move from associate 1 to associate 2 in pwc ac?

like

Hi Fishes,

Anyone from Commodities and Global Markets team? I have an offer from the same would like to know how is the Work like balance and overall team?

Any leads will be helpful.
Thanks in advance

like

What has been the shadiest thing someone has done to you at work?

like

Hi folks,

I am already covering 80c 1.5l limit by elss and pf.

Can i invest 50k only in nps and avail tax benefit under 80ccd 1b.

Tia.

like

Anyone have experience using CBD for pain? I have had shoulder pain for years due to a bone spur and thinking about trying it. Most CBD stuff I’ve seen on social media seems sponsor related

like

Anyone recommend their firm for fed tax? Looking to stay in PA in a top 20 to continue working remotely.

like

DM me for referrals!

likefunny

Is it okay if I get fired from D after my H1B transfer for the new employer gets approved ?

Additional Posts in Excel Genius

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

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

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

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

like

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Would anyone be willing to teach me vlookup?

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

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

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

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

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