Excel Insights

Generic Surface Keyboard (from Shopee) Review

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

Compare Data Between Tables

Group Dates into Months and Quarters in Pivot Tables

Remove Background from an Image in PowerPoint

Use Emojis in Excel Formulas

Remove Background in Canva

Create Transparent PNG using PowerPoint

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

Lookup Two Values in Separate Columns in a Matrix in Excel

Control Page Contents when Printing in Excel

28 July 2024

Add a Password to Specific Cells

Display Texts in the Pivot Table Values Area Redo

Set a Deadline for a Shared Excel File to be Accessible

Find Last Value using LOOKUP Function

Create a SUMIFS like Measure in Power BI

Convert Vertical Data into a Table using WRAPROWS Function

Change Chart or Visual with Button Click in Power BI

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

Rotate Multiple Icons Animation Effect in Canva

Perform FOREX or Currency Exchange in Excel using Currency Tool and the STOCKHISTORY Function

Cut Out Shapes Effect in Canva

Remove Empty Rows in VSTACK Result using FILTER Function

Count Dates if it Belongs to a Certain Month

Sort the Results of TEXTSPLIT Function using SORTBY Function

Create a Gauge Chart in Power BI

Create a Map Chart in Power BI

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

Apply Conditional Formatting in PowerBI Visuals

Combine Data from Excel and Google Sheets

Add a Slicer in Power BI and Modify its Settings

Unpivot a Matrix into a Columnar Table in Excel

Connect Files to PowerBI and Build Data Model

Sort Horizontally by Rows in Excel and Google Sheets

Create a New Function to Shorten Your Formulas using LAMBDA Function

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

Perform a Lookup "Like VLOOKUP" in a Power BI Table

Creating a Column Chart with Quota or Target Line in Power BI

Merge Word Documents into One File

Calculate Overtime and Undertime

Create Certificate in MS Word with Data from Excel

Custom Sort a Chart in Power BI

Connecting Google Sheets to Power BI

Link SharePoint Excel File to PowerBI

Creating a Fishbone or Ishikawa Diagram

Identifying Critical Tasks in MS Project

Extract Data from Picture or Screenshot in Excel

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

Calculate Minutes Late (also if with Grace Period)