by Ilker | Nov 8, 2018 | Excel Macros, Excel Tips & Tricks
This article shows you How to prevent Save As with VBA.You can control your workbook’s events like opening, closing or saving by VBA. Events for Excel’s native objects are built in and ready to use. To prevent Save As event, the address is Workbook...
by Ilker | Nov 8, 2018 | Excel Formulas
The IF function performs a logical test (specified from its first argument), and returns either one of its second or third argument depending on the result of the test. If the test returns TRUE, the result will be the second argument, otherwise it will be the third....
by Ilker | Nov 8, 2018 | Excel Tips & Tricks
A histogram is a visual representation of the distribution of numerical data. Grouping data into specific percentiles can give you a better overview of the big picture. You can create an Excel histogram in two ways:Using formulasAnalysis ToolPak add-in Excel Histogram...
by Ilker | Nov 7, 2018 | Excel Formulas
HLOOKUP function is a lookup and reference function that can search a specific information in a selected table. In this guide, we’re going to show you how to use the HLOOKUP function and also go through some tips and error handling methods. The HLOOKUP searches a...
by Ilker | Nov 7, 2018 | Excel Formulas
VLOOKUP function is a lookup and reference function that can search a specific information in a table. In this guide, we’re going to show you how to use the VLOOKUP function and also add some tips and error handling methods. The VLOOKUP searches a value in the first...
by Ilker | Nov 6, 2018 | Excel Macros, Excel Tips & Tricks
Finding all comment fields inside a workbook might be a challenge if you’re not sure where they might be hiding. Let us show you how to highlight Excel comment using VBA to find them quickly! How to highlight Excel comment using VBAVBA has some predefined types...
by Ilker | Oct 26, 2018 | Excel Macros, Excel Tips & Tricks
Be it for troubleshooting formula errors or data integrity, you might find yourself trying to identify those cells going through the entire workbook. In this article we’re going to show to find in Excel if cell is blank using VBA and automate this process....
by Ilker | Oct 26, 2018 | Excel Formulas
AVERAGIFS function can calculate the average in a range of cells, based on a criteria. In this guide, we’re going to show you how to use the AVERAGIFS function and go through some examples, as well as error handling methods. Supported versions (Windows) Excel 2007 and...
by Ilker | Oct 26, 2018 | Excel Formulas
COUNTIFS function can count the values in a range of cells, based on some criteria. In this guide, we’re going to show you how to use the COUNTIFS function and cover some examples and error handling methods. Supported versions (Windows) Excel 2007 and above (Mac)...
