Kick off your book project in 3 hours! Live workshop on Zoom. You’ll leave with a real book project, progress on your first chapter, and a clear plan to keep going. Saturday, May 2, 2026. Learn more…

Leanpub Header

Skip to main content
Go to Leanpub.com

The Excel Refugee Migration

Stop Babysitting Spreadsheets. Start Commanding Data

James Daniel

You are not bad at data. Your work has outgrown the shape of Excel. This book helps finance, HR, operations, reporting, and business analysis professionals replace manual spreadsheet survival with calmer, reusable workflows in R.

Minimum price

$19.00

$29.00

You pay

$29.00

Author earns

$23.20
$
You can also buy this book with 1 book credit. Get book credits with a Reader Membership or an Organization Membership for your team.
PDF
EPUB
About

About

About the Book

This book is for professionals who never planned to become technical people and still ended up carrying technical work anyway.

You might work in finance. Or HR. Or operations. Or reporting. Or business analysis. The exact title on your email signature matters less than the shape of your week. Files arrive. Formats drift. Lookups break. A dashboard needs updating before a meeting. Someone upstream changes a column name and half your morning disappears.

You know the work.

You know the pressure.

You know the strange fatigue of doing something familiar over and over and still not trusting the process.

This book was built for that reader.

Not the aspiring software engineer.

Not the person who wants to learn programming as a hobby.

The working professional who is smart, capable, overloaded, and tired of babysitting spreadsheets.

Share this book

Categories

RBusiness AnalysisData ScienceCareerConsulting

Feedback

Email the Author

Author

About the Author

James Daniel

James Daniel is the author of The Excel Refugee Migration, a book written for professionals whose jobs depend on data but whose workflows have outgrown the shape of Excel. The book is aimed at readers in finance, HR, operations, reporting, and business analysis who live inside recurring exports, brittle formulas, workbook version chaos, and reporting cycles that steal more time than they should. Rather than offering technical performance or abstract programming theory, Daniel writes from the pressure point of real work: messy files, repeated summaries, deadline-driven reporting, and the quiet fatigue of maintaining systems that should already be lighter. His approach is practical, structured, and respectful of working professionals who do not want to become developers but do want cleaner, repeatable, more trustworthy workflows in R. The result is a book built around relief, control, and better use of analytical judgment.

Contents

