归档： Sandra
-
How to Calculate Age from Date of Birth in Excel?
In our today’s tutorial, we’ll learn how to get age from birthday in Excel. We of course make a formula to compute the ages quickly. Let’s check this out. Here is a worksheet that contains several dates of birth. Type [=DATEDIF(B2,TODAY(),”y”)] in cell C2 and press Enter key. Use the fill handle to get all […]
-
How to Send Mass Email from Excel?
Are you looking for one software to help you send emails in bulk? Someone may say that just need to save these email addresses into a group and then mail them. Come on, every email platform can do this, but the prerequisite is that you allow all the content of emails is the same. Suppose […]
-
How to Create a Bubble Chart in Excel?
There are many kinds of charts. Different charts present different effects. The bubble chart can visually show the relationship between the three variables. In this article, I will introduce how to create a bubble chart in Excel. Take this table as an example. Click any blank cell and click insert, then Scatter or Bubble […]
-
How to Lock Computer Screen?
It’s inevitable that we need to go to the bathroom or make a cup of coffee or go to a meeting in the workplace. To prevent our computers from being viewed or manipulated by others, locking computer screen is a good choice. So how to lock the computer screen? We had talked about this in […]
-
How to Generate Random Numbers in Excel
Have you got the usage of the CHOOSE function in Excel? We learned this in our last post. We will continue to use this function today. Suppose we need to get a list of random serial numbers in Excel. What should you do? Let’s check this out. Using the RAND function to get random numbers […]
-
How to Use the Choose Function in Excel?
Powerful Excel functions can always save us much time, in our today’s tutorial, we are going to learn a new Excel function—the CHOOSE function. The Excel CHOOSE function returns a value from a list using a given position or index. Syntax: Choose (index_num, value1, [value2], …) index_num: The value to choose. A number between 1 […]
-
How to Add Borders Automatically to Cells in Excel?
We usually add borders to cells by clicking on the borders button. Have you ever tried to add borders automatically on your worksheet while you are entering values in a cell? This trick can improve your work efficacy and funny. Let’s check this out. Select the area where we need it and go to the […]
-
How to Fix a Black Screen with Just a Cursor?
Why there’s only a cursor on your desktop screen when you start up your computer? So, in our today’s tutorial, we’ll learn how to solve this problem. Let’s check this out. Method 1 Press the Win key and R together to open the Run Window. Type “explorer.exe” in the open box. Hit OK. Method 2 […]
-
How to save a PowerPoint slide as a picture?
We learned how to extract images from PowerPoint in the last tutorial. But do you know how to save a PowerPoint slide as an image? Here we go. Go to the File and click on Save as. Save as JPEG File Interchange Format (*.jpg) Choose all slides or just the slide you want. We choose […]
-
How to Extract Images from PowerPoint
Are you still right-clicking and saving the pictures in PowerPoint one by one? if you want to extract only one or two images, you can save them in this way, but if there are lots of pics? In this article, we’ll talk about a way to extract images from PowerPoint in only several seconds!! Find […]
