Microsoft Excel 2019 - Training book with many Exercises: From the Beginning to Advanced Applications - Softcover

Schiessl, Peter

Softcover

ISBN 10: 1790688833 ISBN 13: 9781790688838

Publisher: Independently published, 2018

Synopsis

This is the edition in high-quality color print, we have also a cheaper edition with simply color print here by amazon, last not available in Japan and Australia.
---------------------------------------

MS Excel 2019 Training Book with Many Exercises
Completely colored printed!

Numerous exercises integrated in the book! Excel from the start to professional knowledge!

Our Excel book starts with simple basics, continues with the possibilities of entering formulas and copying formulas to numerous advanced applications with complex calculations, from formulas such as RMS to conditions to pivot evaluations.

Thanks to the many practical exercises, everything can be understood immediately. Instead of theoretical learning or blind testing, Excel almost explains itself, the functionality is understood and so there is nothing standing in the way of using it for your own calculations.

Particular emphasis is placed on the formatting and graphical representation of the tables, since Excel data for meetings, product presentations or similar must be presented appropriately in the business area and transferred to other applications. We do not deliver a collection of Excel applications, but a systematic guide so that you can create your own calculations.

From the Content

Part One, the Basics:

• Workbook and spreadsheets,
• Input and save,
• first calculations: sum, product.

Second Part, Professional Handling of Excel:

• relative and absolute copying of formulas,
• automatic filling with row,
• document extensive workbooks with comments,

Part Three, Extended Calculations Based on Numerous Practical Examples:

• Calculate finances: credit, term, interest with RMZ,
• Invoice with articles, VAT and Include date in calculation
• Budget planning,
• A test evaluation with usual evaluations: minimum or greatest value, Average, Round, Standard deviation,
• Diagram,
• Design tables ready for printing: create a diagram for illustration, Transfer format, AutoFormat for tables, Styles in Excel,

Advanced Applications:

• Grade evaluation with Vlook,
• If-then conditions,
• Logical links,
• Find the trend.
• Pivot table and diagram.
• External Data, Monitoring.

This series of training books was founded in the 1990s, and has been used since then in many courses and self-study, constantly improved and adapted to the actual program versions.
Through this origin from computer courses, this booklet differs from many others by not offering a collection of materials, not a reference book, but a guide to the "Learning by Doing", which explains step by step through many practical exercises. Therefore, this book series is ideal for adult education as well as for self-study, especially for beginners.

After studying this book, there is nothing standing in the way of your own applications.

Excel from the start to professional knowledge! With many integrated, practice-related exercises!

Search Amazon for “manual schiessl" and you will find our other titles, e.g., on MS Word (three volumes and a special volume on serial printing), MS PowerPoint, CorelDRAW, Corel Photo-Paint, the range is constantly being expanded.

Edition details

• Publisher: Independently published
• Publication date: 2018
• Language: English
• ISBN 10: 1790688833
• ISBN 13: 9781790688838
• Binding: Paperback
• Number of pages: 135