03545nam 22003853 450 991051056400332120211130080204.09781484278420(electronic bk.)9781484278413(MiAaPQ)EBC6817002(Au-PeEL)EBL6817002(CKB)19934884300041(OCoLC)1287131482(EXLCZ)991993488430004120211130d2021 uy 0engurcnu||||||||txtrdacontentcrdamediacrrdacarrierMastering Excel Through Projects A Learn-By-Doing Approach from Payroll to Crypto to Data AnalysisBerkeley, CA :Apress L. P.,2021.©2022.1 online resource (251 pages)Print version: Zhou, Hong Mastering Excel Through Projects Berkeley, CA : Apress L. P.,c2021 9781484278413 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 &amp -- 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.Electronic books.Zhou Hong853409MiAaPQMiAaPQMiAaPQ9910510564003321Mastering Excel Through Projects2553477UNINA