Mastering Excel 2019 - George, Nathan

. .

Résumé :
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... Get your copy today and start your journey to mastering Excel!...

Biographie:
Nathan George is a computer science graduate with several years' experience in the IT services industry in different roles, including Excel programming and providing end-user support to Excel power users. One of his main interests is using computers to automate tasks and increase productivity. As an author, he has written several technical and non-technical books.

Sommaire:
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....