Sign-In
Cart
Excel Formulas Ninja: The Top Microsoft Excel Functions to Make your Life and Job Easier! Vlookup, If, SumIf, Xlookup and a lot more
Paperback
Series: Excel Ninjas, Book 1
Publisher: Independently Published
Published: May 11 2020
Pages: 238
Weight: 0.53
Height: 0.50 Width: 5.00 Depth: 8.00
Language: English
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.
Also in
Business General
Crucial Conversations Tools for Talking When Stakes Are High, Second Edition
Switzler, Al
Grenny, Joseph
Patterson, Kerry
Paperback
The Pig and I: The Tale of Our Relationship with a Beast We Eat
Endresen, Kristoffer Hattleland
Hardcover
Inspired: Understanding Creativity: A Journey Through Art, Science, and the Soul
Richtel, Matt
Hardcover
Quiet Girls Can Run the World: Owning Your Power When You're Not the Alpha in the Room
Holman, Rebecca
Paperback
Inclusive Conversations: Fostering Equity, Empathy, and Belonging Across Differences
Winters, Mary-Frances
Paperback
Disney's Land: Walt Disney and the Invention of the Amusement Park That Changed the World
Richard Snow
Hardcover
Climb: Taking Every Step with Conviction, Courage, and Calculated Risk to Achieve a Thriving Career and a Successful Life
Brown, Carolyn M.
Gadsden-Williams, Michelle
Paperback
The Token: Common Sense Ideas for Increasing Diversity in Your Organization
Farmer, Crystal Byrd
Paperback
Paris Chic & Trendy: Designers' Studios, Hip Boutiques, Vintage Shops
Ribes-Tiphaine, Adrienne
Paperback
The Reverse Centaur's Guide to Life After AI: How to Think about Artificial Intelligence--Before It's Too Late
Doctorow, Cory
Paperback
The Let Them Theory: A Life-Changing Tool That Millions of People Can't Stop Talking about
Robbins, Mel
Robbins, Sawyer
Hardcover
Unreasonable Hospitality: The Remarkable Power of Giving People More Than They Expect
Guidara, Will
Hardcover
Hbr's 10 Must Reads on Managing Yourself, Updated and Expanded (Featuring How Will You Measure Your Life? by Clayton M. Christensen)
Drucker, Peter F.
Gallo, Amy
Review, Harvard Business
Paperback
The Risk Worth Taking: A Story of Breaking Free and Trading for a Life You Love
Ijeoma, Teri
Hardcover
Focused & Fearless Leadership: Preventing the Crisis Before It Starts
Overton, Melissa Godwin
Paperback
The Retire Sooner Method: The 5 Secrets Behind America's Happiest (and Unhappiest) Retirees
Moss, Wes
Hardcover
1873: The Rothschilds, the First Great Depression, and the Making of the Modern World
Ahamed, Liaquat
Hardcover
Hbr's 10 Must Reads on Mental Toughness, Updated and Expanded (Featuring How to Stop Worrying about What Other People Think of You by Michael Gervais)
Gervais, Michael
Duckworth, Angela L.
Review, Harvard Business
Paperback
The Goal: 40th Anniversary Edition: A Process of Ongoing Improvement
Goldratt, Eliyahu M.
Cox, Jeff
Paperback
Take Breaks, Work Better: Measure Impact, Not Hours, and Transform Your Profitability
Briggs, John
Paperback
How to Be a Rich Old Lady: Your Guide to Easy Investing, Building Wealth, and Creating the Wild, Beautiful Life You Want
Holden, Amanda
Hardcover
Crucial Conversations: Tools for Talking When Stakes Are High
Patterson, Kerry
Grenny, Joseph
McMillan, Ron
Paperback
How We Could: The Framework to Lead Without Drama, Build Alignment, and Call Teams to Greatness
Dorr, Alex
Hardcover
Hbr's 10 Must Reads on Leadership, Updated and Expanded (Featuring Begin with Trust by Frances X. Frei and Anne Morriss)
Edmondson, Amy C.
Ibarra, Herminia
Review, Harvard Business
Paperback
The Everywhere Millionaire: Who Is Really Rich in America and How They Got There
Zidar, Owen
Zwick, Eric
Hardcover
Money Unlocked: How to Make It, Keep It and Multiply It: The New York Times Bestseller
Lee, John
Paperback
The Freedom-Based Business Method: Reset, Systemize, and Realign Your Business to Live a Life of Harmony
Ellis, Natalie
Hardcover
The Daily Stoic: 366 Meditations on Wisdom, Perseverance, and the Art of Living
Holiday, Ryan
Hanselman, Stephen
Hardcover
Surrender to Lead: The Counterintuitive Approach to Driving Extraordinary Results
Terry, Joe
Kriegel, Jessica
Hardcover
The Courage to Commit: Embrace the Radical Power of Sticking with Something
Johnson, Shawn
East, Andrew
Hardcover
A Guide to the Project Management Body of Knowledge (Pmbok(r) Guide) -- Eighth Edition and the Standard for Project Management
Project Management Institute
Paperback
Who Moved My Cheese?: An A-Mazing Way to Deal with Change in Your Work and in Your Life
Johnson, Spencer
Hardcover
The Infinity Machine: Demis Hassabis, Deepmind, and the Quest for Superintelligence
Mallaby, Sebastian
Hardcover
Conversation: How to Connect with Anyone & Make Every Interaction Count
Van Edwards, Vanessa
Hardcover
The Mom Test: How to talk to customers & learn if your business is a good idea when everyone is lying to you
Fitzpatrick, Rob
Paperback
The Millionaire Next Door: The Surprising Secrets of America's Wealthy
Stanley, Thomas J., PH. D.
Danko, William D., PH. D.
Paperback
Dummies Guide to Starting Your Own Business: Essential Steps to Launching and Scaling a Successful Small Business Venture
Press, Essywrites
Paperback
7-Figure Educator: Turn Your Experience as an Educator Into Income, Impact, and Freedom
Jordan-Thomas, Erica
Paperback
Get Scalable: The Operating System Your Business Needs To Run and Scale Without You
Deiss, Ryan
Paperback
Confidence (HBR Emotional Intelligence Series)
Chamorro-Premuzic, Tomas
Review, Harvard Business
Kanter, Rosabeth Moss
Paperback
The Coaching Habit: Say Less, Ask More, and Change the Way You Lead Forever
Stanier, Michael Bungay
Paperback
What the Heck Is Eos?: A Complete Guide for Employees in Companies Running on EOS
Bouwer, Tom
Wickman, Gino
Hardcover
Never Split the Difference: Negotiating as If Your Life Depended on It
Voss, Chris
Raz, Tahl
Hardcover
I Will Teach You to Be Rich: No Guilt. No Excuses. Just a 6-Week Program That Works (Second Edition)
Sethi, Ramit
Paperback
Twenty Minutes Is the New Hour: The Ambitious Woman's Guide to Doing Less and Achieving More
Hauser, Fran
Hardcover
The Overthinker's Guide to Making Decisions: How to Make Decisions Without Losing Your Mind
Nguyen, Joseph
Hardcover
Stop Asking for Referrals: Build a Magnetic Business Through Intentional Care & Real Relationships
McNally, Flor de Maria
Paperback
Hábitos Atómicos: Cambios Pequeños, Resultados Extraordinarios / Atomic Habits
Clear, James
Paperback
The Eureka Machine: Why AI Is the Key to Unlocking a New Era of Scientific Discoveries
Socher, Richard
Hardcover
Mindful Listening (HBR Emotional Intelligence Series)
Review, Harvard Business
Hougaard, Rasmus
Zenger, Jack
Paperback
Expecting Better: Why the Conventional Pregnancy Wisdom Is Wrong--and What You Really Need to Know
Oster, Emily
Paperback
Atlas of the Heart: Mapping Meaningful Connection and the Language of Human Experience
Brown, Brené
Hardcover
Influence and Persuasion (HBR Emotional Intelligence Series)
Cialdini, Robert B.
Review, Harvard Business
Morgan, Nick
Paperback
A Little More Social: How Small Choices Create Unexpected Happiness, Health, and Connection
Epley, Nicholas
Hardcover
Building Great Businesses: Create Momentum, Overcome Setbacks, and Scale with Confidence
Becker, Scott
Hardcover
Money to Burn: The Unvarnished Truth about Leon Black, Apollo, and the Rise of a New Wall Street
Cohan, William D.
Hardcover
Crucial Accountability: Proven Skills to Build Trust, Address Disappointment, and Get Results, Third Edition
Grenny, Joseph
Hale, Justin
Patterson, Kerry
Hardcover
Happiness (HBR Emotional Intelligence Series)
Review, Harvard Business
McKee, Annie
Gilbert, Daniel
Paperback
Power and Impact (HBR Emotional Intelligence Series)
Cable, Dan
Bregman, Peter
Review, Harvard Business
Paperback
Getting to Yes: Negotiating Agreement Without Giving in
Patton, Bruce
Fisher, Roger
Ury, William
Paperback
Mindfulness (HBR Emotional Intelligence Series)
Goleman, Daniel
Review, Harvard Business
Langer, Ellen
Paperback
The Algorithm: The Hypergrowth Formula That Transformed Tesla, Lululemon, General Motors, and Spacex
McNeill, Jon
Hardcover
How to Work with Complicated People: Strategies for Effective Collaboration with (Nearly) Anyone
Leak, Ryan
Hardcover
No Experience Necessary: Why Betting on Yourself in Your Twenties Is the Best Decision You'll Ever Make
Harary, Ronnen
Hardcover
From Operator to Owner: The Entrepreneur's Guide to Running a Business That Doesn't Run You
Landry, Liz
Hardcover
The Way of Excellence: A Guide to True Greatness and Deep Satisfaction in a Chaotic World
Stulberg, Brad
Hardcover
Hbr's 10 Must Reads on Strategy, Updated and Expanded (Featuring the Five Competitive Forces That Shape Strategy by Michael E. Porter)
Porter, Michael E.
Kim, W. Chan
Review, Harvard Business
Paperback
Feedback That Works: How to Build and Deliver Your Message, Second Edition
Center for Creative Leadership
Paperback
Take It Personal: How to Succeed by Building Relationships and Playing the Long Game
Grutman, David
Hardcover
The Phoenix Project: A Novel about It, Devops, and Helping Your Business Win
Behr, Kevin
Spafford, George
Kim, Gene
Paperback