Additional information
by Henry E. Mejia (Author)
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 examples
- Includes for free 40 Practice excel spreadsheets
- You 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 Pro
- Save time at your job and perform better
TOPICS ALSO COVERED IN THIS BOOK:
- Absolute and Relative References
- Nested 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.
