Created for Microsoft (MS) Excel 2019 and Excel 2016, but compatible with Excel 2010, this book contains in-depth explanations of spreadsheet concepts with interactive assignments to test learning and knowledge. It meets all the learning outcomes for Spreadsheets Methods 5N1977.

Section 1: Beginners’ Spreadsheet Assignments (no previous spreadsheet experience required)

Section 2: Intermediate and Advanced Spreadsheet Assignments (some knowledge of MS Excel)

Section 3: Project Guidelines and Sample Exams

DEMONSTRATES HOW TO:

o create formulas and functions

o sort spreadsheet data o present data using a variety of charts

o protect spreadsheets from unauthorised access

o automate decision-making with IF functions

o access data from lists using look-up functions

o program multi-step tasks through the creation, execution, and management of simple macros.

Uses flowcharts to explain difficult concepts.

Worked examples guide the learner through each task, while progress tests and chapter reviews support a ‘learning through practice’ approach

More Information
ISBN/EAN 9781916019997
Author Alan Dillon
Publisher Boru Books
Publication date 17 Apr 2020
Format Paperback
Write Your Own Review
You're reviewing:Excelling in Spreadsheets; for Excel 2016 & 2019

Accounting

Excelling in Spreadsheets; for Excel 2016 & 2019

Alan Dillon
€29.99

Created for Microsoft (MS) Excel 2019 and Excel 2016, but compatible with Excel 2010, this book contains in-depth explanations of spreadsheet concepts with interactive assignments to test learning and knowledge.

In stock