10 Excel tips you should know as a Data Analyst
Look at the 2-column table below, which describes the Department and Employee ID of 20 employees. However, each Department value appears only once. (This is typical of a…
Pro Excel Top 10 Shortcuts
Use Ctrl + Shift + L to bring up the Filter drop down menu, but first make sure you highlight the headings…
Extract Duplicate Records using Vlookup or Filter Function
There are multiple methods of extracting duplicate records. But when it comes to VLOOKUP then this video will help you. First, lets…
Power BI Explained
Power BI is a powerful business analytics tool developed by Microsoft that enables users to visualize and analyze data from various sources,…