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 👇
  • Title
  • Title
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

  • Copie d'écran de bord d'un tableau de bord de Logiciel excel de suivi et de calcul du TRS

    J8/ Model — Calculation and monitoring of OEE Excel 2025 - Industry 4.0 - 1k Users

    Sale

    J8/ Model — Calculation and monitoring of OEE Excel 2025 ...

    From €159,00
    €279,00 From €159,00
    Sale
  • Copie d'écran d'un modèle excel de gestion de projet - suivi de budget et de livrables

    J9/ Budget and Deliverables Tracking Template for Business

    Sale

    J9/ Budget and Deliverables Tracking Template for Business

    From €59,00
    €249,00 From €59,00
    Sale
  • Project management report displaying Gantt chart, S-curve, and resource allocation graphs on a laptop screen.

    J28/ Power Bi Project Management Template to download

    J28/ Power Bi Project Management Template to download

    From €0,00
    From €0,00
  • MS Project template showcasing a ready-to-use Gantt chart for effective task tracking and advanced project formatting.

    J27/ MS Project Gantt Planning Template to download

    J27/ MS Project Gantt Planning Template to download

    From €69,00
    From €69,00
  • Aperçu d'un tableau de bord interactif en Excel pour la gestion de projet avec indicateurs clés de performance.

    J10/ Project Management Excel Model for project managers

    Sale

    J10/ Project Management Excel Model for project managers

    From €49,00
    €219,00 From €49,00
    Sale
  • FMEA dashboard displaying risk analysis, criticality assessment, and corrective action tracking on a laptop screen.

    J30/ Power BI Model - Risk Analysis (Amdec)

    J30/ Power BI Model - Risk Analysis (Amdec)

    From €0,00
    From €0,00
  • Exemple AMDEC Processus Excel - Tableau de bord

    J7/ Model — Example FMEA Excel Process - Dashboard - RPN Monitoring

    J7/ Model — Example FMEA Excel Process - Dashboard - RPN ...

    From €59,00
    From €59,00
  • Livre blanc sur l'industrie du futur : De la vision à l’action : l'avenir de l’industrie - Digital factory

    C1/ ebook: White Paper - From vision to action, the future of industry

    C1/ ebook: White Paper - From vision to action, the futur...

    €39,00
    €39,00
  • A2/ Modèle - Tableau de Bord Production - Suivi TRS Excel - Google Sheet - Digital Factory

    A2/ Advanced OEE Excel Template - Powerful Manufacturing Dashboard

    A2/ Advanced OEE Excel Template - Powerful Manufacturing ...

    From €99,00
    €99,00 From €99,00
  • A1/ Modèle simplifié — Suivi budgétaires excel — Google Sheet - Tableau de bord de suivi de KPI principaux de budget et de livrables projets

    A1/ Template - Budget and project deliverables tracking - Google Sheet

    Sale

    A1/ Template - Budget and project deliverables tracking -...

    From €29,00
    €59,00 From €29,00
    Sale
  • Modèle d'analyse de risques projet Excel - Google Sheet - Tableau de bord inclus pour suivre les niveau des risques avant les mesures et après - Digital factory

    A9/ Model - Project Risk Analysis - Google Sheet/Excel

    Sale

    A9/ Model - Project Risk Analysis - Google Sheet/Excel

    €39,00
    €149,00 €39,00
    Sale
  • Tableau de bord de suivi d'AMDEC Processus Excel - Pro - Digital factory

    A3/ Model - Process FMEA - Google Sheet/Excel - Pro

    Sale

    A3/ Model - Process FMEA - Google Sheet/Excel - Pro

    From €29,00
    €59,00 From €29,00
    Sale
  • Tableau de bord gestion de projet Excel - Google Sheet - Digital factory

    A5/ Model - Dasboard KPI Planning MS Project - Excel - Google Sheet

    A5/ Model - Dasboard KPI Planning MS Project - Excel - Go...

    From €49,00
    From €49,00
  • A5/ Modèle — AMDEC Excel — Google Sheet - Basic - Gratuit - Digital factory

    A5/ Excel FMEA Template - Google Sheet/Excel - Basic

    A5/ Excel FMEA Template - Google Sheet/Excel - Basic

    €0,00
    €0,00
  • C2/ Model — OEE Dashboard - Production Tracking - Excel Template

    C2/ Model — OEE Dashboard - Production Tracking - Excel Template

    Sale

    C2/ Model — OEE Dashboard - Production Tracking - Excel T...

    From €49,00
    €99,00 From €49,00
    Sale
  • A6/ Modèle du tableau de bord — Analyse de risques machine — Google Sheet/Excel - Digital factory

    A6/ Template — Machine risk analysis — Google Sheet/Excel

    A6/ Template — Machine risk analysis — Google Sheet/Excel

    €499,00
    €499,00
  • A8/ Modèle — Notice de maintenance — document Word - Digital factory

    A8/ Model — Maintenance instructions - Example User Manual - Doc

    A8/ Model — Maintenance instructions - Example User Manua...

    From €39,00
    From €39,00
  • tableau comparatif des offres fournisseurs excel

    A4/ Model — Suppliers assessment — Google Sheet/Excel

    Sale

    A4/ Model — Suppliers assessment — Google Sheet/Excel

    From €9,00
    €29,00 From €9,00
    Sale
  • Fichier de Suivi de Production Excel Gratuit : Exemple de Calcul TRS

    J6/ Model — Free Excel Production Monitoring File: Example of OEE Calculation

    J6/ Model — Free Excel Production Monitoring File: Exampl...

    €0,00
    €0,00
  • Guide complet sur le TRS avec décryptage des calculs, avantages et méthodologie d'implémentation sur un ordinateur portable.

    J11/ PDF — TRS - Definition, calculation, benefits and implementation

    J11/ PDF — TRS - Definition, calculation, benefits and im...

    €0,00
    €0,00
  • Industrie 5.0 : Définition, technologie, avantages et défis - PDF

    J12/ PDF — Industry 5.0: Definition, technology, advantages and challenges

    J12/ PDF — Industry 5.0: Definition, technology, advantag...

    €0,00
    €0,00
  • Modèle Excel de Gestion de Maintenance affiché sur un ordinateur portable pour la planification, suivi et analyse de coûts.

    J13/ Maintenance Management Excel Model (CMMS)

    J13/ Maintenance Management Excel Model (CMMS)

    From €99,00
    From €99,00
  • OEE monitoring report on a laptop displaying real-time performance tracking for multiple machines' efficiency.

    J29/ Power BI Model - TRS (Overall Earnings Ratio) Monitoring

    J29/ Power BI Model - TRS (Overall Earnings Ratio) Monito...

    From €0,00
    From €0,00
  • Audit 5S : outil Excel pour améliorer l'organisation / 5S audit: Excel tool for improving organization

    J14/ 5S Excel Model: Checklist, Audit and Control for Industry

    J14/ 5S Excel Model: Checklist, Audit and Control for Ind...

    €0,00
    €0,00
  • Modèle DMAIC Excel pour projets Lean Six Sigma / DMAIC Excel template for Lean Six Sigma projects

    J15/ Advanced DMAIC Model for your Lean Six Sigma Projects - Free Download

    J15/ Advanced DMAIC Model for your Lean Six Sigma Project...

    €0,00
    €0,00
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
  • Comment réduire les coûts administratifs d’une entreprise ? - Digital factory

    How to reduce the administrative costs of a com...

    Introduction to Business Cost Reduction Reducing business costs is essential to maximizing profitability. Accounting, logistics, human resources: the tasks involved are essential, but also costly and time-consuming. However, it is...

    How to reduce the administrative costs of a com...

    Introduction to Business Cost Reduction Reducing business costs is essential to maximizing profitability. Accounting, logistics, human resources: the tasks involved are essential, but also costly and time-consuming. However, it is...

  • Capture d'écran d'un logiciel Kanban affichant un tableau avec des colonnes et des cartes de tâches organisées par étape.

    Improve your project management with the Kanban...

    Introduction Businesses are facing unprecedented challenges when it comes to project management. Client expectations are rising, deadlines are shrinking, and project complexity is constantly increasing. Faced with these challenges, traditional...

    Improve your project management with the Kanban...

    Introduction Businesses are facing unprecedented challenges when it comes to project management. Client expectations are rising, deadlines are shrinking, and project complexity is constantly increasing. Faced with these challenges, traditional...

  • Image d'un concepteur utilisant d'outils avancé pour booster sa créativité dans la conception de voiture de compétition

    How to boost innovation?

    Introduction Innovation is no longer a simple competitive advantage: in a context marked by the constant evolution of technologies and customer expectations, also with the acceleration towards industry 4.0 ,...

    1 comment

    How to boost innovation?

    Introduction Innovation is no longer a simple competitive advantage: in a context marked by the constant evolution of technologies and customer expectations, also with the acceleration towards industry 4.0 ,...

    1 comment
1 3
View all