归档： Sandra
-
How to Create a Gradient Slide in PowerPoint
Most of us would not set the background color of the slide. Or just set a pure color. Actually, we can create a gradient effect to beautify our PowerPoint slides. Go to the Design tab and choose Format Background. Check the Gradient fill in the Fill list. We can set the numbers of gradient stops, […]
-
How to remove all hyperlinks in Excel?
In our today’s tutorial, we’ll learn how to remove multiple hyperlinks from an Excel worksheet at the same time. If we want to remove hyperlinks but keep the text. We can select all the links and right-click to choose Remove Hyperlink in the list. Or we can highlight the hyperlinks area and click on Remove […]
-
How To Use Advanced Filters In Microsoft Excel
When we talk about the filters in Excel, many people know that it can quickly find information or data that fits certain criteria in the clutter. In addition to the filter, there is a feature called an advanced filter. Someone may not have used it, but what does this advanced filter do? In our today’s […]
-
How To Create Dynamic Table in Excel
We’ve known how to create a dynamic graph in Excel. In our today’s tutorial, we are going to know how to create a dynamic table in Excel. Here is a fruit sale table from Monday to Friday. We first select the table area and press Ctrl + T to create the table dialog box. Go […]
-
How to Prevent Duplicate Entries in Excel?
Duplicates would be one of the reasons for wrong data entry. So, how should we prevent duplicate entries in Excel when entering data? Let’s take an example. Here is a school report. Now we need to prevent duplicate names in the Name column. Highlight the name column and go to the Data tab. Choose Custom […]
-
How to Compare Two tables in Excel
We have learned a tutorial on how to compare two Excel worksheets side by side. But if we want to compare two tables in Excel, I mean the two tables are in one Excel worksheet, is there a fast and simple method? There is. Let’s pick a simple example. Here are two monthly test reports […]
-
How to Batch Add Units to Cells in Excel
There is a list of numbers, and you need to add units to each cell. Will you add these units one by one? However, if there are too many cells, the manual method will be cumbersome. Now, we are going to learn a trick to batch add units to cells. Let’s take “kg” as an […]
-
How to Use the YEARFRAC Function in Excel?
How time flies. Do you know how long has 2022 passed? There is a built-in function in Excel called the YEARFRAC function. so, let’s explain how to use the Excel YEARFRAC function. Syntax =YEARFRAC (start_date, end_date, [basis]) start_date: This is the start of the period. It should be entered as a serial date, not a […]
-
How To Reset Network Settings in Windows 10?
If there is something wrong with your network or when you encounter a networking issue. Maybe you can try to reset network settings. Find the internet icon at the bottom of your computer and right-click on it to choose open Network & Internet settings. Or you can also open this window in Windows Settings. Scroll […]
-
Powerful Word Templets for You
We always search for free templates like flyers resumes or business cards online. Actually, we can find almost every kind of templets just in Microsoft Word. Click on File. Choose the second one [New]. You can search for online templates here. Click on the Pizza Menu and create it. Now we got a Pizza Menu, […]
