by Ilker | Sep 8, 2020 | Excel Tips & Tricks
Finding your active file’s location can be a bit tricky at times. However, you can see the file location and even copy its location as a text from the Quick Access Toolbar. In this article, we are going to show you how to show workbook location in Quick Access...
by Ilker | Sep 3, 2020 | Excel Tips & Tricks
Copy and Paste is essential in daily computer use. If you copy and paste a lot, like most people, you can find yourself pasting the same information again and again. Excel’s Clipboard feature lists the items you’ve copied before and allow you to paste them...
by Ilker | Sep 2, 2020 | Excel Tips & Tricks
Let’s say you need to populate items randomly. You can use Excel’s RANDBETWEEN function to select a random item from a list. What if the distribution of the items is not uniform? In this article, we are going to show you how to select a random item by distribution in...
by Ilker | Aug 31, 2020 | Excel Tips & Tricks
You can easily copy sheets in Excel manually with a few simple mouse clicks. On the other hand, you need a macro if you want to automate this process. In this guide, we’re going to show you how to copy sheets in Excel with VBA. Download Workbook Before you start...
by Ilker | Aug 28, 2020 | Excel Tips & Tricks
The ribbon is the name of Excel’s toolbar since Excel 2007. It displays commands as icons in a strip that are grouped into tabs based on their functions. It became customizable with Excel 2010. You can hide unnecessary tabs and commands, or add new ones easily. In...
by Ilker | Jul 28, 2020 | Excel Formulas, Excel Tips & Tricks
You can use Excel formulas to populate a random number or string from a list. You can even build a logic to return numbers without any duplicates. In this article, we are going to show you how to select a random Item from a list in Excel. Download Workbook Although...
by Ilker | Jul 28, 2020 | Excel Tips & Tricks
PDF is a popular file type for sharing. Fortunately, Excel has a couple of tools for an Excel to PDF conversion. The process becomes even easier thanks to Excel’s Page Layout options, where you can define page sizes and properties. In this article, we are going to...
by Ilker | Jul 27, 2020 | Excel Tips & Tricks
Excel is rich in data sorting features - you have built in features like Sort and functions like SORT or SORTBY. However, these methods won’t work without some modification when you need to sort dates in Excel. In this article, we are going to show you how to...
by Ilker | Jul 21, 2020 | Excel Tips & Tricks
Sorting is a crucial part of organizing data. Being everyone’s go-to spreadsheet tool, Excel thankfully offers various tools for sorting data like the sort feature and functions like SORT or SORTBY. However, neither of these approaches can really help you with...
