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 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 Ventura-Mojave Keyboard Shortcuts
    • Microsoft Office
      • Microsoft Office 365
        • Access for Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Publisher for Office 365
        • Word for Office 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • 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
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • 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 2019
      • Sage 50 2018
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Ventura
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • 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
    • Contact Us
    • FAQ
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
Shop Now

Guided Edit Mode in Photoshop Elements – Instructions

Monday, April 04 2022 by Joseph Brownell
A picture of a user editing a photo in Guided Edit mode in Photoshop Elements.
Overview of How to Use Guided Edit Mode in Photoshop Elements:             Guided Edit mode in Photoshop Elements lets you make basic choices and have the program do the work for you. To use Guided Edit mode in Photoshop Elements, click “Guided” in the Shortcuts Bar.             Within Guided Edit mode in Photoshop Elements, select
applycreateeditedit photoseffecteffectsfunctionsguidedguided editguided edit modeGuided Edit Mode in Photoshop Elementsguided editshelphow to use guided edit mode in photoshop elementshow to use guided edit mode in psehow-toimageimagesinstructionslearnlessonoverviewphotophotosphotoshop elementsphotoshop elements 2018photoshop elements 2019photoshop elements 2020photoshop elements 2021photoshop elements 2022picturepicturespseteachtrainingtutorialuseusingvideo
Read more
  • Published in Latest, Photoshop Elements
No Comments

Create a Calculated Field in Access – Instructions

Tuesday, September 21 2021 by Joseph Brownell
A picture that shows how to create a calculated field in Access in query design view.
Overview of Creating a Calculated Field in Access             You can easily create a calculated field in Access queries. A calculated field is a field that derives its value by performing a function on values from other table fields. It can also calculate values entered by hand. The field’s data only appears for the duration
aboutaccessaccess 2013Access 2016Access 2019access add calculated field to queryaccess calculated fieldaccess calculated field in queryaccess databaseAccess for Microsoft 365Access for Office 365access formulas in queriesaccess query calculated fieldaddadd a calculated field in accessaddingcalculated fieldcalculated field accesscalculated field access querycalculated field in accesscalculated field in access querycalculated fieldscalculationcalculationscolumncolumnscoursecreateCreate a Calculated Field in Accesscreate calculated field in access querycreatingdesign viewfieldformulaformulasfunctionfunctionshelphow to add a calculated field in accesshow to add a calculated field in access queryhow to add a calculated field to a query in accesshow to add calculated field in accesshow to add calculated field in access queryhow to create a calculated field in a query in accesshow to create a calculated field in accesshow to create a calculated field in access queryhow-toinfoinformationinsertinsertinginstructionslearnlessonMicrosoft Accessms access calculated fieldms access query calculated fieldoverviewqueriesqueryself studyteachtrainingtutorialvideo
Read more
  • Published in Access 2013, Access 2016, Access 2019, Access for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
No Comments

Aggregate Function Queries in Access – Instructions

Monday, August 16 2021 by Joseph Brownell
A picture of a user creating an aggregate function query in Access.
Overview of Aggregate Function Queries in Access             Aggregate function queries in Access let you create summary queries that perform a mathematical function, called an “aggregate function,” on a field, based on groups of values found in another grouped query field or grouped query fields. These are usually shorter queries, often used for reporting.            
accessaccess 2013Access 2016Access 2019access aggregate functionAccess for Microsoft 365Access for Office 365access group byaccess group by queryaccess query group byaccess query sum group byaccess sum functionaccess sum queryaggregateaggregate accessaggregate function accessaggregate function in accessAggregate Function Queries in Accessaggregate functionsaggregate functions accessaggregate queryaggregation querycoursedesign querydesign viewexpression aggregate query accessfunctionfunctionsgroupgroup bygroup by accessgroup by in accessgroupinghelphow-toinstructionslearnlessonMicrosoft Accessms accessms access aggregate functionsoverviewqueriesqueryself studysum aggregate query accesssummarizesummaryteachtotaltrainingtutorialvideowhat is aggregate accesswhere aggregate query access
Read more
  • Published in Access 2013, Access 2016, Access 2019, Access for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
No Comments

Insert Table Formulas in Word – Instructions

Friday, September 25 2020 by Joseph Brownell
Insert Table Formulas in Word - Instructions: A picture of the default table formula that Word suggests in the “Formula” dialog box.
Insert Table Formulas in Word: Overview             You can insert table formulas in Word tables to perform simple mathematical functions on data. To insert table formulas in Word that add, subtract, multiply, and divide numbers in the table cells, you insert formulas into cells where you want to show the answers to the mathematical operations
cell addresscell addressescoursecreatedocumentdocumentsformulaformulasfunctionfunctionshelphow-toinsertinsert table formulasInsert Table Formulas in Wordinsertinginstructionslearnlessonmakemicrosoft wordnumber formatoverviewpaste functiontabletablesteachtrainingtutorialvideoWord 2013Word 2016Word 2019Word for Microsoft 365word for Office 365write
Read more
  • Published in Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365, Word 2013, Word 2016, Word 2019, Word for Office 365
