Updated September 2017
I’m back on Windows 10 because frankly, the latest version of Excel on the Mac is not yet as good as the Windows version. It does gradually get better.
- the cursor doesn’t always hit the right cell. (I’m using a 4K monitor).
- the keyboard shortcuts are a pain in Excel and Word as many things are not so standard from Windows to the Mac
- other niggling things like the J-Walk Power Utility Pak Add-In for Excel won’t run
- and Microsoft Publisher doesn’t run on the Mac. I’d prefer to use Adobe InDesign but you’ve got to go with the flow you know.
- Grammarly won’t run embedded in Word or Outlook for Mac.
- PPTP remote access to the work network doesn’t function on a Mac unless you buy extra software. Apple has eliminated PPTP due to it being less secure than other methods. There is Shimo VPN for Mac which costs nearly $100! Flow VPN might work and it’s free, I will try it.
Here I will comment on Windows. If you support any other computer and are not careful on yours make sure you don’t get Tech Support scammed. Here is a good page for technical people from Malware Bytes labs.
But, then I need to get some of the convenience back from the Mac
- with viewing of files. Using Adobe Acrobat DC and turning on the option to view in Windows Explorer is OK. Otherwise you can’t browse
- for better searching I’m now trying Exselo Desktop. I don’t like that it needs Java Runtime but eventually on my pristine Windows install I’d need to put JRE some day. There is also Lookeen to try. But it’s not free. But I do want to be able to index my network drives.
- Total Commander
- Mouse – Logitech Anywhere MX with Logitech Options works good.
- Keyboard Maestro and/or Key Remapping
- Multiple Desktops – Built-in to Windows 10
I need to rip a website to edit and send off. Though I still need to find the best way. Now I will use HTTrack Website Copier and then convert the HTML files to PDF and do markup on them. The other option is to edit the raw HTML in something and then do a diff so the other company who has the site can see my markups.
Below was last updated December 2013
I am moving towards using Macs more than Windows lately. I even use Mac keyboards on my PCs as I like the same keyboard key size and touch on all my computers including laptops. Mac keyboards are the same on laptops and all other keyboards, the wireless one and the wired one. The wired one just has more keys on the right. Note that Logitech makes nice Mac keyboards with a nice touch to them but the key layouts and spacings are not all the same amongst Logitech and not the same as the Macs.
Refer to this other page I wrote on how to transition from a PC to Mac for a Power User. I’m not considering Windows 8 and have a fast Windows laptop with SSD that I do my media editing on.
My general principle is to simplify things. Coming from many years on Windows and in fact Windows 7 is very usable and efficient. So I’ve tried to incorporate the best of the Mac and Windows into my work.
Here is a good list of essential windows utility by Digital Inspiration from August 2013
But Scott Hanselman’s 2014 Ultimate Developer and Power Users Tool List for Windows is pretty comprehensive and you can probably read it and stop reading this page!
This is not about utilities but about backups.
I have an old Drobo FS (until I sold it on Ebay in around 2014).
And I have a Synology DS1512+
I did have some issues with my Drobo which now seem fixed that I put NAS drives and other faster drives. Originally the Drobo had all Western Digital Caviar Green drives in it.
So my bottom line is, your files are not backed up if they are just on one NAS. The NAS covers for drive failures but if the NAS itself goes awry your data is gone. So you must backup from your NAS into other drives. Either a matching NAS or separate hard drives. Then I recommend taking the drives off-site.
If you have a lot of data it may not be so practical. You are limited by your networking speed and data caps. Services available are Carbonite, Mozy, Backblaze and Crashplan. See this article for a sobering review
Dropbox is a good option for storage and it has become ubiquitous. But don’t just have your files in Dropbox. They should be backed up elsewhere. There is also Sugar Synch
If you are worried about the Government getting your data, the Cloud isn’t the place for your data. Check out Transporter Sync. No don’t as it’s not available anymore as far as I know (2017)
Or you can roll your own storage. More to come on this.
Keyboard and Mouse
I use the Logitech AnywhereMX mouse on all my Windows machines. It is the only mouse that I’ve never had any wrist or arm issues.
As I said above I’m using the Mac Keyboards.
For Your Health
Lighting and the colour of light at night will affect your sleep which then affects your health.
Get f.lux but note (2017) that the latest Mac’s with newer hardware have this built in and also it’s in Windows 10 (display settings, Night Light).
Windows Explorer isn’t great, though better in Windows 7 as you can use the Windows key with the arrows to move the window to the different halves of the screen by holding down the Windows key and an arrow key simultaneously.
The best file manager is Total Commander. It also can compare directories and synchronize them, one way to update backups etc. It also has a very good file renaming feature which is good for digital photographs etc. I purchased it for $34 US some time back expecting to receive a registration code by Email but instead saw that they Email a CD. But I never got the CD. Well, you can use the shareware forever, it is not crippled, you only need to click past the nag screen.
For partition management use EaseUS Partition Manager. It is a free and easy to use program. You won’t have to suffer using Windows Disk Management. And it moves and resized partitions without killing the data. The usual warnings apply to backup first of course!
For disk cloning including to a smaller SSD and even having it SSD aware use EaseUS Todo Backup Free
I use Acronis True Image PremiumÂ for imaging drives though I think I”ll stop soon and go for free options. Likely I’ll shift to saving images with EaseUS Todo Backup.
For file backups I use SyncBackPro
It is very powerful and can be scheduled for backups also.
I use the Microsoft Security Essentials
If you want a comprehensive guide look here on Gizmodo.
Hard Drive Cleanup
To Find the junk on your hard drive (guaranteed you’ll find lots of space).
I default to WinDirStat, which is free, Open Source and does basically the same thing.
There is also Space Monger. You can get the newest one for $20 with a 30-day free trial or get the old version 1.4 which is free.
I have also used JDiskReport as it is light and straightforward though it isn’t as easy to get to files that need deleting.
There is Treesize professional which tracks size and can also find duplicate files. I’m going to try it.
Find duplicate files, the best I’ve found so far is by Funduc Software called Duplicate File Finder which costs $15.
I had a copy of their program Directory Toolkit about fifteen years ago but now use Total Commander to synchronize directories.
I found JDiskReport
For saving files in PDF format use the free Cute PDF writer. (Not anymore in 2017, not needed). They also have other PDF tools if you are not into Adobe original software. An option to the Adobe PDF reader is the Foxit Reader.
This is not needed as much anymore because of hybrid drives and SSDs. There is a defragger called Vopt from www.goldenbow.com which is old but supposed to be very good. Or you can try Perfect Disk. Or, of course, there is the built-in Windows defrag tool.
DVD and Blueray ripping
I was using DVDFab but got tired of all the updates.
I now use the free MakeMKV. Then with the MKV file I use Handbrake to convert it to a windows file.
I inherited a large folder of files that were all for windows so I used a handbrake batch encoder
Then the names were all messed up so I used the Windows program ReNamer to fix up the names. I also make an Excel function to strip out the junk in the names after the four digit years to save me time on the hundreds of files.
The code is below for the Excel VB.
Function test(s As String) As String
Dim yearcount As Integer
yearcount = 0
Dim n As Integer
'while not at end of string
'if number, start counter, if not number reset counter
'if four, exit loop and chop away, keep extension, exit function
‘ check character before year, if not space add it, remove other stuff
For n = 1 To Len(s)
c = Mid(s, n, 1)
If yearcount = 0 And (c = 1 Or c = 2) Then
yearcount = 1
ElseIf yearcount >= 1 And (c = 1 Or c = 2 Or c = 3 _
Or c = 4 Or c = 5 Or c = 6 Or c = 7 _
Or c = 8 Or c = 9 Or c = 0) Then
yearcount = yearcount + 1
yearcount = 0
If yearcount = 4 Then
test = Left(s, n) + “.mp4”
test = s
Leave a Reply