## Calculate the variance/VAR, VARP

What is data variance? Variance is a value that shows how “varied” a certain data is, and in mathematics it is used mainly in statistics and probabilities. To calculate the variance, we ① Calculate the average difference for each data ② Square each of the differences ③ Add all calculated values ④ Divide everything by the number・・・

## Use functions to automatically distribute training with a capacity based on priority and choices

Companies and schools organizing training courses carried out in a different institute…   The above situation is common, and when organizing this, someone will have to distribute the employees/students to each group and/or institute. This itself does not seem complicated. However, there are times when there is a certain capacity of the number of・・・

## Using the “Pivot Table”

Most people use Excel for the purpose of “data management”. Data management includes data ‘processing’ and ‘analyzing’ (creating tables and calculating values…), and is a crucial skill in the business world. When managing data, the method or way of ‘processing’ data becomes important. There are many ways to process data in Excel and we can・・・

## Line feed code/CHAR(10), replace・delete, CHAR function

Insert a new line in cells (Using a code) To insert a new line in Excel, we can add a text called ‘line feed code = CHAR (10)’. Let us review this line feed code first. → For more information on the CHAR function, click here   Example of use) Insert a new line using・・・

## How to create graphs (rotate row/column, grid lines, 2 axis…)

Create a bar graph In Excel, not only can we keep and calculate data, but we can also create graphs very simply. Let us look at how to create graphs, starting with the most simple, bar graphs. Example of use) How to create a bar graph The table below shows the number of stationary (HB・・・

## 【Practice question】Sum up values that meet a condition_

Practice question 1/Sum up cells that includes a specific text 【Practice question 1 : Question】 The table below shows the number of employees in each office. In each region, there is a department that supervises the offices (branches) named the ‘supervisory’ department. Calculate the number of employees in the ‘supervisory’ department. The total number of・・・

## 【Practice questions】Count data with conditions (empty, full, other than～, duplication）

Practice question 1/Count cells that meet a condition/Empty, full cells 【Practice question 1 : Question】 Below is a business trip schedule of the Sales manager. It shows the location of the trip and if the tickets for transportation are arranged. 1. Calculate the number of trips in which the tickets are arranged. 2. Calculate the number・・・

## Calculate the average (conditions, 0 and spaces)/AVERAGE functions

Calculate the average/mean (AVERAGE function) To calculate the average/mean for data in Excel, we use the AVERAGE function. =AVERAGE(number1, [number2]…) [number1] = Identify the 1st number or cell range to calculate the average for. [number2] = Not obligatory. Identify when there is a number or cell range other than [number1]. Definition of function A function to・・・

## Conditional formulas used in functions such as the IF

Greater/smaller than or equal to~, greater/smaller than~, equal to~ When using the IF function, we sometimes want to include complicated conditions such as ‘greater than…‘ or ‘smaller than or equal to…’. Let us see how we can define these conditions correctly in the formula.   Example of use) How to use the comparison operator・・・

## Calculating date, time/comparison, addition and subtraction

Addition and subtraction of dates, times, minutes Here we will explain about the addition/subtraction of ‘dates’ and ‘times’, something we often use in Excel.   How to calculate the date) Addition・Subtraction The list below shows members’ information for a video rental shop. The expiry date for membership is 1 year, and 2 weeks prior to that・・・ 