What do you think?
Rate this book
EXCEL FORMULAS NINJA: The Top Microsoft Excel Functions to Make your Life and Job Easier! Vlookup, If, SumIf, Xlookup and a lot more
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 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 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 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 levelTHIS BOOK IS FOR YOU IF YOU WANT
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
Absolute and Relative ReferencesNested FunctionsHere 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: LO
“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 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 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 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 levelTHIS BOOK IS FOR YOU IF YOU WANT
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
Absolute and Relative ReferencesNested FunctionsHere 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: LO
161 pages, Kindle Edition
Published May 8, 2020
28 people are currently reading
14 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 4 of 4 reviews
May 31, 2020
Perfect
Easy explanation to understand and achieve your skills. Excel Formulas NINJA help me to save time in my daily work.
Thanks
Easy explanation to understand and achieve your skills. Excel Formulas NINJA help me to save time in my daily work.
Thanks
June 3, 2020
Useful
Very good for beginners or as a refresher course. This will aid anyone who used excel. Highly recommend this book
Very good for beginners or as a refresher course. This will aid anyone who used excel. Highly recommend this book
June 13, 2020
Easy introduction to functions.
Very good introduction easy to follow, the practice files are convinient, and we'll thought out. Will now try rest in series.
Very good introduction easy to follow, the practice files are convinient, and we'll thought out. Will now try rest in series.
June 29, 2020
Great purchase
Really easy read and learn, fantastic topics and very helpful to understand every part of excel.
Thank you so much.
Really easy read and learn, fantastic topics and very helpful to understand every part of excel.
Thank you so much.
Displaying 1 - 4 of 4 reviews