Category: Windows Desktop
-
Create the Union of two tables in Excel revisited
In 2013 I published a technique to create the union of two tables in Excel. This post is still very popular and so I am revisiting this topic. Excel 2016 (and possibly Excel 2013 but I have not tested) has this capability built-in and the new method should always be preferred to the one that…
-
Windows 10 Parental Controls don’t work
I have been testing Windows 10 parental controls and they simply don’t work. Many others have this experience. http://answers.microsoft.com/en-us/windows/forum/windows_10-security/windows-10-family-safety-screen-time-limits-not/57689ce1-6638-4d44-8f2f-9af82138375c They simply do not reliably impose screen time limits and in some cases do not even successfully filter porn. A limitation (not a bug) is that filtering only works with IE and Edge so you must…
-
New features in Excel 2016
Excel 2016 has a lot of new features to wow the power user including support for cascading IF statements and a better CONCAT function. There are also a huge number of improvements to the Pivot Table function as it integrates even more closely with the Power BI tool. https://support.office.com/en-us/article/What-s-new-in-Excel-2016-for-Windows-5fdb9208-ff33-45b6-9e08-1f5cdb3a6c73?ui=en-US&rs=en-001&ad=US Anyone who works with Sales will…
-
How long does it take to reset Windows 10?
My own laptop has broken so I needed to borrow a new one from work. I took a pre-used Microsoft Surface 3. After I had transferred my data and applications it began behaving strangely. I ran and found that there were errors. Therefore I decided to reset the Microsoft Surface 3. “Reset” is a feature…
-
Laptops and 2 in 1 for use with a pen
I am doing work in a school and we are developing our mobile device strategy carefully. At present we believe that devices with touch screens that support pen input may be very useful. We have several teachers who find that pen input on the Microsoft Surface range transforms the way that they work and want…
-
What matters is WordPress and Office 365
Two years ago I placed a bet on what matters in IT and I said it was WordPress and Office 365. I think I won. WordPress powers 25% of the web and the new REST API coming out later this year will drive that upwards. There is a good article that discusses this here. Office…
-
Adding a MicroSD card to a Surface Pro 4
I have a Surface Pro 4 with a 256 GB SSD and I am running a couple of virtual machines for development purposes. Each time I snapshot them it uses more storage and I am running low on space. To increase the storage space I have purchased a 128 GB Kingston MicroSD card these come…
-
[Fixed] Windows 10 roaming profiles break Edge and other packaged applications
— Update 2017-12-15 — I think Roaming Profiles are now deprecated. I will be moving all my users to Local Profiles supplemented by User Experience Virtualisation (UE-V) over the next 12 months. See comments below. — I have recently been imaging Microsoft Surface 3 computers for use by staff in a school. All our staff…
-
Edge and packaged apps won’t launch in Windows 10
We have a Windows 7 domain and don’t use any packaged applications. These were introduced with Windows 8 and allow the secure distribution and installation of apps from an app store. Windows 8 and Windows 10 both give access to the Windows Store and it is (or will be) possible to have a Company Store…
Dr James Bayley 