Google Sheets Beginners: Editing Excel and ODS format files in Google Sheets (31)

You can now work on Excel and Open Document Format (ODS) file right in Google Sheets without converting the file to a Google Sheets file. This makes Googles Sheets a power collaboration tool.

In this tutorial, I’ll cover,

  1. How to upload an Excel sheet to your Google Drive 00:16
  2. Adding an Excel file from your email 01:04
  3. Directly editing an Excel sheet from your email 01:25
  4. How do I know if it’s an Excel, ODS, or Google Sheet? 01:34
  5. Differences in Google Sheets from your Excel sheet 02:07
  6. Benefits of editing in Google Sheets to transfer easily. 02:55
  7. Where has my edited/ opened Excel sheet gone? 03:12
  8. Downloading your file from Google Drive 03:47
  9. Comparisons in sheets, from your Drive to Excel 04:17
  10. A different way to download 05:01
  11. Converting Excel to Google Sheets. 05:17

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Sheets Beginners: You Can Create Custom Page Breaks for Printing and Exporting (30)

Yeap! That’s right. Google Sheets allows you to set custom page breaks for your Google Sheets tabs. So you can print exactly what you want on each page.

  1. What are custom page breaks? 00:00
  2. How custom page breaks work 00:30
  3. Turning custom page breaks off or on 00:58
  4. How to move custom page break lines 01:14
  5. Deleting a page break. 01:33
  6. Resetting all page breaks 02:08
  7. Saving or printing with your custom page breaks 02:28
  8. Removing portions/pages to print or save 03:13
Watch this video on YouTube.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Sheets Beginners: Printing your Google Sheet (29)

All the options available to you when printing your Google Sheet can be quite overwhelming. Find out everything you need to know about printing your Google Sheets documents, tabs and selected ranges.

In this tutorial, I’ll cover,

  1. Ways to access the print button 00:05
  2. Choosing your paper size and orientation 00:30
  3. Using the scale function to resize your sheets to print 00:48
  4. Using margins to effectively print better 01:38
  5. Altering custom page breaks 02:02
  6. Formatting your sheet 02:28 
  7. Formatting – Gridlines 02:29
  8. Formatting – Notes 02:45
  9. Formatting – Page Order 03:15
  10. Formatting – Alignment 03:29
  11. Adding/ Creating Headers and Footers 04:15
  12. Customizing your Header and Footers 04:42
  13. What are Repeat Frozen Rows? 05:32
  14. Printing your Entire Workbook 06:12
  15. electing parts of your Workbook to print 06:26
  16. The Final Print 07:30
Watch this video on YouTube.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Sheets Beginners: Exporting your Google Sheet as different file types (28)

One of the benefits of using Google Sheets is that it can quickly be downloaded as different file types like Excel files (*.xlsx), Open Document Format **.ods), PDFs for reports or CSV or TSV for uploading onto other software systems.

In this tutorial, I’ll cover,

  1. Why downloading in different formats can be useful. 00:15
  2. How to navigate to the download function 00:37
  3. How to download your Google Sheet in Excel or ODS form 00:45 
  4. Differences between Excel and Sheets 01:45
  5. Function Issues that do not translate from Google Sheets into Excel 03:00 
  6. How to download your Google Sheet in PDF form 04:41
  7. How to download your Google Sheet in Webpage HTML form 05:50
  8. How to download your Google Sheet in Comma-Separated Values (CSV) or Tab-Separated Values (TSV) forms 06:59
Watch this video on YouTube.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Sheets Beginners: Trim Whitespace (27)

Trim Whitespace removes all spaces in a text string, leaving just a single space between words.

Search not working? This may be why.

This is a quick and easy tool that you can apply to all of your cells.

Watch this video on YouTube.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.