Excel 2019 in easy steps + Excel Functions & Formulas in easy steps – SPECIAL OFFER

Written by In Easy Steps Team on . Posted in

In Easy Steps » Browse our Bookstore » Accounting and Finance » Excel 2019 in easy steps + Excel Functions & Formulas in easy steps - SPECIAL OFFER

SPECIAL OFFER!

Excel 2019 in easy steps
Excel Functions & Formulas in easy steps

RRP £11.99 each - buy both books together for only £16.00!

See below for details of each book:

 

Excel 2019 in easy steps

By Michael Price
Publication: February 11th, 2019
Pages: 192
ISBN: 978-1-84078-821-1

View or download first chapter and Table of Contents - FREE!

About the book

Are you making the most of this feature-packed spreadsheet?

Excel 2019 in easy steps starts with the basics and then reveals the key clever features on offer – all in easy steps! Areas covered include:

  • Creating, editing and manipulating worksheets
  • Formulas, Functions, Tables, and importing data
  • Handy templates to give you a head start
  • Macros for everyday tasks to save time
  • Charts to get an overview of your data
  • What-if, Goal Seek and Optimization
  • Using the Excel Online app to share and collaborate on spreadsheets and workbooks
  • Adding images and illustrations to your spreadsheet to impress your colleagues!

This primer illustrates how to use Excel to manage your finance and data effectively and easily – both at home and at work. Whether you’re upgrading to Excel 2019 or new to spreadsheets, use this guide to get more out of Microsoft Excel!

About the author

Michael Price is an accomplished author, IT journalist and systems consultant with a wide experience of computing systems ranging from mainframes to personal computers. He's also a successful author with several best-selling In Easy Steps books to his credit, including earlier editions of Excel in easy steps.

 

Excel Functions & Formulas in easy steps

By: Michael Price
Publication: August 31st, 2020
Pages: 192
ISBN: 9781840788815

 

View or download first chapter and Table of Contents - FREE

 

About the book

Excel Functions & Formulas in easy steps shows you how to get the most of Excel, once you’ve mastered the basics. You will learn how to build more powerful spreadsheets using the features of Excel formulas, and explore all the categories of Excel functions including financial, logical, mathematical, and data related functions. Then, review business-oriented scenarios and examples of functions in each of the groups, and consider the additional facilities offered through user-defined functions.

The topics covered apply to all recent versions of Microsoft Excel.

Table of Contents:

  1. Values and Formulas
  2. Managing Formulas
  3. Functions
  4. Financial and Logical
  5. Text, Date and Time
  6. Lookup, Reference and Information
  7. Math, Trig and Statistical
  8. Engineering and Cube
  9. Compatibility and Database
  10. Web and Add-ins
Quantity
Product in stock

Price: £16.00

Loading Updating cart...
LoadingUpdating...