Free Course - Zero to Hero in Microsoft Excel: Complete Excel Guide 2020 @ Udemy

2400

Affiliate

Go to Deal

Cashback

Taegukgi on 19/04/2020 - 11:41 udemy.com (9326 clicks)
Last edited 19/04/2020 - 11:42

APRIL2020F

This post contains affiliate links. OzBargain might earn commissions when you click through and make purchases. Please see this page for more information.

Rated 4.4 (660 ratings), 34,608 students.

What you'll learn

A Beginner's Guide to Microsoft Excel - Microsoft Excel, Learn Excel, Spreadsheets, Formulas, Shortcuts, Macros
Knowledge of all the essential Excel formulas
Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing
Master Excel's most popular lookup functions such as Vlookup, Hlookup, Index and Match
Harness full potential of Excel by creating Pivot tables with slicers
Make great presentations using the Conditional and Table formatting options
Visually enchant viewers using Bar charts, Scatter Plots, Histograms etc.
Increase your efficiency by learning how to create and use important Excel shortcuts
Explore fun and exciting use cases of Excel

Related Stores

Udemy

• 

  Nugs on 19/04/2020 - 11:47

  normally $109.99 !!!! does anyone actually pay that to learn excel?
  .

  • 

    NatoTomato on 19/04/2020 - 12:34

    +15

    No. Nobody pays full price on Udemy because they always have 90% sales.

  • 

    PukeyLuke on 19/04/2020 - 13:50

    +6

    @Nugs Who normally pays $109.99 !!!! Well do the free course. Then do some research on who pays, who gets Udemy for free and who gets 90% off.
    Then do a masterful Excel presentation, with stunning graphs that turn your raw data into ‘must make’ decisions!!

  • 

    reactor-au on 19/04/2020 - 19:26

    They have to pay to learn excel so they can run the numbers, must be a CRC error or sum kind. Lol

• 

  zrach on 19/04/2020 - 12:00

  Does anyone know if this will be useful if I’m just using google sheets?

  • 

    JStar73 on 19/04/2020 - 12:05

    +12

    I would suggest this course for Google Sheets…
    https://courses.benlcollins.com/p/advanced30
    I learnt heaps from that and it is what I refer back to often
    J*73

    • 

      tardis3 on 19/04/2020 - 12:48

      This is awesome, thank you

    • 

      Mysterious on 19/04/2020 - 16:24

      Thanks. Really enjoy these 30 day challenge formats.

    • 

      zrach on 19/04/2020 - 23:31

      Thanks a lot!

• 

  Okayy on 19/04/2020 - 12:16

  -1

  zero to hero! no thanks!

• 

  andrewsant on 19/04/2020 - 12:57

  +2

  Nothing makes hero to zero like Microsoft Office version updates. Every version makes you have to re-learn everything you have already mastered.

• 

  dsp26 on 19/04/2020 - 15:09

  +1

  Once you move on to Google Sheets you won't go back to Excel. For majority of spreadsheet users who do a lot of calculations at almost database scale, GSheets ARRAYFORMULA and QUERY function allows you to create a single formula that is able to populate an entire sheet instead of multiple formulas that chew system resources. This is very useful to have a single formula with variable references then locked, so when other users modify the tab data, ie delete data, it is instantly replaced, and if manual data was inputted, the entire sheet would go blank and you'd know where the manual in put was. Then combined with unlimited revision history and rollback associated with the username who made the changes.. beets having multiple excel files.

  And even then, if you did need to move to database scale (ie, Access), the things you could do with Google cloud console functions and a BigQuery table is almost limitless in comparison.

  Also coding in Javascript (Google Scripts) and being able to implement cloud API's trumps coding in VBA of excel.

  Though i've left it that long ago, I have no idea what new functions there are in Office 2019 or if the online 365 is comparable

  • 

    7hours 44min ago on 19/04/2020 - 21:10

    365 is great.

  • 

    FareEvader on 19/04/2020 - 21:20

    +3

    Sometimes, it's not by choice. It's what software your employer might choose to use.

  • 

    greatlamp on 19/04/2020 - 22:34

    +1

    Array formulas are fixed in the latest versions of excel.

    I agree there are many benefits to learning google sheets, but in a lot of jobs you won't be able to use google for sensitive data.

• 

  perfectlydark on 19/04/2020 - 15:46

  +6

  just going to say if you arent that confident in excel, do the course. its the single best software application ive had to use and still does more than most of the flashier new BI apps do, although you gotta work a little for it and processing time can be an issue for some functions on large datasets. Probably not doing a good job selling it but I love excel as one of my own kids