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

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

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

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

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

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

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

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

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

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

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

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.

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

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

%d bloggers like this: