News:

Skill.jobs Forum is an open platform (a board of discussions) where all sorts of knowledge-based news, topics, articles on Career, Job Industry, employment and Entrepreneurship skills enhancement related issues for all groups of individual/people such as learners, students, jobseekers, employers, recruiters, self-employed professionals and for business-forum/professional-associations.  It intents of empowering people with SKILLS for creating opportunities, which ultimately pursue the motto of Skill.jobs 'Be Skilled, Get Hired'

Acceptable and Appropriate topics would be posted by the Moderator of Skill.jobs Forum.

Main Menu

Quick Filtering Using Tables

Started by Monirul Islam, July 23, 2018, 01:43:25 PM

Previous topic - Next topic

Monirul Islam

Sorting and filtering are two of the most commonly used commands. The Format as Table option allows you to speed up your sorting and filtering. You can also  select multiple filters, sort or filter by colour.

Select the data to be used in your Table
Click on Format as Table
Select your Format Style
You will have a Live Preview of the Formatting options
Excel automatically adds Drop down options to the first row of your Table
You can Filter from the Drop downs



Extra Features

Click on the Table
The Table Tools appears above the Ribbon
Click  on  Total Row
A Total Row is added to your table
Click in the cell containing the Total data
A Drop down appears
You can now select many of the functions used to  Analyse Data such as Average, Max, Min etc


When you have competed your analysis you may want to convert your table into a Range and remove the Drop downs.

To Convert your Table to a Range

Click on the Table
The Table Tools appears above the Ribbon
Click on Convert to Range 

Source: Really Useful