by Ilker | Mar 2, 2021 | Excel Tips & Tricks
Excel opens most files from other sources in Protected View mode by default. In this guide, we’re going to show you how to disable protected view mode in Excel. Excel, like most other Office applications such as Word and PowerPoint, shows this message to ensure...
by Ilker | Feb 25, 2021 | Excel Tips & Tricks
Text to Columns feature can help you split text strings in Excel. Using VBA, you can make this process even faster. In this guide, we’re going to show you how to split text with VBA in Excel. Download Workbook Data In this example, we have rows of data...
by Ilker | Feb 23, 2021 | Excel Tips & Tricks
With alternating background colors, it becomes easier to differentiate between each row. In this guide, we’re going to show you how to highlight alternate rows in Excel. Download Workbook You can set different colors in alternate rows using either of these two...
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 | Feb 19, 2021 | Excel Tips & Tricks
Excel has more than one way for splitting text, such as Text to Columns feature. However, the feature requires a manual user intervention. You can make the process dynamic with help of functions. In this guide, we’re going to show you how to split text with...
by Ilker | Feb 18, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to count a specific character in a string in Excel. Finding the number of a specific character, such as a delimiter, can help with splitting a text with the use of formulas. Download Workbook Syntax...
by Ilker | Feb 18, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to reverse a text string in Excel. Download Workbook Please note that as of we are writing this article, functions like TEXTJOIN and CONCAT are available for Excel 2019 and Microsoft 365 subscribers only. Syntax CONCAT...
by Ilker | Feb 17, 2021 | Excel Tips & Tricks
VCF (Virtual Contact File), also known as vCard, is a file format for business cards that has been in use since 1996. A VCF is a text-based file format can store various information like the contact name, phone number, and email address. Although Excel does not have...
by Ilker | Feb 17, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to run calculate median by criteria in Excel. Download Workbook To calculate median based on a criteria, you need to supply a range of values to be compared against the specific criteria defined in the MEDIAN function....