Learning the basics of Excel: Starting with tables

Initiating a table in Excel.
Opt for a table style from the collection on the Table tab.
Include a Sum row at the end of the table.
The Sum row has the capability to perform various types of computations.
Arranging column A in an ascending sequence.
We have deselected Lemons and Pears while keeping Apples and Bananas chosen.
The table has been filtered to display only the data for Apples and Bananas.
Choose to Remove Filter to reveal all the data in the table once more.
Establishing two criteria for filtering a table.
Now, only the items with values between 200 and 300 in the Jan column are visible.
Choose AVERAGE and highlight the entire row, then hit Enter.
Excel has computed the average values for all four rows in the table.
Modify the column header to match the data exhibited in the computed column.
Generating a chart using data from the table.
You are able to manually adjust the labels in the legend.
The resultant chart is based on the data from our table.

About Author

AndyC

Andy Curtis is an award-winning security consultant, researcher and public speaker. He has been working in the computer security industry since the early 1990s, having been employed by state and federal government, leading healthcare and banking providers across three continents. He has given talks about computer security for some of the world’s largest companies, worked with law enforcement agencies on investigations into hacking groups, and is a regular voice on TV and radio explaining IT security threats.

See author's posts