Category Archives for "Excel"

Find and Highlight Duplicates in Excel

You can quickly find duplicates in Excel by employing a few different strategies. Often users want to see if there is a duplicate email in a list. Also, retailers may want to see if there have been duplicate transactions over a given period of time. There are tons of scenarios where you may want to […]

Vlookup vs Index Match

Vlookup is probably one of the top 5 functions that asked for Excel professionals to demonstrate for analysis or while interviewing. I can personally attest that early in my career I was asked whether I could do Vlookup hundreds of times. I often wonder why VLOOKUP became the go-to function for looking up data when […]

How to Fix VLOOKUP Errors

How to Fix VLOOKUP Errors Summary: VLOOKUP function in Excel is the most widely used function and it comes in very handy while looking up the value from different data sources. However, VLOOKUP also has a lot of limitations and specificities, which leads to various problems and errors. In this article, we are going to […]

Use DATEDIF to calculate time between dates.

There is a great little-known function for determining the days, months and years between two dates. This is not a publicized formula so it will not pop up in your formula bar or in formula dictionary in Excel. However, for me, this is a great formula that allows me to save a lot of time. […]

RIGHT and LEFT Functions in Excel

Left & Right function in Excel 1. LEFT: Definition: LEFT function in Excel returns the left-hand side characters from a text string based on the number of characters specified by the user. Arguments/Syntax: LEFT(text, [num_chars]) text: It is a required argument. It is the text string that contains the characters user wants to extract a […]

Scrape Website Data with Excel or Power BI

Scraping website data can be done easily using Power Query in Excel or by using Power BI. Both these tools have the ability to scrape tabular data from a website. The applications will search for a table within in the website and allows you to import it into the data model or Excel. Follow the instructions […]

Count Unique Values in Excel

Counting unique values in Excel Summary: One of the most common requirements of data manipulation is to either remove duplicates from the data or get the unique count of values. Although, excel doesn’t provide any default function to get the unique count of values but still the removing of duplicate values and getting the unique […]

Change Horizontal Axis Values in Excel 2016

Often there is a need to change the data labels in your Excel 2016 graph. The procedure is a little different from the previous versions of Excel 2016. You will add corresponding data in the same table to create the label. You can also create a new set of data to populate the labels. Be […]

Excel Pivot Table Tips & Tricks

Pivot Tables: Pivot tables in Excel are considered as the most important tool. A pivot table allows the users to organize and summarize the selected columns of data to develop a required analysis report. Using pivot table user can do quick data analysis and it is quite easy to use as well. In this article, […]

Essential Excel Formulas for Accounting

Accounting Functions in Excel Use these essential functions to save time and speed up your accounting task. Excel may not take the place of QuickBooks but useful tips to help you clean up your accounting. For more ways to improve your Excel skills, check Master Excel Beginner to Advanced Compound Interest: A user can calculate […]