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

iebukes Apress 395 次浏览 没有评论
Mastering Excel Through Projects: A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis Front Cover

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

by Hong Zhou
  • Length: 256 pages
  • Edition: 1
  • Publisher: Apress
  • Publication Date: 2021-12-12
  • ISBN-10: 1484278410
  • ISBN-13: 9781484278413
Description

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

Who 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.

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

 

 亲,网盘文件已删,下载链接已失效


因为,我,失业了!于是我老家十八线小县城找了份掏下水道的工作。。。
 
为了生活
 
我决定将iebueks电子网站由免费改为赞助入群:
 
一年45元
 
从百度网盘群满之日算起。
 
这45元除了最新的英文IT电子书,还包括:

免费找书服务,中文英文皆可

国内出版社出版的中文电子书  
中文电子书
2022年公考资料
2022年公考资料
2023年考研学习资料
2023年考研学习资料
人人素材网各种视频素材模板以及中文字幕教程
人人素材网

入群指南


扫描下面二维码关注微信公众号获取资源

微信公众号二维码

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注

Go