[eBook] Free - Excel Formulas and Functions 2020 (Adam Ramirez), Machine Learning For Absolute Beginners - Amazon AU/US

1130

Affiliate

Go to Deal

Cashback

Lysander on 17/06/2021 - 15:04 amazon.com.au (2096 clicks)
Last edited 15/09/2021 - 21:18 by 3 other users

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

Some nice freebies to increase your productivity, help your work life a bit easier and maybe even help you in your career progress. All books are highly rated and free at the time of posting.

Excel Formulas and Functions 2020: The Step by Step Excel Guide with Examples on How to Create Powerful Formulas (Excel Academy Book 1)

Machine Learning For Absolute Beginners: A Plain English Introduction (Second Edition) (Machine Learning From Scratch Book 1)

US Links:

Excel Formulas and Functions 2020: The Step by Step Excel Guide with Examples on How to Create Powerful Formulas (Excel Academy Book 1)

Machine Learning For Absolute Beginners: A Plain English Introduction (Second Edition) (Machine Learning From Scratch Book 1)

Enjoy!

---

Always Free eBook:

I Will Teach You Excel: Master Excel, surpass your co-workers, and impress your boss!

(Amazon Au, Amazon USA

Related Stores

Amazon AU

Marketplace

Amazon Cloud Reader

• 

  Noctuafanboy on 17/06/2021 - 15:41

  +7

  Was so excited for the machine learning one. Turns out I already got it in May… And haven't touched it yet.

  • 

    graceyym on 17/06/2021 - 15:54

    +4

    This and about 300 other books..

    • 

      b2dz on 17/06/2021 - 16:02

      +3

      I just counted, I have 576 ebooks. All free from ozbargain. I've flipped through only three of them.

      • 

        Noctuafanboy on 17/06/2021 - 16:34

        +2

        How many Udemy courses have you signed up for?

      • 

        Lysander on 17/06/2021 - 16:37

        +3

        It is time to sell your TV, consoles, and PC, and get cracking with the reading. You will save heaps of money as you won't buy things shown on Ozbargain!

    • 

      Christoshizz on 17/06/2021 - 16:38

      part of me thinks i need to get a kindle just so i can start going through these books ive hoarded for free.

      • 

        Lysander on 17/06/2021 - 16:39

        +2

        You can just use the kindle app on pc or your mobile devices.

        • 

          b2dz on 17/06/2021 - 18:29

          @Lysander: Yeah but it's not the same. Reading on a Kindle is much better. I agree with Christoshizz, but I'm waiting for the new kindle paperwhite to drop with USB C.

          • 

            SaberX on 19/06/2021 - 02:17

            @b2dz: Why does the USB C make a diff if micro USB cables are still easy to get,?

            • 

              b2dz on 19/06/2021 - 06:34

              @SaberX: I only want to carry one type of cable for every device I have.

  • 

    danielglongo on 17/06/2021 - 17:03

    +1

    Same here …. It turns out I "bought" the Machine Learning book last Feb lol.
    100+ books and 500+ Udemy courses from Ozbargain UNTOUCHED.

• 

  Dobs on 17/06/2021 - 22:34

  OFFSET - The most useful Excel function IMHO but isn't included in the first book. (not sure about 2nd)

  OFFSET used in conjunction with exact MATCH is incredibly useful.
  OFFSET can also be used as the anchors of a Range within a formula e.g. A1:OFFSET(A1,100,1)

  Spending a bit of time to play with OFFSET until you are familiar with it, is time well spent for an Excel user.

  The most common structure of my formulae is =IF(ISERROR(function to do something),"",function to do something) to hide errors.
  HTH

  • 

    KaTst3R on 17/06/2021 - 23:51

    +1

    OFFSET is actually discouraged from a modelling best practice perspective as it is difficult to audit in larger models. There are tricky situations which I would use OFFSET in a crafty way, but probably as a last resort if there is no other way of getting the answer/outcome.

    And also instead of using ISERROR you can use IFERROR, so there is no need to put an IF in front. You just use =IFERROR(function,"") which will blank out if there is an error or give you the answer to the function if there is no error.