#### Archive

Category Archives for "Computer Training"

## Canvas Basics – 04 Move An Object Using The Keyboard

This is the fourth part of a series of posts looking at the <canvas> element in HTML5. I have been using the canvas element to create games and over this series of posts will look at some of the Canvas basics. This is a follow on from the posts looking at maths in games (click […]

## Canvas Basics – 03 Moving An Object

This is the third of a series of posts looking at the <canvas> element in HTML5. I have been using the canvas element to create games and over the next few posts will look at some of the Canvas basics. This is a follow on from the posts looking at maths in games (click here […]

## Canvas Basics – 02 Mouse Detection

This is the second of a series of posts looking at the <canvas> element in HTML5. I have been using the canvas element to create games and over the next few posts will look at some of the Canvas basics. This is a follow on from the posts looking at maths in games (click here […]

## Canvas Basics – 01 Hello World

This is the first of several posts looking at the <canvas> element in HTML5. I have been using the canvas element to create games and over the next few posts will look at some of the Canvas basics. This is a follow on from the posts looking at maths in games (click here to read […]

## Maths In Games Pythagorus and Trigonometry

This is the 4th post in my Maths In Games series, and this is covering the topic that started this whole series. The day I was working on coding a pinball game and I had to apply Pytagorean Theorem and I had a flash back to my school days where I had to sit through […]

## Maths In Games Variables and Physics

This is the 3rd post in the Maths In Games series. The previous posts have given a very brief overview of some of the ways that maths can be used in computer games. Had algebra been explained to me in school using examples of its use in games, it might have made things more interesting […]

## Maths In Games Algebra

In the last “Maths In Games” post (click here to read Maths In Games Intro), we used X and Y coordinates to place our character on screen. This time we are going to talk about algebra and moving our character around. Algebra is the part of mathematics in which letters and other general symbols are […]

## Data Validation List Based On Criteria

In earlier posts, we covered data validation list, from basic to more complex rules.  In this post, we will create a rule for a Data Validation List that will be dependent on another value. If you want to read back over earlier posts, you can click on the links below. Introduction to Data Validation Lists […]

I have seen a lot of people using the AutoFilter (Filter) in Excel with ease, but I’ve been surprised to see that not many people use the Advanced Filter in Excel which, when dealing with lots of information or applying several filters, can save time and effort. In this post I will quickly go over […]

## Animate In Excel 2

In the last post I showed you a macro that would animate in Excel.  In this post I will show you another way I animate in Excel. It is a bit less technical than the last and uses the RANDBETWEEN function to change a chart and conditional formatting to change some colors. This is a […]

## Animate In Excel

When creating a logo for my next site, I wanted to do it completely in Excel and then I later decided to animate in Excel. The logo itself is relatively straightforward using Excel’s shapes. The image below shows the final logo and also the shapes used to make it. I used Excel’s Drawing Tools to […]

## Data Validation List To Automatically Update Source Range

The last 2 posts looked at some Data Validation options in Excel for either a short list or a set range of cells. This time we will use a formula in our Data Validation rule that will work out what range of cells to base the list on. Data Validation Rule To Update As List […]

## Data Validation List Based On Range Of Cells

In the last post we created a short Data Validation List where we typed in the options for our drop-down list. This time we will create a Data Validation List based on a list in a range of cells. In this example we will create Data Validation Lists to column A and the options in […]

## Data Validation List In Excel Introduction

In the next few posts we will look at Data Validation Lists in Excel.  You may have seen these and called them drop-down lists.  We will start with the most basic form of a small Data Validation List and then get more advanced. For this post, we will create a Data Validation List based on […]