#### Tag Archive

Tag Archives for " computer training "

## Canvas Basics – 05 Limiting Movement To Canvas

This is the fifth post in this series looking at the <canvas> element in HTML5. Each post will give a new element of snippet of code that can be put together to create your own games. So far we have displayed text on screen, looked at the mouse’s X and Y co-ordinates on the canvas, […]

## 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 […]

## Maths In Games

This post and the next few will cover “Maths in Games”. The idea came to me after talking to different friends about their kids in school and how very little has changed over the years. When I was their age I used to sit through Math classes wondering why I would ever need to know […]

## 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 […]