Excel Formulas and Functions

80 Top Excel Functions Made Easy

Nathan George

$67.95 $57.78

Hardback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

GTech Publishing
09 December 2022

Spreadsheet software

Series: Excel 365 Mastery

Summary
Details

Leverage the full power of Excel functions

Excel Formulas and Functions provides clear, step-by-step explanations on creating formulas with over 80 of the most useful Excel functions.

This book provides a detailed description of each function, its arguments, and practical examples relevant to real-world productivity tasks. Create powerful formulas with simpler syntax using modern functions like IFS, XLOOKUP, XMATCH, TEXTSPLIT, and FILTER. 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.

Excel Formulas and Functions is a great reference guide for working with Excel in your job, business, studies, or home. This book has been organized to make it easier for you to quickly find answers to your questions.

Downloadable sample files for hands-on learning

All examples in this book are available online as downloadable Excel files. You can learn Excel formulas and functions faster with the sample files as you don't need to create the examples in the book from scratch. You can copy and adapt the tried and tested formulas for use in your own worksheets.

This book covers the latest version of Excel for Microsoft 365 (2022 update).

In this book, you'll learn how to:

Troubleshoot and fix formula errors. Use the latest lookup and reference functions to find and reference values in your formulas. Return rows and columns of data using dynamic array functions. Sort and filter data without changing the source data. Use logical functions to include decision branches in your formulas. Deploy advanced logical functions in place of convoluted nested functions for more efficient and flexible solutions. Use date and time functions to address a wide range of date calculations. Manipulate text strings easily with new and more flexible text functions. Perform a variety of aggregate and summary calculations using math and statistical functions. Calculate loan payments, the value of investments, and depreciation using special financial functions.

By: Nathan George
Imprint: GTech Publishing
Country of Publication: United Kingdom
Dimensions: Height: 254mm, Width: 178mm, Spine: 18mm
Weight: 735g
ISBN: 9781915476081
ISBN 10: 1915476089
Series: Excel 365 Mastery
Pages: 300
Publication Date: 09 December 2022
Audience: General/trade , ELT Advanced
Format: Hardback
Publisher's Status: Active