TeachUcomp, Inc.

P: 877-925-8080

  • HOME
  • COURSES
    • Course List
    • For Lawyers
    • My Courses
    • Online Learning
      • Member Login
      • Online Learning FAQ
      • Subscribe
    • Training Options
  • FOR BUSINESS
    • Business Licensing
    • Request a Quote
  • MANUALS
  • REFERENCE CARDS
    • Adobe
      • Acrobat DC
      • Lightroom Classic CC 2018
      • Photoshop 2020
      • Photoshop CC 2018
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
    • Microsoft Office
      • Microsoft Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • OneNote for Windows 10
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Word for Office 365
      • 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 Pro
      • 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
    • Windows
      • Windows 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
  • MEMBER LOGIN
    • Manage My Account
    • Member Login
    • My Courses
  • MY CART
Shop Now

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

Record a Macro in Excel – Instructions and Video Lesson

Friday, January 24 2020 by Joseph Brownell
Record a Macro in Excel - Instructions and Video Lesson: A picture of the “Record Macro” dialog box in Excel.
Record a Macro in Excel: Overview              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, it repeats your
courseexcelexcel 2013Excel 2016Excel 2019Excel for Office 365helphow-toinstructionslearnlessonmacromacrosMicrosoft Office 2019Microsoft Office 365Office 2019office 365overviewrecordRecord a Macro in Excelrecording macrosself studyteachtrainingtutorialvideoworkbookworkbooks
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

Split Panes in Excel – Instructions and Video Lesson

Thursday, January 16 2020 by Joseph Brownell
Split Panes in Excel - Instructions and Video Lesson: A picture of a large Excel workbook that is horizontally split into two separate panes.
Split Panes in Excel: Overview             To split panes in Excel when viewing a large worksheet, use the “Split” command in Excel. This command lets you split the Excel worksheet into different panes. Each pane contains its own horizontal and vertical scroll bars. Therefore, you can scroll each pane separately to view information from different
courseexcelexcel 2013Excel 2016Excel 2019Excel for Office 365helphow-toinstructionslearnlessonMicrosoft Office 2019Microsoft Office 365Office 2019office 365overviewself studysplitSplit Panes in Excelsplit workbookssplit worksheetsteachtrainingtutorialvideoworkbookworksheet
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

Set Margins in Excel – Instructions

Friday, November 22 2019 by Joseph Brownell
Set Margins in Excel - Instructions: A picture of the “Margins” tab within the “Page Setup” dialog box in Excel.
Set Margins in Excel: Overview             To set margins in Excel worksheets before printing, open the “Page Setup” dialog box. To open the “Page Setup” dialog box, click the “Page Layout” tab in the Ribbon. Then click the “Page Setup” dialog box button in the lower-right corner of the “Page Setup” button group. Then click
applychangecourseeditexcelExcel 2019helphow-toinstructionslearnlessonmarginmarginsMicrosoft Office 2019Microsoft Office 365Office 2019office 365overviewpage setupprintprintingself studysetSet Margins in Excelteachtrainingtutorialvideoworkbookworksheetworksheets
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

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

Compare Workbooks in Excel – Instructions

Monday, November 18 2019 by Joseph Brownell
Compare Workbooks in Excel - Instructions: A picture of a user comparing two workbooks in Excel side by side.
Compare Workbooks in Excel: Overview             This lesson shows you how to compare workbooks in Excel. To compare workbooks in Excel, first open the workbooks to compare to each other. To then compare them side by side, with each workbook taking an equal portion of the screen, click the “View” tab in the Ribbon. Then
comparecompare documents in excelCompare Workbooks in Excelcomparingcoursedisableenableexcelexcel 2013Excel 2016Excel 2019helphow-toinstructionslearnlessonMicrosoft Office 2019Microsoft Office 365Office 2019office 365overviewSynchronous Scrollingteachtrainingtutorialvideoview side by sidewindowWindowsworkbookworkbooks
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

Trace Error in Excel – Instructions and Video Lesson

Tuesday, November 12 2019 by Joseph Brownell
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: Overview             Trace Error in Excel lets you trace arrows back to cells referenced by a formula if it displays an error. The Trace Error tool is available when auditing a worksheet within a workbook. Note that the formula cell that you select must contain an error to use the Trace Error
audtingcourseexcelexcel 2013Excel 2016Excel 2019formulaformulashelphow-toinstructionslearnlessonmicrosoft excelMicrosoft Office 2019Microsoft Office 365Office 2019office 365overviewteachtrace errorTrace Error in ExcelTrace Error in Excel 2013trainingtutorialvideoworkbookworkbooksworksheetworksheets
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
  • 1
  • 2
  • 3

Recent Posts

  • Buy Photoshop Elements 2021 Training: A picture of the Mastering Photoshop Elements Made Easy v.2021 digital download and/or DVD training interface.

    Buy Photoshop Elements 2021 Training

    New Photoshop Elements 2021 Training Now Availa...
  • Create Group Items in QuickBooks Desktop Pro - Instructions: A picture of a user adding items to a Group item in QuickBooks Desktop Pro.

    Create Group Items in QuickBooks Desktop Pro – Instructions

    Create Group Items in QuickBooks Desktop Pro: O...
  • @Mentions in Microsoft Teams: A picture showing someone selecting a suggested @mention in a post in Microsoft Teams.

    @Mentions in Microsoft Teams

    Overview You can send a co-worker or an entire ...

Categories

Archives

  • GET SOCIAL

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

TOP
Flash Sale! $49 All-Access 1 Days 7 Hours 43 Minutes 41 Seconds      $199 $49 Entire Library!
See Deal