1Google Sheets : Simplified 4
16—or how to become a Spreadsheet Sorcerer with a few lines of code 89
2Introduction 4
17Annexure 5: Troubleshooting Common Google Sheets Problems 95
3Chapter 1: Introduction – Why Google Sheets? 7
18Annexure 6: Creating Professional Dashboards in Google Sheets 99
4Chapter 2: The Basics — Sheets 101 Without the Fluff 14
19(a.k.a. The Secret Sauce That Makes You Look Like a Spreadsheet Wizard Without Breaking a Sweat) 104
5Chapter 3: Working Smarter — Mastering Formulas 22
20AKA: “How to Work Together in Sheets Without Turning It Into a Spreadsheet War” 108
6Google Apps Script is JavaScript made for Google Sheets (and it’s cooler than you think). 31
21Annexure 9: Google Sheets for Financial Modeling and Analysis 112
7Chapter 5: Real-World Problems and Real-World Sheets 37
22Annexure 10: Google Sheets Security and Privacy Tips 116
8Chapter 6: Productivity Hacks That Actually Save Time 44
23Bonus: Quick-Access Formula Database 121
9Chapter 7: Templates and Tools You’ll Use Forever (Yes, Really... Forever!) 49
24Some Google Sheet Ideas, to create by yourself 125
10Chapter 8: Fixing the Broken Stuff — Debugging Like a Pro 54
25Google Sheets Subscription Tracker 127
11Chapter 9: Going Pro — Connecting Sheets with Other Apps 62
26Thank You 131
12Chapter 10: What’s Next? Becoming the Sheets Wizard in Your Office 70
27Sign up for Sankar Srinivasan's Mailing List
13Annexure 1: Google Sheets and API Integration 76
28Also By Sankar Srinivasan
14Annexure 2: Advanced Google Sheets Formula Guide 80
29About the Author
15Annexure 3: Google Sheets Add-ons 85
