Categories：Excel Tips
-
How To Extract Specific Substring In Microsoft Excel
In daily work, we sometimes need to extract the characters or text we need from some information or data. When it comes to character extraction, we have to mention the three string functions LEFT, RIGHT, and MID. Ok, let’s get start to learn how to use them. Syntax: LEFT(text, [num_chars]) RIGHT(text,[num_chars]) MID(text, start_num, num_chars) The […]
-
Six Microsoft Excel Chart Tips & Tricks
After we have completed a chart, have we considered such a question, is this chart “professional” enough? The “professional” mentioned here actually also represents an attitude, a rigorous attitude towards work, an attitude of paying attention to details and pursuing exquisiteness and perfection! Today Sandra would share with you guys a few tips to make […]
-
Useful Excel Tricks for Conditional Formatting
As we know that Conditional Formatting can easily spot trends and patterns in your data using bars, colors, and icons to visually highlight important values. But in fact, many people still ignore that conditional formatting is a very useful tool. So today, Sandra would share several tricks for using Conditional Formatting. Highlight Duplicate Data Select […]
-
Excel 2016 Help: Solutions to 7 Common Problems
In our daily using Microsoft Excel, we can often encounter some knotty questions. This tutorial is a guide to tell you how to do it. Q1：Why these 0 disappeared？ When you enter a string of numbers starting with 0 in the cell, you will find that all the zeros at the beginning are gone. You can […]
-
12 Excel Date Entering Method and Tips
Entering a single date is easy, but what about hundreds or thousands of date data? If you can only enter the most basic manual input, or a “ctrl+;”, it is really difficult to quickly complete the input work. In fact, there are 12 methods for date entry, and different methods are suitable for different entry […]
-
How To Make A Progress Doughnut Chart In Excel
The doughnut chart is a one kind of pie chart. It’s very easy to understand, and you can always see them in news or business report. More important is that doughnut chart is extremely easy to create. Let’s get started. Basic Table We need to prepare a basic table first. Take an example like below. […]
-
How to Create A Barcode in Microsoft Excel？
When we go shopping, we can always see the barcode of the product. Do you know how these barcodes are made? Today the author will teach you how to make commodity barcodes in Microsoft Excel. However, the product code needs to be obtained by applying to the relevant department. The author here is just teaching […]
-
Excel Tips and Tricks of Filter Function
There should be no one who doesn’t know how to use Excel’s filter function. But being able to use it does not mean “Efficient”. In many cases, because you don’t know the method, you will spend extra time on unnecessary steps. In today’s article, Sandra will introduce 7 tips of quickly selecting cell to everyone, […]
-
How To Quickly Delete Blank Rows In Excel?
Yes, you read that right, this article is to share how to delete blank rows. Have you started to think about why there is such simple content? Come on, It’s not so easy as your thinking. I guess most of you guys choose to right-click the row and delete it. Let’s try the better and […]
-
How To Create Attendance Sheet In Excel
The attendance sheet records our attendance records such as our usual commuting, being late, leaving early, absenteeism, and asking for leave, and is also the proof of our salary. Today, the author will share with you guys how to use Excel to make a powerful attendance table, which can not only record attendance, but also […]
