归档： Cordelia
-
How to Insert a Formula to Do Calculations in Microsoft Excel
Editing a worksheet referring to total amount or commercial profit usually needs some calculations. If it’s a complex operation, you may expend much time on it and the result could still be wrong. So how about letting Excel help you out? I’d like to share a quick guide of entering formula in Microsoft Excel here. […]
-
How to Insert Sparklines (mini charts) in Microsoft Excel
Sparklines are the mini charts in Excel cells that using simple and small graphs to present the status of data intuitively. Let’s see how to create and insert a sparkline inside a specific cell. The sheet below shows the incomes of A and B from January to December. Now I want a more intuitive view […]
-
How to Enable or Disable the Camera in Windows 10
Many computers now come with their own cameras, so you can use them to record videos or video chat with your friends and family. But the camera also involves issues of privacy and security, and it is best to turn it off when not in use. So how do you turn the camera on or […]
-
How to Encrypt Your Excel Workbook with Password
An Excel File may contain some important data and information. To prevent peeking, you can encrypt the Excel workbook with a password to protect the data in it. Just follow these steps: 1. Open the file you want to encrypt. Click File on the top-left corner of Excel, tap Info on the left sidebar and […]
-
How to Modify the Name Extensions of a Batch of Files in Win 10
When you get a batch of files on the computer with incorrect or unwantted name extensions, you can right-click each of them to Rename the suffix. But by normal means you can only rename one file at one time, if there are many files, it will become troublesome and take a lot of your time. […]
-
How to Batch Modify the Format of Numbers or Letters in Word
Sometimes you may need to change the format of all the numbers or letters in a Word document for typesetting purpose. If the document is not very long, it’s no problem to do the work manually, otherwise you’d better try another way to batch modify the format. One simple solution for this situation is Find […]
-
How to Insert a Picture as the Background of Excel
Working on the same sheet all day long and dealing with tons of data can be very exhausting. You may consider bringing some new colors to refresh the tired eyes. Changing the background seems like a good idea. 1. Switch to Page Layout tab and click Background in Page Setup section. 2. Then a window […]
-
How to Find the Maximum or Minimum Value in Excel
To find out the Maximum and Minimum value in a long list of data in Excel, one effective way is sorting data at first and then find the one you want in the beginning or in the end. But if you don’t want any change to the order of the data, there’s another simple method. […]
-
How to Clear the Format of a Table in Microsoft Excel
Sometimes you may not be satisfied with the current format of an Excel sheet and want to reconstruct it from the beginning. Clearing the format at once is the best idea at this point comparing to cancel each operation you’ve done. So how to do it exactly? 1. Drag your mouse to select the whole […]
-
Why Your Computer Screen Flickers and How to Fix It
When using a desktop computer, you may encounter a situation that the screen flickers constantly, which will seriously affect the normal use of the computer. So how to solve this annoying problem? In general, screen flashing rarely appears on a computer monitor in good condition, if you slip up, you can consider from following aspects […]
