Mastering Excel 2019: An All-in-One Tutorial Resource - Softcover

George, Nathan

Softcover

ISBN 10: 1916211380 ISBN 13: 9781916211384

Verlag: GTech Publishing, 2020

Inhaltsangabe

Learn Excel Fast in Simple and Easy Steps

Mastering Excel 2019 is your all-in-one, step by step, tutorial to the latest and most powerful version of Excel from Microsoft 365. This book contains everything you need to know to master the basics of Excel and a selection of advanced topics relevant to real-world productivity tasks you'll encounter in your job, business or home.

This guide has been designed to be a resource for you whether you're an Excel beginner, intermediate user, or a power user. You will learn not only how to use specific features, but in what context those features need to be used.

Excel Made Easy Without the Jargon

This book is concise and to the point, using clear and practical examples that you can adapt to your own needs. The aim is to show you how to perform tasks in Excel as quickly as possible without getting bogged down with the unnecessary filler text you may find in some other Excel books.

Three Books in One!

Mastering Excel 2019 is made up of Excel 2019 Basics, Excel 2019 Advanced Topics, and Excel 2019 Functions. Now brought together and organized as an all-in-one powerful guide. This book brings you all the powerful material in those books and more.

Mastering Excel 2019 also comes with downloadable sample files to enable you to follow the examples in the book hands-on.

By reading this book, you will:

• Master all the fundamentals to quickly get up to speed with creating solutions for common Excel tasks.
• Create basic and advanced formulas for different types of calculations.
• Use Excel tables to easily manage and manipulate your data.
• Filter, sort, and apply styles to data lists and Excel tables.
• Analyze your data visually with charts and sparklines.
• Use data from external sources like Access databases, CSV text files, and websites.
• Deploy macros to automate repetitive tasks and increase your efficiency.
• Create dynamic summaries of your data with pivot tables and pivot charts.
• Analyze different data scenarios and projections with What-If Analysis tools.
• Password-protect workbooks, worksheets, ranges, or even specific cells.
• Create formulas with over 70 of the most useful and powerful Excel functions, including new dynamic array functions like XLOOKUP, XMATCH and FILTER.
• Master many more Excel features…

Scroll up and click on the Buy Now button on the top right-hand side of the page and get started today!

Über diesen Titel

Über die Autorin bzw. den Autor

Nathan George is a data scientist at Tink in Stockholm, Sweden, and taught data science as a professor at Regis University in Denver, CO for over 4 years. Nathan has created online courses on Pythonic data science and uses Python data science tools for electroencephalography (EEG) research with the OpenBCI headset and public EEG data. His education includes the Galvanize data science immersive, a PhD from UCSB in Chemical Engineering, and a BS in Chemical Engineering from the Colorado School of Mines.

Details zur Ausgabe

• Verlag: GTech Publishing
• Erscheinungsdatum: 2020
• Sprache: Englisch
• ISBN 10: 1916211380
• ISBN 13: 9781916211384
• Einband: Taschenbuch
• Anzahl der Seiten: 537
• Kontakt zum Hersteller: Manufactured by Amazon on behalf of the author; https://www.amazon.de/hz/contact-us; ; c/o Amazon Media EU S.à.r.l., 38 Avenue John F. Kennedy; Luxembourg; L-1855; Luxemburg