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

Record a Macro in Excel – Instructions and Video Lesson

Wednesday, February 08 2023 by Joseph Brownell
A picture that shows how to record a macro in Excel using the “Record Macro” dialog box.
Overview of How to Record a Macro in Excel:              You can easily record a macro in Excel. Macros are small programs that record your actions as you perform a task in Excel. The actions are then saved as a Visual Basic Module, which is a type of program. When you run the macro later,
coursecustom keyboard shortcut for excel macroexcelexcel 2013Excel 2016Excel 2019Excel for Office 365helphow to assign keyboard shortcut when recording a macro in excelhow to record a macro in excelhow to record macros in excelhow to stop recording a macro in excelhow-toinstructionskeyboard shortcutlearnlessonmacromacrosMicrosoft 365Microsoft Office 2019Microsoft Office 365Office 2019office 365overviewrecordRecord a Macro in Excelrecording macrosself studystop recording macro in excelteachtrainingtutorialuse relative referencesuse relative references togglevideoworkbookworkbooks
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

Hide Columns or Rows in Excel – Instructions and Video Lesson

Wednesday, July 08 2020 by Joseph Brownell
Hide Columns or Rows in Excel - Instructions: A picture of a user hiding selected columns in an Excel workbook.
Hide Columns or Rows in Excel: Overview             You can hide columns or rows in Excel that contain sensitive data. You can do this to hide data you need for formulas but don’t want to show in a worksheet, like salary information, for example. Hiding a column or row conceals its display, but still uses
columncolumnscourseexcelexcel 2013Excel 2016Excel 2019Excel for Office 365helphideHide Columns or Rows in ExcelhidingHiding and Unhiding Columns and Rows in Excelhow-toinstructionslearnlessonMicrosoft Office 2019Microsoft Office 365Office 2019office 365overviewrowrowsteachtrainingtutorialunhideunhidingvideowidthworkbooksworksheetworksheets
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

Resize Columns and Rows in Excel – Instructions and Video Lesson

Tuesday, June 30 2020 by Joseph Brownell
Resize Columns and Rows in Excel - Instructions and Video Lesson: A picture of a user resizing selected columns in an Excel workbook.
Resize Columns and Rows in Excel: Overview             There are many ways to resize columns and rows in Excel. You can adjust the width of columns to correct the display of longer cell entries. You can also adjust row height to accommodate larger fonts. To resize columns and rows in Excel, you must first select
adjustadjustingAdjusting Column Width and Row Heightautofitautomaticallycolumncolumn widthcolumnscourseexcelexcel 2013Excel 2016Excel 2019Excel for Office 365headingheighthelphow-toinstructionslearnlessonmanuallyMicrosoft Office 2019Microsoft Office 365Office 2019office 365overviewresizeResize Columns and Rows in Excelresizingrowrow heightrowsselectselectingselecting columns and rowsteachtrainingtutorialvideowidthworkbooksworksheetworksheets
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

Print a Chart in Excel – Instructions and Video Lesson

Tuesday, June 23 2020 by Joseph Brownell
Print a Chart in Excel - Instructions and Video Lesson: A picture of a user printing a selected chart in Excel.
Print a Chart in Excel: Overview             To print a chart in Excel that appears embedded in a worksheet without printing the rest of the worksheet, select the chart or one of the chart’s elements, first. Alternatively, to print a chart in Excel that appears embedded in a worksheet along with its accompanying worksheet data, click into
chartchartscourseexcelexcel 2013Excel 2016Excel 2019Excel for Office 365helphow to print a chart in excelhow-toinstructionslearnlessonMicrosoft Office 365overviewprintPrint a Chart in Excelprintingprinting chartsselectselectingteachtrainingtutorialvideoworkbooksworksheetworksheets
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

Apply Password Protection to an Excel File – Instructions

