How To Change the Columns Width and Rows Height in Excel

This entry is part 3 of 9 in the series Learn Excel: For Beginners

Whenever you work on an Excel spreadsheet, in most cases you will need to change the size of the cells to be able to view all the content they contain. But, to do this, and due to the tabular structure of the spreadsheet, you will of course have to resize the entire column or row … Read more

How to Use Excel: Beginners Guide to Learn All Excel Basics

Excel tutorial for beginners
This entry is part 1 of 9 in the series Learn Excel: For Beginners

This tutorial is an Excel tutorial for beginners covering all the basic features of this software. It will enable you to master Excel basics, quickly and efficiently.

You will learn how to use the Excel interface; how to create and save a workbook; how to manage Excel sheets; how to enter, edit, and format data; how to manage rows, columns, and cells; how to format cells; how to use formulas and functions; how to sort and filter data; how to create and edit charts; how to print a sheet or part of it; how to hide the ribbon, how to convert an Excel sheet to PDF; and how to customize the Quick Access Toolbar.

After this tutorial, you will no longer remain a beginner in Excel.

The 4 Ways To Join the Content of Cells in Excel

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

Excel 32 Bit vs 64 Bit

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

What Are Excel File Formats and Extensions

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

Why Excel Says Not Enough Memory And How To Fix It

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

Difference Between an Excel Spreadsheet and a Database

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

Pros and Cons of Excel Macros

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

What Is the Difference Between XLS and XLSX

XLS versus XLSX

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

What Can a Cell Name Start With in Excel

There are some rules for naming a cell in Excel, especially for the first character in the name, as not all characters are acceptable by Excel. So, what characters a cell name can start with or cannot in Excel? I made some experiments and got a lot of results that I organized by categories of … Read more

How to Sort Data in Excel

Excel sort
This entry is part 7 of 9 in the series Learn Excel: For Beginners

In this Excel tutorial, we’ll learn how to sort data in Excel using the simple sort command (how to sort text, numbers, or dates), as well as how to sort multiple columns, how to sort by color, and how to sort by rows using the custom sort.

Cell Format Types in Excel and How To Implement Them

Number format drop-down list in Excel
This entry is part 2 of 9 in the series Learn Excel: For Beginners

This tutorial about cell format types in Excel is an essential part of your learning of Excel and will definitely do a lot of good to you in your future use of this software, as a lot of tasks in Excel sheets are based on cells format, as well as several errors are due to a bad implementation of it.

How to Filter Data in Excel

Clear filter in Excel
This entry is part 9 of 9 in the series Learn Excel: For Beginners

In this tutorial on how to filter data in Excel, we will see how to apply a filter on an Excel spreadsheet, how to use its different options, how to clear a filter for a specific column or for all columns, and how to remove the filter from all the spreadsheet.