{"product_id":"excel-formulas-ninja-the-top-microsoft-excel-functions-to-make-your-life-and-job-easier-vlookup-if-sumif-xlookup-and-a-lot-more-paperback","title":"Excel Formulas Ninja: The Top Microsoft Excel Functions to Make your Life and Job Easier! Vlookup, If, SumIf, Xlookup and a lot more - Paperback","description":"\u003cp\u003eby \u003cb\u003eHenry E. Mejia\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eThis is the 1st Book in the \u003cstrong\u003e\u003cem\u003eEXCEL NINJA SERIES\u003c\/em\u003e\u003c\/strong\u003e  \u003cstrong\u003eBecoming an Excel Formulas and Functions Ninja is easier and faster with this book  \u003c\/strong\u003eIf you don't believe me, continue reading.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003e\u003cem\u003e\"A STRAIGHTFORWARD, EXERCISE-BASED AND FAST WAY TO LEARN EXCEL FUNCTIONS\" - Employee from a State Department of Education\u003c\/em\u003e\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eUsing excel formulas is an unbelievable advantage because you can get more things done, investing less time in front of the computer. There are a lot of Excel functions like: Vlookup, Xlookup, IF, Sumif, CountIf, Concatenate, Round, Index Match, etc., and with this book it will take no time to master the TOP FORMULAS.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eDIFFERENTIATION FACTORS OF EXCEL FORMULAS NINJA\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eA Straightforward and No Fluff Excel Guide  Save time, learn more.\u003c\/li\u003e\n\u003cli\u003eEntertaining Excel Training\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eFull of screenshots and Formulas and Functions examples\u003c\/li\u003e\n\u003cli\u003eIncludes for free 40 Practice excel spreadsheets\u003c\/li\u003e\n\u003cli\u003eYou will learn to use a lot of Formulas on excel in many different ways \u003c\/li\u003e\n\u003cli\u003eYou will learn \u003cstrong\u003equickly and in an easy to understand way\u003c\/strong\u003e. At the end of the book you will become an Excel Formulas Ninja with this practice workbook.\u003c\/li\u003e\n\u003cli\u003eGradually increases your knowledge level\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eTHIS BOOK IS FOR YOU IF YOU WANT TO: \u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eUnderstand once and for all How to use the Top Formulas in excel like a Pro\u003c\/li\u003e\n\u003cli\u003eSave time at your job and perform better\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eTOPICS ALSO COVERED IN THIS BOOK: \u003c\/strong\u003e\u003cbr\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAbsolute and Relative References\u003c\/li\u003e\n\u003cli\u003eNested Functions\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHere is the TABLE OF CONTENTS\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eCHAPTER 1: BASIC THINGS ABOUT FUNCTIONS\u003c\/p\u003e\u003cp\u003eCHAPTER 2: ARITHMETIC FORMULAS\u003c\/p\u003e\u003cp\u003eSUM FAST\u003c\/p\u003e\u003cp\u003eAVERAGE EASILY\u003c\/p\u003e\u003cp\u003eGET THE LOWEST VALUE OF A GROUP\u003c\/p\u003e\u003cp\u003eGET THE HIGHEST VALUE OF A GROUP\u003c\/p\u003e\u003cp\u003eCOUNT VALUES\u003c\/p\u003e\u003cp\u003eCREATE A FLEXIBLE ARITHMETIC FORMULA\u003c\/p\u003e\u003cp\u003eMULTIPLY EASILY\u003c\/p\u003e\u003cp\u003eMULTIPLY AND SUM FAST AT THE SAME TIME\u003c\/p\u003e\u003cp\u003eCHAPTER 3: ABSOLUTE REFERENCES, RANKING AND STATISTICS FORMULAS\u003c\/p\u003e\u003cp\u003eCREATE RANDOM NUMBERS FOR YOUR EXPERIMENT\u003c\/p\u003e\u003cp\u003eGET THE MIDDLE NUMBER\u003c\/p\u003e\u003cp\u003eGET THE MOST COMMON NUMBER\u003c\/p\u003e\u003cp\u003eGET THE TOP X NUMBER\u003c\/p\u003e\u003cp\u003eGET THE BOTTOM X NUMBER\u003c\/p\u003e\u003cp\u003eCREATE A RANKING\u003c\/p\u003e\u003cp\u003eCREATE A SMOOTHER RANKING\u003c\/p\u003e\u003cp\u003eROUND NUMBERS THE WAY YOU WANT\u003c\/p\u003e\u003cp\u003eROUND NUMBERS UP\u003c\/p\u003e\u003cp\u003eROUND NUMBERS DOWN\u003c\/p\u003e\u003cp\u003eCONVERT DIFFERENT MEASURES\u003c\/p\u003e\u003cp\u003eCHAPTER 4: SEARCH AND REFERENCE FORMULAS\u003c\/p\u003e\u003cp\u003eSEARCH IN DATA BASES WITH VLOOKUP\u003c\/p\u003e\u003cp\u003eSEARCH HORIZONTALLY WITH HLOOKUP\u003c\/p\u003e\u003cp\u003eLEARN TO USE THE NEW XLOOKUP\u003c\/p\u003e\u003cp\u003eCHAPTER 5: FINANCIAL FORMULAS\u003c\/p\u003e\u003cp\u003eCALCULATE REAL VALUE WITH ANNUAL CASHFLOWS DISCOUNTING INFLATION\u003c\/p\u003e\u003cp\u003eCALCULATE REAL VALUE WITH RANDOM CASHFLOWS DISCOUNTING INFLATION\u003c\/p\u003e\u003cp\u003eGET THE INTERNAL RATE OF RETURN FOR YOUR INVESTMENTS\u003c\/p\u003e\u003cp\u003eLEARN HOW MUCH YOU NEED TO PAY FOR A LOAN OR INVEST FOR A GOAL\u003c\/p\u003e\u003cp\u003eDISCOVER HOW MUCH INTEREST YOU AREPAYING\u003c\/p\u003e\u003cp\u003eHOW MANY MONTHS DO YOU NEED TO PAY OR INVEST?\u003c\/p\u003e\u003cp\u003eHOW MUCH ARE YOU GOING TO RECEIVE IF YOU INVEST IN A TREASURY BOND?\u003c\/p\u003e\u003cp\u003eCHAPTER 6: LOGICAL FORMULAS\u003c\/p\u003e\u003cp\u003eSET YOUR CUSTOM CRITERIA\u003c\/p\u003e\u003cp\u003eHIDE ERROS\u003c\/p\u003e\u003cp\u003eCOUNT VALUES IF A CONDITION IS MET\u003c\/p\u003e\u003cp\u003eSUM VALUES IF A CONDITION IS MET\u003c\/p\u003e\u003cp\u003eCHAPTER 7: TEXT FORMULAS\u003c\/p\u003e\u003cp\u003eEXTRACT TEXT FROM THE BEGINNING AND THE END\u003c\/p\u003e\u003cp\u003eEXTRACT TEXT FROM ANYWHERE\u003c\/p\u003e\u003cp\u003eELIMINATE SPACES\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eJOIN TEXT FROM MANY CELLS TO ONE CELL\u003c\/p\u003e\u003cp\u003eCHAPTER 8: QUICK FINAL TIPS\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eTake action now and GET THIS BOOK. \u003cstrong\u003eBecome better at your job, Become and Excel Ninja\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eHow much money is your time\/hour worth?\u003c\/strong\u003e $10, $20, $50, $100?\u003c\/p\u003e\u003cp\u003eEven if this book could save you just 1 hour a week, it would have been a great return of your investment. And believe me, you can save much more time than just 1 hour a week. \u003c\/p\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 238\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.5 x 8 x 5 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e May 11, 2020\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":51789547864352,"sku":"9798645118303","price":17.82,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0974\/9764\/5344\/files\/6242cc92505bcb9bc5704465b9764fa5.webp?v=1780667263","url":"https:\/\/ebocreations.com\/products\/excel-formulas-ninja-the-top-microsoft-excel-functions-to-make-your-life-and-job-easier-vlookup-if-sumif-xlookup-and-a-lot-more-paperback","provider":"The E-Book Oasis LLC","version":"1.0","type":"link"}