Categories：Excel Tips
-
Excel 2016 Tutorial: 10 Basic Concepts in VBA
Before we manipulate the VBA code, we should have a preliminary understanding of some concepts in Excel VBA, which will help us learn Excel VBA well. If we count the concepts in VBA, it is estimated that we will not be able to finish it in 10 articles. Therefore, only the most basic concepts will […]
-
Detailed VBA Excel Tutorial: From Entry to Master
Among the many parts in Excel, VBA is the most important and difficult part to learn. VBA can achieve almost any function, from simple data processing, to batch data analysis, and interaction with other Office software, and even interaction with the operating system to achieve complex functions, VBA can almost do it. So what is […]
-
How to Convert a Picture Table to Excel
Have you ever had this kind of experience at work? You need to make a table of paper or pictures into Excel. Are you typing little by little in Excel? This is too much trouble. Today, the author will share with you two useful websites. These two websites can recognize the picture table into the Excel table. This can […]
-
Nine Common and Basic Excel Functions and Formulas
Familiar with Excel function formulas can help us to complete work more quickly and efficiently when processing data. For ordinary people, they only need to master some commonly used formulas and complete daily office work. Today, the author will share with you a few simple and practical function formulas. 1. Rank Function =RANK(F2,F:F) This function […]
-
Ten Useful Microsoft Excel Shortcuts You Should Know
Familiar with the shortcut keys in Excel can make our work more efficient. We all know that Excel has a lot of shortcut keys. But today the author will share you ten very useful shortcuts. Each one is super easy to use. You’d better learn it! 1. Percentage Format Shortcut Keys: Ctrl + Shift + […]
-
Methods To Insert Euqal Approximately Symbol
When we have to insert some special symbols in Excel, but there is no shortcut key for us to use. The article will show 2 methods to help you find these special symbols. Let’s take equal approximately symbol as an example. Method 1: Insert Approximately Equal Symbol First, open the form you want to edit. […]
-
How to Sort Data by Font Color in Microsoft Excel
When editing a worksheet, sometimes you might change the color of the font to make the it more readable. And in some cases, like analyzing monthly sales data, you need to sort data by font color in Excel, which could help to understand your data better, quickly find what you want and make more effective […]
-
How to Compare Two Excel Worksheets Side by Side
If you want to compare two worksheets with similar or related data, switching to one window then switching back is apparently not the best idea. Let the two worksheets both display on the screen side by side. You can make a more intuitive and convenient comparison. You may know that Windows already have the feature […]
-
How to Insert a Hyperlink to Microsoft Excel
You’ve probably seen some tables containing hyperlinks in which you can click those texts with underlines to open a new web page and view more information. Inserting hyperlinks to Excel is actually a very simple yet pratical trick. Let’s see how to do it. 1. Select the cell you want to add a hyperlink. 2. […]
-
3 Methods to Wrap Text in Microsoft Excel
Microsoft Excel doesn’t wrap text by default, no matter how much text you enter in one cell. This could lead to the content of cells beside being covered, and finally affect the layout of the entire Excel spreadsheet. To avoid this , you can try these methods to wrap text in Microsoft Excel manually or […]
