Learning to calculate standard deviation in Excel (the simplest method)

msrxp Excell September 28, 2020
This tutorial shows how to calculate the standard deviation based on the total population using the STDEV.P function in Excel and how to estimate the standard deviation based on the sample using the STDEV.S function…
Read More

How to draw a table in Excel? (With editing and filtering them)

msrxp Excell September 28, 2020
In this article, we will teach you how to create a spreadsheet in Excel. You can use this on both Windows and Mac operating systems. Part 1: Creating a table 1. Open an Excel document. To open…
Read More

Types of averages in Excel + GPA video tutorial

msrxp Excell September 28, 2020
There are many situations in which calculating the average is useful. For example: What is the average height of students in a class? What is the average monthly electricity bill during a year? And What is…
Read More

Learn how to delete specific rows in Excel (the easiest way)

msrxp Excell September 28, 2020
When working with large datasets, you may need to delete rows immediately based on the cell values ​​in it (or based on a condition). Consider the following examples: 1. You have sales data and want…
Read More

Hide and replay blank lines in Excel

msrxp Excell September 28, 2020
This tutorial describes three different ways to hide lines in a worksheet. It also explains how to show hidden lines in Excel and how to copy visible lines. If you want to prevent users from paying…
Read More

Complete training in writing formulas in Excel software 2010-2016 (video)

msrxp Excell September 28, 2020
In the continuation of Excel application tutorials, here we fully teach you how to write formulas in Excel 2010-2016 software.  In fact, one of the most powerful features in Excel 2010 to 2016 software is the ability to calculate…
Read More

Copy and paste tutorial in Excel (all practical tricks)

msrxp Excell September 28, 2020
There are several ways to copy and paste information into Smartsheet or between Smartsheet and other applications. The table below contains an overview. Note: Currently, the use of copy and paste in Excel columns is not supported.…
Read More

20 practical tips for data analysis to make various researches in Excel easier

msrxp Excell September 28, 2020
1. Think of research as a way to find treasure Analyzing the data is like finding a treasure. In other words, collecting data is like collecting treasure and gold. Although the research process can be tedious, you…
Read More

Learn 12 very useful techniques in Excel that will make you a professional!

msrxp Excell September 21, 2020
Excel software is very useful, but learning it requires training. If you use the techniques and tips in this article, you can do your job faster and without stress. In this article you can learn how…
Read More

List of 50 most useful Excel formulas (important functions)

msrxp Excell September 21, 2020
With the increasing development of mathematics and applications of this field and the frequency of the number of formulas and the complexity of some formulas, to accurately calculate these formulas and prevent errors, we can…
Read More