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

Aggregate Function Queries in Access – Instructions

A picture of a user creating an aggregate function query in Access.
Aggregate Function Queries in Access: Video Lesson             This video lesson, titled “Aggregate Function Queries,” shows you how to create aggregate function queries in Access 2019 and Access for Microsoft 365. This video lesson is from our complete Access tutorial, titled “Mastering Access Made Easy v.2019 and 365.” Overview of Aggregate Function Queries in Access
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

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

Create Calculated Columns in Power Pivot in Excel – Instructions

Create Calculated Columns in Power Pivot in Excel - Instructions: A picture of a user creating a calculated column in the data model window of Power Pivot in Excel by typing a simple formula.
Create Calculated Columns in Power Pivot in Excel: Video Lesson             This video lesson, titled “Calculated Columns,” shows you how to create calculated columns in Power Pivot in Excel. This video lesson on how to create calculated columns in Power Pivot in Excel is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019
Read more
No Comments