USD - Using and Sharing Data Overview

Using and Sharing Data Overview

Why are research skills important for business? Research skills can be described as an ability to locate, evaluate, analyze, and report information and data on a given topic.

Businesses and organizations heavily invest in market research because it is a critical component of business strategy, operations, and, ultimately, success of any business or organization. Every year, companies spend billions of dollars on market research.

For example, your bakery is doing great and you would like to open another location. However, it would be wise to research the area, potential customers, competitors, market trends, and other factors prior to investing in a new location. Otherwise, your business may fail at that location.

In this module, you will learn how to utilize electronic research tools to gather, evaluate, analyze, and report data and information in accepted business formats. You will also learn about copyright laws and consequences of plagiarism.

Click on the video to learn more about this module: 

 

Click "Next" on the carousel below to preview the lessons for this module.

 

  Key Terms-

Clear Rules: Removes conditional formatting from only the selected data or from the entire worksheet.

Conditional Formatting: Used to format cells that meet a certain criterion.

Filter Button: Appears next to each table heading and opens the drop down where you can choose how to sort or filter your data.

Format as Table: Button that converts the selected data into a table and allows you to add table formatting, filters, and total rows to data.

Grand Total: Shows the sum or average of all records in the outline.

HLOOKUP: Horizontal look up, an Excel function to look up and retrieve data from a specific row in a table.

Manage Rules: Allows to edit and reorder existing rules in the worksheet.

New Rule: Allows to create custom conditional formatting rule that meets the specific needs.

Outline: Summary of selected data, organized in columns and rows.

PivotChart: Chart or graph that shows information from the PivotTable.

PivotTable: Summarizes data from a more extensive table and may include sums, averages, and other statistics chosen by the user.

Slicer: A data filter with convenient buttons that filters pivot table data.

Subtotal: Shows the sum or average of all data belonging to their own outline level.

VLOOKUP: Vertical look up, an Excel function to look up and retrieve data from a specific column in a table.

 IMAGES CREATED BY GAVS