Vai al contenuto principale della pagina
Autore: | Zhou Hong |
Titolo: | Mastering Excel Through Projects : A Learn-By-Doing Approach from Payroll to Crypto to Data Analysis |
Pubblicazione: | Berkeley, CA : , : Apress L. P., , 2021 |
©2022 | |
Descrizione fisica: | 1 online resource (251 pages) |
Soggetto genere / forma: | Electronic books. |
Nota di contenuto: | 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. | |
Titolo autorizzato: | Mastering Excel Through Projects |
ISBN: | 9781484278420 |
9781484278413 | |
Formato: | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione: | Inglese |
Record Nr.: | 9910510564003321 |
Lo trovi qui: | Univ. Federico II |
Opac: | Controlla la disponibilità qui |