Microsoft says a new Windows 10 update fixes a zero-day vulnerability to a massive, global ransomware attack that uses leaked NSA code.
If you haven’t used Excel’s People Graph add-in yet, you’ll like it if you need to show a quantity of people or a handful of other objects for any reason. It’s part of a recent update of Excel 2016 for both Windows and Mac. Here’s an example:
We have a list of the populations of northeastern US states.
Click anywhere in the list. On the ribbon bar, go to the Insert tab, then in the Add-ins group, click People Graph. (If your Excel screen is narrow, Add-ins may be a drop-down you have to click, first.)
This puts a sample graph on the worksheet. Click it or roll your mouse over the upper-right corner, and you’ll see a couple of buttons. Click the grid-like button.
In the pop-up screen, type a title for the chart, then click Select Your Data. In this example, we’ll select the whole range, from A1 through B10, including the column headers.
Click the green Create button , and you’re done! You may see a message telling you to stretch out the chart so you can see all the data. If necessary, you can zoom out on the page.
If you click the gear button in the upper-right corner, you’ll see options that let you choose the overall format of the chart, how the figure will look, and what shape you get – a person figure, cat, dolphin, diamond, and a few more. Unfortunately, there isn’t an option to use a custom shape.
This time of year, some people’s thoughts turn to major sporting events….. and wagering on them. Because of trademark restrictions, I won’t name any specific one, but some people race owls, so I’ll use a hypothetical “Superb Owl” competition, which gets played in 4 quarters.
This brings us to Microsoft Excel and the worksheet you can download here. Feel free to edit the sheet to insert the teams of your choice. Let’s say the two teams are the Barred Owls from the National Flying Conference, and the Snowy Owls, from the American Flying Conference. As your coworkers place their wagers (you enter the cost of a wager in P8), enter their names into the grid of 100 squares, with each box indicating a possible score. So F10 would be a score of 7-3, with the Nationals leading. If the score is in the double digits, we use just the second digit.
Down columns O and P, enter the score at the end of each quarter. Using a horrific, mind-bending formula that mashes up the INDEX, MATCH, VALUE, IF, LEN and RIGHT functions, column R determines who won at the end of each quarter. Since people can buy more than one square, you can add up their wins and losses down column Q.
Of course this is just for fun and not to encourage gambling. Check your local laws for what is or isn’t permissible. And may the best owls win!
To get up to speed quickly in Excel, check out Excel 2016 Formulas and Functions in 90 Minutes.
If you round numbers in Excel using the Increase Decimal or Decrease Decimal buttons on the Home tab of the ribbon bar, Excel still does its calculations on the full number. Those two buttons are only formatting, and the full number can rear its head elsewhere on the sheet. If you want to really round numbers, use the ROUND function. Its syntax is:
=ROUND(number to be rounded, number of decimal points)
You can also force a number to be rounded up or rounded down regardless of its natural value using the ROUNDUP and ROUNDDOWN functions, which use the same syntax. And if you place a minus sign before the second argument, Excel will round to the nearest 10 value. Here are some examples, rounding the formula of =97/13:
To learn more formulas and functions in Excel 2016, check out my course.
The new Portrait mode in iOS 10 gives your pictures a depth of field that the regular Photo mode doesn’t. Like with a camera that has an adjustable aperture, Portrait mode focuses on the person or object in the foreground and slightly blurs out the background.
You’ll find this feature only on the iPhone 7 Plus because it requires both 12 megapixel cameras. One camera is a wide-angle ƒ/1.8 aperture and the other is a telephoto ƒ/2.8 aperture.
To use the feature, start up the Camera app and slide the mode selector on bottom to Portrait. The first time you do this, it will tell you that the feature is still in beta, so your results may vary.
An indicator on bottom will tell you if you need to move the phone closer or farther away from the subject, and will also tell you if you need more light. As with the regular camera modes, you can tap the subject on the screen and flick upwards to brighten it. When the depth effect turns on, you’ll see the indicator on bottom.
Here is the same shot using the regular Photo mode on the left, and the Portrait mode on the right.
When you go into the Photos app on your Mac, you’ll see a depth effect label on any picture that’s using it. You won’t see the labels in the Photos app on your iPhone.
So how does it work? The image you see on the screen is from the telephoto lens. Simultaneously, the wide angle lens measures the difference between what it sees and what the telephoto lens sees, and creates a 9-point depth map. The camera’s software uses that map to create an artificial depth of field, blurring the background. This is why Portrait mode doesn’t allow you to zoom in or out. If you pinch or spread your fingers on the screen, nothing happens.
If your eyes are sharp and you look closely, you’ll see the effect is a little less than the quality of the depth of field you’ll get with a good SLR. That’s because on a regular camera, you get this effect with one lens that’s bigger. The wider the aperture (lower numbers), the more pronounced the effect will be. But that isn’t to dismiss what Apple has done, and we can expect the feature to improve in later updates.