Category: Windows Desktop
-
How to add a “sleep” button to a Microsoft Sculpt Ergonomic Keyboard
This post tells you how to remap a the “pause” key to “sleep” if your keyboard does not have a “sleep” key. This is really useful because there is no easy keyboard shortcut in Windows 11 to send your computer to sleep. Put it in your startup folder Windows + R > shell:startup When you…
-
Fixed: Microsoft Teams Meeting button missing in Outlook Desktop
My daughter’s lap is 5 years old and started misbehaving. I advised her to “reset” it and do a clean install of all the applications that she uses. After installing Microsoft Teams and then Microsoft Office the “Microsoft Teams Meeting” button was missing in the Outlook Desktop application. On inspection of Outlook I found that…
-
Will Windows become a Linux emulation layer?
Amid the tedium of the new normal, a fun article to read. The argument is that Microsoft’s present and future is cloud services and therefore maintaining the Windows operating system will become a tedious expense that is better passed to the open source community (ie. people who write and test code with no expense to…
-
How to add a row number to an Excel table 2020 using Power Query Editor
Back in 2013 I wrote post on how to add a row number to an Excel table. This post is still popular and the method still works well. But it is now 2020 and I would do it differently. Every Excel power user should become familiar with the “Data” tab which gives access to Excel…
-
Fixed: HP Photosmart C5100 Only Prints Last Page of Document
If your HP Photosmart C5100 or similar printer has started only printing the last page of any document then you have a issue with newly updated drivers. The standard steps to resolution are, Run the printing troubleshooter Delete the printer, remove the drivers and reinstall If you have tried these and they did not work…
-
Power Query: How to load only fresh rows and create an Excel history table
I have previously written about the powerful ETL (Extract, Transform and Load) functions that are now in Excel Office 365 desktop edition. We have seen how we can combine tables and unpivot data (Excel articles). In this article I will show you how to create a history table for imported data. It is very common…
-
Next steps in Excel ETL – learning M
Excel 365 Get and Transform Data (was Power Query, actually ETL) allows you to use the M language to create custom columns. Naturally enough I hoped with would either be Excelish or JavaScriptish but no, because it is specialised for report writing it is quite different and you have to learn a new language. Here…
-
Excel ETL – import multiple CSV files
I have previous blogged on how to unpivot data using Excel and Excel 365 (was Excel 2016) just keeps getting better and better. It can now do ETL (Extract, Transform and Load) operations that used to require SSIS. This article tell you how to import multiple CSV files in one operation. (for example, bank statements).…
-
Windows 10 Creators Update: How to turn off focused inbox
If there is one thing that is guaranteed to make me fume with anger it is vendors mucking about with my email. I think that ordinary home users should use Office 365 and Microsoft email services. Outlook.com offers you a free mail account with an *@outlook.com address. You can also use it with other addresses…
-
Using Excel 2016 to unpivot data
Normal people, by which I mean those who don’t process data all day will often create data that is present in a crosstab table. This is a poor structure for storing and processing information. We say that its “denormalised” because the three different columns “Europe”, “USA”, “Asia” contain information of the same type – “budget…
Dr James Bayley 