Mastering Excel through projects a learn-by-doing approach from payroll to crypto to data analysis
Master Excel in less than two weeks with this unique project-based book! Lets 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 experi...
| Other Authors: | |
|---|---|
| Format: | eBook |
| Language: | Inglés |
| Published: |
New York, New York :
Apress Media LLC
[2022]
|
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009638339406719 |
Table of Contents:
- Intro
- Table of Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Chapter 1: Master Excel Through Projects
- Why Learn Through Projects
- Cell Reference and Formula
- Formula
- Cell Reference in Formulas
- Experiment
- Excel Options and Show Formulas
- Autofill or Copy
- Experiment 1
- Experiment 2
- Experiment 3
- Functions to Learn
- SUM, AVERAGE, MAX, MIN, and COUNT
- CHAR and CODE
- MID
- RANDBETWEEN
- LOOKUP
- Experiment 1
- Experiment 2
- Experiment 3
- IF
- IFERROR
- Autofill Formulas
- Relative Cell Reference
- Absolute Cell Reference
- Work on the Project
- Chapter Tip
- Review Points
- Chapter 2: Food Nutrition Ranking
- Functions to Learn
- IF
- ISBLANK
- AND, OR
- VLOOKUP
- Work on the Project
- Name Manager and Data Validation
- Instructions to Complete the Project
- Chapter Tip
- Review Points
- Chapter 3: Payroll Calculation
- Functions to Learn
- ROUND
- SUBSTITUTE
- INDEX
- MATCH
- Experiment 1
- Experiment 2
- Experiment 3
- INDIRECT
- Work on Project 1
- Federal Tax Withholding Explanation and Worksheet Setup
- Instructions to Complete Project 1
- Work on Project 2
- Table Setup and Naming
- Instructions to Complete Project 2
- Chapter Tip
- Review Points
- Chapter 4: Public and Private Key Cryptography
- Functions to Learn
- CONCATENATE and the &
- Operator
- LEN and INT
- MOD and Its Use in Encryption
- QUOTIENT and GCD
- COUNTIF
- Knowledge to Learn
- Work on the Project
- Chapter Tip
- Review Points
- Chapter 5: Two-Way Table and Chi-Square Test
- Functions to Learn
- ISERROR
- ADDRESS
- Work on the Project
- Chapter Tip
- Review Points
- Chapter 6: Kaplan-Meier Analysis
- Functions to Learn
- MEDIAN
- COUNTIFS
- Work on the Project
- Chapter Tip
- Review Points.
- Chapter 7: PivotTable Data Analysis
- Group and Subtotal
- What-If Analysis
- PivotTable and PivotChart
- Work on the Project
- Chapter Tip
- Review Points
- Chapter 8: K-Means Clustering and Iterative Calculation
- Functions to Learn
- SQRT
- SUMXMY2
- AVERAGEIFS
- SHEET
- Work on Project 1
- Iterative Calculation
- Experiment 1
- Experiment 2
- Work on Project 2
- Chapter Tip
- Review Points
- Chapter Summary and Book Summary
- Index.
