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
Master Copy and Paste Techniques in Power Automate
Understanding how to transfer text and dynamic content seamlessly between different steps in Power Automate is essential for building fluid, efficient workflows that save time and reduce errors. Jonathan highlights a straightforward method that empowers users to copy content from one action and paste it into another while maintaining the integrity and dynamic functionality of… Read More
Enhance Your Canvas Power Apps Using Collections
In this tutorial, Matthew Peterson from Certlibrary walks you through how to harness the power of collections in Canvas Power Apps. Collections are essential for temporarily storing and manipulating data within your app, enabling smoother data handling across multiple screens. Matthew provides clear, step-by-step instructions for practical use cases like selecting multiple records and displaying… Read More
Step-by-Step Guide to Creating SharePoint Alerts
In this detailed tutorial, Jonathon Silva explains how to set up SharePoint alerts to keep you updated on changes within your document libraries. These alerts are essential for staying informed about edits, additions, or deletions in your SharePoint environment. How to Locate Your SharePoint Document Library for Alert Setup To begin setting up alerts in… Read More
Introduction to Basic HTTP Requests in Power Automate
In this tutorial, Jonathon Silva guides you through the basics of creating HTTP requests using Power Automate. By leveraging the HTTP action, Jonathon demonstrates how to fetch a random joke from GitHub’s official Joke API and send it directly to Microsoft Teams, making automation both fun and practical. Creating a Dynamic Flow Trigger with User… Read More
Mastering Advanced Pivot Table Features in Excel
Microsoft Certified Trainer Allison Gonzalez from Certlibrary shares expert tips on enhancing the appearance and functionality of pivot tables in Excel. Building on basic pivot table concepts, this guide dives into customization techniques that make your data summaries more visually engaging and user-friendly. When working with pivot tables in Excel, one of the most powerful… Read More
Understanding Application Insights: A Powerful Tool for Monitoring Website Performance
Monitoring your website’s performance is essential for gaining valuable insights into user behavior and ensuring an optimal user experience. In this article, Chris Seferlis introduces Application Insights, a robust application performance management service offered by Microsoft Azure. In today’s fast-paced digital landscape, delivering a seamless and responsive user experience is paramount for any web application.… Read More
Unlocking the Power of Microsoft Forms and Power BI Integration for Survey Analysis
In this comprehensive tutorial, Amelia Roberts from Certlibrary demonstrates how to seamlessly integrate Microsoft Forms with Power BI to convert your survey data into meaningful insights. Microsoft Forms offers a straightforward platform for designing surveys, quizzes, and other data collection forms, while Power BI excels at analyzing and visualizing that data in real-time. This integration… Read More
Latest Enhancements to the Power BI Matrix Visual | May 2024 Update
In this informative video, Allison Gonzalez from Certlibrary unveils the newest improvements made to the Matrix visual in Power BI, released in the May 2024 update. For those who appreciate the versatility of Excel pivot tables, these upgrades bring similar layout options and increased flexibility to the Matrix visual. Let’s dive into what’s new and… Read More
How to Apply Conditional Formatting to Emails in Microsoft Outlook
In a detailed video tutorial by Angelica Domenech, a trainer at Certlibrary, users learn how to leverage conditional formatting in Microsoft Outlook to better manage and prioritize their emails. Angelica provides step-by-step instructions on creating rules that automatically color-code emails based on specific conditions, making it easier to spot important messages and boost productivity. Related… Read More