归档： Sandra
-
How to Fix Error Code 0×8007007e in Windows 10
Have you ever met such an error code 0×8007007e in Windows 10? Today, I’m going to print some webpage, then the error 0x8007007E appears. The error 0×8007007e usually appears when software and drivers are not compatible with the update you’re trying to install. To resolve the error, we can do as following. Press the Win […]
-
How to Fix Weird Font Problem in Windows 10?
One time, I just emptied the D drive of my computer and rebooted it, then the fonts on my computer became so strange. I know that our computer has smooth fonts by default. But sometimes it would be changed, so how to fix weird font problem in Windows 10? How to improve the look and […]
-
How to Sum Every Other Column in Excel?
In our last tutorial, we learned the way of how to sum every other row in Excel. Let’s continue this in the second part, knowing how to sum every other column in Excel. Here is a random number table. Let’s get the sum of the odd columns as the screenshot below first. Type this =SUMPRODUCT((MOD(COLUMN(A1:G10),2)=1)*A1:G10) […]
-
How to Sum Every Other Row in Excel?
As we all know, the sum function can help us easily get the sum of a row or column, or even an area. But on special occasions, we need to sum up every other row in Excel. So, this is today’s point, how to sum every other row in Excel? Let’s take an example. Here […]
-
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 […]
