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 alternate colors in Excel worksheets
You often have to work with a lot of data on Excel spreadsheets. Therefore, you will be very confused because of looking at numbers and data for a long time working. Therefore, so that you do not have to confuse and headache with spreadsheets, you should color alternately. for cells, lines to make the data […]
How to break a line in an Excel spreadsheet
If with Microsoft Word, when you enter content at any position, if you want to break a line, you just need to click the "Enter" button. However, for Excel, you cannot do so. If you don't know how to do it, your "Enter" button is like a "dead" button that can't be done. So, if […]
How to set the time for Excel to automatically save, avoid data loss
For those who often work with Word and Excel, it will be inevitable that the cases are not good or bad. For example, if you forget to save a post, the power will go out, while you are in the middle of composing, the computer will shut down. Therefore, the safest way is still how […]
Classification of Algorithms in Machine Learning
There are many different types of learning algorithms, classified according to many different criteria. For example, based on how that model learns (learning style) or according to function, it can be summarized by the following criteria: Does the training process need human supervision? Supervised (supervised), Unsupervised (unsupervised), Semi-supervised (half supervised) and Reinforcement Learning (reinforcement learning). […]
Instructions for creating Hyperlink in Excel
Hyperlink is a document source, when you click on it, it will be taken to another page or a certain location on the Web. When using Excel you can create Hyperlink to Website, to another Sheet in the same Excel file, link to newly created Excel file and link to Email address. In this article […]
Instructions for creating a list of lists in Excel
When using Excel, there are times when you will need to create a list of values. In it, you can only choose a single value. Then you need to create a List in excel. The following article will help you. Here, I create a List on Excel 2013. However, if you use Excel 2007, 2010, […]
Instructions for setting the default font and font size in Excel
On the Excel application is always installed a Font with the default font size. That is, when you need to use Excel, you open it and it will impose that font and font size for you. Therefore, if it is not the font that you often use, you can change to another more appropriate font. […]
Instructions to add Up Down button for Excel
When using Excel, sometimes you will find it difficult to switch up in excel. Excel supports you with a tool that adds Up Down buttons to help your move be done more quickly. In this article, I guide you to add the Up Down button in Excel 2013. However, if you use Excel 2010, 2007, […]
Instructions for setting a password for Sheet
When working or studying, confidential information is extremely important. You have an Excel Sheet that you don't want to share with others. You are afraid that others will change the information in your Sheet. So, you need to set a password for that Excel Sheet. The article below can help you. In the following article, […]
Instructions for setting and breaking passwords in Excel
With the nature of the work of some people requiring high security, setting a password for the data file is essential, as is in Excel. The following article will guide you in detail on how to set a password for an Excel file in the simplest way on the basis of Microsoft Excel 2013. 1.Open […]
Instructions to show and hide Sheet in Excel
When using Excel, you have too many Sheets that cannot be checked. Unused Sheets will mess up when you manipulate other Sheets. You cannot delete these Sheets. So you need to hide and show Sheet in Excel. The following article will help you. In this article, I show you how to hide and show Sheets […]
How to hide formulas in Excel worksheets
When using Excel, you use a lot of formulas in spreadsheets. However, if you don't want other people to see these recipes, you need to hide them. The following article will guide you. In this article, I hide formulas in Excel 2013. However, if you use Excel 2007, 2010, 2016, the method is similar. Example […]
How to sort data ABC(alphabet) and ascending and descending in Excel
When you work with a long Excel sheet, make sure you have some way to sort the search utility. As now, there are many people who still often use a number of ways such as sorting names in alphabetical Vietnamese alphabetical order or sorting by ascending or descending digits. So what steps do you need […]
How to sort and filter data in Excel
When using Excel, you may have to sort and filter data by a certain criterion to make it easier to compare and search. This is a pretty important function, commonly used in Excel. For spreadsheets that contain a lot of different information, sorting and filtering data will help you find the information you want more […]
Enter data using the Auto Correct function in Excel
In the process of working with Excel spreadsheets, you have to re-enter the same data many times. That way you not only get bored but also waste time. Therefore, to speed up fast data entry in Excel spreadsheets, you should use the Auto correct function. Specifically how to use it, the following article we will […]
Instructions to filter duplicate data in Excel
After filtering the duplicate data, excel is to delete the duplicate data in the excel spreadsheet. If there is too much data, manual data filtering will take a lot of time of the user. The following article will guide you through the simplest and fastest way to filter duplicate data. In this article, I guide […]
Instructions for creating and removing pagination lines in Excel
When working with Excel, you often have too long table data. When you print it out, you must edit it accordingly. This requires you to know how to show pagination lines and remove pagination lines in Excel. This article will help you. In this article, I guide you to create and remove pagination lines in […]
Instructions to hide, show and color grid lines in Excel
Gridlines are translucent lines that appear cells to distinguish them across worksheets. When using Excel, you want to remove this grid or color it for easier viewing. The following article will guide you. In this article, I show you how to hide and color grid lines for Excel 2013. However, if you use Excel 2010, […]
Instructions for copying formulas in Excel
When working with Excel, you often use formulas to calculate. A data table will have a lot of data that calculate the same formula. To save time you can copy the formula without retyping. This article will guide you to do this. In this article, I copy the formula using Excel 2013. However, if you […]
How to enter math and chemistry formulas in Excel
Are you a student or teacher? Want to use Excel to enter chemical and mathematical formulas but don't know how? The following article will guide you. In this article, I show you how to enter chemical and mathematical formulas for Excel 2013. However, if you use Excel 2007,2010,2016, the same is true. The article consists […]
