國立虎尾科技大學 |

Mastering Excel Through Projects = A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis /

紀錄類型:	書目-語言資料,印刷品 : Monograph/item
正題名/作者:	Mastering Excel Through Projects/ by Hong Zhou.
其他題名:	A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis /
作者:	Zhou, Hong.
面頁冊數:	XVI, 240 p. 225 illus.online resource. :
Contained By:	Springer Nature eBook
標題:	Microsoft software. -
電子資源:	https://doi.org/10.1007/978-1-4842-7842-0
ISBN:	9781484278420

Mastering Excel Through Projects = A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis /
Zhou, Hong.

Mastering Excel Through ProjectsA Learn-by-Doing Approach from Payroll to Crypto to Data Analysis /[electronic resource] :by Hong Zhou. - 1st ed. 2022. - XVI, 240 p. 225 illus.online resource.

Chapter 1: Master Excel through Projects -- Chapter 2: Food Nutrition Ranking -- Chapter 3: Payroll Calculation -- Chapter 4: Public and Private Key Cryptography -- Chapter 5: Two-Way Table and Chi-Square Test -- Chapter 6: Kaplan-Meier Analysis -- Chapter 7: PivotTable Data Analysis -- Chapter 8: K-means Clustering and Iterative Calculation.

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. Through these projects, you will experience firsthand how Excel skills are organized together to accomplish tasks that sound complex and daunting when first described. Get started with a word game which asks users to find English words that amount to exactly 100 points, with each letter of the alphabet assigned a point 1, 2, 3, … 26, respectively. You will disassemble a word into letters and then sum up their points, and then take it one step further, contemplating how to make the completed Excel worksheet more user friendly and completely automated. Increasingly challenging tasks like this example build on what you have learned and increase your confidence along the way, ensuring your mastery of Excel. What You Will Learn Gain confidence to tackle a challenging Excel-related mission, even those that seem impossible Become skilled in the creative uses of Excel formulas and functions and other built-in features Appreciate the art of refining worksheets to maximize automation Understand the value of treating each worksheet as a unique product This book is for people who are interested in learning Excel as quickly and efficiently as possible. While Excel beginners and intermediate users are the primary audience, experienced Excel users might also discover new skills and ways of working with Excel. Hong Zhou is a professor of computer science and mathematics at the University of Saint Joseph in Connecticut. Before returning to school for his doctoral degree, Dr. Zhou worked as a Java developer in Silicon Valley. Since 2004, Dr. Zhou has been teaching various courses in computer science, data science, mathematics, statistics, and informatics. His major research interests include data mining, bioinformatics, software agents, and blockchain. Dr. Zhou became interested in Excel through teaching computer skills and using them for research purposes; for example, applying Excel in teaching data mining, encryption, and health informatics. He also enjoys applying his Excel skills to help colleagues in their research projects.

ISBN: 9781484278420

Standard No.: 10.1007/978-1-4842-7842-0doiSubjects--Topical Terms:

1253736
Microsoft software.

LC Class. No.: QA76.76.M52

Dewey Class. No.: 005.268

Mastering Excel Through Projects = A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis /
LDR:04719nam a22003975i 4500 001 1093403
003 DE-He213
005 20220512151027.0
007 cr nn 008mamaa
008 221228s2022 xxu| s |||| 0|eng d
020 $a 9781484278420 $9 978-1-4842-7842-0
024 7 $a 10.1007/978-1-4842-7842-0 $2 doi
035 $a 978-1-4842-7842-0
050 4 $a QA76.76.M52
072 7 $a UMP $2 bicssc
072 7 $a COM051380 $2 bisacsh
072 7 $a UMP $2 thema
082 0 4 $a 005.268 $2 23
100 1 $a Zhou, Hong. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1063167
245 1 0 $a Mastering Excel Through Projects $h [electronic resource] : $b A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis / $c by Hong Zhou.
250 $a 1st ed. 2022.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2022.
300 $a XVI, 240 p. 225 illus. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
505 0 $a Chapter 1: Master Excel through Projects -- Chapter 2: Food Nutrition Ranking -- Chapter 3: Payroll Calculation -- Chapter 4: Public and Private Key Cryptography -- Chapter 5: Two-Way Table and Chi-Square Test -- Chapter 6: Kaplan-Meier Analysis -- Chapter 7: PivotTable Data Analysis -- Chapter 8: K-means Clustering and Iterative Calculation.
520 $a 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. Through these projects, you will experience firsthand how Excel skills are organized together to accomplish tasks that sound complex and daunting when first described. Get started with a word game which asks users to find English words that amount to exactly 100 points, with each letter of the alphabet assigned a point 1, 2, 3, … 26, respectively. You will disassemble a word into letters and then sum up their points, and then take it one step further, contemplating how to make the completed Excel worksheet more user friendly and completely automated. Increasingly challenging tasks like this example build on what you have learned and increase your confidence along the way, ensuring your mastery of Excel. What You Will Learn Gain confidence to tackle a challenging Excel-related mission, even those that seem impossible Become skilled in the creative uses of Excel formulas and functions and other built-in features Appreciate the art of refining worksheets to maximize automation Understand the value of treating each worksheet as a unique product This book is for people who are interested in learning Excel as quickly and efficiently as possible. While Excel beginners and intermediate users are the primary audience, experienced Excel users might also discover new skills and ways of working with Excel. Hong Zhou is a professor of computer science and mathematics at the University of Saint Joseph in Connecticut. Before returning to school for his doctoral degree, Dr. Zhou worked as a Java developer in Silicon Valley. Since 2004, Dr. Zhou has been teaching various courses in computer science, data science, mathematics, statistics, and informatics. His major research interests include data mining, bioinformatics, software agents, and blockchain. Dr. Zhou became interested in Excel through teaching computer skills and using them for research purposes; for example, applying Excel in teaching data mining, encryption, and health informatics. He also enjoys applying his Excel skills to help colleagues in their research projects.
650 0 $a Microsoft software. $3 1253736
650 0 $a Microsoft .NET Framework. $3 565417
650 1 4 $a Microsoft. $3 1387749
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484278413
776 0 8 $i Printed edition: $z 9781484278437
776 0 8 $i Printed edition: $z 9781484284452
856 4 0 $u https://doi.org/10.1007/978-1-4842-7842-0
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)