No Comments

Function Compatibility in Excel – Instructions

Friday, October 18 2019 by Joseph Brownell
Function Compatibility in Excel - Instructions: A picture of the “Compatibility” functions in Excel.
Function Compatibility in Excel: Overview             Function compatibility in Excel supports older functions that have been replaced by newer versions of those functions. In Excel, some older formula functions have been replaced with new versions. These replacements occur to increase their accuracy and to better reflect their purpose. These new, more accurate statistical functions have
2013compatibilitycourseeditexcelexcel 2013Excel 2016Excel 2019findformulaformulasfunctionfunction compatibilityFunction Compatibility in Excelfunctionshelphow-toinstructionslearnlessonlocatemicrosoftmicrosoft excelMicrosoft Office 2019Microsoft Office 365officeOffice 2019office 365overviewreplaceseeself studyteachtrainingtutorialvideoviewworkbookworksheet
Read more
  • Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
No Comments

Create Calculated Columns in Power Pivot in Excel – Instructions

Thursday, September 12 2019 by Joseph Brownell
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: Overview             This lesson shows you how to create calculated columns in Power Pivot in Excel. You can create calculated columns and measures from the tables in the Power Pivot data model. Doing this lets you create table values that you can then add to PivotTables and
addcalculated columncalculated columnscoursecreateCreate Calculated Columns in Power Pivot in ExcelCreate Calculated Columns in Power Pivot in Excel 2016data modelexcelExcel 2016Excel 2019formulaformulasfunctionfunctionshelphow-toinstructionslearnlessonmeasuremeasuresmicrosoft excelMicrosoft Office 365Office 2019office 365overviewPower Pivotteachtrainingtutorialvideo
Read more
  • Published in Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2016, Office 2019
No Comments

The Pv Function- Excel for Lawyers Tutorial and Video Lesson

Friday, August 30 2019 by Joseph Brownell
The Pv Function- Excel for Lawyers Tutorial: A picture of a user creating a formula that uses the Pv function in Excel.
The Pv Function: Overview             This lesson shows you how to use the Pv function in Excel. Most of the functions that a lawyer needs to know assist them in business and financial computations. You can use these functions to help both the law firm as well as its clients.
excelexcel 2013Excel 2016Excel 2019Excel for Lawyersformulaformulasfunctionshelphow-toinstructionslawlaw firmlawyerlawyerslearnlessonMicrosoft Office 365office 365overviewsyntaxteachThe Pv Functiontrainingtutorialvideo
Read more
  • Published in Excel 2013, Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Microsoft Excel Training for Lawyers, Office 2013, Office 2016, Office 2019, Office 365
No Comments

The Fv Function- Excel for Lawyers Tutorial

Thursday, August 29 2019 by Joseph Brownell
The Fv Function- Excel for Lawyers Tutorial: A picture of the Fv function being used in Excel.
The Fv Function: Overview             The Fv function assists you in determining the future value of an investment based on periodic but constant payments with a constant interest rate. The future value is the total amount that a series of payments will be worth at a specified future time. For example, if you saved $100
excelexcel 2013Excel 2016Excel 2019Excel for Lawyersformulaformulasfunctionshelphow-toinstructionslawlaw firmlawyerlawyerslearnlessonmicrosoft excelMicrosoft Office 365office 365overviewsyntaxteachThe Fv Functiontrainingtutorialvideo
Read more
  • Published in Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Microsoft Excel Training for Lawyers, Office 2016, Office 2019, Office 365
No Comments
  • 1
  • 2

 

Recent Posts

  • A picture showing how to create a clipping mask in Photoshop Elements.

    Create a Clipping Mask in Photoshop Elements – Instructions and Video

    Overview of How to Create a Clipping Mask in Ph...
  • A picture of the “Add/Edit Multiple List Entries” window that lets you copy and paste list data from Excel into QuickBooks Pro.

    Copy and Paste List Data from Excel into QuickBooks Pro- Instructions

    Overview of How to Copy and Paste List Data fro...
  • A picture showing how to duplicate a layer in Photoshop Elements using the “Duplicate Layer” dialog box.

    Duplicate a Layer in Photoshop Elements – Instructions

    Overview of How to Duplicate a Layer in Photosh...

Categories

Archives

  • GET SOCIAL

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

TOP
Sale! $49 All-Access 2 Days 19 Hours 3 Minutes 42 Seconds      $199 $49 Entire Library!
See Deal