Microsoft Excel Cheat Sheet

Microsoft Excel Cheat Sheets Now Available             TeachUcomp, Inc. is pleased to announce our Microsoft Excel cheat sheet, titled “Excel 2021 & 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
Read more
No Comments

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

A picture of the “Add/Edit Multiple List Entries” window that lets you copy and paste list data from Excel into QuickBooks Pro.
Overview of How to Copy and Paste List Data from Excel into QuickBooks Pro:             A feature that improves the speed of company file creation is the ability to copy and paste list data from Excel into QuickBooks Pro. You can copy and paste list data from Excel into QuickBooks Pro to add it into
Read more
No Comments

Accept or Reject Changes to a Shared Workbook in Excel – Instructions

A picture showing how to accept or reject changes to a shared workbook in Excel if using the traditional “Shared Workbooks” feature.
Overview of How to Accept or Reject Changes to a Shared Workbook in Excel             If using the traditional “Shared Workbooks” feature in Excel, you can then either accept or reject changes to a shared workbook in Excel after highlighting the changes made. To accept or reject changes to a shared workbook in Excel, click
Read more
No Comments

Insert an Excel Worksheet into a Word Document – Instructions

Insert an Excel Worksheet into a Word Document - Instructions: A picture of a user inserting an Excel spreadsheet into a Word document.
Insert an Excel Worksheet into a Word Document: Overview How to Insert an Excel Worksheet into a Word Document             You can easily insert an Excel worksheet into a Word document to harness the power of Excel within Word. This helps Word users who like creating worksheets and performing calculations in Microsoft Excel. To insert
Read more
No Comments

Apply Password Protection to an Excel File – Instructions

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
Read more
No Comments

Outline Excel Data in Microsoft Excel – Instructions

Outline Excel Data in Microsoft Excel - Instructions: A picture of an Excel worksheet with an outline applied.
Outline Excel Data in Microsoft Excel: Overview             You can outline Excel data to add an organizational quality to a long or wide worksheet. When you outline Excel data, you group worksheet data into different levels based on column and row headings. Lower level data is associated with the headings in the rows or columns.
Read more
No Comments

Format Error Bars in Charts in Excel- Instructions

Format Error Bars in Charts in Excel - Instructions: A picture of the “Format Error Bars” task pane in Excel.
Format Error Bars in Charts in Excel: Overview             You can format error bars in charts in Excel if you add them to a chart. To format error bars in charts in Excel, first choose the set of error bars to format. To do this, click the “Format” tab within the “Chart Tools” contextual tab.
Read more
No Comments

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

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.
Read more
No Comments