Excel tutorials or tips and tricks.
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 : A spreadsheet 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. The question now is what is the … 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
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
In this Excel tutorial, we’ll see why and how to freeze a row in Excel, how to freeze a column in Excel, how to freeze multiple rows and columns, and of course how to unlock frozen rows and columns if we don’t need anymore the locked display of information.
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.
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.
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.
In this tutorial, we will see different methods of how to sum in Excel using the AutoSum tool and the SUM function.