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
Instructions for drawing charts in Excel
With reports that have many related data to compare, the easiest way to show it to others is in the form of a chart. However, have you understood the operations to draw charts in Excel yet? The following article will detail how to draw the simplest charts on Microsoft Excel 2013 version, and basically they […]
Instructions for drawing pie charts in Excel 2013
When using Excel, there is a lot of data that you need to represent in a chart. Excel supports you with many types of charts to represent your data such as pie charts, bar charts, line charts. In this article, I will guide you to draw a pie chart. Here, I guide you to draw […]
How to draw a line chart in Excel 2013
When using Excel, you want to turn a table of data into a chart to be more beautiful and easy to follow, you need to draw a chart in Excel. Line charts in Excel, also known as line charts, help us to see the fluctuations of data over time. In this article, I will guide […]
Simple manipulation with rows and columns in Excel
After creating a fixed table in Excel's worksheet, we have the option to change the size of that table easily by inserting or deleting the rows and columns you want. The following article is a brief and complete summary of steps to help you work faster when handling your work. And they are supported on […]
How to create and edit tables in Excel 2013
When using Excel, to make it easier to find, calculate, manage and analyze data, you need to create a table for the data in Excel. Creating a table in Excel is extremely simple. The following article will guide you to create and edit tables in the simplest and fastest way. In this article, I do […]
Instructions on how to merge cells in Excel
Sometimes in the process of working with Excel spreadsheets you encounter a form that needs to merge cells. Therefore, you feel worried because you have never done it, so you don't know how to do it? Rest assured, the following article I will guide you specifically on this operation. When you are new to Word […]
Instructions for inputting and editing data in Excel
Excel is a widely used electronic table processing tool today. When you start using Excel, you need to learn how to enter and edit data. The following article will guide you. The article consists of 2 parts: Input operations in Excel Edit data in Excel 1. Input operations in Excel Enter data in the cell: […]
How to freeze rows and columns in Excel 2013
When using Excel, you work with Excel files that have too many records. At this time, viewing, comparing and contrasting data can be time consuming and error prone. The following article will help you fix the columns that need to be compared to shorten the time and bring more efficiency. This is an article where […]
Instructions to check the input data of a cell in Excel
When you import Excel data, sometimes you need to check some conditions before importing. This will put you in control of your data. In this article, I guide you to create conditions to check data before importing for Excel 2013. However, if you use Excel 2007, 2010, 2016, the method is similar. The article consists […]
How to convert rows to columns and vice versa in Excel.
When using Excel, the data presented is not beautiful. You want to convert data from rows to columns and from columns to rows to be more beautiful. In this article I will guide you. In this article, I show you how to convert rows to columns and vice versa in Excel 2013. However, if you […]
Instructions on how to change the color of cells according to the value in Excel
When you have to work with too much data in Excel, to avoid mistakes, you need to distinguish those data. Excel supports you how to color cells according to the desired value. In this article, I will guide you to change the color of the cell according to a simple and fastest value. Here, I […]
How to create cell comments in Excel
When using Excel, there is a lot of data that you cannot remember all. Excel supports you to create comments (Comment) for cells. This will make it easier to review and remember the data. In this article, I will guide you to add, edit, and delete comments in Excel. Here, I add, edit, delete comments […]
Split data from one column into two columns on Excel
Sometimes in the process of working, you encounter Excel document files that need to be processed. For example, split data in this column into a new column Excel. At that time, you don't know how to solve the manual separation job faster. Then don't worry too much about it, the following article I will guide […]
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 […]
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, […]
