If you’ve ever recorded a video on your smartphone, only to find it sideways or upside down, then you know how frustrating it can be to watch it later. If you use Windows, there are a couple of excellent ways to fix this problem.
Source: How to Rotate a Video 90 Degrees on Windows
Win + Ctrl + D
Win + Ctrl + Left
Win + Ctrl + Right
Win + Ctrl + F4
— Read on www.cnet.com/how-to/how-to-use-multiple-desktops-in-windows-10/
MS Excel 2016: How to Change Column Headings from Numbers to Letters
Source: MS Excel 2016: How to Change Column Headings from Numbers to Letters
Excel Comments – Macros
Source: Excel Comments – Macros
‘Kudos: https://www.contextures.com/xlcomments03.html
Sub ResetComments()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Top = cmt.Parent.Top + 5
cmt.Shape.Left = _
cmt.Parent.Offset(0, 1).Left + 5
Next
End Sub
Sub Comments_AutoSize()
‘posted by Dana DeLouis 2000-09-16
Dim MyComments As Comment
Dim lArea As Long
For Each MyComments In ActiveSheet.Comments
With MyComments
.Shape.TextFrame.AutoSize = True
If .Shape.Width > 300 Then
lArea = .Shape.Width * .Shape.Height
.Shape.Width = 200
‘ An adjustment factor of 1.1
‘ seems to work ok.
.Shape.Height = (lArea / 200) * 1.1
End If
End With
Next ‘ comment
End Sub
Bytefusion’s ntpquery seems to be incredibly old, but works. Sadly, it requires initial installation, but the application files will work fine when copied to another system.
Source: How can I query an NTP server under Windows? – Super User
To query the time service:
w32tm /query /status
To change time service:
w32tm /config /manualpeerlist:<IP Address or Host Name>
Tip: After changing service IP/Host, run another w32tm /query /status to confirm the settings show the new time service IP/Host.
What’s the difference between bandwidth and latency? By reading the definition of both terms above you probably already spot the difference between the two, but I’ll give you an analogy to make it easier to understand it if you are still confused. Imagine a highway with 4 lanes where the speed limit is 60 mph. Now on the Internet, bandwidth is the highway, and latency is the 60 mph speed limit. Now if you want to increase the amount of cars that travels through the highway you can add more lanes, but because the highway has too many curves, and bumps, you can’t increase the speed limit so all cars have to travel at 60 mph still. It doesn’t matter how many lanes the highway has, the cars will get to their destination at the same time regardless of the size of the highway!
Why increasing bandwidth increases download speed then you might ask, isn’t that speed? No, by increasing bandwidth you increase capacity not speed. Following the highway analogy, imagine that vehicles traveling through that highway were all trucks with house bricks for delivery. All trucks have to travel at 60 mph, but once they arrive at their destination instead of delivering 4 loads of bricks, 6 loads are delivered because 2 more lanes were added to the highway. The same thing happens when you add bandwidth to an Internet connection, the capacity is increased but the latency (speed ) stays the same.
