Tag

Microsoft Excel Archives - Excel Basics In 30 Minutes: Official Site

How to calculate the yield on a CD in Excel

By Video

How to use the FV() function in Excel to calculate the yield of a certificate of deposit with compound interest. 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.

How to join text & values in Microsoft Excel

By Video

This neat function can join text, values, and blank spaces to make sentences. 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.

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.

How to filter text lists to highlight words in Excel

By Video

How to filter text lists in an Excel spreadsheet to highlight certain terms (Excel 2019 for Windows or Excel 2019 for macOS). Length: less than 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.

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.