- Home
- Tutorials
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, […]
Continue readingCanvas 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 […]
Continue readingCanvas 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 […]
Continue readingCanvas 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 […]
Continue readingCanvas 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 […]
Continue readingData 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 […]
Continue readingAdvanced Filter in Excel
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 […]
Continue readingAnimate 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 […]
Continue readingAnimate 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 […]
Continue readingData 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 […]
Continue readingData 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 […]
Continue readingData 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 […]
Continue readingExcel Format dates to include st, nd,rd and th
In an eBook “Date Functions”, I showed you a formula that would include st, nd, rd and th to a day number, so 14 November would display as 14th November. I have since been asked by some people if it is possible to format dates to include st, nd, rd and th. The answer is yes, you […]
Continue readingSum By Color in Excel
With improvements to the last few versions of Excel I see people using colors in cells more, the ability to filter by color adds to the benefit of using fill colors. However, the increasing use of colors has led to the increasing number of requests for help I receive to sum by color in Excel. […]
Continue readingExcels Scenario Manager
This post looks at Excel’s Scenario Manager function in 4 main sections. Setting up scenarios with the Scenario Manager Switching between scenarios Creating a summary report comparing scenarios Overcome one of the downfalls of scenario reports – making sense of “changing cells” If you are familiar with the scenario manager summary reports already but want […]
Continue reading