Archive List for Basic Course

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

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

Create, select from, and deactivate drop-down lists

Basic Course

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

Basic Course

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

To the top