Giới thiệu
hocvietcode.com là website chia sẻ và cập nhật tin tức công nghệ, chia sẻ kiến thức, kỹ năng. Chúng tôi rất cảm ơn và mong muốn nhận được nhiều phản hồi để có thể phục vụ quý bạn đọc tốt hơn !
Liên hệ quảng cáo: trienkhaiweb@gmail.com
How to save a text file in word as an image
Nowadays, there are many people working on computers. Therefore, the possibility of document files being lost due to theft is very likely. Therefore, they always want to find a way to protect those documents. Depending on the needs of each person choose for themselves different protection methods. Today, I will share with you how to […]
How to hide/show important text in Word
Currently, working on a computer is a familiar job for many people. Therefore, the exchange and sending of text files is also more and more popular. However, there are cases where your document file has important issues, you don't want that person to know that information. Both do not want to delete that information, and […]
Basic functions commonly used in Excel
Are you a person who regularly uses Microsoft Excel for your work purposes? So do you know the functions in Excel or not? To help you work faster, the following article will provide the most complete statistics of the basic functions in Microsoft Excel . 1. Logical function AND function: Syntax: AND (Logical1, Logical2, ….) […]
Use the SUMIF function to calculate sums containing conditions in Excel
You are calculating the total wages to be spent on employees of a company A this March. However, the payroll includes the list of team leaders and department heads. That, makes you have to choose very time consuming. So why don't you use the SUMIF function to calculate it quickly. However, how to use it, […]
Use the SUMIFS function to sum operations containing multiple conditions
You have just been assigned the task of calculating a table of numbers. In addition to simple calculations, that data table also has extremely difficult summations with two to three conditions attached. You don't know how to quickly deal with those metrics. So let Web888 guide you to do it quickly and accurately using the […]
How to use the COUNT function- count function on Excel
When you work with numbers on Excel spreadsheets, it is inevitable that you will inevitably use the count function. Accordingly, the COUNT function is one of the most basic counting functions used a lot by office workers. So, for those of you who are new to spreadsheets to understand more about this function. Today, Web888 […]
How to use the count function containing the condition COUNTIF
When working with Excel, you cannot avoid using the COUNTIF function. Because this is the function that contains the condition that is used a lot. However, so far, many of you are still quite confused with this function. So, to help you better understand how to use this function, today Web888 will show you how […]
The COUNTIFS function counts with multiple conditions
In the process of working on Excel, you have to be familiar with a lot of different math functions. There are functions you rarely use, but there are functions you must use often, such as the COUNTIFS function. Many of you will be quite unfamiliar with this function, but it is really very effective for […]
How to use the IF function in Excel
If Word is a tool used to edit documents, with Excel it is in charge of solving math operations on spreadsheets. Usually, for simple math, you just need to use simple functions. However, in some conditional operations, you are forced to use more difficult operations such as the IF function. So, how to use this […]
How to use the Right function, the Left function in Excel
When you need to process strings in Excel, you can't help but mention the Left and Right functions. However, not everyone understands and knows how to use these two functions. Therefore, today Web888 will guide you specifically to understand more and be able to use these functions in the process of working with Excel spreadsheets. […]
View current date with TODAY function in Excel
When you process data that needs to be calculated to the current date and time, you often use the Today function. There will be many people who think that the present moment can be grasped by everyone. However, not only does it update the exact time, but it also applies very well to the calculation […]
Use the MAX, MIN function to find the maximum and minimum value in Excel
In the process of tabulating statistics, there are times when you have to find and show the maximum and minimum values of that data table. If the table has little data, you can find it manually. However, with long data tables, it takes time to find them. Therefore, the fastest and most accurate is to […]
How to use the AVERAGE function to calculate the average value in Excel
When you work with Excel, you must calculate the average of the values in the data table. So what will you do in the meantime? Instead of using a click calculator, you can use functions to make calculations in Excel faster. In this case, you can use the function to calculate the mean of AVARAGA. […]
How to use the SUMIF function in Excel 2013
The Sumif function is a conditional sum function. This function is used quite a lot in study and work. By using the sumif function, you can perform calculations with one or more conditions. In this article, I will show you how to use the sumif function in Excel 2013. However, if you use Excel 2010, […]
How to use the Round function in Excel
When using Excel to summarize data, calculate the average, you will need to use the Round function. The Round function is the rounding function in Excel. When using the Round function, you will get the most rounded value in Excel's data cells. In this article, I will share with you the formula and illustration of […]
Some functions to calculate accrual and depreciation of assets in Excel
To help you work faster when calculating in Excel. The following article will summarize the most detailed functions for calculating interest, accumulated principal, and asset depreciation on Excel. first . CUMIPMT . function Function: calculate the accrued interest for the loan from the first period to the last period. Syntax: CUMIPMT (rate, nper, pv, start_period, […]
Distribution functions in Excel
The terms normal distribution, exponential distribution, hypergeometric distribution, … must be very familiar to us. But how to be able to calculate faster in Microsoft Excel environment? With the full support of Excel functions, you can quickly get the results you want. And the following article will introduce more details about functions in the distribution […]
Function to calculate standard deviation, probability and amortization in Excel
With strong support from Microsoft Excel version, we can easily calculate sample standard deviation, amortization and probability using built-in functions. The following article will share more about functions and syntax of functions. first . STDEV . function Function: Helps us to estimate the standard deviation based on the sample. The standard deviation is a measure […]
Summary of time functions in Excel
To help you quickly and accurately manipulate time functions in Excel. The following article will summarize how to use some basic functions such as Minute, hour, day, now, today, … as well as how to set the default time in Excel. first . Minute function Function: Converts some time value to one minute in the […]
Introduction to chart types in Excel 2013
When using Excel, you have data that you want to represent graphically. A histogram is a visual representation of numeric values. Excel supports you with many types of charts to display the data to make it easier for you to understand the meaning of the numbers. In this article, I will introduce you to some […]
