Read 9 min

I have tested hundreds of applications for planning and scheduling in construction. What strikes me is that all of them are trying to read our mind about how we run our business, make assumptions about how we operate, and make generalizations about the dynamics involving the people we employ. Most of them are in love with their application, not us.

Recently I took a Toyota or TPS approach to making long term decisions for scheduling applications in construction. I applied the advice to, “only use proven technologies,” and, “make decisions as a group slowly and implement fast” to the question of what applications I could recommend for construction scheduling. Here is what I found…

Only two softwares come to mind when I think of what I can promote when it comes to planning and scheduling (especially in a Takt system) for construction. At the top of the list is Excel. If Microsoft is doing 1 thing right it is Excel. Many builders achieve a high level of success because they have learned and utilized Excel for their work. I have had the privilege of training and teaching many people like this, and most are further down their career path than those who have not chosen to learn Excel. To give you the same gift, I have chosen to write this blog post where I highlight my favorite tools in Excel and how you can build any schedule with it.



The image above is a great reference included to help kick start you on an amazing Excel journey. Before you Excel experts click away I have one final offer:

We have a world class training that can teach anyone in construction to use Excel to manage any size of project. You will learn to stabilize your project and give yourself back the time you needed to optimize your operations. Sign up today and come join the builders who have found their work life balance.



Here are some of the best tips we have for any Builder wanting to sharpen their skillsets:

Formatting – We will start by showcasing formatting tips to make your content visually appealing and understandable. Please experiment with these on your computer.

Formatting Tips

Fonts & Sizes


Cell Color Fill

Font Color

Bold, italics, Underline


Format Cell Alignment

PRO TIP – Format Paint

HOT KEYS – If you want to go fast in Excel, use Hot keys. There are a few that you need to learn to be proficient. I set my left hand by the keyboard ready to use any of the commands below at a moments notice. Here are my favorites:

Hot Keys Tips

Copy – Ctrl + c

Paste – Ctrl + v

Undo – Ctrl + z

Cut – Ctrl + x

Select All – Ctrl + a

Save – Ctrl + s

Find – Ctrl + f

F7 – Spell Check

For more hot keys go here: (Click here)

Move by Highlight – When you need to move something, simply highlight it and move it with your cursor. (beware of merged cells).

Special Paste – Excel has added more paste options so keep testing them out and see what they do. Here are my new favorites:

Special Paste List



No Boarders

Keep Source Formatting


Values and Source Format

Paste Picture

Paste Link

PRO TIP – Transpose (this takes things that are horizontal and pastes them vertical or Vice a versa.


Sum, Count, Average by Highlighting – This will save you a lot of time. At the bottom of your screen you will see the list showing these sums when you highlight a group of cells. This will save you time in needing to create formulas.


Creating a List – Ever see people make a drop down of things to pick from? Jealous? Don’t be, just do this:

Step 1 create a list:

Select the Data Tab in the Ribbon and then Data Validation:

Make Sure the Allow has selected (List), and then select the list you just created by clicking this source button:

You just did it, you are now in the cool club:

There are a lot more things to learn, but you can start here and keep learning. Soon enough you will be addicted to Excel and able to complete to use it for your scheduling tasks. If you liked this please drop us a line or a comment.



If you want to learn more we have:

-Takt Virtual Training: (Click here)
-Check out our Youtube channel for more info: (Click here) 
-Listen to the Elevate Construction podcast: (Click here) 
-Check out our training programs and certifications: (Click here)
The Takt Book: (Click here)

Discover Jason’s Expertise:

Meet Jason Schroeder, the driving force behind Elevate Construction IST. As the company’s owner and principal consultant, he’s dedicated to taking construction to new heights. With a wealth of industry experience, he’s crafted the Field Engineer Boot Camp and Superintendent Boot Camp – intensive training programs engineered to cultivate top-tier leaders capable of steering their teams towards success. Jason’s vision? To expand his training initiatives across the nation, empowering construction firms to soar to unprecedented levels of excellence.

On we go!