#### Tag Archive

Tag Archives for " Tutorials "

## OEE Solution – Querying Various Sheets

In this post we will pull together formulas that we’ve seen in these posts Formula to get first, second and third highest values Formula to get last row number http://blog.thejaytray.com/excels-indirect-function/ Data Validation Lists COUNTIF Function Before continuing, if you are not familiar with the above posts or functions I would recommend reading them.  Although I […]

Continue reading

## Pareto Chart In Excel

Although there are Excel add-ons and more recent versions of Excel make it easier, for a lot of people Pareto charts are still awkward to put together. A pareto chart is a type of chart that contains both bars and a line graph. The bars show the individual order of items in descending order and […]

Continue reading

## Formula to get first second and third highest values

In this post I will show you how to look up the first, second, third and so on values.  This formula can also be used to create Pareto charts which I will also go through in the next post. In previous posts I touched on the idea of having a file that could quickly query […]

Continue reading

## FORMULA TO GET LAST ROW NUMBER

In Excel, you can write a formula to get the last row number containing data. At first, it’s not an obvious formula, but using Excel’s own logic and  lookup function can give you the answer. When i was first asked by somebody for a formula to get the last row number I almost immediately saw […]

Continue reading

## Excel Option Buttons

It’s been a while since I posted about Excel macros, so I think it’s time I touched on this subject again.  In this post we will add Option Buttons to a sheet and have that sheet change based on the selected option. With Option Buttons, only one option can be selected at a time. If […]

Continue reading

## Excels INDIRECT Function

The INDIRECT “function returns the reference specified by a text string”.  What does this mean and why would I use it? I have seen people have problems with amending formula to reference different sheets in particular, most of them just recreate the formula rather than trying to amend it. One of the ways around this […]

Continue reading

## Speedomoter For Excel Dashboard

Help creating the speedometer chart for displaying information is becoming a more common request I receive. As the information available to us increases, so too does the reporting requirements. Dashboards are becoming increasingly common and while there is a lot of great software out there for displaying information in a dashboard format, there is no […]

Continue reading

## Canvas Sprite Sheet Animation

Having gone through moving shapes around screen, let’s bring our retro game tutorials up to date by about 10 years and look at sprite sheet animation. If you have been following the series of posts linked below, then this will add to what you have done so far and you will see some things being […]

Continue reading

## Canvas Snake Game Tutorial

Feeling nostalgic and looking to create your own phone game Snake? This game tutorial will show you how to create it using just a simple text editor and web browser. If you have been following the series of posts linked below, then this will add to what you have done so far and you will […]

Continue reading

## Canvas Basics – Arkanoid Game Tutorial

Whether you know it as Breakout, Arkanoid or any of the many names the game is known as, this tutorial will show you how to create Arkanoid using just a simple text editor and web browser. Over the last few posts, we have been looking at elements of code for gaming and we even created […]

Continue reading

## Canvas Basics – 09 More On Arrays

This is the ninth 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 covered the main elements needed to create a basic Pong-style tennis game.  In this post, […]

Continue reading

## Canvas Game Tutorial Pong

After several posts about Canvas and game code, we are finally ready to put together our first game, Pong in this game tutorial. For those of you too young to remember 2d games or why it was so important for Marty McFly’s parents to kiss at the dance…. Pong is a basic tennis-style game. The […]

Continue reading

## Canvas Basics – 08 Bouncing And Deflecting

This is the eighth 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 reading

## Canvas Basics – 07 Random Positions

This is the seventh 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 reading

## Canvas Basics – 06 Collision Detection

This is the sixth 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 reading
Follow

### Follow The JayTray Blog

Get every new post delivered to your Inbox

Join other followers: