Resources
How to find duplicates in Excel and remove or consolidate them
Duplicate values in a dataset can cause headaches if you do not know how to deal with them. In this guide, we're going to show you how to find duplicates in Excel and also go over how you can remove or consolidate them using a few examples. [button...
How to prevent a #REF error in Excel
A #REF! error in Excel indicates an invalid reference. This pesky error can pop up after removing a sheet, rows or columns, or copying a formula. In this guide, we're going to show you how to prevent a #REF error in Excel. [button...
How to use Text to Columns in Excel
Data doesn't always come in a nice table layout, especially, when you retrieve it from an external source like a web site. Thanks to the Excel Text to Columns feature, you can split data into multiple columns. In this article, we are going to show you how to use the...
How to make Excel calculate faster
Excel is a fairly an efficient software given that it can perform complex calculations. However, depending on your system, it can also get pretty slow when running complicated calculations. How formulas are used, and size of the workbook are typically the culprit if...
All You Need to Know on How to Create a VBA loop in Excel
A loop is an essential concept for any programming language, and VBA follows the same approach. You can use loops to repeat an action until a specified condition is reached, or move through objects in a group, e.g. all worksheets in a workbook. A loop is an essential...
Control Shift Enter Excel Shortcut (CSE) and Array Formulas
Control Shift Enter Excel shortcut, as known as CSE, is a key combination you can use to apply array functions.CSE abbreviation is also used for array formulas that are entered using the Control + Shift + Enter key combination when entering a formula. Array formulas...
10 Things You Need to Know About the VLOOKUP Excel Function
In this guide we're going to go over 10 things you should know about the frequently-used-yet-not-so-easy-to-use VLOOKUP Excel function. Although this guide mainly focuses on the VLOOKUP function, these tips also apply to the HLOOKUP function, which essentially does...
How to convert seconds to time value in Excel
When it comes to date and time values, Excel evaluates them a bit differently than how we process them. For Excel, date and time values are numbers in a date or time display. Although this behavior allows making date and time calculations easier, it can be helpful to...
How to compare loans with different durations in Excel
Want to get a loan for a home or vehicle, but can't decide which option is the best? Use Excel to compare your options and make better decisions! Excel's PMT function is perfect for this type of analyses. In this article, we're going to show you how to compare loans...