Microsoft Excel 2016 - Training book with many Exercises - Paperback

by Peter Schiessl (Author)

MS Excel 2016 Training Book
******************** Completely colored printed! ********************

Amazon now offers cheaper color printing, including full color, which is why we have offered the same book much cheaper. This book is the edition with the high quality color printing.

Emerging from numerous Excel courses, this book is not a collection of material, but a proper training book. It lead you to working with Excel from the beginning with many exercises. As it progresses step by step in the material, advanced exercises and applications are finally achieved. So also suitable for self-study! Learning by doing!

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 notes,

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 V-reference,
-If conditions,
-Logical links,
-Find the trend.
-Pivot table and diagram

Set attachment Excel:
View, Quick Access toolbar.

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!
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.
Numerous tutorial videos leave behind only the usual TV effect: afterwards a yawning emptiness, which is avoided in this book, by the material itself can be tested and imitated from simple exercises to later following semi-professional applications. Thus, the handling of the special routines of a calculation program is almost playful and by the way learned by trying out.