• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Office / Use Filters to Analyse Project Data

Use Filters to Analyse Project Data

Microsoft Project has two ways of filtering its’ tables. There is the AutoFilter, similar to what you would see in Excel, and there is the in-built filters.

Filtering allows you to perform some simple analysis of your project data. It can be used to find which tasks begin this week, which tasks have slipped, or the most expensive tasks.

Using the AutoFilter

The AutoFilter tool allows you to filter using the data in the table. Because Project provides so different tables to view different information about your project. This method of filtering provides a high level of flexibility as it works with the data you are working with.

You can also insert and hide columns to get the information you need in the table to use for your filters.

  1. Click the AutoFilter button on the Formatting toolbar
Using the AutoFilter in Project
  1. Click the required filter arrow on the column heading that you wish to filter. The image below shows the Predecessors column being used to find all tasks that are dependent upon a specific task
Filtering by the Predecessors column
  1. The column being used for the filter is shown with blue text to make it easy to identify
Blue text of an applied filter

Using the In-built Filter Tool

The Filter tool that comes with Microsoft Project provides predetermined filters to cater for all the common filtering requirements.

Click the Filter list arrow on the Formatting toolbar

Using the in-built Project filters

Select the Filter you want to use

The filter will be performed. It may require further input from you. The image below shows the Using Resource filter prompting me to select the required resource from a list

Using resource filter in MS Project

The filtering tools in Microsoft project allow you to perform some simple analysis of project information. For further analysis, you could export the project data into Excel. This would enable you to perform much more powerful analysis of your project data.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • Excel SWITCH Function – Nested IF Function Alternative
  • Sum Formulas Only in Excel
  • How to Calculate Age in Excel
  • Custom Sort in Excel
  • Case Sensitive Lookup with XLOOKUP in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

LinkedIn Twitter YouTube

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Blog
  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2009 Computergaga · All Rights Reserved ·