Split a Cell Diagonally

In this video I'll show two ways to diagonally split a cell. One way is a put a diagonal line through a cell and the other is to insert a shape object.

Create a Dynamic Chart with Checkboxes

If you want to show multiple views of a chart, sometimes it may involve letting your audience select some criteria so they can see different views of the data. You'd want to embed some kind of interaction for your users and putting together a dynamic, interactive chart may be your option. To learn how to create a dynamic combination chart (with check boxes to choose with chart series to show) check out this video.

Return Multiple Items with One Lookup Value

How to lookup one value and return multiple values associated with it. This is an array function that needs to be entered with the keyboard combination CTRL+SHIFT+ENTER, which essentially enters it as an array formula.