Skip to main content
Tag

Google Sheets

Mar 02
enter exponents in Excel

How to Email an Excel attachment From Google Sheets!

By Blog, Video

We’ve all experienced working on Google Drive or Sheets and then needing to send the document to a colleague or friend, only to be stumped by the various drop downs and buttons to look through to figure out how to do what we intend successfully and quickly. So, today I’m going to show you an easy way to convert a Google Sheet to an Excel .xlsx document to email as an attachment.

  1. You will want to pull up the Google Sheet you want to send. Here’s how to do it: go to “File”, and then select “Email”.
  2. In the “Email this file” pop up, you will be able to input the receivers name (if their name and email are already in your address book) or their email address. This doesn’t require somebody to have a Google account or that they are a collaborator on the document. So, you can also type in personal email or something else or paste in something.
  3. Also, in the “Email this file” pop up, you can see that the subject is the title of the particular form you’re sending. Then, below that, you put a message about the document or informing your colleague about anything.
  4. Finally, at the very bottom of the pop up, you will change the “File type” from pdf to Microsoft excel. And then click send. The document will send as a .xlsx attachment.

The document can be opened in Google Sheets again, downloaded and opened in Microsoft Excel, or some other program that can read .xlsx files.

For a more visual step by step example, or if you’re just a visual learner, here is my video going through all the steps to email an excel attachment!

If this helped you out, please take a moment to browse my website. Check out my YouTube channel @In30Minutes for other helpful tips and tricks. For more information, you can reference my book about Google Drive that explores docs, sheets, slides, and many other Google apps. It’s currently in its third edition and available on in30minutes.com. Additionally, you can find multiple other guidebooks for any of your other technological needs on the website. We also have cheat sheets for Google sheets, both basic and intermediate level.

Nov 21

How to edit Excel files in Google Sheets

By Blog, Video

Today I’m going to be talking about how to edit a Microsoft excel .xlsx file in Google Sheets using the Google Chrome browser. You can also check out my video detailing how to do this as well.

Office Editing Extension:

First, you don’t need to convert an Excel file. All you will need is a Google Drive account and to be working in a Chrome browser for Mac or PC. However, you will need to install a special type of extension in the Chrome browser called Office Editing.

In order to install Office Editing, you need to go to Window and then select extension or go to the chrome web store (chrome.google.com) and then search for it. Extensions are like little software programs that you can attach to Google Drive, docs, or Sheets.

Once you have it installed you have to open the excel document from Google Drive. You cannot upload it directly to Google Sheets. If you do try to upload an excel file into Google Sheets, even using the Google Chrome browser, it will automatically convert it into Google Sheets. Sometimes you don’t want to do that because you might need to keep it in excel.

How to edit Excel files:

So, here’s how you edit Excel files. Open a document from Google Drive: go to new, select file upload, then you find your excel document. Once you click open, it will upload the excel document and you will see a green X next to the document which indicates that it’s an Excel document, not Google Sheets.

You can see that all the data is there, and it uses formulas as well as the raw values. However, unlike Excel and Google Sheets, there is no formula bar or options to create new formulas based on the data. The Office compatibility mode for Excel gives you a limited number of options to manipulate the data, but it doesn’t give you the full suite of tools.

So, let’s say I wanted to alter a formula in a certain cell. If you alter the formula is will update the cell. However, some of the functions, when updated, will create a raw number, but in the wrong number format. To fix this you can go to format then choose number format, such as currency and then adjust the decimal places.

Now, once I’ve done that, if I wanted to, I could just download the excel file and then I can email it to somebody. You can find more instruction how to do this in my article How to Email an Excel attachment From Google Sheets. You could also share this with somebody else in Google Sheets. Usually this is useful for simple edits or to make someone check it before its sent somewhere else.

Also, if you do want to get a more full set of features like making charts or accessing the different features that are on the Google Sheets toolbar, you can convert it to Google Sheets. To do this you will go to File then Save as Google sheets.

If this helped you out, please take a moment to browse my website and check out my YouTube channel @In30Minutes for other helpful tips and tricks. For more information on how to get the most out of Google Sheets, check out my book Google Drive & Docs in 30 minutes to learn more about Google Drive, Docs, Sheets, and Slides.

Jul 05

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

Jun 24

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

Feb 24

How do they compare? Excel Online vs. Google Sheets

By Video

Which is better, Google Sheets or Excel Online (Microsoft’s free online spreadsheet program)? The Excel Online vs. Google Sheets differences are narrowing, but there is one clear winner. Most of the features are compared side by side in the first six minutes of the video. The video is narrated by Ian Lamont, author of Google Drive & Docs In 30 Minutes and Excel Basics In 30 Minutes.

Jan 27

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.

Mar 23

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.