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 DC
      • Lightroom Classic CC 2018
      • Photoshop 2021
      • Photoshop 2020
      • Photoshop CC 2018
      • 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

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

Format a PivotTable in Excel – Instructions and Video

Monday, November 04 2019 by Joseph Brownell
Format a PivotTable in Excel: A picture showing the “Design” tab of the “PivotTable Tools” contextual tab in the Ribbon of Excel.
Format a PivotTable in Excel: Overview             You can apply preset styles to format a PivotTable in Excel. To format a PivotTable in Excel, click into any cell in the PivotTable. Then click the “Design” tab of the “PivotTable Tools” contextual tab within the Ribbon. Then click the desired style to apply from the listing
bandingchangecolumnscourseexcel 2013Excel 2016Excel 2019formatFormat a PivotTableFormat a PivotTable in ExcelFormat a PivotTable in Excel 2013formattingFormatting PivotTableshelphow-toinstructionslayoutlearnlessonMicrosoft Office 2019Microsoft Office 365modifyOffice 2019office 365optionsoverviewpivottablepivottablesrowssettingsstylestylessummaryteachtrainingtutorialvideo
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 a KPI in Power Pivot for Excel – Instructions

Friday, October 11 2019 by Joseph Brownell
Create a KPI in Power Pivot for Excel - Instructions: A picture of the “Key Performance Indicator (KPI)” dialog box in Power Pivot for Excel.
Create a KPI in Power Pivot for Excel: Overview             Creating measures within the data model in Power Pivot then lets you create a KPI in Power Pivot for Excel. KPI stands for Key Performance Indicator. A KPI is a value, and often associated symbol, that gauges the performance of a base field in attaining
addcoursecreateCreate a KPI in Power Pivot for Excelexcelexcel 2013Excel 2016Excel 2019goalhelphow-toinsertinstructionsKPIKPIslearnlessonmakemeasuremeasuresmicrosoft excelMicrosoft Office 2019Microsoft Office 365Office 2019office 365overviewpivot tablepivot tablespivottablepivottablesPower Pivotpowerpivotself studystatusteachtrainingtutorialvaluevideo
Read more
  • Published in Excel 2016, Excel 2019, Excel for Office 365, Latest, Microsoft, Office 2016, Office 2019, Office 365
No Comments

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

Thursday, May 04 2017 by Joseph Brownell
Add Excel Tables to a Data Model in Excel 2016- Instructions: A picture of the “Workbook Connections” dialog box in Excel, showing references to Excel tables in the data model.
Add Excel Tables to a Data Model in Excel 2016: Overview             You can manually add Excel tables to a data model in Excel 2016 or earlier workbooks. You can then use them as the data source for PivotTables and PivotCharts. Note that this process has changed in Excel 2019 and Excel for Office 365.
addAdd Excel Tables to a Data ModelAdd Excel Tables to a Data Model in Excel 2016classconnectionscoursedata modelexcelexcel 2013Excel 2016helphow-toinstructionslearnlessonmicrosoft exceloverviewpivot chartpivot tablepivotchartpivottablesself studytabletablesteachtrainingtutorialvideoworkbookworkbooks
Read more
  • Published in Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016
No Comments

Using PowerPivot in Microsoft Excel 2013

Tuesday, March 25 2014 by Keeley Byrnes
For the complete course click here.             Starting PowerPivot PowerPivot is an add-in that is included in Microsoft Excel Professional Plus 2013. It was also available in Excel 2010, but has seen many improvements to its functionality in the 2013 version. PowerPivot is not available in Excel 2007. PowerPivot essentially
classclassescoursecreatedownloaddvdexcelexcel 2010excel 2013helphow to use pivottablehow-tom icrosoft officemanualmicrosoftmicrosoft excelms officepivottablespowerpivotsoftwaretrainingtutorialvba
Read more
  • Published in Excel 2013, Latest
No Comments

 

Recent Posts

  • Create Other Charge Items in QuickBooks Desktop Pro- Instructions: A picture of a user creating an Other Charge item in QuickBooks Desktop Pro.

    Create Other Charge Items in QuickBooks Desktop Pro- Instructions

    Create Other Charge Items in QuickBooks Desktop...
  • Bounced Checks in QuickBooks Desktop Pro- Instructions: A picture of the “Manage Bounced Check” window in QuickBooks Desktop Pro.

    Bounced Checks in QuickBooks Desktop Pro – Instructions

    Bounced Checks in QuickBooks Desktop Pro: Overv...
  • A picture that shows how to create moving elements in Photoshop Elements.

    Moving Elements in Photoshop Elements – Instructions

    Overview of How to Create Moving Elements in Ph...

Categories

Archives

  • GET SOCIAL

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

TOP
Sale! $49 All-Access 0 Days 14 Hours 46 Minutes 24 Seconds      $199 $49 Entire Library!
See Deal