How to Use the TEXT Function in Excel to Format Dates

A picture showing how to use the TEXT function in Excel to format dates.
Video Lesson:       This video lesson, titled “How to Use the TEXT Function in Excel to Format Dates,” shows you how to use the TEXT function in Excel to format dates. How to Use the TEXT Function in Excel to Format Dates:             The TEXT function in Excel lets you convert dates and
Read more
No Comments

Use Excel to Extract Address Elements from a List Exported from QuickBooks Desktop

A picture showing how to use Excel to extract address elements from a list exported from QuickBooks Desktop. The formula in this picture extracts the city data from a field containing the city, state, and zip code.
Video Lesson:       This video lesson, titled “How to Use Excel to Extract Address Elements from a List Exported from QuickBooks Desktop,” shows you how to use functions and formulas to extract address elements from a list exported from QuickBooks Desktop. How to Use Excel to Extract Address Elements from a List Exported
Read more
No Comments

Use the CLEAN Function to Remove Hidden Characters in Excel

A picture showing how to use the CLEAN function to remove hidden characters in Excel.
Video Lesson:       This video lesson, titled “How to Use the Clean Function to Remove Hidden Characters in Excel,” shows you how to use the CLEAN function to remove hidden characters in Excel. How to Use the CLEAN Function to Remove Hidden Characters in Excel:             The CLEAN
Read more
No Comments

Microsoft Excel Cheat Sheet

Microsoft Excel Cheat Sheets Now Available             TeachUcomp, Inc. is pleased to announce our Microsoft Excel cheat sheet, titled “Excel for Microsoft 365 Introduction” is now available. Our Microsoft Excel quick reference card helps both busy professionals and students learn how to quickly do tasks in Excel. This Microsoft Excel reference is a great tool
Read more
No Comments

The Ribbon in Excel – Instructions and Video Lesson

A picture showing how to change the Ribbon display options in Excel for Microsoft 365.
How to Use the Ribbon in Excel: Video Lesson             This video lesson, titled “Excel for Microsoft 365 Tutorial: How to Use the Ribbon,” shows you how to use the Ribbon in Excel for Microsoft 365. This video lesson is from our complete Excel tutorial, titled Mastering Excel Made Easy™. Overview:             The Ribbon in
Read more
No Comments

Full Screen Mode in Excel – Instructions and Video Lesson

A picture showing how to switch to full screen mode in Excel for Microsoft 365.
Full Screen Mode in Excel: Video Lesson             This video lesson, titled “Excel for Microsoft 365 Tutorial: How to Switch to Full Screen Mode in Excel,” shows you how to switch to full screen mode in Excel for Microsoft 365. This video lesson is from our complete Excel tutorial, titled Mastering Excel Made Easy™. Overview:
Read more
No Comments

Resize Columns and Rows in Excel – Instructions and Video Lesson

A picture showing how to resize columns and rows in Excel by using the “AutoFit Column Width” command to automatically resize columns to fit their contents.
Resize Columns and Rows in Excel: Video Lesson             This video lesson, titled “Excel for Microsoft 365 Tutorial: How to Adjust Column Width and Row Height in Excel,” shows you how to resize columns and rows in Excel. This video lesson is from our complete Excel tutorial, titled Mastering Excel Made Easy™. Overview:             You
Read more
No Comments

Print a Chart in Excel – Instructions and Video Lesson

A picture showing how to print a chart in Excel.
Print a Chart in Excel: Video Lesson             This video lesson, titled “Excel for Microsoft 365 Tutorial: How to Print a Chart in Excel,” shows you how to print charts in Excel. This video lesson is from our complete Excel tutorial, titled Mastering Excel Made Easy™. Overview             To print a chart in Excel that
Read more
No Comments