归档: Sandra
-
How to Schedule Shutdown Windows 10?
How do you set a timer to shut down your Windows 10 computer? Or how to turn off your computer at a certain time? There are several ways, but in our today’s tutorial, I’d like to share with you guys the easiest one. Press the Win key and R key together to open the Run […]
-
How to Stop Sharing a Folder in Windows 10?
The folder sharing function of Windows 10 is very convenient and easy to use, but it also increases the security risk of the computer. If you need to disable the default folder sharing, you can do so by following the steps below. Find the search button on your desktop. And type Computer Management to open […]
-
Ten Tricks for AutoFill in Excel You Should Know
I want to ask you guys a question at the beginning of this tutorial. How do you enter a serial number from 1 to 10 in Excel? Type 1, 2, 3… one by one? If you do so, the ten hidden tricks are tailored for you. No.1 Enter A Serial Number from 1 to 10 […]
-
How to Convert PDF Files into Excel?
In our daily work, we may need to convert some types of files into another one. How to convert different types of files quickly? There are three ways to solve this problem. Here we go. No.1 Online Converter You can search online there are many free converter websites. These sites are easy to be used. […]
-
How to Clear My Clipboard History in Windows 10?
We always use the shortcut keys Ctrl C and Ctrl V to copy and paste. The windows clipboard saved our copy paste history. You can copy multiple items in it. Many people even don’t know how to view clipboard history. So today, we are going to learn how to use and clear clipboard history in […]
-
How to import XML File into Excel in Seconds?
XML is the abbreviation of Extensible Markup Language. It’s a markup language and file format for storing, transmitting, and reconstructing arbitrary data (From Wikipedia). We can usually see the XML file format on the web, so we can’t use this file directly. What we are going to learn today is how to import XML file […]
-
How to Set the Excel Background?
Setting a picture as your Excel background can add some personality to your worksheet. It’s quite easy. Let’s get started. Go to the Page Layout tab and click on Background. There are three ways to insert pictures. Choose the picture you like to be the worksheet background. This step can just change the current worksheet, […]
-
How To Create Small Multiple Line Charts in Excel?
Creating a line chart in Excel is easy. Just select the data area and go to the Insert tab to choose the insert line chart. There is a worksheet of fruit prices for five months. We can get the line chart. But we are going to learn another kind of line chart to show the […]
-
How to Add Borders in Excel Automatically in Two Conditions
We usually select the cell(s) where we want to add the border firstly, then click the border list arrow from the Home tab to add borders. And click No Border to remove borders. Today, we are going to learn a totally different and useful way to add or remove borders automatically. We first select the […]
-
How to Use the UNIQUE Function in Excel? ——Easy Tutorial
Time to learn a new function. Today, we are going to learn the UNIQUE function. The UNIQUE function can help us returns a list of unique values in a list or a range. So, if you need to extract unique values from the range, you can use this function. Syntax: =UNIQUE(array,[by_col,[exactly_once]) Array: It represents a […]