17966
  •
  • MS Project : Création des filtres avancés - Tutoriel
1 2

Digital Factory

T4/ MS Project: Creating advanced filters - Tutorial

T4/ MS Project: Creating advanced filters - Tutorial

€19,00
€19,00
Sale Sold out

Paid Tutorial: An access link will be sent to you after purchase.

In this MS Project tutorial you will learn how to create advanced filters.

  • Filter milestones or KPIs that are important to your project

These filters would be useful for your complex projects.

👉 Discover the full training program

To start, let's add a "project name" column to easily identify which project each task belongs to. Right-click on the column header, then click "Insert Column" and type the column name. Then, assign a project name to each task. You can adjust the width of the column for better visibility.

Now, let's create an advanced filter to display only the project milestones. Go to the "View" tab, then click on "Filter" and select "New Filter". In the window that opens, name this filter. Then, add the criteria:

  • Fields: Select the added column or type the column name.
  • Conditions: Select "equal to".
  • Value: Type "project".
  • Select "And"
  • Fields: Select column, task name or type "Name"
  • Conditions: "contains"
  • Value: Type "gate".

With these conditions, this filter will only show the tasks in the project that contain the word "gate". Click "Save" .

To apply this filter, go back to the "View" tab and select the filter you just created . To remove the filter, click the triangle next to "Tasks" in the column header and choose "Clear Filter".

Now let's add a "category" column to categorize our milestones. Right-click on the column header, then click "Insert Column" and select "Category". Assign categories to the milestones, for example, development, design, etc.

Finally, let's create a filter to display only milestones in the development category. Go to the "View" tab, then click on "Filter", choose "New filters" . In the window that opens, name this filter. Then, add the following criteria:

  • Fields: "Category", conditions: "equal to", value: "development".
  • Fields: "Name", conditions: "equal to", value: "gate".

Click "Save" and apply the filter . Feel free to experiment with other criteria to customize your filters to your needs. Thank you for following this tutorial.


  • Access your product in 30 seconds: steps 👇
View full details

FAQs

How will I receive links to the videos?

Links to the videos will be sent to the email address you used to place your order. Be sure to check your inbox and spam folder.

Will I have unlimited access to videos?

Yes, you will have unlimited access to videos for life. You can watch them as many times as necessary to fully assimilate the content.

Are the videos downloadable?

No, the videos are not downloadable. They are only accessible online via the links provided after ordering.

Can I share video links with others?

No, video links are strictly personal and should not be shared. They are intended solely for the use of the buyer.

Is there support available if I have questions about the content of the videos?

Yes, if you have any questions about the content of the videos, you can contact us at [hello@digitalfactory.store]. We would be delighted to help you.

Subscription offers

Subscription - Access to Excel, Power BI and Ms project tutorials and models

Corporate Pack

€369.00 / single payment
  • No renewal constraints
  • Full access to all tutorials:
  • MS Project: Planning, Resources
  • Power BI: Data Preparation, Dashboards
  • Power Automate: Workflow Automation
  • Full access to all models:
  • Project management, Operational efficiency, Lean,...
  • Premium Dashboards Included
  • Unlimited downloads
  • Personal space included
  • 30 minute support included
Subscribe

Monthly Subscription

€39.90 /month
  • Full access to all tutorials:
  • MS Project: Planning, Resources
  • Power BI: Data Preparation, Dashboards
  • Power Automate: Workflow Automation
  • Full access to all models:
  • Project management, Operational efficiency, Lean,...
  • Premium Dashboards Included
  • Unlimited downloads
  • Personal space included
  • 30 minute support included
Subscribe

Annual Subscription

€299.00 /year
  • All the advantages of the monthly
  • Save 36% compared to monthly
  • Priority consultation with an expert
  • Updates and new models every week
Subscribe

Free

0 €
  •  Access to free models
  • Access to free tutorials
  • News and Updates
Subscribe

Recommendations

1 25
View all

Any questions?


Digital Factory Expert on the phone with a client, our experts are available to answer prospects' questions at any time
Make an appointment with an expert via Google Calendar Appointment
Or
Write to Us

Contact form

blog posts

View all
1 3
View all