Table of Contents

  • Front Matter
    • Dedication
    • About This Book
    • Who This Book Is For
    • What This Book Is Trying to Solve
    • How to Read This Book
    • What You Will Need
    • What You Will Learn to Do
    • What Makes This Book Different
    • Book Roadmap
    • Optional Setup Check
    • Introduction: The Day My Spreadsheet Died
      • Why This Book Exists
      • What This Book Will Help You Do
  • Main
    • 1. When Being the Excel Hero Starts Costing You Your Future
      • The Skill That Made You Valuable is Starting to Trap You
      • The Report is Done, and You Are Still Behind
      • You Are Spending Analyst Energy on Janitorial Work
      • Manual Excellence Has a Career Ceiling
      • This Is Not a Discipline Problem. It Is a Tool-Workflow Mismatch
      • The Next Move Is Not Becoming Technical. It Is Becoming Harder to Waste
      • Optional Workflow Snapshot
    • 2. Python Was Never the Point: Why R Feels Like the Tool You Were Looking For All Along
      • You Were Not Bad at Learning. You Were Badly Matched
      • What Feels “Technical” Depends on Where you Are Standing
      • R Feels Less Like a New Identity and More Like a Bridge
      • The Speed of the First Win Changes Everything
      • The Real Comparison Is Not Python Versus R. It Is Friction Versus Fit
      • You Are Not Trying to Become a Developer. You Are Trying to Stop Wasting Your Best Hours
      • What The Right First Tool Should Feel Like
      • Optional Workflow Snapshot
      • You Do Not Need the Perfect Language. You Need the Next Useful One
    • 3. R Without the Fear: The First Hour That Finally Feels Useful
      • The Hardest Part of Learning R Is Arriving with Spreadsheet Scars
      • Start with Less Than You Think You Need
      • The First Good Sign is That R Works with The Grain of Your Thinking
      • Your First Dataset Should Look Like Work, Not Like a Classroom
      • Filtering Without Formula Anxiety Feels Bigger Than It Should
      • The First Hour Should End with a Result, Not a Lecture
      • You Do Not Need to Understand Everything to Trust the Direction
      • Save Something Small and Real
      • The Psychological Shift is the Real Milestone
      • Optional Workflow Snapshot
      • The Next Relief Comes from Realizing Your Excel Brain Still Matters
    • 4. You Already Speak Half the Language: Translating Your Excel Brain into R
      • You Were Never Thinking in Cells as Much as You Thought
      • Stop Dragging Formulas. Start Thinking at The Column Level
      • A Workbook Is Often Pretending to Be a Database
      • Filters, Tabs, and Helper Columns Were Always Trying to Become Verbs
      • The Old Workflow Was Not Simple. It Was Familiar
      • When the workbook becomes a story you are no longer proud of
      • The Relief Is Not That R Is Perfect. It Is That the Logic Becomes Readable
      • Optional Workflow Snapshot
      • The Next Step Is Not to Memorize R. It Is to Stop Translating Under Pressure
    • 5. Your AI Co-Pilot: Using Gemini Inside RStudio as Your Personal R Translator
      • Why Browser Chat Feels Helpful Until the Work Gets Real
      • Gemini Inside RStudio Changes the Game
      • The Setup Is Simpler Than It Looks
      • The Shortcut Is Where It Starts Feeling Like Leverage
      • A Good Prompt Starts With the Business Rule, Not the Syntax
      • VLOOKUP, Pivot Tables, and Other Spreadsheet Habits Translate Beautifully
      • Comments Turn the Editor into a Quiet Prompting Surface
      • Verification Is What Keeps the Workflow Professional
      • The Best Part Is Not Faster Code. It Is Lower Friction
      • Optional Workflow Snapshot
      • What This Means for an Excel Refugee
    • 6. Clean Data, Clean Mind: The R Workflow That Eliminates Manual Hell
      • Dirty Data Does Not Stay in the Spreadsheet
      • The Calm Sequence That Replaces Panic
      • Stop Fixing Rows One by One
      • Duplicates Are Never Just Duplicates
      • Dates Are Where Fragile Workflows Go to Humiliate People
      • Categories Break Quietly
      • One Pipeline Beats Fifty Tiny Fixes
      • Future-You Is the Real Stakeholder
      • The Version That Saves Hours Every Week
      • Optional Workflow Snapshot
      • Now The Numbers Deserve To Be Summarized
    • 7. Pivot Tables Are Dead. Long Live dplyr
      • The Fastest Good Idea Excel Ever Gave You
      • The Drag-and-Drop Trap
      • When The Summary Knows More Than The Workbook
      • dplyr Lets You State The Question Directly
      • group_by() And summarise() Are Not Programming Tricks
      • Stop Rebuilding The Same Answer
      • Readable Logic Is A Professional Advantage
      • One Good Summary Script Is Worth More Than Ten Familiar Clicks
      • Your Summary Workflow Should Outlive The Current File
      • Optional Workflow Snapshot
      • Once The Summary Is Stable, The Next Problem Is The Visual
    • 8. Charts That Actually Impress: ggplot2 vs. Excel’s Chart Wizard
      • Why Default Charts Keep Selling You Short
      • The Difference Between A Chart And A Point
      • The Plot That Finally Looks Like You Know What You Are Doing
      • Stop Decorating. Start Directing Attention
      • Trends Deserve More Respect Than Default Line Charts Usually Give Them
      • When One Chart Is Not Enough, Facets Save You From Visual Overcrowding
      • The Quiet Power Of Labels, Order, And Restraint
      • Save The Plot Like It Matters
      • The Plot Is Not There To Prove You Worked
      • Optional Workflow Snapshot
      • The Chart Should Carry More Of The Conversation Than You Do
    • 9. Your First Real Project: A Full Analysis From Raw File to Boardroom Slide
      • The Request That Used to Ruin Your Morning
      • The Question Before The Spreadsheet
      • The Files Arrive And The Mess Begins
      • When The Mess Finally Becomes A Model
      • Clean, Merge, Summarize
      • Build The Slide They Remember
      • What This Project Proves About You
      • This Was Not A Practice Exercise
      • The Threshold Into Chapter 10
    • 10. The R-Powered Strategist: Your 30-Day Migration Plan and What Comes Next
      • The Monday You Work Differently
      • The 30-Day Plan That Turns Learning Into Habit
        • Week 1: Setup And Translation
        • Week 2: AI Workflow And Cleaning
        • Week 3: Analysis And Visualization
        • Week 4: One Live Work Project
      • Do Not Announce The Revolution
      • The Tool Was Never The Identity
      • What Comes After This Book
      • Stop Returning To The Old Workflow
      • A Simple Reporting Workflow That Keeps Paying You Back
      • You Were Never Bad At Data
      • The Last Quiet Upgrade
  • Appendices
    • Appendix A. The Master Excel-to-R Cheat Sheet
      • A.1 Core Translation Map
      • Quick Syntax Shelf
      • A.2 Common Patterns
        • Monthly Sales Reporting Pattern
        • HR Headcount Reconciliation Pattern
        • Budget vs Actual Workflow
        • Weekly KPI Reporting Pattern
        • Department Summary Pipeline
        • Payroll Cleanup Workflow
        • Executive Slide Preparation Pattern
      • A.3 Fast Decision Table
      • A.4 Monday Morning Rescue Card
        • Fast Response Scaffold
        • Export Decision Shelf
        • Last Quiet Reminder
    • Appendix B. The In-Session AI Prompt Library for R
      • B.1 Formula Translation Prompt
        • Nested IF To case_when()
        • Basic Formula Logic To mutate()
        • Text Classification Rule Prompt
        • Status Grouping Prompt
        • Date Correction Prompt
        • Helper-Column Logic Made Readable
      • B.2 Join Logic Prompt
        • One-To-One Join Prompt
        • One-To-Many Join Prompt
        • Mismatched Key Names Prompt
        • Missing Join Matches Prompt
        • Post-Join Checking Prompt
      • B.3 Summary Prompt
        • Totals By Region Prompt
        • Averages By Department Prompt
        • Counts By Status Prompt
        • Grouped Monthly Summary Prompt
        • Multiple Summary Metrics Prompt
      • B.4 Validation Prompt
        • Row-Count Check After A Join
        • Missing-Value Check Prompt
        • Total Comparison Prompt
        • Spot-Check Prompt
        • Suspicious Result Prompt
        • Comment-And-Highlight Diagnosis Prompt
      • B.5 The Two Shortcuts That Make This Workflow Fast
        • Ctrl + Shift + C Opens Chat
        • Ctrl + Shift + S Sends The Selected Prompt Or Highlighted Code
      • B.6 Future Prompt Library Expansions
        • Error Diagnosis Prompt
        • Refactor This Code Prompt
        • Comment-To-Code Prompt
        • Explain This Object In My Environment Prompt
        • Turn This Cleaning Logic Into A Reusable Function Prompt
        • Build A Plot From This Summary Prompt
        • Help Me Interpret This Result Prompt
        • Last Working Rule
    • Appendix C. Recommended R Packages by Use Case
      • C.1 Data Import
        • Data Import Use-Case Map
        • Import Workflow Snippets
        • What This Package Combination Does Best
        • When To Reach For It
        • Typical Workflow
        • Watch Out For
        • Example You Can Adapt
      • C.2 Data Cleaning
        • Data Cleaning Use-Case Map
        • Cleaning Workflow Snippets
        • What This Package Combination Does Best
        • When To Reach For It
        • Typical Workflow
        • Watch Out For
        • Example You Can Adapt
      • C.3 Data Transformation
        • Data Transformation Use-Case Map
        • Transformation Workflow Snippets
        • What This Package Combination Does Best
        • When To Reach For It
        • Typical Workflow
        • Watch Out For
        • Example You Can Adapt
      • C.4 Visualization
        • Visualization Use-Case Map
        • Visualization Workflow Snippets
        • What This Package Combination Does Best
        • When To Reach For It
        • Typical Workflow
        • Watch Out For
        • Example You Can Adapt
      • C.5 Reporting
        • Reporting Use-Case Map
        • Reporting Workflow Snippets
        • What This Package Combination Does Best
        • When To Reach For It
        • Typical Workflow
        • Watch Out For
        • Example You Can Adapt
      • C.6 File Paths And Project Hygiene
        • File Paths And Hygiene Use-Case Map
        • Hygiene Workflow Snippets
        • What This Package Combination Does Best
        • When To Reach For It
        • Typical Workflow
        • Watch Out For
        • Example You Can Adapt
      • Future Package Additions
        • How To Evaluate A Future Package Addition
        • What This Package Does Best
        • When To Reach For It
        • Typical Workflow
        • Watch Out For
        • Example You Can Adapt
      • Package Comparison Notes
        • How To Compare Packages Practically
        • Practical Decision Logic
        • Edge Case Or Limitation
      • Package Combinations For Specific Use Cases
        • Monthly Sales Reporting Combination
        • Payroll Cleanup Plus Excel Export Combination
        • Weekly KPI Reporting Combination
        • In-Session AI Workflow Combination
        • Last Working Rule
    • Appendix D. Glossary: Excel Terms, R Terms, and Workflow Language
      • D.1 Glossary
        • Core Workflow Language
        • Excel-To-R Translation Language
        • Cleaning Language
        • Visualization And Charting Language
        • Reporting And Delivery Language
        • In-Session AI Workflow Language
        • Nuance Notes For Terms That Deserve More Than One Line
        • Extended Glossary Entries You May Need Next
        • Last Working Rule
  • Back Matter
    • Author’s Note
      • Why This Book Had to Exist
      • What I Hope Changed for You
      • The Excel Refugee Companion Kit
      • For Teams, Managers, and Organizations
      • You Were Never the Problem
    • References

The Leanpub 60 Day 100% Happiness Guarantee

Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.

You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!

So, there's no reason not to click the Add to Cart button, is there?

See full terms...

Earn $8 on a $10 Purchase, and $16 on a $20 Purchase

We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.

(Yes, some authors have already earned much more than that on Leanpub.)

In fact, authors have earned over $15 million writing, publishing and selling on Leanpub.

Learn more about writing on Leanpub

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!

Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.

Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.

Learn more about writing on Leanpub