TeachUcomp, Inc.

 MY CART
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Accounting
      • Adobe
        • Acrobat
        • Lightroom Classic
        • Photoshop
        • Photoshop Elements
      • Crystal Reports
      • Employment Skills
        • Interview Skills
        • Resume Skills
      • For Lawyers
        • Excel for Lawyers
        • Outlook for Lawyers
        • QuickBooks for Lawyers
        • Word for Lawyers
      • HTML
      • JavaScript
      • Microsoft Office
        • Access
        • Excel
        • Microsoft Office Suite
        • OneNote
        • Outlook
        • Outlook on the Web
        • PowerPoint
        • Publisher
        • Word
      • Microsoft Project
      • Microsoft Teams
      • QuickBooks Online
      • QuickBooks Pro
      • Sage
        • Peachtree
        • Sage 50
      • SQL
      • Windows
    • Video Course Options
  • SUBSCRIPTIONS
  • MANUALS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements
    • Crystal Reports
    • For Lawyers
      • Excel for Lawyers
      • Outlook for Lawyers
      • QuickBooks for Lawyers
      • Word for Lawyers
    • HTML
    • JavaScript
    • Microsoft Office
      • Access
      • Excel
      • OneNote
      • Outlook
      • Outlook on the Web
      • PowerPoint
      • Publisher
      • Word
    • Microsoft Project
    • Microsoft Teams
    • QuickBooks Online
    • QuickBooks Pro
    • Sage
      • Peachtree
      • Sage 50
    • SQL
    • Windows
  • REFERENCE CARDS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements 2025
      • Photoshop Elements 2024
      • Photoshop Elements 2023
      • Photoshop Elements 2022
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
      • Google Docs
      • Google Drive
      • Google Forms
      • Google Sheets
      • Google Slides
    • Mac OS
      • Mac OS Keyboard Shortcuts
    • Microsoft Office
      • Excel Formulas and Functions
      • Excel Keyboard Shortcuts
      • Excel Tables PivotTables and Charts
      • Microsoft 365
        • Access for Microsoft 365
        • Excel for Microsoft 365
        • Microsoft Office 365
        • Outlook for Microsoft 365 Classic Edition
        • Outlook for Microsoft 365 (New Outlook)
        • PowerPoint for Microsoft 365
        • Publisher for Microsoft 365
        • Word for Microsoft 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • OneNote for Windows 10
        • Outlook 2021
        • PowerPoint 2021
        • Publisher 2021
        • Word 2021
      • Microsoft Office 2019
        • Access 2019
        • Excel 2019
        • Microsoft Office 2019
        • Outlook 2019
        • PowerPoint 2019
        • Publisher 2019
        • Word 2019
      • Microsoft Office 2016
        • Access 2016
        • Excel 2016
        • Microsoft Office 2016
        • OneNote 2016
        • Outlook 2016
        • PowerPoint 2016
        • Publisher 2016
        • Word 2016
      • Microsoft Office 2013
        • Excel 2013
        • Microsoft Office 2013
        • OneNote 2013
        • Outlook 2013
        • PowerPoint 2013
        • Word 2013
      • Microsoft Office for iPad
        • Microsoft Office for iPad
      • Word Keyboard Shortcuts
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • QuickBooks Pro 2024
      • QuickBooks Pro 2023
      • QuickBooks Pro 2022
      • QuickBooks Pro 2021
      • QuickBooks Pro 2020
      • QuickBooks Pro 2019
      • QuickBooks Pro 2018
      • QuickBooks Pro 2017
      • QuickBooks Pro 2016
      • QuickBooks Pro 2015
      • QuickBooks Pro 2014
    • Sage
      • Sage 50 Accounting
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop (PC/Windows) 2024
      • QuickBooks Desktop (PC/Windows) 2023
      • QuickBooks Desktop (PC/Windows) 2022-2015
    • Windows
      • Windows 11 and 10
  • SUPPORT
    • Company
      • About Us
      • Blog
      • Contact Us
      • Our History
      • Our Philosophy
        • Customer Service
        • Mission
      • Policies
      • Testimonials
    • FAQ
      • Contact Us
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
Shop Now

How to Use the TEXT Function in Excel to Format Dates

Wednesday, July 02 2025 by Joseph Brownell
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
convert dataconvert date/time to textconvert dates to textcourseexcelExcel for Microsoft 365Excel for Office 365excel tips and tricksExcel trainingExcel tutorialformat date/timeformat datesformat textformulaformulasfunctionfunctionsguidehelphow to use excelhow-toinstructionslearnLearn excellessonmanualmicrosoftMicrosoft 365microsoft exceloffice 365overviewreferencesoftwareteachtext functiontrainingtutorialvideoWindows 11
Read more
  • Published in Excel for Office 365, Latest, Microsoft, Office 365
