Excel tutorials or tips and tricks.
When you create a workbook in Excel, you’ll notice that the cells have the same default size (width and height). These default dimensions are usually fine, but if you have repetitive needs to always change the columns width or rows height before any data entry, you might need to set new default values to use … Read more
In this tutorial, I will show you how to copy columns width and rows height in Excel. But before this, let’s see why and when this can be useful for you. Well, you might want to copy the columns width or rows height to speed up formatting a new worksheet to match the layout of … Read more
Units of column width and row height in Excel can be a little confusing, as this software uses two different units for columns and rows, as well as for the view displayed by the user (Normal view or Page Layout view). In the following, I will show you what are Excel column width and row … Read more
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
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.
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