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: Video Lesson             This video lesson, titled “Sorting Data,” shows you how to sort a table in Excel. This video is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Sort a Table in Excel: Overview             You can sort a table in Excel using any
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: Video             This video lesson, titled “Creating a Data Model from External Relational Data,” shows how to create a data model from external relational data in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2016-2013.” Create a Data
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: Video Lesson             This video lesson, titled “Monitoring Project Costs,” shows you how to view project costs in Microsoft Project. This video lesson is from our complete Microsoft Project training, titled “Mastering Project Made Easy v.2016-2013.” View Project Costs in Microsoft Project: Overview             This lesson shows you how
Read more
No Comments

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

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: Video Lesson             This video lesson, titled “Creating a Data Model from Excel Tables,” shows how to add Excel tables to a data model in Excel 2016 or earlier. This video on how to add Excel tables to a data model in Excel 2016 or
Read more
No Comments

NULL Values in SQL – Tutorial

NULL Values in SQL - Tutorial: A picture of the main bullet points of the lesson on NULL values in SQL.
NULL Values in SQL: Video Lesson             This video lesson, titled “NULL Values in SQL,” discusses handling and finding NULL Values in SQL and shows an example using Microsoft Access. This video lesson is from our introductory SQL course, titled “Mastering Introductory SQL Made Easy v.1.0.” NULL Values in SQL: Overview             When creating tables
Read more
No Comments

The Format Property for Yes/No Fields in Access – Tutorial

The Format Property for Yes/No Fields in Access - Tutorial: A picture of a user setting the
The Format Property for Yes/No Fields in Access: Video Lesson             This video lesson, titled “The Format Property for Logical Fields,” shows you how to set the Format property for Yes/No field in Access. This video lesson is from our complete Access training, titled “Mastering Access Made Easy v.2013-2007.” The Format Property for Yes/No Fields
Read more
No Comments

Report Tables in Project 2013 – Tutorial

Report Tables in Project 2013 – Tutorial: A picture of a report table and its associated Field List pane in Microsoft Project 2013.
Report Tables in Project 2013: Video Lesson             This video lesson, titled “Using Report Tables,” shows you how to use report tables in Project 2013. This video lesson on how to use report tables in Project 2013 is from our complete Microsoft Project training, titled “Mastering Project Made Easy v.2013-2010.” Report Tables in Project 2013:
Read more
No Comments

How to Create Tables in Microsoft Excel 2013

Excel can store information in tables. An Excel table is information stored in a table format and defined as being a table within Excel. When you store information in a table format, you place the different types of information that you want to collect in columns, which are called “fields” in database terminology. Each “field”
Read more
No Comments