Название: Excel 2019 Made Simple: A Well-Explained Guide to Mastering Microsoft Excel Formulas and Functions with Step-By-Step Picture Illustrations
Автор: Aaron Baddey
Издательство: Independently published
Год: 2020
Страниц: 113
Язык: английский
Формат: pdf, rtf
Размер: 10.1 MB

This Excel guide book; Excel 2019 Made Simple is the comprehensive guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided step-by-step with picture illustrations through the powerful new features and capabilities to take full advantage of what the updated version offers. This book will take you from basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic. It provides you with a broad scope of the most common Excel applications and functions―including formatting worksheets, setting up formulas.

Excel 2019 now permits users to create their custom functions using jаvascript. Earlier versions of Excel already enabled users to create user-defined functions using Excel's built-in Visual Basic for most Applications programming language; since jаvascript has emerged as a frequently used platform for such purposes, Microsoft has added this new capability to permit more excellent compatibility with third-party solutions.

Also, you will learn to use the updated functions which include:

•concat
•ifs
•maxifs
•minifs
•switch
•textjoin