归档: Sandra
-
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 […]
-
How to Do When Shut Down Button Is Missing
Have you ever encounter this situation? When you want to click the Power button in Windows 10 start menu. But the Shut down button is missing. So, how to shut down your computer? Press Win and R to quickly open Run Window. Type “gpedit.msc” in the box, and hit OK. Go to User Configuration> Administrative […]
-
How To Increase Virtual Memory In Windows 10
Normally, the virtual memory is set by default in the system. Some computer users would set it to 8G in order to make the computer run more smoothly. But some computer noobs do not know how to set it. so this tutorial would talk about the way in detail. Ok, let’s get started. Right-click This […]
-
How To Change Slide Vertical in PowerPoint
When you open a new PowerPoint presentation, the slides are horizontal by default. However, you can change them to vertical in a few simple steps. Go to Design tab and click on the arrow below the Slide Size. Choose Custom Slide Size in the list. Now, you can change the orientation of slides. It’s so […]
-
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 […]
-
10 Features of Microsoft Word
We use Microsoft Word for daily office work, but do you know what are the features of Word? So, today the author will take you to get a deeper understanding of our daily office partner, Microsoft Word. (1) What You See Is What You Get We use Word to edit the content of the document, […]
-
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 […]
-
Some Common Problems In Automatic Numbering In Microsoft Word
In Word, we often use automatic numbering to add sequences to paragraphs for us. However, we often encounter some weird problems in the actual application process. Therefore, the author will share with you the solutions to several problems that we often encounter in automatic numbering. How To Adjust Space In A Bullet List? If you […]