No Comments

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

Friday, June 27 2025 by Joseph Brownell
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
clean datacoursedeleteexcelExcel for Microsoft 365Excel for Office 365excel tips and tricksExcel trainingExcel tutorialexportextract datafix datafix data exported from quickbooks desktopformulaformulasfunctionfunctionsguidehelphow to use excelhow-toIF functioninstructionsISBLANK functionlearnLearn excelLEFT functionlessonlistsmanualmicrosoft exceloverviewQuickBooks DesktopREGEXEXTRACT functionremoveRIGHT functionsoftwareSUBSTITUTE functionteachtrainingtutorialvideo
Read more
  • Published in Excel for Office 365, Latest, Microsoft, Office 365, Quickbooks
No Comments

Use the CLEAN Function to Remove Hidden Characters in Excel

Wednesday, June 25 2025 by Joseph Brownell
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
clean dataclean functioncoursedeleteexcelexcel for beginnersExcel for Microsoft 365Excel for Office 365excel tips and tricksExcel trainingExcel tutorialformulaformulasfunctionfunctionsguidehelphidden charactershow to use excelhow-toinstructionslearnLearn excellessonmanualmicrosoftMicrosoft 365microsoft excelnon-printing charactersoffice 365onlineoverviewreferenceremoveremove hidden characterssoftwareteachtrainingtutorialvideoWindows 11
Read more
  • Published in Excel for Office 365, Latest, Microsoft, Office 365
No Comments

Microsoft Excel Cheat Sheet

Wednesday, October 23 2024 by Joseph Brownell
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
cheat sheetcheat sheetsexcelExcel for Microsoft 365Excel for Office 365Microsoft 365microsoft excelMicrosoft Excel Cheat SheetMicrosoft Excel Cheat Sheetsmicrosoft excel shortcutsmicrosoft excel tipsMicrosoft Office 365new productnewsoffice 365product releasequick referencequick reference cardsreference cardreference cardsreference guide
Read more
  • Published in Excel for Office 365, Latest, Marketing, Microsoft, News, Office 365, What's New at TeachUcomp?
No Comments

The Ribbon in Excel – Instructions and Video Lesson

Tuesday, February 27 2024 by Joseph Brownell
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
always show the ribbonbutton groupsbuttonscontextual tabcontextual tabscourseexcelExcel for Microsoft 365Excel for Office 365full screen modefull screen viewhelphow-toinstructionslearnlessonMicrosoft 365Microsoft Office 365office 365overviewribbon display optionsshow tabs onlyteachthe ribbonthe ribbon in exceltrainingtutorialvideo
Read more
  • Published in Excel for Office 365, Latest, Microsoft, Office 365
No Comments

Full Screen Mode in Excel – Instructions and Video Lesson

Monday, February 26 2024 by Joseph Brownell
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:
courseexcelExcel for Microsoft 365Excel for Office 365exit full screen modefull screen modefull screen viewhelphow-toinstructionslearnlessonMicrosoft 365Microsoft Office 365office 365overviewswitch to full screen modeteachtrainingtutorialvideo
Read more
  • Published in Excel for Office 365, Latest, Microsoft, Office 365
No Comments

Resize Columns and Rows in Excel – Instructions and Video Lesson

Friday, February 23 2024 by Joseph Brownell
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
adjustadjustingAdjusting Column Width and Row Heightautofitautomaticallycolumncolumn widthcolumnscourseexcelExcel for Microsoft 365Excel for Office 365headingheighthelphow-toinstructionslearnlessonmanuallyMicrosoft 365Microsoft Office 365office 365overviewresizeResize Columns and Rows in Excelresizingrowrow heightrowsselectselectingselecting columns and rowsteachtrainingtutorialvideowidthworkbooksworksheetworksheets
Read more
  • Published in Excel for Office 365, Latest, Microsoft, Office 365
No Comments

Print a Chart in Excel – Instructions and Video Lesson

Thursday, February 22 2024 by Joseph Brownell
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
chartchartscourseexcelExcel for Microsoft 365Excel for Office 365helphow to print a chart in excelhow-toinstructionslearnlessonMicrosoft 365Microsoft Office 365overviewprintPrint a Chart in Excelprintingprinting chartsselectselectingteachtrainingtutorialvideoworkbooksworksheetworksheets
Read more
  • Published in Excel for Office 365, Latest, Microsoft, Office 365
No Comments
  • 1
  • 2
  • 3
Save $150! One Year Online Entire Library $49. Click here for more info.

 

Categories

  • GET SOCIAL

© 2001-2025 Copyright TeachUcomp, Inc. All rights reserved.

TOP
SALE! $49 All-Access 2 Days 22 Hours 41 Minutes 4 Seconds      $199 $49 Entire Library!
See Deal