Comprehensive and visual training for working with functions and writing formulas in Excel (Functions)

In the continuation of the series of practical tutorials for Excel software, we will provide a comprehensive tutorial on how to create and develop commonly used functions and formulas in Excel software in a visual…

Video tutorial on how to edit rows, columns and cells in Excel

rows, columns and cells in Excel. By default, each row and column of a new project is set to the same height and width as the default. Excel allows you to change the width of…

Video tutorial on how to type numbers automatically in Excel features

Introduction: The Office suite has various features and menus. One of these features is Excel, which has many applications in the field of engineering, administrative, financial and accounting.  features , One of the applications of Excel…

Step-by-step tutorial on how to freeze in Excel + video

 In this article, we want to teach you how to freeze in Excel with an instructional video. So if you want to learn this title, be sure to follow this article to the end. Introduction: Since…

Learn how to work with formulas in Excel step by step (for beginners)

You probably won’t be excited about learning formulas. Most of us have a laid back attitude when it comes to painting a picture about ourselves. That’s why we use Microsoft Excel to do the math.…

Step-by-step tutorial for creating a drop-down list with data valuation

Validation Data feature effectively improves data entry in Excel and reduces typos and errors. You can use the validation criterion to restrict the input data or even define certain rules for entering information in the software yourself so that you…

Learn how to select certain cells in Excel

We want to select specific cells on a page, for example, cells containing constants, formulas, empty cells, and و, and perform operations such as copy, move, delete, color, fill, or protect them. To do this,…

How to create a checklist with the help of conditional format in Excel

If you want to control your daily activities, you can create a To Do list . This list will be really useful for completing your tasks. We will use the IF function in conditional formatting . To better understand this, let us give…

Step-by-step tutorial for adding / combining formulas in Excel

In Excel software you can merge cells using the Concatenate function . Using the ” CONCATENATE ” function is the best way to combine different cell text formulas or merge data. The CONCATENATE function allows you to bring cell text from multiple cells into a single…

Teach descriptive statistics in Excel in a very simple language

In this article, we will talk about descriptive statistics in Excel 2016. Descriptive statistics are used to quickly calculate numerical statistics such as mean, median, mode, standard deviation, range, minimum, maximum, and more in Microsoft Excel…