Today I learned that Microsoft has an official link for shortcuts in excel:
https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f

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

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? 

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

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!

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?

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?

I think Alexa is my best friend.

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

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?

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

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

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

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.

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.

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

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 😭

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

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.

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?

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.

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.

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 🙏

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

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.

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 🙏

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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?