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

Merge and Split Table Cells in Publisher- Instructions

Merge and Split Table Cells in Publisher- Instructions: A picture of a user merging multiple table cells in Publisher.
Merge and Split Table Cells in Publisher: Overview             After adding a table to a publication, you can merge and split table cells in Publisher to control its layout. You can merge multiple selected cells together into one larger cell. You can also split a single, selected cell into multiple, smaller cells. This is often
Read more
No Comments

Sort a Table in Word – Instructions and Video Lesson

Sort a Table in Word - Instructions: A picture of a user sorting a table in Word.
Sort a Table in Word: Overview             You can sort a table in Word that is used for storing and organizing data. It is possible to sort a table in Word by one or more columns of data in the table. You can sort a table in Word both alphabetically or numerically. You can also
Read more
No Comments

Add Excel Tables to a Data Model- Instructions

Add Excel Tables to a Data Model- 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: Overview             You can manually add Excel tables to a data model within a workbook. You can then use them as the data source for PivotTables, PivotCharts and Power View reports. Before doing this, however, first create the necessary tables within Excel. Also, to add Excel tables to
Read more
No Comments