There are four ways to join the content of the cells in Excel: the ampersand operator &, and the functions CONCATENATE, CONCAT, and TEXTJOIN. The & operator and the CONCATENATE function can be used whatever the Excel version is, whereas The CONCAT and the TEXTJOIN functions are available only in Excel 2019 or newer, and … Read more
When doing statistical analysis in Excel, you’ll often need to count the entries that met a specific criteria; e.g. how much a text, number, or alphabetical entry occurs. To do that, you’ll need to use one the COUNTIF function. The COUNTIF function in Excel allows to count the number of occurrences of a number, text, … Read more
Beginning with version 2010, Excel became offered in two “bitness versions”: a 32-bit and a 64-bit. Prior to Excel 2010, only the 32-bit version was available. The 32-bit and 64-bit versions of Excel are practically the same in terms of the features they provide to the user, but they are still different “by design,” as we will see right below. … Read more
Excel Options is a feature that you can use to customize a lot of settings related to Excel display and behavior. In this article, I will show you where to find the Excel Options feature, what settings you can set using it, and how to fix the issue of not being able to display the … Read more
In this article, we’ll learn what are Excel file formats and extensions, and what distinguishes one from another. We’ll also see how to know the type of an Excel file and how to change it to another format when needed. A/ Excel file formats and extensions Excel has many different file formats or types that … Read more
One of the Excel error messages that disrupt the user’s workflow and aren’t so easy to resolve is the “Not Enough Memory” error. In this tutorial, I will tell you when this error usually occurs, will explain the possible causes behind it, and will give you some effective steps and solutions to fix it. A- … Read more
An Excel spreadsheet can be comparable to a database visually, as they are both organized in a tabular format; however, they are two different things and present a lot of differences that distinguish one from the other. The differences between an Excel spreadsheet and a database are : Excel sheet has cells; a database has … Read more
Before diving into the pros and cons of Excel macros, I will start by giving you a definition of macros in Excel and what are they used for. An Excel macro is an action or a series of actions that are recorded by Excel recorder, at the user’s request, to produce an automated process for … Read more
The standard Excel workbooks can have one of two extensions: XLS or XLSX. The XLS format is the old one and was the default format before Excel 2007. XLSX is the newer one that was introduced in 2007; it is the default format for Excel 2007 and later. In the following, I will list you … Read more
Converting an Excel spreadsheet or workbook to a PDF has so many advantages that allow users to easily share and print them: The PDF format is universal. All modern devices, operating systems, and browsers can easily read PDF documents. So, a user that receives an Excel workbook can view it without the need of having … Read more