Google Sheets: 20 Proven Tricks to Boost Your Productivity

By MR PRASHANTH KV

Google Sheets is coming with lots of advanced functions and features similar to Microsoft Excel, a popular offline Spreadsheet application. So you just don't limit your Google Sheet experience to basic formatting and simple data entry. Use some advanced features in it to boost your productivity. In this book you can find 20 proven tips & tricks that will definitely benefit you.If you know the basic to use any Spreadsheet application, you can be a pro in Google Sheets using the tips & tricks detailed in this book.All the tutorials in this book are written with unique examples and screenshots. The book gives you insights in to advanced data filter technique using filter command, advanced use of SUMIF, Naming Ranges to get a clean worksheet, where and how to use Vlookup and Hlookup, creating a line chart, bar chart, combination charts, create progress report using charts ("S" Curve), Transpose command and function, difference of sum and subtotal functions, get any country's currency format, combined use of IF, AND, OR logical functions, Pivot Table, Data Validation, Concatenate, Round Numbers and finally tips to create a Unit Calculator using SUMIF and Data Validation.

• Format: Paperback
• Language: English
• ISBN: 1521271925
• ISBN13: 9781521271926
• Release Date: May 2017
• Publisher: Independently published
• Length: 61 Pages
• Weight: 0.48 lbs.
• Dimensions: 11.0" x 0.2" x 8.5"