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 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 […]
Some changes in Microsoft Excel 2013
Along with the continuous development of technology, software applications are also upgraded and improved strongly. And the tool that can't be talked about is Microsoft Excel. Since its inception, it has become an indispensable working environment in office computing. Until the following versions are released, they are integrated with more user support features. So what's […]
Common errors in Excel and how to fix them
In the Microsoft Excel environment, after manipulating data, some strange characters may appear, which are some errors we accidentally create. To better understand this problem, the following article will help us make the most complete statistics of common errors in Excel. 1. ##### Width error Reason: When the data cell lacks width. When entering negative […]
Common keyboard shortcuts in Excel
To make your work more professional as well as save more time, the keyboard task is a necessary condition. Keyboard shortcuts will be a great assistant for you to complete your work. And the following article will list some of the most common keyboard shortcuts in Microsoft Excel version 2013, and basically they are supported […]
How to quickly number ordinal in Excel
Numbering in Excel is one of the basic operations when you work with data tables. However, up to this point, there are still a lot of people who number manually, so it is very time consuming. So, to take advantage of the features available in this application, today I will show you more specifically how […]
How to print any document selection in Excel
On a document file that is dozens of pages long but you only want to use and print a part of that document, how do you do that? There will be different ways to handle it, some people will retype that part of the text, some people will copy to a new File and then […]
How to quickly number pages in Excel
Are there many Excel users who don't know if Excel data needs to be numbered or not? Most, in many cases, you don't need to type. However, there are also cases where you need to number the pages to make them easy to distinguish. So how to number pages in Excel is also a question […]
How to write italic with multiple angles on Excel
Sometimes at work, you need to create italic lines in a certain format in Excel tables. However, you do not know how to do? You are completely assured. It will not be difficult if you follow the steps below that I am about to show you. Excel is one of the working tools that is […]
How to close parentheses and highlight negative numbers in Excel
Excel is known as a spreadsheet that is used by many people in their daily work, especially for those who work in the accounting field. When you work with Excel, it allows you to use many different types of numbers. Therefore, so that when looking at the spreadsheet, it is easy for readers to distinguish […]
How to insert text and images in Excel
When using Excel, you have a table of data, you want to stamp these data as your own. To do this, you need to insert a watermark logo in Excel. Your text, logo or image when inserted into the spreadsheet will be blurred under the text background. The article below will help you do just […]
Instructions for aligning Excel margins before printing
When using Excel to print data to a computer, to keep the document in good shape and not skewed, you need to align before printing. This is a very necessary condition, but some of you still do not know this. The article below will help you with that. In this article, I guide you to […]
Part 1: Instructions for designing crossword puzzles in PowerPoint
In the lecture, or in the competition, the crossword game creates a certain interest and attraction. If you have seen the way to Olympia, the crossword competition is an indispensable part. Designing crossword puzzles is not as difficult as people think. Just the Powerpoint tool is enough for you to do. Powerpoint is available on […]
Part 2: Design a crossword puzzle interface with PowerPoint
In this part, I will guide you to design the interface: crossword puzzle. We use Powerpoint to do this. Please read carefully and follow each step correctly. If you do it wrong, skim it, you may get confused in the next step. You use office 2003, 2007, 2010, 2013 or 2016 all do the same. […]
