This is the fourth part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites. The sprites are created in PowerPoint and imported in Excel as images. This part (part #4) deals with planning the clock face layout. How to make a realistic looking digital clock in MS Excel – PartContinue Reading

Digital Clock Tutorial - Part #3

This is the second part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites. The sprites will be created in PowerPoint and imported in Excel as images. How to make a realistic looking digital clock in MS Excel – Part #3 This part (part #3) demonstrates how to use veryContinue Reading

About Excel animation and Excel games – an introduction:   Hello everyone, in this section we will be talking about sprites and and how to use the sprites in MS Excel to create animation. This is going to be a general discussion, a demonstrative, introductory talk. It shows you what we can do with sprites in Excel. In general language,Continue Reading

I am including a preview of our next series of tutorials about creating wireframe animations and games in MS Excel. These wireframe animation methods can be used in various engineering Excel models, as well as in scientific models and games in Excel. This training will be about creating a simple internal combustion engine 2D model in MS Excel. Join outContinue Reading

This is an introductory video about creating, scaling and animating wireframe shapes in MS Excel. The tutorial is made from the ground up starting with a blank workbook. A square is created. Scaling factors are added which can turn the square into a custom size rectangle. The tutorial demonstrate the use of VBA driven spin buttons and also VBA drivenContinue Reading

This is the second post on Excel speed. This has serious implications in creating usable Excel animations. The first part benchmarked the calculation speed of Excel 2003 versus Excel 2007 for various size arrays of formulas. This part analyzes the effect of formula complexity on the spreadsheet speed. About the speed of animated models in MS Excel – part #2Continue Reading

This is an Excel animation and an engineering model of a Buck voltage switching regulator. Excel 2003 was used. Besides real time control of  common parameters such as switch ON resistance, load current, load capacitance, output voltage (vout), input voltage (vbat) etc, the user can also run very specialized tests in which the output current and “vbat” can be modulatedContinue Reading

This post considers several aspects about improving the speed of spreadsheets in both MS Excel 2003 and 2007. It has significant effects on animations in MS Excel. In this first part, a “stopwatch” macro is described which, when incorporated in any of calculation loop, can measure the frequency your loop is executed. In this first part of the tutorial theContinue Reading