Filtering Data Using Microsoft Excel


We can use Microsoft Excel when dealing with long lists. There are several techniques you can use to achieve this. One is to Go to the Data Tab and Select the Filter button the Second option is to activate from the Home tab and Select Filter. Whilst the Filter tool is useful and will show you only the data that you are interested in. It also has the sort feature built into it under the Drop-down arrows.

This however will not turn on the Freeze Pane, add colour to every second row, turn on total row allow you to quickly and easily add a range name to the table. Try using Format as Table feature found under the Home tab next to Conditional Formatting. It’s great with Pivot tables if your data is continuously being added to. Visit my blog on ” Format As Table Feature In Excel

Pivot Table in Microsoft Excel are use when working with large lists of data. If you find yourself needing to summarize and product financial reports, try Pivot Tables. They are not as complicated as they first look. Visit my blog on “How To Create A Simple Pivot Table In Excel“. If you have over 100 columns of data try creating a Vlookup to represent five or 10 columns of data that you will be refining by then create your Pivot Table from this. If your lookup value is located in the middle of set of data try using two functions the Index function with two match functions for the Row and Column inputs.

To make it easier to follow your functions you might like to create Range Name. Names that represent a range of cells then use that name in your function. Like the Table components of the Vlookup Function.

Microsoft Office Small Group Training Sessions

AZ Solutions Pty Ltd delivers customized training courses here in Sydney – Australia. We come to you. All you need is a board room, PC’s for each student and a TV/ Projector with a HDMI connection cable. In our training sessions you are welcomed to bring examples of your work to class. We prefer it.

Call Now M 0414 417 059 visit www.azsolutions.com.au

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
This entry was posted in Excel and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s