Thursday, March 12 2020 by Joseph Brownell
Apply Password Protection to an Excel File - Instructions: A picture of a user adding a password for opening the Excel file to a workbook.
Apply Password Protection to an Excel File: Overview             When you apply password protection to an Excel file, you prevent people from opening it without knowing the required password. After password protection is enabled on a file, no one can open it without the password. Therefore, password-protecting files poses some risk. This is because if
addaddingapplyApply Password Protection to an Excel Fileapplyingcourseencrypt documentencrypt with passwordexcelexcel 2013Excel 2016Excel 2019Excel for Office 365helphow-toinstructionslearnlessonmicrosoft excelMicrosoft Office 2019Microsoft Office 365Office 2019office 365open passwordoverviewpasswordpassword protectpassword protectionremoveremovingteachtrainingtutorialvideoworkbookworkbooks
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

Change the Chart Type in Excel – Instructions

Wednesday, January 15 2020 by Joseph Brownell
Change the Chart Type in Excel - Instructions: A picture of a user changing the chart type of a selected chart in Excel.
Change the Chart Type in Excel: Overview             After creating a chart, you can change the chart type in Excel. Alternatively, you can also choose a different sub-type of the same general chart type you first selected. Either way, note that if you change the chart type, you may lose custom formatting you have applied
changeChange the Chart Type in Excelchangingchartchart typechart typeschartscourseexcelexcel 2013Excel 2016Excel 2019Excel for Office 365helphow-toinstructionslearnlessonMicrosoft Office 2019Microsoft Office 365Office 2019office 365overviewteachtrainingtutorialvideoworkbooksworksheetworksheets
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

Add Excel Tables to a Data Model in Excel 2019- Instructions

Tuesday, November 26 2019 by Joseph Brownell
Add Excel Tables to a Data Model in Excel 2019- Instructions: A picture of the “Import Data” dialog box in Excel, which lets users add tables to a workbook’s data model.
Add Excel Tables to a Data Model in Excel 2019: Overview             You can manually add Excel tables to a data model in Excel 2019 or Excel for Office 365 workbooks. You can then use them as the data source for PivotTables and PivotCharts. However, note that this process changed from earlier versions of Excel.
addAdd Excel Tables to a Data ModelAdd Excel Tables to a Data Model in Excel 2019classconnectionscoursedata modelexcelExcel 2019Excel for Office 365helphow-toinstructionslearnlessonmicrosoft excelMicrosoft Office 2019Microsoft Office 365Office 2019office 365overviewpivot chartpivot tablepivotchartpivottablesself studytabletablesteachtrainingtutorialvideoworkbookworkbooks
Read more
  • Published in Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2019, Office 365
No Comments

AutoSave in Excel for Office 365 – Instructions

Wednesday, November 20 2019 by Joseph Brownell
AutoSave in Excel for Office 365 - Instructions: A picture of the “Version History” panel you can use to revert changes made to a file with AutoSave enabled in Excel for Office 365.
AutoSave in Excel for Office 365: Overview AutoSave in Excel for Office 365: How to Enable AutoSave in Excel for Office 365             This tutorial shows you how to use AutoSave in Excel for Office 365. AutoSave in Excel for Office 365 is automatically enabled when you save a workbook using the newest file formats
AutoSave in ExcelAutoSave in Excel for Office 365coursedisableenableexcelExcel for Office 365helpHow to Disable AutoSave in Excel for Office 365How to Enable AutoSave in Excel for Office 365How to Manually Save Changes in AutoSave in Excel for Office 365How to Save a Copy in AutoSave in Excel for Office 365How to Undo Changes and Revert to a Previous Save State in AutoSave in Excel for Office 365how-toinstructionslearnlessonMicrosoft Office 365office 365overviewrevertteachtrainingtutorialUndoversion historyversionsvideoworkbookworkbooks
Read more
  • Published in Excel for Office 365, Latest, Microsoft, Office 365
No Comments
  • 1
  • 2
  • 3

 

Recent Posts

  • A picture showing how to select text in Photoshop Elements within a bounding box in a type layer.

    Select Text in Photoshop Elements- Instructions

    Overview of How to Select Text in Photoshop Ele...
  • A picture showing how to change item prices in QuickBooks Desktop Pro by using the “Change Item Prices” window.

    Change Item Prices in QuickBooks Desktop Pro – Instructions

    Overview of How to Change Item Prices in QuickB...
  • 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...

Categories

Archives

  • GET SOCIAL

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

TOP
Sale! $49 All-Access 0 Days 5 Hours 20 Minutes 3 Seconds      $199 $49 Entire Library!
See Deal