by Ilker | Mar 26, 2019 | Excel Tips & Tricks
A percentage is a number or ratio that represents a fraction of 100, and this representation is used widely from interest rates to risk analysis, or really in any application when the contribution of a specific item to the whole is to be highlighted. In this article,...
by Ilker | Jan 29, 2019 | Excel Tips & Tricks
Conditional Formatting is commonly used to highlight data fields to easily identify outliers, or narrow down the results. However, this feature works a bit differently when dealing with a Pivot Table. Pivot Tables are also dynamic elements, and conditional formatting...
by Ilker | Jan 16, 2019 | Excel Formulas
Excel TEXT function helps apply a certain formatting to a numeric value. You can think this function as an alternative to number formatting. In this guide, we’re going to show you how to use the TEXT function and also go over some tips and error handling...
by Ilker | Jan 14, 2019 | Excel Tips & Tricks
The Format Painter is the life saver when you need to copy only the formatting settings from one section to the other in your spreadsheet. In this guide, we’re going to show you how to use format painter in Excel. The best part is, this feature is supported by pretty...
by Ilker | Dec 18, 2018 | Excel Tips & Tricks
Number Formatting feature in Excel allows modifying the appearance of cell values, without changing their actual values. Currency formatting with dollar signs ($), or highlighting negative values with red are common examples. Another advantage of this feature is the...
by Ilker | Dec 18, 2018 | Excel Tips & Tricks
Number Formatting feature in Excel allows modifying the appearance of cell values, without changing their actual values. Currency formatting with dollar signs ($), or highlighting negative values with red are common examples. Another advantage of this feature is the...
by Ilker | Sep 25, 2018 | Excel Tips & Tricks
Number Formatting feature in Excel mainly allows you to change the appearance of cells without overwriting their contents. Currency formatting or highlighting colors are common examples. But that’s not all! You can also use this feature to hide the value of a...
by Ilker | Jul 13, 2018 | Excel Tips & Tricks
To sum by week number is a bit different than How to sum by month. Instead of finding start and end dates of date range, we focus on exact week number by using WEEKNUM function. Syntax =SUMIFS( range of values to sum, range of week number helper column, current week)...
by Ilker | Jul 10, 2018 | Excel Tips & Tricks
This article shows you how to generate month list by formulas and how to display Excel month names instead of actual date values. We will use DATE, YEAR and MONTH formulas as well as Number Formatting. Syntax =DATE( YEAR( previous date ), MONTH( previous date )+1, 1)...
