AI & Machine Learning in Excel 4

What's inside

AI & Machine Learning in Excel 4: 10 courses, 200 hands-on lessons, with a full solutions appendix.

Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.

• 10 complete courses, 200 lessons, 200 exam questions with answers
• Worksheets with row and column labels – easy to type in
• Tasks with exact solutions and hints in the appendix
• All figures are fictional practice data

Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.

Courses in this book

• Hidden Markov Models by Hand: States & Emissions, the Forward Algorithm, Viterbi Decoding, Smoothing & Simple Learning from Counts
• The Kalman Filter by Hand: Noisy Measurements, Predict & Update Steps, Kalman Gain, Constant-Velocity Tracking, Sensor Fusion & Tuning
• How Tokenizers Work by Hand: Characters & Pairs, Byte-Pair Merges, Vocabulary Size, Tokens per Word, Sequence Length & Embedding-Table Costs
• Recurrent Networks by Hand: Hidden States, Unrolling Through Time, Vanishing Gradients, LSTM Gates, GRU Cells & Sequence Prediction
• Support Vector Machines by Hand: Separating Lines, Margins, Hinge Loss, Soft Margins, Kernel Tables & Support Vectors
• Autoencoders & GANs by Hand: Encoders, Bottlenecks, Reconstruction Error, Anomaly Scores, Latent Space, Variational Sampling, Generator vs Discriminator Losses & Mode Collapse
• Scoring Generated Text by Hand: N-Gram Overlap, Clipped Precision, BLEU & Brevity Penalty, ROUGE Recall, Token F1, Exact Match & Agreement with Human Ratings
• Imbalanced Data by Hand: The Accuracy Trap, Balanced Metrics, Resampling, Synthetic Minority Samples, Class Weights, Cost-Based Thresholds & Probability Correction
• Prompt Engineering by the Numbers: Prompt Anatomy & Token Budgets, Templates, Few-Shot Examples, Test Sets, Scoring Rubrics, Format Checks, Consistency & Version Comparisons
• AI at Work by the Numbers: Task Audits, Suitability Scores, Time-Saved Logs, Draft Quality Checks, Review Time, Data-Handling Rules, Team Adoption & a Monthly Report

Details

Format	PDF, US Letter (8.5 × 11 in)
Language	English
Pages	569
Series	The Tabellab Workbook, volume 4
Author	Babala Özdemir
Delivery	Instant download after payment