The world’s most-used spreadsheet shows up in such a wide variety of places that it’s sometimes easy to forget just how much it can impact a business. Far beyond just tracking the bottom line, even a relatively straightforward business like an auto shop can find several uses for Microsoft Excel.

10 Top Uses For Excel in an Auto Shop

Tracking the Bottom Line: Yes, it’s true! You can put Excel to use by giving it your income and your outgo and having it chart your profits over time.

Inventory and Ordering: With a little bit of wizardry, Excel can not only keep track of how much inventory you should have, but it can Email you an alert when you get too low on a particular product, making ordering a breeze.

Doing the Schedule: Of course, Excel can be used to graphically display what times any given employee will be on the clock and thus make it easy to ensure that all of the necessary coverage is there for you.

Customer Tracking: Few businesses need to track customers more accurately over a longer period of time than an auto shop; Excel offers you the power to do just that. By setting up an entry form that gathers the necessary information and then stores it deep in another sheet, you can easily keep records on hundreds of customers and their vehicles over months and years.

Receipts: Because of an auto shop’s specific needs when it comes to breaking down parts, labor, taxes, and other charges, Excel makes for an excellent receipt-making program.

Invoicing: Speaking of templates, Excel comes equipped with a wide variety of templates for invoicing services — like laundry service for your work grubs.

Create Recommendations: Whether you put it on your receipts or on your work orders, Excel’s ability to add drop-down menus to a cell can make it easy for your employees to select an extra bit of maintenance that a customer’s car could use.

Maintain Service Histories: The same drop-down menus that power the ability to offer maintenance recommendations can be used to create standardized service histories that are easy to read and use.

Work Orders: A simple Excel template will allow you to create standardized and easy-to-read work orders that can be printed, modified, and saved with ease.

Customer Reminders: This is clever. Excel can be programmed to send an Email when a cell gets beyond a certain limit — so if you’re doing oil changes that should be done every few months, just collect the customer’s Email address and have Excel use it to send them a helpful Email a few months after they had their oil changed last!

The powers that Excel can offer your auto shop stretch so far beyond merely watching the profit margins that if you’re not using it for more advanced functions, you’re losing out. Stretch it’s wings! Set some automatic alarms for your inventory and some automatic Emails for your customers, and see what Excel can do for you!… READ MORE


When you start to see a pattern in behavioral issues; such as an employee coming in late, here are the things you need to consider:  1) If you don’t nip it in the bud it will get worse. 2) Employees need to be responsible for their own behavior. 3) They need to know why you have a special policy. So, next time an employee starts developing bad behavior patterns, such as arriving late, calling them to the private environment and asking them why they are late. When they have given you their explanation, say something like this …

Employees Coming in Late

“Mike, I realize you’ve been late four times now this month, and let me tell you what concerns me. First of all, if you’re not here at 7:30 in the morning, the first thought that comes to mind is that you or someone in your family might be sick or injured, and you might need my help.my second thought was that your car might be damaged, or you might be in an accident, and I began to wonder if I should send Larry or Frank out to look for you. complicates matters even further, when you are not here on time, and I stand at the service counter, I don’t know what to tell customers who ask me if their car will be ready for the day, and then there’s one more thing, Mike. I just can’t expect anyone else here at Acme Auto Body to be here on time when you don’t, now that I know old habits are hard to break, so this is what I will do. Next time you are late, I will ask why, but it really doesn’t matter because that one will happen to me. If you are late, once again I will ask why, and that will happen to me too. But if you are late for the third time, for whatever reason, it will be a difficult day for me, Mike, because what I will do is call you to my office, and I will give you your final salary check. Mike, I want to be clear with you. I think of your world, and I will be happy to be working with you for the rest of my life. You are a star, you really are, and I don’t want to see our relationship end, so please don’t put me in a position where I have to let you go. Do we have understanding, Mike? “

Now this is why this is an easy and powerful way to solve behavioral problems. First of all, many employees will think, “Gosh, what’s a few minutes?” They will tell themselves that they often work through breaks, overtime, etc., so you can see how easy it is for them to think that you are not only choosing, but that you are being very unfair. That is why it is very important for you to tell them that it is not the minutes you are worried about; instead, … READ MORE


