Vai al contenuto principale della pagina

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



(Visualizza in formato marc)    (Visualizza in BIBFRAME)

Autore: Zhou Hong Visualizza persona
Titolo: Mastering Excel Through Projects : A Learn-By-Doing Approach from Payroll to Crypto to Data Analysis Visualizza cluster
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  Visualizza cluster
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