by Ilker | Nov 26, 2018 | Excel Macros, Resources
Excel, just like other Office products, supports comments. Although comments are helpful to add tips or other details into your spreadsheets, deleting them may become time consuming while trying to find and select all of them. In this article, we’re going to...
by Ilker | Nov 20, 2018 | Excel Tips & Tricks, Resources
Excel, just like other Office products, supports AutoShapes. Although Excel shapes are nice to have for presentation purposes, getting rid of them may become time consuming if your workbook is cluttered with them. This article shows you how to delete Excel shapes...
by Ilker | Nov 19, 2018 | Excel Formulas
Excel DATEVALUE function returns a date serial number from a specified date that is stored as text. This function comes in handy when your dates are stored as text data, instead of Excel's date number format. In this guide, we’re going to show you how to use the...
by Ilker | Nov 19, 2018 | Excel Formulas
The DATE function in Excel returns a date serial number from specified year, month and day values. In this guide, we’re going to show you how to use the DATE function and also throw in some tips and error handling methods.Supported versionsAll Excel versionsDate...
by Ilker | Nov 16, 2018 | Excel Macros, Excel Tips & Tricks, Resources
Excel, just like other Office products, supports inserting pictures of various formats into your workbooks. However, deleting them may be time consuming in large workbooks if you’re trying to find and delete every single image manually. Let us show you how to...
by Ilker | Nov 15, 2018 | Excel Macros, Excel Tips & Tricks, Resources
Excel, just like other Office products, can detect URLs and email addresses, and turn them automatically into hyperlinks. While this can usually speed things up when creating workbooks, they can become nuisance when you don’t want them to be clickable links with...
by Ilker | Nov 13, 2018 | Excel Formulas
The Excel YEAR function returns the year from a specified date serial number. In this guide, we’re going to show you how to use this function and also go over some tips and error handling methods.Supported versionsAll Excel versionsExcel YEAR Function Syntax...
by Ilker | Nov 13, 2018 | Excel Formulas
The Excel MONTH function returns the month from a specified date serial number. In this guide, we’re going to show you how to use the this function and also throw in some tips and error handling methods. Supported versions All versions Excel MONTH Function Syntax...
by Ilker | Nov 13, 2018 | Excel Formulas
The DAY function in Excel returns the day from a specified date number. In this guide, we’re going to show you how to use this function and also include some tips and error handling methods.Supported versionsAll Excel versionsDAY Function in Excel Syntax...
