LEADER 03545nam  22003853  450 
001 9910510564003321
005 20211130080204.0
010   $a9781484278420$b(electronic bk.)
010   $z9781484278413
035   $a(MiAaPQ)EBC6817002
035   $a(Au-PeEL)EBL6817002
035   $a(CKB)19934884300041
035   $a(OCoLC)1287131482
035   $a(EXLCZ)9919934884300041
100   $a20211130d2021      uy             0
101 0 $aeng
135   $aurcnu||||||||
181   $ctxt$2rdacontent
182   $cc$2rdamedia
183   $acr$2rdacarrier
200 10$aMastering Excel Through Projects $eA Learn-By-Doing Approach from Payroll to Crypto to Data Analysis
210  1$aBerkeley, CA :$cApress L. P.,$d2021.
210  4$d©2022.
215   $a1 online resource (251 pages)
311 08$aPrint version: Zhou, Hong Mastering Excel Through Projects Berkeley, CA : Apress L. P.,c2021 9781484278413 
327   $aIntro -- 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.
327   $aChapter 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.
608   $aElectronic books.
700   $aZhou$b Hong$0853409
801  0$bMiAaPQ
801  1$bMiAaPQ
801  2$bMiAaPQ
912   $a9910510564003321
996   $aMastering Excel Through Projects$92553477
997   $aUNINA