by Ilker | Jul 2, 2019 | Excel Macros, Excel Tips & Tricks
Macros in Excel are code blocks that you can run in your workbooks to process a batch of commands. Macros are great for automating repetitive tasks such as copying or removing data from specific cells. However, macros can be daunting for new users. Creating a macro is...
by Ilker | Jul 1, 2019 | Excel Formulas
The Excel ISNUMBER function is an Information formula that returns TRUE if value is a number, and FALSE if not. As the name suggests, the formula asks the question “Is number?” to its argument. This way, you can test the outcome of a formula or a cell...
by Ilker | Jul 1, 2019 | Excel Formulas
The Excel ISLOGICAL function is an Information formula that returns TRUE if the input is a logical value, and a FALSE result otherwise. As the name suggests, the formula asks the question “Is logical?” to the argument value. This formula can be especially...
by Ilker | Jun 28, 2019 | Excel Tips & Tricks
The Excel Developer tab is a Ribbon tab which contains a number of tools aimed towards advanced features of Excel such as VBA, add-ins, form and ActiveX controls. Although you can access the VBA Editor with the shortcut (Alt+F11), the Developer tab in the Ribbon also...
by Ilker | Jun 28, 2019 | Excel Formulas
The ISERROR Excel function is an Information formula that returns TRUE if the target value contains an error value, and FALSE if it does not. As the name suggests, the formula asks the question “Is error?” to its argument, and returns a Boolean result....
by Ilker | Jun 27, 2019 | Excel Formulas
The ISERR Excel function is an Information formula that returns TRUE, if the reference value is an error code (except for #N/A), and FALSE otherwise. As the name suggests, the formula asks the “Is error?” question, and can be especially useful for...
by Ilker | Jun 26, 2019 | Excel Formulas
The Excel ISBLANK function is an Information formula that returns TRUE if the reference cell is completely empty, and FALSE otherwise. As the name suggests, the formula asks the “Is X blank?” question to its argument. Although a cell must be completely...
by Ilker | Jun 26, 2019 | Excel Formulas
The Excel CONVERT function is an Engineering function that converts a number between unit systems. You can convert feet into meters, pounds into kilograms, gallons into liters Fahrenheit into Celsius, and so on with this formula. In this guide, we’re going to show you...
by Ilker | Jun 25, 2019 | Excel Tips & Tricks
Excel can get the stock market data from 60 different stock exchanges around the world. However, this information will not refresh automatically, and currently you need to refresh stock data manually, or write a VBA code to automate the process. In this article, we...
