Custom Regions in 3D Maps in Excel – Instructions

Custom Regions in 3D Maps in Excel - Instructions: A picture of the “Import Custom Region Set” dialog box in the 3D Maps window in Excel.
Custom Regions in 3D Maps in Excel: Overview Custom Regions in 3D Maps in Excel: Importing Custom Regions             You can import your own custom regions in 3D Maps in Excel, if needed. Custom regions in 3D Maps in Excel are defined geospatial regions saved as either “kml” or “shp” files. You often create these
Read more
No Comments

Create a 3D Map in Excel – Instructions

Create a 3D Map in Excel - Instructions: A picture of a user creating a new 3D Maps tour in Excel.
Create a 3D Map in Excel: Overview Create a 3D Map in Excel: Creating a New Tour             After enabling the 3D Maps add-in in Excel, you can then create a 3D Map in Excel. To create a 3D Map in Excel, click the “Insert” tab in the Ribbon. Then directly click the “3D Maps”
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

Data Visualizations in Power View in Excel – Instructions

Data Visualizations in Power View in Excel - Instructions: A picture of the “Design” tab within Power View in Excel.
Data Visualizations in Power View in Excel: Overview             You can visualize report data in a Power View worksheet by adding data visualizations in Power View in Excel. To add data visualizations in Power View in Excel, drag a data field from the “Power View Field” task pane into the “Fields” section of the task
Read more
No Comments

Use the Field List in Access – Instructions

Use the Field List in Access - Instructions: A picture of the Field List in Access.
Use the Field List in Access: Overview             You can use the Field List in Access to easily add data fields to a data entry form. Most forms are connected to an underlying table or query from which they display and/or update the table data. In form design view, you can access the list of
Read more
No Comments

The Field List in Report Charts in Project – Tutorial

The Field List in Report Charts in Project - Tutorial: A picture of a selected report chart in Project 2013 showing the Field List pane.
The Field List in Report Charts in Project: Overview             You can use the Field List in report charts in Project to change the data shown in the chart. The Field List in report charts in Project appears in a pane at the right side of the application window. Here you can modify the fields
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: Overview             When creating tables in SQL, you will need to deal with NULL values in SQL. A NULL value is a value that is unknown. These values can occur within database tables when a user who is performing data entry skips entering a value into a field. When a value
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: Overview             You can set the Format property for Yes/No fields in Access to change the way that they will display in forms and reports. The following formats are available for logical fields in Access. To set the Format property for Yes/No fields in Access, simply select
Read more
No Comments