Tag

Google Sheets Archives - Google Drive & Docs In 30 Minutes

Google Sheets text wrapping: clip, wrap, overflow

By Video

From @in30minutes, learn how to set text wrapping settings in Google Sheets. Length: about 4 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

NOTE: 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.

Disable Google Sheets gridlines in exported PDFs

By Video

Learn how to export a PDF from Google Sheets and disable the gridlines. Length: about 90 seconds. 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.

In 2 minutes: How to export PDFs from Google Sheets

By Video

Learn how to export a PDF from Google Sheets, including adjusting columns and page width. Length: about 2 minute. 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.

Two ways to alphabetize lists in Google Docs

By Video

Alphabetize a list of terms in Google Docs, with an assist from Google Sheets. Length: about 3 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.

Calculate mortgage payments with PMT() in Google Sheets

By Video

How to use the PMT() function in Google Sheets to calculate monthly mortgage or loan payments. Includes several examples. Length: about 6 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.

Two ways to enter exponents in Google Sheets

By Video

How to express exponents in Google Sheets using the carat symbol (^) or the POWER() function. Includes several examples. Length: about 3 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.

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.

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.

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.

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