Excel Genius

19291 members
Discussions, Useful Tips, Resources, Macros, More

Is there a way where I can sum up the value by categories ( say L/M/H) for each section?

like
Reaction Icon Like
Arrow Icon

What are the 15 best shortcuts I should teach my mom for her to get better at Excel for her job (She is probably a 4.5/10 at excel) Any personal favorites that you like and no one else uses often?

like
Reaction Icon Like
Arrow Icon

Does anyone know what causes a cell reference in a formula, to include the sheet name when the formula is in that same sheet? Ie. On Sheet 1, =SUM(Sheet 1’! A1:A10)

like
Reaction Icon Like
Arrow Icon

So, this is a SharePoint question, but I thought someone here may know the answer. Can anyone tell me how to write a formula in a date field validation to restrict responses to a date after a certain date? Say, I wanted to only allow dates after 07/05/2020. Google and YouTube failed me.

like
Reaction Icon Like
Arrow Icon

Our group is exploring Alteryx. When I review im Excel, I can click on a cell to verify the formula. In Alteryx, I will get a hard coded Excel sheet. What are some ideas to make Alteryx reviewable?

like
Reaction Icon Like
Arrow Icon

Best CapIQ tips and tricks for excel API? Recently discovered you can import screens from your account (using new template) directly into Excel with CIQ identifiers. Any other cool tricks?

like
Reaction Icon Like
Arrow Icon

That time of the week again! Weekly tip thread below:

like
Reaction Icon Like
Arrow Icon

Trying to count across multiple columns with 2 criteria, too long for sum product, trying to put into VBA... any ideas?

likehelpful
Reaction Icon Like
Arrow Icon

It almost feels silly to ask, but my company issues Thinkpad X1 Carbons with 16gb ram and they still crash when I try to save 10mb excel files. I know that there are tricks (like going to manual calc and turning off auto calc at save) but I struggle to believe that crashes on an ostensibly high-end machine for what’s really not a lot of data can be considered normal. Does anyone know how to improve performance (or what computer specs we should be looking to improve on if we upgrade hardware)?

like
Reaction Icon Like
Arrow Icon

Hi I need help please! Trying to sumifs with one of the criteria being a blank cell. Problem is the cell is not truly blank as it contains a formula that is producing the blank cell. How can I get around this to get my proper summed results???

like
Reaction Icon Like
Arrow Icon

Does anybody know how to create a series of PDFs from a data validation list wherein (be it macros, etc.) the program runs through each individual name in the list and pulls in the associated data points that are specific to field on the list, while simultaneously labeling each pdf report unique to the name on the list? Currently, I must cycle through one-by-one, click “save” each time, and then label it, which takes hours.

like
Reaction Icon Like
Arrow Icon

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
Reaction Icon Like
Arrow Icon

Help. OMG Help. I accidentally reverted to an old excel version and lost all of my changes. They are in none of the versions in the history. Is it gone forever??

like
Reaction Icon Like
Arrow Icon

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?

like
Reaction Icon Like
Arrow Icon

Flashfill not sequencing numbers when using the handle it’s just copying numbers....

like
Reaction Icon Like
Arrow Icon

Are there any free resources to learn financial modeling for buy/sell deals?

like
Reaction Icon Like
Arrow Icon

Tip of the week thread: If anyone has any fun tips or tricks they feel like everyone should know, please comment below!

likeuplifting
Reaction Icon Like
Arrow Icon

What are some good free resources for new consultants joining with zero to little experience? Things like navigating excel with keyboard. Vloookups, pivot tables?

like
Reaction Icon Like
Arrow Icon

Does anyone here use ASAP Utilites as an Excel add-in? This thing is amazing.

like
Reaction Icon Like
Arrow Icon

How to change a date field from 2002/01/15 to YYYY-MM-DD. The right click and date selection is not converting it for some reason. Even tried to do a custom field but it’s not changing :(

like
Reaction Icon Like
Arrow Icon

Download the Fishbowl app

That was just a preview…
Sign Up to see all discussions
  • Discover what’s 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 with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Sign in here

Share

Embed this post

Copy and paste embed code on your site

Preview