Mastering Excel Through Projects_ A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis

Table of Contents

Chapter 1: Master Excel Through Projects 

Why Learn Through Projects 

Cell Reference and Formula 

Formula 

Cell Reference in 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

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

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