Excel 2019 Functions : 70 Top Excel Functions Made Easy - Nathan George

Excel 2019 Functions

70 Top Excel Functions Made Easy

By: Nathan George

Paperback | 25 August 2019

At a Glance

Paperback


$44.44

or 4 interest-free payments of $11.11 with

 or 

Aims to ship in 7 to 10 business days

Leverage the Full Power of Excel Functions

Excel 2019 Functions provides a detailed walkthrough of 70 of the most useful Excel functions, including many tips to enable you to maximize the power of Excel through the use of functions.

This book provides a detailed description of each function, its arguments, and its use is demonstrated with fitting examples. Learn how to use functions like VLOOKUP, IFS, COUNTIFS, DATEDIF, NETWORKDAYS, FIND, NPV, SUMIFS etc. From simple calculations to building complex spreadsheets that require multiple formulas, knowing the right function to use can increase the accuracy and efficiency of your work.

Achieve More with Less Effort

Learn new functions introduced in Excel 2016 and 2019 like the IFS functions that make it easier to create powerful formulas much simpler syntax.

Excel 2019 Functions will be a great reference guide for you whether you're a beginner or already skilled with Excel. By the time you finish this guide, you will understand how functions work in Excel, how to find the right functions, and how to combine them in solving complex problems.

This book comes with downloadable Excel practice files for all examples. Hence, you can follow the tutorials without needing to create the examples from scratch in Excel. You can also copy the tried and tested formulas and use them in your own workbooks.

In this book, you'll learn how to:

  • Find and enter functions in Excel.
  • Use lookup and reference functions to find and reference values in your formulas.
  • Use logical functions to execute conditional statements and calculations.
  • Deploy IFS functions in place of convoluted nested functions for more efficient and robust formulas.
  • Use a wide array of date and time functions to address all kinds of date calculations.
  • Manipulate text strings with text functions.
  • Carry out financial calculations with special financial functions.
  • And much more...

Buy now to get started today!

More in Spreadsheet Software

Microsoft Excel 365 Bible : Bible - Michael Alexander

RRP $95.95

$62.25

35%
OFF
Excel 2019 For Dummies : Excel for Dummies - Greg Harvey

RRP $52.95

$39.35

26%
OFF
Excel Formulas & Functions For Dummies : 6th edition - Ken Bluttman
Excel All-in-One For Dummies : For Dummies (Computer/Tech) - Paul McFedries
Financial Modeling in Excel For Dummies : 2nd edition - Danielle Stein Fairhurst
Excel Dashboards & Reports For Dummies : 4th edition - Michael Alexander
Microsoft Power BI Dashboards Step by Step : Step by Step - Errin O'Connor
Microsoft Excel 2019 Step by Step : Step by Step - Curtis Frye

RRP $60.95

$44.35

27%
OFF
Financial Analysis with Microsoft Excel : 9th edition - Timothy Mayes
Advancing into Analytics : From Excel to Python and R - George Mount
Excel 2010 : The Missing Manual - Matthew MacDonald

RRP $60.80

$29.25

52%
OFF
Excel Hacks : Hacks - David Hawley

RRP $45.75

$26.25

43%
OFF
Microsoft 365 Excel VBA Programming For Dummies - Dick Kusleika
Head First Excel : A Learner's Guide to Spreadsheets - Michael Milton
Learning Statistics and EXCEL in Tandem - Saroja Selvanathan

RRP $104.95

$89.50

15%
OFF
Excel Data Analysis For Dummies : 5th edition - Paul McFedries

BOXING DAY

RRP $69.95

$27.95

60%
OFF