Convert or flip data between rows and columns in Excel

Convert or flip data between rows and columns in Excel

One of the things that I have to do periodically and always forget how to do is converting rows of data to columns or columns of data to rows. This quite often occurs when I’m collecting data from different sources and want to put them all in the same format in Microsoft Excel. From the 2007 version of MS Excel (I think), there has been a neat feature to enable you to do this. The reason that I always forget how to convert from columns of data to rows and vice-versa is because I expect it to be on the ribbon as a commonly used function but it is not.

Catering for colour blindness in Windows 10

Catering for colour blindness in Windows 10

I came across a neat feature of Windows 10 quite by accident this weekend that will help me with my colour blindness. However, before I found it, I had a lot of frustration trying to “fix” the problem. I was typing away on my computer Friday night and it was just before 3AM when suddenly my screen turned black and white (greyscale). I looked in Windows Color Settings but that was greyed out as it is controlled by my GeForce graphics card software. I had a quick look in the Nvidia Control Panel but couldn’t see anything that would have any effect. I figured maybe a restart would sort it

Switching from HTTP to HTTPS in WordPress

Switching from HTTP to HTTPS in WordPress

This short article goes through the simple steps to move your WordPress website from HTTP to HTTPS yourself without using plug-ins or other tools. With the increased pressure from internet browser manufacturers to move content to a secure web, the switch is important for those wanting a higher search ranking or performing any action other than basic information. There’s no magic involved in this move and I don’t go into details of all the things that you can do, I just show you how to get your website up and running after you have a secured certificate installed. Getting started Make sure you take a site backup and that includes

Five Quality Assurance Testing Techniques

Five Quality Assurance Testing Techniques

We had a very minor release of an application last week as the front end application and the back end procedures were operating double standards. The front end was asking for a value greater than or equal “>=” to a certain value and the back end said the rule only applied to values greater than this amount “>”. It took hours to figure out what was wrong and a minute to fix it. We were looking at the changes that we made in the last release suspecting that a bug must have been introduced at that time. This is because the issue had never occurred before and the application is

EU General Data Protection Regulation (GDPR)

EU General Data Protection Regulation (GDPR)

I’ve been meaning to write for a while from the perspective of website owners and operators about the new European Union’s (EU) General Data Protection Regulation (GDPR) which comes into force May 25, 2018. This is following my previous post “What effect does the GDPR have on my website” in which I looked at cookies. I’ve seen articles pointing out the highlights of GDPR just rewriting the articles using different language so I’ll try not to do that. I will keep it brief, using simple language and where possible will use examples that mean something to website owners. I might not cover everything but hopefully, I will capture the main

Entity Framework Code First Example

Entity Framework Code First Example

In this article, I will walk through an example in an attempt to show Entity Framework Code First. In this Code First exercise, I will install SQL Server LocalDB, create a Visual Studio project, install Entity Framework and then create the database objects (including some test data) through the Visual Studio project using Entity Framework Code First. To start off it is probably worth mentioning what the Entity Framework is and why it is important in software development and also what Code First means. In the past, developers coded either directly from their application to a database. The application would either populate tables or call database server functions or procedures

Chrome will show ‘Not Secure’ warning for HTTP forms

Chrome will show ‘Not Secure’ warning for HTTP forms

Google have started emailing webmasters to let them know about their plan for all web traffic to be delivered through an encrypted channel. This means delivering all web pages via HTTPS rather than HTTP. They are modifying their Google Chrome browser and have already made some changes earlier in the year. If a form delivered by standard text (HTTP) has a credit card or password field then Chrome already flags up in the address bar that it is ‘NOT SECURE’. The next step comes in October 2017 with the release of Chrome 62, although the exact date of the release has not been announced. In version 62, Chrome will treat

Publishing Visual Studio web app to Azure PaaS

Publishing Visual Studio web app to Azure PaaS

In this article, I will use Microsoft Visual Studio to create a web application, published publicly as a Web App to the Azure cloud. This is the first in a series about using Microsoft tools and the Azure cloud that I want to write. This will just use a very simple example to show how quickly you can publish a website to the Azure cloud without any complicated servers to install or configure. It really is simple but will get more complicated in future articles when I will explore more in-depth scenarios and a continuous integration and delivery model. For the moment, we don’t want anything complicated so we will

My experience using the Duolingo German language course

My experience using the Duolingo German language course

When I added a websites section to my blog I always intended to showcase sites that I found interesting or useful. Today, I would like to walk through a website called Duolingo that helps language students keep their skills fresh. The site can be found at https://www.duolingo.com/ or on a mobile device using the respective application store. Four months ago, I thought I would see if I could learn a language from scratch just by using the Duolingo website and mobile app. In the past, I have learned a little French and Spanish so I couldn’t use them. It was a friend from Romania that pointed me to the site

Applying conditions to AVERAGE, SUM and COUNT functions in Microsoft Excel

Applying conditions to AVERAGE, SUM and COUNT functions in Microsoft Excel

This is my first article on Microsoft Excel in over two years and continues the series with descriptions and examples of applying conditions to the popular Excel SUM, COUNT and AVERAGE functions. I started writing this article about 6 months ago when one of my friends asked me how to count the number of occurrences in a spreadsheet where a condition in another column was true. I had thought that I had already written such an article and was about to point her to it but it wasn’t there. I remember it was on my list of articles to write about Excel but I’d obviously not written it yet. Anyway,