If you're old enough to remember this, you're an OG Excel user ✊

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

Nah, the reason is simple - for excel to recognize something as a formula, you need to start with "="

However, some people realized that you can also start with (+) or (-), which sometimes makes you type faster (worst case scenario, it's the same).

What excel does after you finish your formula is to automatically put the "=", which generates these "=+" expressions

likehelpful

Victor is pretty much correct.

It was more efficient when you had a keyboard with a numeral keypad. You could hit the big “+” key over to the right to start your formula, versus hunting for the small “+” next to the backspace. And of course the “=“ requires an additional key stroke of simultaneously hitting the shift key.

With everyone moving to small laptops that did away with the numeral keypad, I can see how it would seem illogical.

Post Photo
likehelpful

What's the answer

like

Not applicable, I have 2 years of experience

like

+A17

like

You don't need this anymore? Boy I am old

like

Related Posts

Has anyone actually tried virtual therapy for mental health?

like

Solo trip to europe for two weeks this august, 27/F, deciding between two options: city and beachside or maybe both! I generally like walkable cities, good food, bespoke wine bars, stay a while in cafe scenes. Aside from London, Paris, Lisbon, (been to these cities already) any recommendations?? Keeping in mind that europe is still easing out of covid restrictions, would like to head somewhere that’s going to be more open. TIA :).

like

Any good gift ideas for summer interns heading back to school? Would prefer something more meaningful (advertising/writing-related) vs. the gift card route. Thanks!!

likeuplifting

Hello all!

Any thoughts on interview process, compensation, culture etc. at ADQ in Abu Dhabi?

All feedback would be helpful!

Thanks :)

like

Hey everyone,

Expecting an offer from Google for a Product Analyst role. What is the fair fixed component for this role? What would be the CTC? Any inputs are highly appreciated.

like

Has anyone switched from data science "consulting" to Google. And would be open to answer a couple of DMs? Or share their exp. on herr? Thank you

like

Hey! Would anyone be willing to chat about what it’s like working at Microsoft? Found some roles I’m interested in and would love to pick someone’s brains on their experience. Thanks all!

like

Does MS value Agile/Scaled Agile/SAFe etc?

like

Anyone work in Industry Solutions Delivery? Thoughts?

like

Chan Kitha❤️ Song is lit

like

Anyone looking for a senior SALT position , would be in our south florida practice. West Palm Beach, Fort Lauderdale or Miami office

Just found out I got laid off. Cheers to the weekend 🍺

like
like

Hey Guys, Likes Please to activate DM

like

Hello Friends I am looking for an opportunity in the field of Environmental Regulatory Compliance and Sustainability. Please help.

like

Hi Fishes, I am looking for a role in data analyst/Business analyst/product analyst with Hyderabad as location or WFH.
Experience: 2yrs as Senior Analyst at eClerx
Current CTC: 11LPA
expecting CTC: 14LPA+
If you have any vacancy in your company please let me know
Thanks

like

We are looking for Search Language Specialists - Manual Software Testing for our Team.

Requirements :
Primary language proficiency (Read/write/Speak) as Native speaker : Marathi & Bengali (Mandate)

Work Location: Bangalore

Work Type : Hybrid

Degree : IT/Technical Degree

SoftSkills : 
Good Communication skills and willingness to work on internationalisation Localization and Translation query.

Good Team Player.

Experience : 3 years

like

How is Novartis account in Accenture?

like

Hi, My current CTC in Accenture is 14.5LPA and Total years of experience is 9yrs. Thinking about job change. How much CTC I should ask for the next company for 9yrs of experience.

like

I'll be completing 24 months at level12 on sept 30.
when can i expect promotion and how much hike.?

like

Additional Posts in Excel Genius

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

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

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

Anyone know what these badges are?

Post Photo
likefunny

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

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

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’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

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!

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

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

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

Would anyone be willing to teach me vlookup?

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

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

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

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