Me teaching Excel this week.

Comments

• NumbersCanBeFun@kbin.social ⁨11⁩ ⁨months⁩ ago

  I gave up trying to teach excel to my co workers. Now I just type in all the formulas and lock the cells I don’t want them messing with.

  You would be shocked how many times a week the stupid quote workbook would get messed up because apparently we need to be told a million times not to type into certain cells on the worksheet.

  source

  • Rentlar@lemmy.ca ⁨11⁩ ⁨months⁩ ago

    I usually set up things way differently between Excel stuff for myself and Excel stuff that anyone else is supposed to touch.

    Just colour all the untouchable cells dark grey or black bg on black text, or put on a separate sheet entirely.

    source

    • NumbersCanBeFun@kbin.social ⁨11⁩ ⁨months⁩ ago

      I did try this. I even color coded it red and said “if you type in the red the book is dead”. Didn’t help much 😅

      source
    • jadero@mander.xyz ⁨11⁩ ⁨months⁩ ago

      Gotta lock those cells, even when the sheet never leaves your control.

      source
  • jadero@mander.xyz ⁨11⁩ ⁨months⁩ ago

    I used to teach Excel at an adult vocational college. When I moved into the corporate world, I quickly learned why the University of Hawaii’s research found that well over half of spreadsheets have critical errors. Even the people treated as Excel experts were often clueless.

    I’m not saying that spreadsheets should be banned from the workplace, but they definitely need to be very tightly controlled.

    Oh, and always, always lock formula cells, even in sheets that never leave your control. :) If possible, make use of Excel’s native data forms, too.

    source
  • driving_crooner@lemmy.eco.br ⁨11⁩ ⁨months⁩ ago

    I have a process that use python to read and process some excel files from the commercial team and then the result feed a dashboard. Every week the assistant of the director write me saying that the dashboard didn’t update correctly, I look what happens and everytime it was the commercial people messing with the excel where it was already told hundred of times they should not mess with anything except their corresponding cells. Next week I’m learning how to block the file except the cells they should edit.

    source
• ivanafterall@kbin.social ⁨11⁩ ⁨months⁩ ago

  If you need something aspirational:

  Microsoft Excel World Championships

  source

  • fossilesque@mander.xyz ⁨11⁩ ⁨months⁩ ago

    Haha, I was more angry I had to fat thumb through excel trying to do things for me instead of just coding it out. I think it’s good for the kids to see people experiment and mess up a bit though because it shows them it’s ok to tinker. We got it in the end and they told me it helped! :)

    source

    • EatYouWell@lemmy.world ⁨11⁩ ⁨months⁩ ago

      You could have coded in some VB scripts.

      source

      • -> View More Comments
• Ragdoll_X@lemmy.world ⁨11⁩ ⁨months⁩ ago

  I’m more of a Pandas Dataframe kind of guy myself

  source

  • driving_crooner@lemmy.eco.br ⁨11⁩ ⁨months⁩ ago

    The pd.read_excel() to df.to_excel() pipeline.

    source
  • fossilesque@mander.xyz ⁨11⁩ ⁨months⁩ ago

    You my people.

    source
• teft@startrek.website ⁨11⁩ ⁨months⁩ ago

  youtu.be/hkI-JkaT_Wo?t=42

  Image

  source
• originalucifer@moist.catsweat.com ⁨11⁩ ⁨months⁩ ago

  *sientits

  source