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

That is nice! I am self proclaimed shortcut expert, but there are still a few I didn’t know about in there. I need to print it out and frame it for quick reference! Always takes me a bit to get used to shortcuts but are a real life saver once you are used to them.

like

Some of these are good, but some take longer than just finding the button in the ribbon. Bookmarked anyway, thank you! 😊

like

There is some good stuff in there I'd never realized. Definitely saving it to my Google Keep. I love keyboard shortcuts, it's funny to me how reaching for a mouse is such a minor task, but once you get used to doing things from the keyboard it just seems super annoying.

like

Link saved. Thanks!

like

Related Posts

How do you all keep up with trends in risk and internal audit?

like

Hi Friends,
What will be my in hand salary after all deductions? Thanks in advance.

Post Photo
like

Hi everyone,

I’m currently looking to build a career within the ESG consulting and strategy space. I am in a career transition phase and have a tax consultancy background from a Big 4 for 5+ years. However, I believe I have gained some skills that are transferable to ace at ESG consulting as well. While I am still in the process of upskilling myself and gaining the required knowledge, could you help me with referring my CV or with some leads? 

like

Can someone pls share reviews about camera ISP team in multimedia group of Qualcomm ? Tech stack: camera prototyping. How is the WLB? How much CTC do they offer for 4.5years? Location: bangalore

like

Hello Fishes,

Looking for a job referral in
Toll Group , can anyone please help me out.
I have the Job ID with me.

Thanks in advance:)

like

Does anyone have a preferred car service company? I am looking for a service that can consistently provide traveler alerts such as when car has arrived, passenger is on board, trip competed, etc. across US cities. I have found a company that will do this when I book travel in NYC, but when my Professionals arrive in their destination cities the affiliates do not offer this same feature. Any suggestions? Thank you!

like

Am an executive assistant and There is one executive I support who is very annoying. He doesn't behave this way with backup admin assistants when am out of the office

How do you deal or work with such people?

like

Lease on my current vehicle ends in a few weeks. Do you think auto prices will drop and financing will become free in the next little while?

Should I hold off and Uber around until the drop?

like

I think Alexa is my best friend.

like

Has anyone been able to negotiate anything extra or terms when being laid off?

like

LOS- Tax, retain shows no hours booked for the next few weeks. Asked my coach and he responded not enough work to give all associates 50-55 hours...I haven't received warnings- should I be concerned?

Is Forrester Construction a good company to work for?

like

Living her warmest, cuddliest life 🔥

Post Photo
like

How much does internal operations director at McK or Bain make a year in NAMR?

like

Does anyone know any ISB couples?
(Preferably those who have graduated in 2017 or before)
Please DM.

like

Best consulting firms for PE work (CDD,Value Creation)? Looking for the best firm for exit ops to PE ops eventually. Thanks!

like

Additional Posts in Excel Genius

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

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

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

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

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

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

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

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

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

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

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

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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?

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

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!

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

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

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

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!

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

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