Mastering Excel through Projects - A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis

• Main Author: Zhou, Hong
• Format: eBook
• Language: English
• Published: Berkeley, CA Apress, an imprint of Springer Nature 2021; Apress; Apress L. P
• Edition: 1
• Subjects: Business-Computer programs; Computer Science; COMPUTERS; Electronic spreadsheets; General Engineering & Project Administration; General References; Microsoft and .NET; Professional and Applied Computing; Project management
• ISBN: 9781484278413; 1484278410; 9781484278420; 1484278429
• DOI: 10.1007/978-1-4842-7842-0

Master Excel in less than two weeks with this unique project-based book! Let's face it, we all master skills in our own way, but building a soup-to-nuts project is one of the best ways to make learning stick and get up to speed quickly. Whether you are just getting started with Excel or are an experienced user, this book will elevate your knowledge and skills. For a beginner, the micro examples in each chapter will warm you up before you dive into the projects. For experienced users, the projects, especially those with table setup considerations, will help you become more creative in your interactions with Excel. Readers will benefit from building eight unique projects, each covering a different topic, including a word game, a food nutrition ranking, a payroll (tax withholding) calculation, an encryption, a two-way table, a Kaplan-Meier analysis, a data analysis via a pivot table and the K-means Clustering data mining method.