Mejia - Excel Formulas Ninja: The Top Microsoft Excel Functions to Make your Life and Job Easier!

This is the 1st Book in the EXCEL NINJA SERIES! Becoming an Excel Formulas and Functions Ninja is easier and faster with this book! If you dont believe me, continue reading.A STRAIGHTFORWARD, EXERCISE-BASED AND FAST WAY TO LEARN EXCEL FUNCTIONS - Employee from a State Department of EducationUsing 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.DIFFERENTIATION FACTORS OF EXCEL FORMULAS NINJAA Straightforward and No Fluff Excel Guide! Save time, learn more.Entertaining Excel TrainingFull of screenshots and Formulas and Functions examplesIncludes for free 40 Practice excel spreadsheetsYou will learn to use a lot of Formulas on excel in many different waysYou will learn quickly and in an easy to understand way. At the end of the book you will become an Excel Formulas Ninja with this practice workbook.Gradually increases your knowledge levelTHIS BOOK IS FOR YOU IF YOU WANT TO:Understand once and for all How to use the Top Formulas in excel like a ProSave time at your job and perform betterTOPICS ALSO COVERED IN THIS BOOK:Absolute and Relative ReferencesNested FunctionsHere is the TABLE OF CONTENTSCHAPTER 1: BASIC THINGS ABOUT FUNCTIONSCHAPTER 2: ARITHMETIC FORMULASSUM FASTAVERAGE EASILYGET THE LOWEST VALUE OF A GROUPGET THE HIGHEST VALUE OF A GROUPCOUNT VALUESCREATE A FLEXIBLE ARITHMETIC FORMULAMULTIPLY EASILYMULTIPLY AND SUM FAST AT THE SAME TIMECHAPTER 3: ABSOLUTE REFERENCES, RANKING AND STATISTICS FORMULASCREATE RANDOM NUMBERS FOR YOUR EXPERIMENTGET THE MIDDLE NUMBERGET THE MOST COMMON NUMBERGET THE TOP X NUMBERGET THE BOTTOM X NUMBERCREATE A RANKINGCREATE A SMOOTHER RANKINGROUND NUMBERS THE WAY YOU WANTROUND NUMBERS UPROUND NUMBERS DOWNCONVERT DIFFERENT MEASURESCHAPTER 4: SEARCH AND REFERENCE FORMULASSEARCH IN DATA BASES WITH VLOOKUPSEARCH HORIZONTALLY WITH HLOOKUPLEARN TO USE THE NEW XLOOKUPCHAPTER 5: FINANCIAL FORMULASCALCULATE REAL VALUE WITH ANNUAL CASHFLOWS DISCOUNTING INFLATIONCALCULATE REAL VALUE WITH RANDOM CASHFLOWS DISCOUNTING INFLATIONGET THE INTERNAL RATE OF RETURN FOR YOUR INVESTMENTSLEARN HOW MUCH YOU NEED TO PAY FOR A LOAN OR INVEST FOR A GOALDISCOVER HOW MUCH INTEREST YOU AREPAYINGHOW MANY MONTHS DO YOU NEED TO PAY OR INVEST?HOW MUCH ARE YOU GOING TO RECEIVE IF YOU INVEST IN A TREASURY BOND?CHAPTER 6: LOGICAL FORMULASSET YOUR CUSTOM CRITERIAHIDE ERROSCOUNT VALUES IF A CONDITION IS METSUM VALUES IF A CONDITION IS METCHAPTER 7: TEXT FORMULASEXTRACT TEXT FROM THE BEGINNING AND THE ENDEXTRACT TEXT FROM ANYWHEREELIMINATE SPACESJOIN TEXT FROM MANY CELLS TO ONE CELLCHAPTER 8: QUICK FINAL TIPSTake action now and GET THIS BOOK. Become better at your job, Become and Excel NinjaHow much money is your time/hour worth? $10, $20, $50, $100?Even 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.