Office 365 Microsoft Excel for Faculty/Staff
You can create and format a table, to visually group and analyze data.
Select a cell within your data.
Select Home > Format as Table.
C...
Fri, 25 Jan, 2019 12:07 PM
Sorting is one of the most common tools for data management. In Excel, you can sort your table by one or more columns, by ascending or descending order, or ...
Fri, 25 Jan, 2019 12:22 PM
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you fi...
Fri, 25 Jan, 2019 12:22 PM
You can quickly total data in an Excel table by enabling the Total Row option, and then use one of several functions that are provided in a drop-down list f...
Fri, 25 Jan, 2019 12:23 PM
Convert data into table
In order to use a slicer, you must convert your data into a table first.
There are four ways to convert data into a table:...
Fri, 25 Jan, 2019 12:24 PM
Create a chart
Select data for the chart.
Select Insert > Recommended Charts.
Select a chart on the Recommended Charts tab, to previe...
Fri, 25 Jan, 2019 12:26 PM
Add a chart title
In the chart, select the "Chart Title" box and type in a title.
Select the plus sign.
Select the arrow next ...
Fri, 25 Jan, 2019 12:26 PM
When you create a chart, the legend appears by default, but you can hide the legend or change its location after you create the chart.
You can also show a...
Fri, 25 Jan, 2019 12:27 PM
When the numbers in a chart vary widely from data series to data series, or when you have mixed types of data (price and volume), plot one or more data seri...
Fri, 25 Jan, 2019 12:28 PM
Add a Trendline
Select a chart.
Select the + to the top right of the chart.
Select Trendline.
Format a trendline
In the Fo...
Fri, 25 Jan, 2019 12:30 PM