Henry E Mejia

Excel Formulas Ninja Henry E Mejia

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 don't believe me, continue reading.

"A STRAIGHTFORWARD, EXERCISE-BASED AND FAST WAY TO LEARN EXCEL FUNCTIONS" - Employee from a State Department of Education

Using 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 NINJA

A Straightforward and No Fluff Excel Guide! Save time, learn more. Entertaining Excel Training
Full 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 ways You 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 level

THIS 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 better

TOPICS ALSO COVERED IN THIS BOOK:


Absolute and Relative ReferencesNested Functions

Here is the TABLE OF CONTENTS

CHAPTER 1: BASIC THINGS ABOUT FUNCTIONS

CHAPTER 2: ARITHMETIC FORMULAS

SUM FAST

AVERAGE EASILY

GET THE LOWEST VALUE OF A GROUP

GET THE HIGHEST VALUE OF A GROUP

COUNT VALUES

CREATE A FLEXIBLE ARITHMETIC FORMULA

MULTIPLY EASILY

MULTIPLY AND SUM FAST AT THE SAME TIME

CHAPTER 3: ABSOLUTE REFERENCES, RANKING AND STATISTICS FORMULAS

CREATE RANDOM NUMBERS FOR YOUR EXPERIMENT

GET THE MIDDLE NUMBER

GET THE MOST COMMON NUMBER

GET THE TOP X NUMBER

GET THE BOTTOM X NUMBER

CREATE A RANKING

CREATE A SMOOTHER RANKING

ROUND NUMBERS THE WAY YOU WANT

ROUND NUMBERS UP

ROUND NUMBERS DOWN

CONVERT DIFFERENT MEASURES

CHAPTER 4: SEARCH AND REFERENCE FORMULAS

SEARCH IN DATA BASES WITH VLOOKUP

SEARCH HORIZONTALLY WITH HLOOKUP

LEARN TO USE THE NEW XLOOKUP

CHAPTER 5: FINANCIAL FORMULAS

CALCULATE REAL VALUE WITH ANNUAL CASHFLOWS DISCOUNTING INFLATION

CALCULATE REAL VALUE WITH RANDOM CASHFLOWS DISCOUNTING INFLATION

GET THE INTERNAL RATE OF RETURN FOR YOUR INVESTMENTS

LEARN HOW MUCH YOU NEED TO PAY FOR A LOAN OR INVEST FOR A GOAL

DISCOVER HOW MUCH INTEREST YOU AREPAYING

HOW 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 FORMULAS

SET YOUR CUSTOM CRITERIA

HIDE ERROS

COUNT VALUES IF A CONDITION IS MET

SUM VALUES IF A CONDITION IS MET

CHAPTER 7: TEXT FORMULAS

EXTRACT TEXT FROM THE BEGINNING AND THE END

EXTRACT TEXT FROM ANYWHERE

ELIMINATE SPACES


JOIN TEXT FROM MANY CELLS TO ONE CELL

CHAPTER 8: QUICK FINAL TIPS




Take action now and GET THIS BOOK. Become better at your job, Become and Excel Ninja

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