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

Create a Calculated Field in Access – Instructions

A picture that shows how to create a calculated field in Access in query design view.
Video Lesson on How to Create a Calculated Field in Access:             This video lesson, titled “Creating a Calculated Field,” shows how to create a calculated field in Access. This video lesson is from our complete Access tutorial, titled “Mastering Access Made Easy v.2019 and 365.” Overview:             You can easily create a calculated field
Read more
No Comments

Insert Table Formulas in Word – Instructions

Insert Table Formulas in Word - Instructions: A picture of the cell addresses within a sample table, shown at the top of the Word document.
Insert Table Formulas in Word: Video Lesson             This video lesson, titled “Inserting Table Formulas,” shows how to insert table formulas in Word. It is from our complete Word tutorial, titled “Mastering Word Made Easy v.2019 and 365.” Insert Table Formulas in Word: Overview             You can insert table formulas in Word tables to perform
Read more
No Comments

View Formulas in a Table in Word – Instructions

View Formulas in a Table in Word - Instructions: A picture of a formula in a table cell in Word.
View Formulas in a Table in Word: Video Lesson             This video lesson, titled “Viewing Formulas vs. Formula Results,” shows how to view formulas in a table in Word. This video lesson is from our complete Word tutorial, titled “Mastering Word Made Easy v.2019 and 365.” View Formulas in a Table in Word: Overview            
Read more
No Comments

Trace Error in Excel – Instructions and Video Lesson

Trace Error in Excel - Instructions: A picture of formula auditing arrows shown in a worksheet after using the Trace Error tool in Excel.
Trace Error in Excel: Video Lesson             This video lesson, titled “Tracing Errors,” shows you how to use Trace Error in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Trace Error in Excel: Overview             Trace Error in Excel lets you trace arrows back to
Read more
No Comments

Function Compatibility in Excel – Instructions

Function Compatibility in Excel - Instructions: A picture of the “Compatibility” functions in Excel.
Function Compatibility in Excel: Video Lesson             This video lesson, titled “Function Compatibility,” shows how to use function compatibility in Excel. This video on function compatibility in Excel is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Function Compatibility in Excel: Overview             Function compatibility in Excel supports older functions
Read more
No Comments