by Ilker | Jul 5, 2021 | Excel Tips & Tricks
Excel usually converts fractions automatically when you enter a date or text value. In this guide, we’re going to show you how to display fractions in Excel. Download Workbook Using number formatting to display fractions Excel stores and calculates any numerical value...
by Ilker | Feb 23, 2021 | Excel Tips & Tricks
10 Excel tips to increase productivity In this guide, we’re going to show you 10 tips to increase your Excel productivity for when working with spreadsheets. Cell styles You can change the color, font type and borders around cells. Modifying these elements can help...
by Ilker | Jan 6, 2021 | Excel Tips & Tricks
Data formatting can get mixed up when you open a data file with CSV format. In this article, we are going to show you how to avoid formatting change in CSV files in Excel. Download Workbook If you need to prevent numbers from changing into dates when entering data,...
by Ilker | Nov 9, 2020 | Excel Tips & Tricks
Adding symbols or icons into charts can enhance the visual representation, and make it easier to understand the data. In this article, we are going to show you how to use symbols on charts in Excel. Download Workbook Adding symbols to Excel Note that you can always...
by Ilker | Oct 25, 2019 | Excel Formulas, Excel Tips & Tricks
Rounding numbers is a crucial element of creating legible and easy-to-use spreadsheet tools. Excel offers a few methods to do this, including a formula approach and the number formatting feature. In this guide, we’re going to show you how to round numbers in...
by Ilker | Oct 1, 2019 | Excel Tips & Tricks
In Excel, you can actually show numbers as a percentage, without using any calculations. A percentage is a number or ratio that means a fraction of 100. They are expressed with the percentage sign (%), following the ratio. For example, 12% means 12/100, 0.12 or...
by Ilker | Sep 3, 2019 | Excel Tips & Tricks
Excel’s merge cells feature provides an easy way to group multiple cells together. You can create multi-level headers by merging cells on the previous row or column. Merged cells looks like a higher category that contain the information in the following cells....
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...
