Tag

Tips 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.

How to calculate monthly mortgage payments in Excel

By Video

How to use the PMT() function in Excel to calculate monthly mortgage or loan payments. Includes several examples. Length: about 5 minutes. Narrator Ian Lamont is the founder of i30 Media Corporation, publisher of MICROSOFT WORD 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 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.

Two ways to enter exponents in Microsoft Excel

By Video

How to express exponents in Excel 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 MICROSOFT WORD 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 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.

Excel 2019: A quick conditional formatting tutorial

By Video

How to use the conditional formatting tool on the Home ribbon to format text and highlight certain values in an Excel spreadsheet (Excel 2019 for Windows or Excel 2019 for macOS). Length: 4 minutes. Narrator Ian Lamont is the author of EXCEL BASICS 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 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.

How to remove duplicate cell values in Excel

By Video

How to remove duplicate text or numerical values in an Excel spreadsheet (Excel 2019 for Windows or Excel 2019 for macOS). Length: 2 minutes. Narrator Ian Lamont is the author of EXCEL BASICS 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 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.

How to line up numbers and text in Excel

By Video

How to line up numbers and center text in an Excel spreadsheet (Excel 2019 for Windows or Excel 2019 for macOS). Length: 4 minutes. Narrator Ian Lamont is the author of EXCEL BASICS 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 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.

How to alphabetize a list of words in Excel

By Video

A quick explanation of how to alphabetize a list of terms in an Excel spreadsheet (Excel 2019 for Windows or Excel 2019 for macOS). Narrator Ian Lamont is the author of EXCEL BASICS 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 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.

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 print gridlines on Excel 2016 for Windows 10

By Blog
A reader of my Excel book wrote to me about a problem he had to print gridlines for Excel 2016 on Windows 10, which he installed after purchasing an Office 365 subscription. It’s a common problem as many options are buried deep within Excel’s settings. Here’s how to print gridlines using Excel 2016 for Windows 10:
  1. Open the Excel document.
  2. Go to Backstage View by clicking File.
  3. You will see a list of different print options. Scroll to the bottom and click the link that says Page Setup.
  4. The Page Setup pop-up will appear. There are four tabs. Click the one that says Sheet.
  5. Select the checkbox that says Gridlines.

Here’s the location of the checkbox:

Excel 2016 print gridlines Windows 10