Part 4. Digital Tools Explained
4.1 Microsoft Excel
What is Microsoft Excel?
Microsoft Excel is a spreadsheet developed by Microsoft that features calculation, graphing tools, pivot tables, and various formulas and functions called Visual Basic for Applications. Excel can be used to store and organize data and create datasets.
Microsoft Excel performs a range of statistical functions such as carrying out calculations and presenting sums and percentages, which makes these programs ideal for sorting, filtering, and storing data. Formulas are among one of the stand-out features of this spreadsheet programs. Formulas facilitate the data analysis process with many of the popular programs including a wide range of preset functions preventing users from having to type in commands manually. Microsoft Excel files are also sustainable and can be converted and saved in a variety of formats. Among one of them is a comma separated value, or .CSV file, that allows data to be saved in a tabular format.
This chapter offers basic tips for getting started with Microsoft Excel.
Getting Started with Excel
What follows is information on how to perform basic functions in Excel working with “The Black Short Story Dataset – Vol. 1.”
Sort
The “sort” function enables users to order information in one column or multiple columns in ascending or descending order.
To sort on one column, follow these steps:
- Click any cell in a column you want to sort.
- Click on the Data tab in the Sort & Filter group
- ClickAZ to sort in ascending order (or click ZA to sort in descending order).
Filter
Filter your Excel data if you only want to display records that meet certain criteria. To filter data, follow these steps:
- Click any single cell inside a data set.
- Click on the “Data tab,” in the Sort & Filter group
- Click Filter.
- Click the arrow next to “Anthology Type.” Click on “Select All” to clear all the check boxes, and click the check box next to “Short Story Black Collection.” The data will filter to display only the information associated with that category.
- To remove the filter: Click the “clear” button in the Sort & Filter group to remove the filter and the arrows, click Filter.
Charts
A simple Excel chart can say more than a sheet full of numbers.
To create any chart, follow these steps:
- Select the range of data
- Click on the “Insert tab,” in the Charts group
- Click the Line symbol.
To change your chart to a different type, follow these steps:
- Select the chart.
- Click on the “Design tab,” in the Type group,
- Click Change Chart Type.
- Click the type of chart you desire, on the left side.
If you want to switch the horizontal and vertical axis on a chart, follow these steps:
- Select the chart.
- Click On the Design tab, in the Data group
- Click switch Row/Column.
Tables
To insert a table, execute the following steps.
- Click any single cell inside the data set.
- On the Insert tab, in the Tables group, click Table.
- Excel automatically selects the data for you.