data extraction

Unlocking the Power of the FILTER Function in Excel

Unlocking the Power of the FILTER Function in Excel

Learn how to use Excel's powerful FILTER function to dynamically extract specific data based on multiple conditions, perfect for creating responsive dashboards and reports.

Q&A with Erik van Hurck: Recent Additions to Microsoft Planner and What They Can Do for You

Q&A with Erik van Hurck: Recent Additions to Microsoft Planner and What They Can Do for You

Join Microsoft MVP Erik van Hurck for a live Q&A session exploring the latest Microsoft Planner features and how they can enhance your project management workflow.

Beyond ProjectData: Unlocking Local Custom Fields in Project Online with ProjectServer API

Beyond ProjectData: Unlocking Local Custom Fields in Project Online with ProjectServer API

Master extracting local custom fields from Project Online using ProjectServer API to enhance your project reporting capabilities.

Beginner’s Guide: Extracting Project Online Data into Power BI & Excel with Power Query

Beginner’s Guide: Extracting Project Online Data into Power BI & Excel with Power Query

This comprehensive guide teaches you how to extract, transform, and analyze Microsoft Project Online data using Power Query in Excel or Power BI for improved project reporting and visualization.