All articles with 'Check Box' Tag

Modeling tiles in a room using Excel Conditional Formatting

Published on Apr 22, 2014 in Charts and Graphs, Learn Excel
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

Published on Mar 30, 2011 in excel apps, Excel Howtos, Huis, Learn Excel, Posts by Hui
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 »