Mastering Excel Through Projects
A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis
| Price | $34.18 - $35.99
|
| Rating |  |
| Author | Hong Zhou |
| Publisher | Apress |
| Published | 2022 |
| Pages | 240 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484278410 |
| ISBN-13 | 9781484278413 |
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.
- Hong Zhou
Similar Books
Microsoft Excel 2019 Formulas and Functions 
by Paul McFedries
Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more powerful spreadsheets. Use Excel 2019 and Office 365 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and funct...
Price: $17.27 | Publisher: Microsoft Press | Release: 2019
by Jakub Narebski
Git is one of the most popular types of Source Code Management (SCM) and Distributed Version Control System (DVCS). Despite the powerful and versatile nature of the tool enveloping strong support for nonlinear development and the ability to handle large projects efficiently, it is a complex tool and often regarded as "user-unfriendly...
Price: $49.99 | Publisher: Packt Publishing | Release: 2016
by Daniel Li
Grunt.js continues to excel as the build automation tool of choice. Along with its support for many third-party technologies, Grunt is packaged with a clean API for defining tasks. This powerful tool can streamline your workflow by automating the preparation tasks for production, such as compression, compilation, obfuscation, testing, and...
Price: $13.99 | Publisher: Packt Publishing | Release: 2014
by Richard Grimmett
Robots are quickly bursting from the world of science fiction right into our own living rooms. The small-but-mighty BeagleBone Black embedded processor provides the power and capability to program your own robotic projects using its complete Linux development environment.Mastering BeagleBone Robotics lets you push your creativity to the l...
Price: $44.99 | Publisher: Packt Publishing | Release: 2014
by James Miller
IBM Watson provides fast, intelligent insight in ways that the human brain simply can't match. Through eight varied projects, this book will help you explore the computing and analytical capabilities of IBM Watson.The book begins by refreshing your knowledge of IBM Watson's basic data preparation capabilities, such as adding and...
Price: $44.99 | Publisher: Packt Publishing | Release: 2018
Microsoft Excel Formulas and Functions
by Paul McFedries
Use Excel 365 and Excel 2021 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including recent improvements ranging from dynamic arrays to XLOOKUP and LET. McFedries step-by-step projects w...
Price: $43.06 | Publisher: Microsoft Press | Release: 2022
Mastering AutoCAD 2019 and AutoCAD LT 2019
by George Omura, Brian C. Benton
Mastering AutoCAD 2019 and AutoCAD LT 2019 is the world's all-time best-selling guide to the world's most popular drafting software. Packed with tips, tricks, techniques, and tutorials, this guide covers every inch of AutoCAD and AutoCAD LT - including certification. This new edition has been fully updated to align with the soft...
Price: $42.42 | Publisher: Wiley | Release: 2018
by Enrique Ramos Melgar, Ciriaco Castro Diez
If you've done some Arduino tinkering and wondered how you could incorporate the Kinect - or the other way around - then this book is for you. The authors of Arduino and Kinect Projects will show you how to create 10 amazing, creative projects, from simple to complex. You'll also find out how to incorporate Processing in your pr...
Price: $34.01 | Publisher: Apress | Release: 2012