วีดีโอ

This video shows how to use the LOOKUP value to fix it when it is giving incorrect value. LOOKUP can search the last entry instead of first one unlike VLOOKUP or INDEX MATCH that will always give you the first lookup value found. As a bonus topic, this video also shows how to find the last lookup value using XLOOKUP.

This video shows how to create a measure in Power BI that imitates or similar to a SUMIFS or AVERAGEIFS formula in Excel wherein you need to get the sum of a certain field only if it follows a certain condition or criteria. Though this can be done using filters, a measure has the benefit of being a variable that you can use in later formulas and not something that exists only in visuals.

Convert Vertical Data into a Table using WRAPROWS Function

This video shows an effect in Power BI wherein when a button is pressed, the chart or visual changes to a different type of visual or chart. This shows a technique that uses bookmarks to remember settings of a report and executes the action using a button. How to bring in data to Power BI: th-cam.com/video/vu5hlYGvzXE/w-d-xo.htmlsi=_HaFe4pBHMrIB8Ud How to create basic visuals in Power BI: th-ca...

This video shows how you can send multiple data or information from rows in Excel to just one page in MS Word. This page has more than one certificate or ID or pay slip or document so that you maximize one page and have more than one layout and design per page.

This video shows a Canva Tips and Trick wherein there are icons or objects or elements that rotate together as if like in a wheel. This video uses a circle to act as the axis of the rotation.

This video shows how to convert currencies using Excel and use this in formulas to show live foreign exchange FOREX rates of different countries. This video has two parts: the use of Data Currency Pair tool and the use of STOCKHISTORY function in Microsoft 365 to generate even an entire history of currency close amounts up to the most recent or last close.

This video shows a Canva trick how to create an effect that imitates the subtract shapes under the Merge Shapes tool in PowerPoint into Canva. This can help in create a hole like or cut out effect from shapes in Canva where the cutout or the hole looks transparent.

This video shows how to remove or filter out empty rows that the VSTACK function captures when you highlight entire columns or empty cells in a table. This uses the FILTER function to choose only rows that have values.

This video shows how to count the dates in a list. The dates have to be from a certain month that is interpreted as text. Instead of using COUNTIF, the solution uses IF and array to convert a column into text month which the IF will then check.

This video shows how to use the TEXTSPLIT and the SORTBY Functions in MS Excel. The video will then solve how to sort the results of TEXTSPLIT function to follow a different order (like swapping the resulting cells) using SORTBY array.

This video shows how to create a gauge chart in Power BI and modify the maximum value and create a target line in the chart.

This video show the settings to enable maps in Power BI in order to set it up correctly not doing so will get an error in PowerBI when creating a map chart. This videos shows what to put in the Latitude, Longitude, and Location fields in a map chart. How to connect files and build data model: th-cam.com/video/vu5hlYGvzXE/w-d-xo.html

This video shows how to use SUMX and RELATED Function when you need to multiply values from one table with values from another field in another table in the data model. This is similar to doing SUMPRODUCT in Excel yet, the columns are from different queries. How to connect files and build data model: th-cam.com/video/vu5hlYGvzXE/w-d-xo.html

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