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

1130

Related Stores

Amazon AU
Amazon AU
Marketplace
Amazon Cloud Reader
Amazon Cloud Reader

closed Comments

  • +7 votes

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

    • +4 votes

      This and about 300 other books..

      • +3 votes

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

        • +2 votes

          How many Udemy courses have you signed up for?

        • +3 votes

          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!

      •  

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

        • +2 votes

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

          •  

            @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.

            •  

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

              •  

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

    • +1 vote

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

  •  

    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

    • +1 vote

      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.