Perhaps you’re a former truck driver, who wants to stay closer to home, or maybe you’re ready for a career change after many years doing dispatch, but you don’t want to switch out of the field or waste your training and experience. The right transport operations training can only build on what you’ve got already, launching a new career or helping you advance. Continuous skill updates are the reality in most industries and transportation, driving and freight are no different.

Drivers

Past truck drivers should consider a switch into a dispatch role. You heard their voice on the radio while you were on the road, and just as you learned to understand what they were saying, you already have most of the basics to get you off the ground. Add some formal dispatcher training, available in a variety of educational formats, and you’re well on your way to trading the driver’s seat for the comforts of a control centre chair, and hands on a steering wheel for a headset. Your industry experience will also be especially appealing to employers because you’ll know all the challenges that drivers face, and all the rules and regulations.

Dispatchers

If you have existing dispatcher training, that means that you’re already at least part way to being qualified radio operator, complete with formal certification. While the technology has been around for a great deal of time, its reliability keeps it relevant even in the face of advances in mass communication. In fact, with the use of satellites and the role of radio waves in cell phones you may already be on the cutting edge of technology. You could take this into a career in radio broadcast, including safety warnings or fire monitoring, or if you’re particularly gifted with technology, your knowledge of the switchboard could even translate into further electrical or automotive technician training.

Mechanics

People who have automotive technician training are also well on their way to more. This could mean going back to a mechanic school for more certification so you can command a higher salary by adding auto body repair or other specialties to your resume, or learning some business and sales training to start your own garage or dealership franchise, but also the possibility of owning a freight business. As you already understand the full workings of a car you’re ready to do your own maintenance and know it’s up to code. Alternatively if you are tired of the same views through your garage bay doors, you could retrain through transport operations training and become a driver. You could see the entirety of the country as you drive between cities or enjoy a bustling schedule making downtown deliveries. This is a good career for extra money in retirement, because it is not as physically demanding as your job as a mechanic, and if you’ve had a lifetime of servicing engines, you’re more than ready to tackle the road.… READ MORE


Auto technicians use each wrenches and pc programs with equal ease..  Cars today operate with the assistance of laptop systems that control heating and cooling systems, fuel feed, ignition and and several of the conveniences such as the sound system and GPS programs.  The challenges for auto technicians today include the traditional variations in design and functionality used by various auto makers.  Equally challenging is the fact that auto producers continually upgrade the technology used to operate today’s vehicles.

You can study with auto manufacturers.  In order to keep auto technicians up to date many manufacturers operate training schools  who want to learn from the source.  Nissan, BMW, Toyota and Ford all offer training programs that lead to certification. Continuing education is also offered by many of the other auto makers; sometimes those courses are available at automotive vocational schools. The changes in each design and complexity for the inner workings of automobiles change much more rapidly today than a generation ago

Choose an area of expertise.  Most auto technician training facilities separate their teaching into three areas:  Basic auto repair, collision repair, and diesel maintenance and repair.  Diesel mechanics typically work on  buses and trucks.  The salaries for all three of these options have a variation of about ten percent among them, according to the Department of Labor.

Many automotive professionals seek certification.  The National Institute for Automotive Service Excellence (ASE) offers a testing program that leads to certification, a factor that can be important to employers.  The general requirement for taking the ASE examination is two years of experience in the field, but graduation from an automotive vocational program can be substituted for one of those years.  For automotive repair alone, there are eight specializations such as brake repair and ignition systems that are available for ASE certification, each with its own exam.

Consider whether your preference is working for a dealer or for a repair shop.  This isn’t a decision you need to make immediately, your school offers special courses for individual brands, as some do. Usually selecting one of these additional courses adds a few weeks to the educational program, which are generally about a year in length. If you choose to study the workings of Volkswagen or BMW autos, for example, it will be an excellent addition to your resume but may limit your options for seeking employment.

Give some thought to becoming a manager. Some automotive vocational schools include classes in business management and the oversight duties involved in running a shop.   If you want to learn these skills at the beginning of your career, find an academy or community college program that includes them.  And whether or not you choose to pursue management opportunity,  continuing education will be a part of your life.  A good question on a job interview is whether or not the employer pays for refresher courses for the staff professionals.… READ MORE


