All articles with 'Check Box' Tag
Modeling tiles in a room using Excel Conditional Formatting
Last week we learned how to answer questions like, “How many tiles in a room?” using Excel. We learned about CONVERT function and fraction number format settings in Excel.
But why stop at calculation? We can even model a room full of tiles, thanks to Excel’s grid nature.
So today, we will learn how to create a room layout as shown above, using Excel.Continue »
Form Controls – Adding Interactivity to Your Worksheets
Excel can be a bland collection of cells with text and numbers or it can be a playground where you can have interactive engagement with your models.
The choice is yours!
Excel provides a small number of tools to allow you to interact with your models.
These tools are called Form Controls and can be added into and linked to your models data.
This post will look at the various types of Form Controls and discuss their application and use.Continue »