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

Mastering Excel Through Projects:A Learn-Author:-Doing Approach from Payroll to Crypto to Data Analysis
Author:Hong Zhou
Publisher Finelybook 出版社:Apress; 1st ed. edition (November 28, 2021)
Language 语言:English
pages 页数:256 pages
ISBN-10 书号:1484278410
ISBN-13 书号:9781484278413

Book 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

隐藏内容1积分,请先!没有帐号? 注 册 一个!
觉得文章有用就打赏一下
未经允许不得转载:finelybook » Mastering Excel Through Projects:A Learn-Author:-Doing Approach from Payroll to Crypto to Data Analysis

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

觉得文章有用就打赏一下

非常感谢你的打赏,我们将继续给力更多优质内容,让我们一起创建更加美好的网络世界!

支付宝扫一扫打赏

微信扫一扫打赏