Tag

Google Sheets Archives - Excel Basics In 30 Minutes: Official Site

How to edit Excel files in 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 Blog, Video

Updated! 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

DISCLAIMER: This is not an official Microsoft video, nor do I represent Microsoft Corporation. Please review Microsoft’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.

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

How to convert Google Sheets to Excel on an iPhone

By Blog, 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. https://in30minutes.com

DISCLAIMER: This is not an official Microsoft video, nor do I represent Microsoft Corporation. Please review Microsoft’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.

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

How to edit Excel files in Google Sheets using Office Compatibility Mode

By Video

If you don’t own Microsoft Excel, it is still possible to perform limited editing of MS Excel spreadsheets inside of Google Sheets using Office Compatibility Mode. This short video (less than 5 minutes) explains the special Chrome Extension required to use Office Compatibility Mode, and then shows how to edit Excel files in Sheets, using as an example an .xlsx file inside of Google Sheets. The narrator is Ian Lamont, author of the top-selling Excel Basics In 30 Minutes and Google Drive & Docs In 30 Minutes.

How to convert .xlsx files to Google Sheets

By Blog, Video

In six minutes, learn how to convert .xlsx files to Google Sheets, a free online spreadsheet program that is part of the Google Drive office suite. If you have Excel 2010 or 2013, this is a way to get the files into Google Drive. The technique also works with .xls files in older versions of Microsoft Excel. Three examples are given, with step-by-step instructions of how to handle the conversion process. There are also some warnings about formatting problems which can occur when the Microsoft Excel documents are imported into Google Drive.

Start the video below. To see the video full-screen, press the icon on the bottom bar of the video.

The narrator of the video is the author of Excel Basics In 30 Minutes, which you can buy here for the Kindle, iPad, or Nook, or download as a PDF. There is also a paperback edition available.