In today’s financial climate, shoppers are attempting to come across solutions to save revenue. As well as the elevated cost of gasoline, proper vehicle upkeep is becoming additional high priced every single day. Customers can save a substantial level of funds by getting strategies to acquire low cost tyres. Beneath are a few of them.

Salvage yards

There are many cars, trucks and SUV’s which have been wrecked and sent to the salvage yards. Most still have really very good components on them and are sold as applied. This involves promoting their applied tyres. With such a huge choice of automobiles, the chances of locating employed affordable ones that should match a distinct automobile is higher. The very best issue about getting employed tyres at salvage yards is that they’re ordinarily very inexpensive.

The treads may be checked to view if they pass inspection by sticking a penny or possibly a nickel inside the indenture involving them. When the head is not displaying, the tyres need to pass. Also, to assist make certain that the tyres have not dry-rotted, check the inspection around the front windshield. If it is actually not very old, the tyres need to be okay.

Service stations

A lot of service stations repair and alter automobile tyres. At instances, buyers ask for their tyres to become changed off even if they nonetheless have lots of tread on them and they could nonetheless pass the state inspection. A few of these stations retain the employed tyres. Asking them if they have any for sale may well give a inexpensive option to acquiring new ones. Service stations must spend to dispose of any tyres that they do not choose to maintain so they very nicely might sell them.

Division discount shops

Some of the significant division discount stores carry automobile supplies. Numerous of them sell these supplies significantly much less than regular auto shops. Tyres could be purchased usually at 20 to 30 percent discount.

Tyre discount shops

Tyre discount stores usually supply wider selections when looking to find affordable tyres. They buy in bulk and may sell them less costly than department discount stores. These stores may also be discovered on the internet. They might present extra incentives for shopping for them on the web, such as absolutely free shipping.

Auto tyre shops

Each and every so often, these specialty retailers will provide sales which can be truly very good buys. Tyres is often purchased rather cheaply. Some have even advertised that if a client buys a single tyre, the second tyre will be free. Other sales can involve affordable prices for tyres which are going to become discontinued and not sold within the future by them.

There are plenty of places that customers can look to buy definitely low-cost tyres. Following only a couple of minutes of browsing, actual bargains can be located.… READ MORE


When considering buying a new car, you really need to make sure whether you are buying out of necessity or desire. After all it is the one investment you will make that is guaranteed to depreciate in value.

Factors such as depreciation can be one of the biggest costs in buying a car. Even if you only buy a one-year-old vehicle, you’ll be incurring and dealing with some seriously large losses in the first year. These losses can be up to forty percent of the cars value.

Focus on the maths, and you may be able to purchase a better equipped, more powerful version of the model you want by opting for a used car. You might even be able to upgrade to a bigger, better model thanks to big second-hand savings. The way cars are made now, it doesn’t matter if there are a few miles on the clock.

Cars vary in terms of reliability and owner-satisfaction reports can show you which brands are proving robust and which are proving to be tricky. Make sure you do your homework or you could be left counting the cost of a bad buy.

Even if the car you desire is more than a few years old, it doesn’t mean it can’t be protected by a warranty. Most approved-used car schemes will provide 12 months of cover, and you can always take out your own policy with an quality, independent provider for a few hundred pounds or less

If you’ve got enough money in the bank and you’re determined to buy new, negotiate fiercely. Use a price guide to find out the kind of savings that you should be able to get on any brand new car, and you’ll offset some of those nasty depreciation losses I mentioned earlier.

Furthermore, a new car will also come with a full manufacturer’s warranty, which covers you for most usual faults free of charge. This usually gives you a decent period of peace of mind. Some companies are now even offering a warranty up to seven years to entice people to buy new.

Incentives, promotions and offers such as no-interest finance agreements are normally available to new cars, so this might be enough to influence you not to go down the used car route. Try and be wary of allowing this to shape your overall decision. Test the real value of these offers against the overall purchase cost.

One thing that you can’t argue with is that a new car will be to your precise specification, and you just can’t compare the feeling of sitting in your own new car for the very first time.

Go to a reputable website that offers reviews of cars, their prices and potential shortcomings before buying. It could save you thousands.

I hope that from reading this article you find it useful in helping you to make the best decision about your new car. It’s never easy easy coming to the right decision but the more research … READ MORE