This is a continuation tutorial, the third in the wire-frame tutorial series. Here we take the 2D basic house we created on an 2D scatter chart that had scaling, translations and rotation and replace all the cell formulas with two user defined functions (UDF). These basic tutorials use elementary math/geometry and trigonometry (middle school and high school level). As the… Read More... "Excel Animation Tutorial – 2D Wire-frame House #3 (adding UDF – user defined functions)"
This is a continuation tutorial, the second in the wire-frame tutorial series. Here we take the 2D basic house we created on an 2D scatter chart and introduce rotation. These basic tutorials use elementary math/geometry and trigonometry (middle school and high school level). As the series progresses, the tutorials will reach 3D level and the creation of more complex shapes… Read More... "Excel Animation Tutorial – 2D Wire-frame House #2 (adding rotation)"
>. This tutorial brings up an older topic from my blog, excelunusual.com. It is the second part of a short series, showing in detail, how to create a virtual joystick in MS Excel/VBA to serve as a game controller. The Excel file will be available for download on my blog, excelunusual.com. Enjoy! 0:00 Hello my friends and welcome back 0:02… Read More... "Excel Animation – the Virtual Joystick Tutorial #2"
>. This tutorial brings up an older topic from my blog, excelunusual.com. It is the first part of a short series, showing in detail, how to create a virtual joystick in MS Excel/VBA to serve as a game controller. The Excel file will be available for download on my blog, excelunusual.com. Enjoy! Hello my friends and welcome back today 0:02… Read More... "Excel Animation – the Virtual Joystick Tutorial #1"
>. This tutorial brings briefly introduces an older airplane/Ninja cat animation, then it shows how to flip a logic (Boolean) variable using the operator “Not”. Most of the tutorial however, is centered toward the Active X control button in Excel animation and the associated macro. It shows how to create and customize this button, then it shows how to introduce… Read More... "The ActiveX Spin Button tutorial – VBA tricks for Excel Animation"
By popular demand I am coming back to Excel after a long hiatus. This is the third in the series of beginner level tutorials targeted to building Excel animated models and games. >. This is the third part of the video tutorials about one of the most important Excel animation macros (or sub routines). It’s the “toggle” macro built pretty… Read More... "The Start-Pause VBA Macro for Excel Animation, tutorial – part 3"
By popular demand I am coming back to Excel after a long hiatus. This is the second in the series of beginner level tutorials targeted to building Excel animated models and games. >. This is the second part of the video tutorials about one of the most important Excel animation macros (or sub routines). I am reviewing there (with PowerPoint… Read More... "The Start-Pause VBA Macro for Excel Animation, tutorial – part 2"
By popular demand I am coming back to Excel after a long hiatus. This is the first in the series of beginner level tutorials targeted to building Excel animated models and games. >. Past a few minutes of introduction into a 4-stroke engine Excel animation model, the video dives into how to build the first and perhaps the most important… Read More... "The Start-Pause VBA Macro for Excel Animation, tutorial – part 1"
By popular demand I am coming back to Excel after a long hiatus. This is an update of an older model previously presented on this blog. > I added a few features to the roller coaster model as follows: 1) Performance log 2) All sorts of colors and color scheme selection 3) Speed control 4) Coaster length adjustment 3) Ground… Read More... "Excel Roller Coaster Update #1"
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 – Part… Read More... "How to make a realistic looking digital clock in MS Excel – Part #4 – (create a clock face layout – PowerPoint design)"
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,… Read More... "Sprite Animation – what are sprites and how to use them in Excel animation and Excel games"
This is a preview of a minigun Excel animation, that I developed in MS Office. This animated model could be used in future Excel games. I created the graphics in PowerPoint while the animation is being run 100% by VBA code. Join our group to find out more: https://www.facebook.com/groups/excelunusual/ Enjoy, George Read More... "A minigun animation in MS Excel for Excel games"
This is a model I made quite some years back to model the stability of an air compressor driven by an electric motor. The purpose was also to try to select the motor parameters, transmission ratios, energy loss in the flexible couple. I will make the Excel file available at a later date. Read More... "Electric Motor & Air Compressor Excel Animation – Dynamic simulation demo/preview"
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 out… Read More... "How to Create a Wireframe Internal Combustion Engine 2D Animation in MS Excel – Preview"