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

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…

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

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…

# Types of averages in Excel + GPA video tutorial

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…

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

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…

# Hide and replay blank lines in Excel

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…

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

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…

# Copy and paste tutorial in Excel (all practical tricks)

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.…

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

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…

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

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…

# List of 50 most useful Excel formulas (important functions)

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…