by Ilker | Apr 11, 2019 | Excel Tips & Tricks
The AutoCorrect is an essential feature which is designed to correct typos automatically. This feature is also helpful for changing abbreviations to full versions, adding symbols, or correcting grammar errors, but it can also sometimes do things in a way that...
by Ilker | Apr 8, 2019 | Excel Tips & Tricks
Unlike the dollar sign ($), the cent symbol doesn’t have a place in our keyboards. In this article, we’re going to show you how to insert a this symbol in Excel, and walk you through 5 different methods to do this.Copy & PasteCopy & Paste the...
by Ilker | Apr 2, 2019 | Excel Tips & Tricks
Delta, which is the 4th letter of the Greek alphabet, is widely used in mathematics and science. Unfortunately, most keyboards don’t have this key and you would have to use different methods to get it in your Excel spreadsheets. In this article, we’re...
by Ilker | Mar 27, 2019 | Excel Tips & Tricks
An expanding reference or range is essentially a dynamic reference which can expand as a formula is copied down or across cells. In this article, we’re going to show you the expanding references in Excel and go over some common use cases.Creating an expanding...
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 | Mar 8, 2019 | Excel Tips & Tricks
Excel Table is a tool for managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which includes filtering, formatting, sizing, and auto populating formulas dynamically. In this guide, we’re going to go over some...
by Ilker | Mar 6, 2019 | Excel Tips & Tricks
In Excel, a blank cell doesn’t always mean a cell with an empty string (“”). An example to this is invisible characters like a new line character which can be entered by pressing the Alt + Enter key combination when you’re in a cell. You can...
by Ilker | Mar 5, 2019 | Excel Tips & Tricks
If you lost a worksheet or cannot find the worksheet tabs section in your workbook, fear not! In this guide, we’re going to show you how to unhide sheets and various methods to restore disappeared worksheet tabs. Unhide Sheets in ExcelExcel allows hiding...
by Ilker | Feb 21, 2019 | Excel Formulas, Excel Tips & Tricks
With the introduction of the dynamic arrays and spill concepts, Microsoft has also released a spill range operator (#). This operator is designed to reference spill ranges dynamically.For example, the cell D3 has =UNIQUE(B3:B16) formula which spills the return values...
