Hesco barriers are steel baskets with fabric in them that we fill with dirt overseas to create thick, protective walls. They are a very common feature on any site, and it would be nice to have a shape that distinctly looks like a Hesco barrier on the camps site diagram. Today I'm going to show you how to make that. Because its an individual cell that is usually never alone, I'm going to make a continuous shape or a multiple shape to accomplish this task.

What that means is that as I expand the individual Hesco, it becomes two side by side, then three, four, etc. eventually to make a full length Hesco wall. If you ever worked with Visio floor plans, you may recall a shape called Multi-Urinal or Multi-sink that has this ability. In abstract, what we are going to do is create a bunch of identical shapes, uniquely ID each one of them, and use formulas to determine their placement. We will also use a formula to hide/ unhide each shape in the group depending on how wide the group is expanded out to.

I first started out in IT as a platoon RTO. Part of the job involved doing the PSG admin work; rosters, statistics, maintaining the weapons MAL, etc. The vast majority of the work was done using Excel, which, at the time, I knew next to nothing about. Work that now takes me a couple minutes would take me about an hour because I didn't know anything about functions. This video contains all the stuff that I know now that I wish I knew back then.

It will cover formatting a spread sheet, several functions (which I unwittingly refer to as "equations") and touches on pivot tables and charts.