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

Use a Top 10 AutoFilter in Excel – Instructions

Use a Top 10 AutoFilter in Excel - Instructions: A picture of the “Top 10 AutoFilter” dialog box in Excel.
Use a Top 10 AutoFilter in Excel: Overview             You can use a Top 10 AutoFilter in Excel to show a specified number of the top or bottom percent or items in a field within the table. When you use a Top 10 AutoFilter in Excel, it defaults to showing the top 10 percent of
Read more
No Comments

Sort a Table in Excel – Instructions and Video Lesson

Sort a Table in Excel - Instructions: A picture of the “Sort” dialog box within Excel for Office 365.
Sort a Table in Excel: Overview             You can sort a table in Excel using any of the fields available. Sorting is one of the main reasons that you create tables in Microsoft Excel. It allows you to easily organize information in the table records. By default, Excel can sort alphabetically or numerically in either
Read more
No Comments

Create Tables in Word – Instructions

Create Tables in Word - Instructions: A picture of a user creating tables in Word by using the grid in the “Table” button’s drop-down menu.
Create Tables in Word: Overview About Creating Tables in Word:             You can create tables in Word for many reasons. It is possible to create tables in Word that manipulate data, like a spreadsheet program. You can also create tables in Word to simply store data. Alternatively, you can use them to help you structure
Read more
No Comments

Insert Table Formulas in Word – Instructions

Insert Table Formulas in Word - Instructions: A picture of the default formula that Word suggests in the
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
Read more
No Comments

Create a Data Model from External Relational Data in Excel – Instructions

Create a Data Model from External Relational Data in Excel - Instructions: A picture of a user selecting the external relational data tables to add to the data model in an Excel workbook by using the “Select Table” dialog box.
Create a Data Model from External Relational Data in Excel: Overview             You can create a data model from external relational data in Excel. Data models in Excel let you store multiple tables of information. They can then be used a data source for PivotTables, PivotCharts, and Power View reports.             The choice to add
Read more
No Comments

Rename a Field in a Table in Access – Instructions and Video Lesson

Rename a Field in a Table in Access - Instructions: A picture of a user renaming a table field in Access.
Rename a Field in a Table in Access: Overview             You can rename a field in a table in Access that you have already created. You should be extremely careful when you do this! This is because any changes you make to field names are not necessarily updated in all the previously created objects. This
Read more
No Comments

View Project Costs in Microsoft Project – Instructions

View Project Costs in Microsoft Project - Instructions: A picture of the “Cost” table within the “Gantt Chart” view of a project file in Project.
View Project Costs in Microsoft Project: Overview             This lesson shows you how to view project costs in Microsoft Project. Monitoring project costs is a very important aspect of many projects. You can see much of the cost data you need to monitor in the “Cost” table of your project file. You can switch the
Read more
No Comments