Audio Bersama

Hello everyone… Welcome to Beyond Static 4 U… Today, I’m going to show you a super useful Excel trick… It’s the DGET function… which helps you easily extract exact information from a database… Let’s take a look at the screen… Here we have our employee data — Employee ID, Name, Designation… Join Date, and Salary… Now, let’s say you need the details for Employee ID 1005… This is where the DGET function comes in… The formula is: DGET(database, field, criteria) Database means the entire table