# Archive List for Basic Course

## 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・・・

## 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・・・

## Create, select from, and deactivate drop-down lists

How to create a drop-down list If we realize that we are using the same words repeatedly in a table, it might be more efficient to use a drop-down list. Here, we will explain how to use the ‘Data Validation’ to create drop-down lists. What is a drop-down list? A drop-down list allows us to select words/values・・・

## Set a password/Book・File, Worksheet, Cell range

Set a password to a book/file For Excel books/files that are private and want to prevent other people’s access, we can set a password to the book to protect them.   How to set it up) Protect Excel book with a password We can set a password during the ‘Save’ or ‘Save As’ process. (1)　Open ‘Save’・・・ 