Mastering the SUMIFS Function in Excel for Smarter Data Analysis
In this installment of our Excel Essentials Series, Microsoft Certified Trainer Allison Gonzalez breaks down one of the most powerful Excel functions—SUMIFS. If you’re looking to take your Excel skills to the next level and perform more advanced data analysis, this tutorial is the perfect starting point. The SUMIFS function in Excel is a powerful… Read More
Build Dynamic Measures in Power BI Service Using Visual Calculations
In this tutorial, Greg Trzeciak from Certlibrary explores a powerful new feature in Power BI—the ability to create measures through visual calculations directly within the Power BI Service. This enhancement empowers users to build and modify calculations without needing to open Power BI Desktop, allowing for faster report development and real-time data insights. Understanding Visual… Read More
Harnessing the Full Potential of Microsoft Copilot: Features, Setup Guide, and Key Updates
In this detailed guide, Devin Knight introduces the newest features of Microsoft Copilot, showcasing how this AI-powered assistant is now accessible to individuals and businesses of any size. Let’s explore the latest enhancements and walk through the steps to activate Copilot in your Microsoft 365 environment. Microsoft has introduced significant updates to its Copilot offerings,… Read More
Microsoft Power BI Named a Leader in 2020 Gartner Magic Quadrant for Analytics and BI Platforms
Microsoft Power BI has once again been recognized as a top-tier solution in the analytics and business intelligence (ABI) space, securing its position as a Leader in the 2020 Gartner Magic Quadrant for BI and Analytics Platforms. This marks the 13th consecutive year that Microsoft has been acknowledged for its innovation, performance, and enterprise-wide impact.… Read More
Build an Employee Directory with PowerApps and Office 365
In this PowerApps tutorial, Brian Knight from Certlibrary walks you through how to build a dynamic employee directory using PowerApps and the Office 365 Users connector. This directory serves as the foundation for a future “shout out” app to recognize employees—a project that began with whiteboarding and mockups in Balsamiq with the HR team. This… Read More
Mastering the USERELATIONSHIP DAX Function in Power BI
In this Power BI tutorial, Matt Peterson from Certlibrary breaks down one of the most essential but often misunderstood DAX functions: USERELATIONSHIP. If you’ve ever needed to access multiple relationships between tables in your data model but struggled with Power BI’s limitation of only one active relationship at a time—this guide is for you. Power… Read More
Power BI Field Parameters: A Smarter Way to Use Measure Slicers
In this expert-led tutorial, Mitchell Pearson from Certlibrary explores how Field Parameters in Power BI can revolutionize your reporting. Learn how to give users dynamic control over the measures they want to see—without cluttering visuals or overwhelming end-users. Designing compelling Power BI reports that balance clarity and comprehensive insight is an ongoing challenge for data… Read More
How to Build a Dynamic Fiscal Year Date Table Using DAX in Power BI
In this step-by-step tutorial, Amelia Roberts from Certlibrary demonstrates how to create a dynamic fiscal year date table in Power BI using DAX formulas. Since many organizations have fiscal years that differ from the standard calendar year, crafting a custom date table tailored to your fiscal calendar is essential for accurate reporting. In many organizations,… Read More
Beginner’s Guide to Navigating the Power BI Desktop Interface
In this tutorial, Microsoft Certified Trainer Allison Gonzalez offers a detailed walkthrough of the Power BI Desktop interface, specifically designed for beginners. This video is part of a foundational series that introduces users to Power BI’s core features and helps them confidently start building reports and visualizations. How to Download and Install Power BI Desktop… Read More
Quick Guide to Setting Up Microsoft Bookings Effortlessly
Greg Trzeciak from Certlibrary demonstrates how to create a personal Microsoft Bookings page in under five minutes. Microsoft Bookings is a versatile scheduling tool within the Microsoft 365 suite that simplifies appointment management for professionals across various industries. This post provides a clear, concise overview based on Greg’s tutorial to help you get started quickly… Read More