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.

This book is intended for developers who wish to use PhoneGap to develop useful, rich, secure mobile applications for their enterprise environment. The book assumes you have working knowledge of PhoneGap, HTML5, CSS3, and JavaScript, and a reasonable understanding of networking and n-tier architectures.

Do you need an intermediate desktop reference for Microsoft Excel? The four-panel desktop reference and cheat sheet contains step-by-step instructions and shortcuts for commonly used intermediate-level features of Excel. Instructions and examples apply to both the Windows and macOS versions of Excel for Microsoft 365, and includes a list of keyboard shortcuts, as well as instructions for functions and formulas (with examples), formatting, references, security, and more.