Calculate the variance/VAR, VARP

Basic Course

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

Basic Course

  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”

Basic Course

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

Basic Course

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

【Practice question】Sum up values that meet a condition_

Practice Course

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

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

Basic Course

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

Basic Course

  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

Basic Course

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

To the top