This cheat sheet contains intermediate-level tips, examples, and shortcuts of Google Sheets, the free online spreadsheet program and Microsoft Excel alternative. The four-panel reference is printed on 8.5 by 11 inch high-quality card stock, perfect for desks, walls, and shelves. It has holes for three-ring binders. Fully recyclable and designed for readability. Topics include:* Keyboard shortcuts for Chromebooks, Windows, and macOS* Join text and numbers* Exponents and roots* Order of operations & nested functions* Calculate loan and interest payments* Time differences* Using SUMIF, AVERAGEIF & COUNTIF* Sorting multiple columns* Merge cells* Convert text to columns* Find & Replace* Remove duplicates* Freeze row/column* Fill a series* Creating static cell references* Referencing other sheets* Formatting and themes* Protecting sheets and cell ranges* Sharing and collaboration basics* Convert Excel to Sheets and vice versa Note that the Google Sheets Intermediate Reference and Cheat Sheet does not cover Google Drive, Google Docs, Google Slides, or other applications in Google's free online office suite. The Google Sheets Intermediate Reference and Cheat Sheet was created by the publisher of the top-selling guides Google Drive & Docs In 30 Minutes, LinkedIn In 30 Minutes, Excel Basics In 30 Minutes, and other titles.
Average Rating
Informations
About the author
i30 Media
Author
Google Sheets Intermediate Reference and Cheat Sheet
by i30 Media
Books Like Google Sheets Intermediate Reference and Cheat Sheet
If you're looking for books similar to Google Sheets Intermediate Reference and Cheat Sheet, here are some recommendations based on themes, tone, and narrative style.
Spreadsheet Formulas and Functions
John Walkenbach
A comprehensive reference for advanced spreadsheet users. The book delves deep into complex formulas and functions across multiple software platforms. It provides detailed explanations and practical examples of advanced data manipulation techniques. Suitable for professionals seeking to enhance their spreadsheet skills.
Advanced Google Sheets Techniques
Emily Rodriguez
A deep dive into advanced Google Sheets functionalities. The book covers complex formulas, automation techniques, and integration strategies. It provides expert-level insights into maximizing spreadsheet potential. Suitable for professionals looking to take their spreadsheet skills to the next level.
Spreadsheet Programming Secrets
Alex Johnson
A technical guide to advanced spreadsheet programming and automation. The book covers scripting, macros, and custom function development. It provides in-depth techniques for extending spreadsheet capabilities beyond standard functions. Suitable for technical professionals and power users.
Digital Collaboration Mastery
Lisa Martinez
An in-depth exploration of online collaboration tools and techniques. The book provides strategies for effective remote work and team communication. It covers various platforms, including spreadsheet-based collaboration tools. Ideal for modern professionals navigating digital workplace environments.
Excel Basics In 30 Minutes
i30 Media
A concise guide to understanding Microsoft Excel fundamentals for beginners. The book provides clear, practical instructions for navigating spreadsheet software. It covers essential functions, formulas, and basic data management techniques. Perfect for professionals and students looking to quickly improve their spreadsheet skills.
Google Drive & Docs In 30 Minutes
i30 Media
A comprehensive guide to Google's online productivity suite. The book explains how to effectively use Google Drive for file storage and collaboration. It offers step-by-step instructions for document creation, sharing, and management. Ideal for users wanting to maximize their cloud-based workflow efficiency.
Data Analysis with Google Sheets
Michael Milton
A comprehensive guide to data analysis using Google Sheets. The book covers advanced techniques for data manipulation, visualization, and interpretation. It provides practical examples and step-by-step instructions for transforming raw data into meaningful insights. Perfect for analysts and business professionals.
Productivity Hacks with Spreadsheets
David Chen
A practical guide to using spreadsheets for personal and professional productivity. The book offers innovative strategies for time management, project tracking, and workflow optimization. It provides numerous templates and techniques for streamlining daily tasks. Recommended for individuals seeking to improve efficiency.
The Data Visualization Handbook
Mark Williams
A comprehensive guide to creating effective data visualizations using spreadsheet tools. The book explains how to transform raw data into compelling visual narratives. It covers design principles, color theory, and chart selection strategies. Ideal for analysts and professionals who want to communicate data effectively.
Cloud Productivity Masterclass
Jennifer Lee
An extensive exploration of cloud-based productivity tools and techniques. The book provides strategies for integrating various online platforms and maximizing workflow efficiency. It offers practical advice for professionals navigating digital work environments. Recommended for those seeking comprehensive digital productivity insights.
Data Science for Spreadsheet Users
Rachel Kim
An introduction to data science techniques using spreadsheet tools. The book bridges the gap between basic spreadsheet skills and advanced data analysis. It provides practical examples of statistical analysis, machine learning concepts, and data interpretation. Ideal for professionals looking to expand their analytical capabilities.
The Efficient Workspace
Thomas Anderson
A comprehensive guide to optimizing digital workspaces and productivity tools. The book explores strategies for integrating various software platforms and streamlining workflow. It provides practical advice for creating efficient, technology-enhanced work environments. Recommended for professionals seeking holistic productivity solutions.
LinkedIn In 30 Minutes
i30 Media
A practical guide to leveraging LinkedIn for professional networking and career development. The book provides strategies for creating an effective profile, connecting with industry professionals, and using the platform for job searching. It offers insights into personal branding and online professional presence.
The Spreadsheet Detectives
Sarah Thompson
An engaging book that explores real-world applications of spreadsheet technologies. It presents case studies of how professionals use spreadsheets to solve complex problems. The book combines technical instruction with practical storytelling. Ideal for those wanting to understand the broader impact of spreadsheet skills.
No account connected — sign in to comment.