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 section is dedicated to modeling the 3D perspective effect in Excel 2003 standard.
Excel Animation Tutorial – 2D Wire-frame House #2 (adding rotation)
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)"
Excel Animation Tutorial – 2D Wire-frame House #1 (build, scaling, x&y translations)
In this tutorial, a very simple 2D house will be built from scratch. Three parameters, will then be set up to control the scale, x offset and y offset. A demo macro is then created to animate the house with the three parameters changing in time. The purpose of this tutorial is to demonstrate at a very basic level how… Read More... "Excel Animation Tutorial – 2D Wire-frame House #1 (build, scaling, x&y translations)"
Excel Magic Animation
A collection of animated models in Excel. They were created using cell formulas and VBA. No add-ons or any kind of plugins were used. Read More... "Excel Magic Animation"
Cars and Yoga – Excel Animation Discussion
>. In this brief video, I am introducing an old yoga animation, together with a fresh driving car model which is a work in progress. You will soon be able to download both of them from excelunusual.com. Enjoy! 0:00 hello my friends and welcome back 0:03 i just found today is gonna be a very 0:05 short video i found… Read More... "Cars and Yoga – Excel Animation Discussion"
Excel Animation – the Virtual Joystick Tutorial #2
>. 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"
Excel Animation – the Virtual Joystick Tutorial #1
>. 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"
Dance of the Constellations – Excel Animation
An Excel animated model using Free shapes created by a VBA (Visual Basic for Applications) routine. A conditional “Do” loop runs the show. Every loop cycle the stars and connecting lines are deleted and new ones are formed in different positions. The sizes, positions and colors are controlled by harmonic functions (sin/cos(x)). Visit excelunusual.com for more Excel animations. Enjoy! Thanks… Read More... "Dance of the Constellations – Excel Animation"
The ActiveX Spin Button tutorial – VBA tricks for Excel Animation
>. 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"
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 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"
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 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"
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 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"
Excel Roller Coaster Update #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"
How to make a realistic looking digital clock in MS Excel – Part #4 – (create a clock face layout – PowerPoint design)
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)"