Excel Formulas Ninja: The Top Microsoft Excel Functions to Make your Life and Job Easier! Vlookup, If, SumIf, Xlookup and a lot more (Paperback)

Excel Formulas Ninja: The Top Microsoft Excel Functions to Make your Life and Job Easier! Vlookup, If, SumIf, Xlookup and a lot more By Henry E. Mejia Cover Image

Excel Formulas Ninja: The Top Microsoft Excel Functions to Make your Life and Job Easier! Vlookup, If, SumIf, Xlookup and a lot more (Paperback)

$12.95


Not On Our Shelves—Ships in 1-5 Days
(This book cannot be returned.)

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

  1. A Straightforward and No Fluff Excel Guide Save time, learn more.
  2. Entertaining Excel Training
  3. Full of screenshots and Formulas and Functions examples
  4. Includes for free 40 Practice excel spreadsheets
  5. You will learn to use a lot of Formulas on excel in many different ways
  6. 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.
  7. 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.

Product Details ISBN: 9798645118303
Publisher: Independently Published
Publication Date: May 11th, 2020
Pages: 238
Language: English