EXCEL FORMULAS NINJA: The Top Microsoft Excel Functions to Make your Life and Job Easier! Vlookup, If, SumIf, Xlookup and a lot more (Excel Ninjas) - Softcover

Mejia, Henry E.

Softcover

ISBN 13: 9798645118303

Publisher: Independently published, 2020

Synopsis

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. 

About this title

About the Author

Henry E. Mejia is an online entrepreneur who discovered the great benefit of knowing how to use Microsoft Excel at an advanced level, and now he devotes part of his time to creating courses so that more people can enjoy free time and better opportunities that an Advanced Excel user can have. Henry also realized that the vast majority of people give away a lot of their life in front of the computer. That time could be used in more productive or more enjoyable activities, only if people knew how to use Excel a little better. The goal of Henry's books is to open the door for workers and business owners to use Excel more efficiently, so they can have more and better growth opportunities.

Edition details

• Publisher: Independently published
• Publication date: 2020
• Language: English
• ISBN 13: 9798645118303
• Binding: Paperback
• Number of pages: 236