Excel Help

  • Creator
    Topic
  • #189341
    nicole2035
    Member

    Does anyone know a great place to start to get free materials or a good paid online course? How do people become skilled at building these excel sheets?

    i started downloading free tutorials at accounting web which have helped here and there. i have noticed although i can use the basics of Excel, i’m not great at making my spreadsheets usable or readable from scratch. I also try to look at what my oc-workers spreadsheets look like and they’re not that great either lol. Anyone got some different suggestions other than accounting web?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Author
    Replies
  • #613177
    Kimboroni
    Member

    I have heard many good things about lynda.com.

    AUD 84 (1/9/14-Wiley books/TB + free materials)
    FAR 83 (5/21/14-the above + NINJA 10 Pt Combo Lite)
    REG 84 (7/9/14-Wiley books/TB + NINJA Audio/FC/Notes)
    BEC 76 (10/5/14-Wiley books/TB + NINJA Audio/FC)

    Disclaimer: My ninja avatar is not meant to imply that I have any affiliation with this site other than being a forum member. That's a pic of a T-shirt that my daughter gave me for my birthday. 🙂

    #613178
    Anonymous
    Inactive
    #613179
    ryuhadoken
    Member

    I don't know if this will be helpful or not, but try this guy on Youtube. He has file to download so you can also follow along.

    https://www.youtube.com/user/ExcelIsFun

    #613180
    masa_inn
    Participant

    Huge second to ryuhadoken's suggestion! You can also read “Slaying the Excel Dragon”, written by the same guy who runs the Youtube channel. It's free with Kindle Unlimited, but definitely worth paying for. I also have his book about array formulas; and it's great as well.

    I would highly recommend learning as many keyboard shortcuts as you can master. Ctrl* probably saved me hours of time.

    Also, I converted a lot of my coworkers to ASAP Utilities, as per recommendation of a nice CPA candidate here 🙂

    FAR
    AUD 02/10/14 passed
    BEC
    REG

    Roger, WTB, Ninja materials

    #613181
    Anonymous
    Inactive

    Best way to learn is just to pick something, try to figure out how to optimize, and Google everything you don't know how to do. Like, “I need it to SUM this column based on criteria in both these other columns – how can I do that?” Google and figure it out! I consider myself highly proficient in Excel and this is how I learned everything useful that I know.

    #613182
    leglock
    Participant

    @Masa

    What is asap utilities

    #613183
    masa_inn
    Participant

    @leglock

    https://www.asap-utilities.com/

    These utilities make mass changes (such as make all positive numbers negative, delete extra spaces, etc) a breeze. Pretty much everything they do can be done with formulas, but ASAP is more convenient and saves loads of time.

    FAR
    AUD 02/10/14 passed
    BEC
    REG

    Roger, WTB, Ninja materials

Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.