by Ilker | Nov 21, 2019 | Excel Tips & Tricks
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...
by Ilker | Nov 19, 2019 | Excel Tips & Tricks
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...
by Ilker | Nov 18, 2019 | Excel Tips & Tricks
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...
by Ilker | Nov 4, 2019 | Excel Tips & Tricks
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...
by Ilker | Oct 30, 2019 | Excel Tips & Tricks
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...
by Ilker | Oct 30, 2019 | Excel Tips & Tricks
This is the second part of the how to solve quadratic equations in Excel guide. Here, we are going to be focusing on how to do this manual and VBA method, whereas the first part shows how to do this using the Goal Seek feature. In this guide, we are going to show you...
by Ilker | Oct 29, 2019 | Excel Tips & Tricks
A quadratic function is a type of equation that contains a squared variable. It is called quadratic because quad means square in Latin. The quadratic functions usually have a structure like ax² + bx + c = 0, where x represents an unknown variable, and a, b, and c...
by Ilker | Oct 28, 2019 | Excel Tips & Tricks
Excel is not a word processor software, but you may still want to list things in various parts of your workbooks. Bullet points are great for creating lists, as its the universal indicator of an unordered list. Here, we’re going to cover 4 different ways to...
by Ilker | Oct 27, 2019 | Excel Tips & Tricks
Although Excel tasks typically involve working with numbers, you can also manipulate text strings by concatenating them. In this guide, we’re going to show you how to concatenate strings in Excel using the ampersand character and also with the help of other...
