Excel Insights

Calculate Minutes Late (also if with Grace Period)

Using INDEX and MATCH to Lookup Values in Range of Cells

Combining Data using CONCATENATE, CONCAT, TEXTJOIN, and "&" in Google Sheets

Apply Conditional Formatting in PowerBI Visuals

Rotate Multiple Icons Animation Effect in Canva

Convert Vertical Data into a Table using WRAPROWS Function

Format Dates and Numbers Correctly, Extract Data using Text to Columns

Power Pivot: Connect Many Tables in Pivot Tables

Create a Map Chart in Power BI

Calculate Minutes Late (also if with Grace Period)

Create Certificate in MS Word with Data from Excel

Connect Two Pivot Tables Created from Different Data Sources using Bridge Table

Format Cell if Date is 30 Days To Go or About to Reach the Deadline

Change Chart or Visual with Button Click in Power BI

Lookup Two Values in Separate Columns in a Matrix in Excel

Link SharePoint Excel File to PowerBI

Compare Data Between Tables

Lookup Two Values under Two Separate Columns in a Table in Excel

Calculate Overtime and Undertime

Extract Data from Picture or Screenshot in Excel

Combine Data from Excel and Google Sheets

28 July 2024

Display Texts in the Pivot Table Values Area Redo

Group Dates into Months and Quarters in Pivot Tables

Sort Horizontally by Rows in Excel and Google Sheets

Sort the Results of TEXTSPLIT Function using SORTBY Function

Add a Password to Specific Cells

Creating a Fishbone or Ishikawa Diagram

Custom Sort a Chart in Power BI

Remove Background in Canva

Generic Surface Keyboard (from Shopee) Review

Connecting Google Sheets to Power BI

Create a SUMIFS like Measure in Power BI

Create Transparent PNG using PowerPoint

Remove Empty Rows in VSTACK Result using FILTER Function

Mail Merge Send Multiple Data from Excel to One Page in Word (for IDs, Certificates, etc.)

Use SUMX and RELATED Function in Power BI to Multiply Values from Different Tables in the Model

Set a Deadline for a Shared Excel File to be Accessible

Merge Word Documents into One File

Control Page Contents when Printing in Excel

Connect Files to PowerBI and Build Data Model

Use Emojis in Excel Formulas

Create a New Function to Shorten Your Formulas using LAMBDA Function

Remove Background from an Image in PowerPoint

Find Last Value using LOOKUP Function

Automating Formatting of Heading and Creating of Table of Contents in Google Docs

Creating Pivot Tables in Google Sheets

S02E03 Automating Captions in MS Word

Convert Text-Formatted Dates to Actual Dates in Excel

Creating Calculations or Formulas in Pivot Tables

Make Dynamic Ranges in Formulas using OFFSET Function