Skip to main content
Tag

Google Sheets

Oct 15
Love0

How to use Concatenate() function to join text & values in Google Sheets

By Video

This neat function can join text, values, and blank spaces to make sentences. Includes several examples. Length: about 5 minutes. Narrator Ian Lamont is the founder of i30 Media Corporation, publisher of GOOGLE DRIVE & DOCS IN 30 MINUTES.

Web: https://in30minutes.com/?y
Amazon: https://amzn.to/2DTPiG4
Twitter: https://twitter.com/@in30minutes
Facebook: https://www.facebook.com/in30minutes

DISCLAIMER: This is not an official Google video, nor do I represent Alphabet Inc. Please review Google’s terms of service before using this feature. i30 Media Corporation cannot be held liable for any direct, indirect, incidental, consequential, or special damages of any kind, or any damages whatsoever, arising out of or in connection with the use of this video.

Sep 27
Love0

How to calculate CD yield & compound interest using FV() in Google Sheets

By Video

How to use the FV() function in Excel to calculate the yield of a certificate of deposit with compound interest. Includes several examples. Length: about 5 minutes. Narrator Ian Lamont is the founder of i30 Media Corporation, publisher of GOOGLE DRIVE & DOCS IN 30 MINUTES.

Web: https://in30minutes.com/?y
Amazon: https://amzn.to/2DTPiG4
Twitter: https://twitter.com/@in30minutes
Facebook: https://www.facebook.com/in30minutes

DISCLAIMER: This is not an official Google video, nor do I represent Alphabet Inc. Please review Google’s terms of service before using this feature. i30 Media Corporation cannot be held liable for any direct, indirect, incidental, consequential, or special damages of any kind, or any damages whatsoever, arising out of or in connection with the use of this video.

Sep 01
Love0

How to edit Microsoft Excel files with Google Sheets

By Video

An explanation of how to directly edit Excel .xlsx spreadsheet files in Google Sheets. This requires Office Compatibility Mode, which can be activated in Google Drive using the Office Editing extension in the Chrome browser for Windows and macOS. Length: about 5 minutes. Also includes a folder naming trick. Narrator Ian Lamont is the founder of i30 Media Corporation, publisher of GOOGLE DRIVE & DOCS IN 30 MINUTES.

Web: https://in30minutes.com/?y
Amazon: https://amzn.to/2DTPiG4
Twitter: https://twitter.com/@in30minutes
Facebook: https://www.facebook.com/in30minutes

DISCLAIMER: This is not an official Google video, nor do I represent Alphabet Inc. Please review Google’s terms of service before using this feature. i30 Media Corporation cannot be held liable for any direct, indirect, incidental, consequential, or special damages of any kind, or any damages whatsoever, arising out of or in connection with the use of this video.

Jun 23
Love0

Excel 2019 vs. Google Sheets: Which is better for you?

By Video

In 13 minutes, learn the main differences between Excel Online (Microsoft’s free online spreadsheet program) and Google Sheets (Google’s free online alternative). Topics and timecodes are listed below, and include interfaces, features, examples, collaboration, and more. Narrator Ian Lamont is the author of EXCEL BASICS IN 30 MINUTES and the publisher of the EXCEL 2019 REFERENCE AND CHEAT SHEET.

00:00 Basic comparison of Excel 2019 and Google Sheets
01:30 Excel Online registration requirements and OneDrive
02:20 Google Sheets registration and online storage in the cloud
02:45 Google Sheets offline compatibility mode
03:30 Excel Online cost vs Excel 2019
04:00 Feature comparison – Creating a chart I
05:20 Excel Online ribbon interface and features
05:45 Google Sheets toolbar
06:20 Functions comparison
07:40 Interface comparison
08:00 Creating a chart II – making modifications
11:20 Which one I use – Google Sheets or Excel Online?
11:45 Collaboration comparison

Web: https://in30minutes.com/?y
Amazon: https://amzn.to/2DTPiG4
Twitter: https://twitter.com/@in30minutes
Facebook: https://www.facebook.com/in30minutes

Feb 10
Love0

How to permanently delete a file in Google Sheets mobile app

By Video

Learn how to permanently delete a Google Sheets or Microsoft Excel .xlsx file using the iOS Google Sheets mobile app on an iPhone or iPad. There are two steps involved – “removing” and “deleting.” In this 3-minute video, learn how to delete (or restore) a trashed file using your iPhone or iPad! This technique uses the Google Sheets mobile app for iOS, available for free on your iPhone or iPad. Narrated by the author of Google Drive & Docs In 30 Minutes and Excel Basics In 30 Minutes.

Nov 15
Love0

Convert to Excel from the Google Sheets mobile app for iOS

By Video

Learn how to convert Google Sheets to Microsoft Excel .xlsx using the iOS Google Sheets mobile app on an iPhone or iPad. In this 90 second video, learn how to convert between Sheets and Excel using your iPhone or iPad! This technique uses the Google Sheets mobile app for iOS, available for free on your iPhone or iPad. Narrated by the author of Google Drive & Docs In 30 Minutes and Excel Basics In 30 Minutes.

Jan 18
Love0

How to import a PDF table into Google Sheets

By Video

In less than 12 minutes, learn how to take a PDF table and import it into Google Sheets in order to change the data, create charts, or reconvert it to another format such as Microsoft Excel .xlsx. Note that it’s a complicated workaround involving other tools in the Google Suite (including Google Drive and Google Docs and text and CSV files), and will only work with simple PDF tables – complex tables, or mixed tables and other content on the PDF page can’t easily be converted to PDF using this method. This video also shows how to handle errors in the import process, such as mismatched columns and rows. The PDF to Sheets tutorial is a huge time-saver for power users, accountants, bookkeepers, MBA students, and others who want to save time with Google Sheets. This short G Suite video is narrated by the author of Google Drive and Docs In 30 Minutes.