Excel Magic: IGNITE your PROCESS NINJA POWERS

I don’t think it’s any secret that I LOVE Excel.  With all the love I have for Excel, I’m still greatly perplexed as to why more people don’t utilize this amazing software more.  Why most people only use it to put together a basic spreadsheet to add up a column or two of numbers.  

Come on people! Don’t you realize that excel can make your life sooooo much easier? Trust me on this one. Excel has been my main system for improving the lives of my clients!

I shared some of my tips for streamlining excel in a previous blog post – 5 Easy Tips to Streamline Your Excel Experience.

I don’t want to rehash these tips, rather I want to share with you some real-life examples of how I’ve improved my clients’ lives using only excel. 

Here are some examples:

  1. Weekly Report

    1. There was once a weekly report that took all day on Monday to create. Data had to be pulled from multiple sources of truth, reformatted, manipulated, and put into graphs/tables so that it would make sense to the higher ups. 


“8 Hours? Come on, we can do better”, I said.

And better we did! Using formulas, VLOOKUPs, PivotTables and Graphs, this weekly report no longer took 8 hours to do, it took 20 minutes.
8 hours down to 20 MINUTES!!! 


That’s a time savings of:

7.7 hours a week, 30.7 hours a month (3.8 days) and 

398.7 hours a year (49.8 days)


DAMN!!  Excel you’re crazy! I’m going on an extra vacation with that time!




  1. Quarterly Audit

    1. A busy admin had to audit her team members' information in 2 systems. There were over 300 employees to compare. The comparison was being done by hand. She was printing off two sets of information and going line by line. Is their name the same? Address? Employee number? Social Security Card? You get the picture. Yuck. 


She had only gotten ½ way through and it had already taken her a day and a half. 12 hours.  And only ½ way through. So, you’re looking at a 3-day process. Yuck again. 


Excel to the rescue. By creating a template with VLOOKUPs and IF equations, all that is needed is a dumb of the information from each system and then wall-a, excel tells you, within seconds, which information is the same and which information is not the same.  Maybe then spend a couple of hours reconciling the incorrect information, and bam, you’re done!


24 hours (3 days) down to let’s say 4 hours (1/2 a day)!!! 


On this quarterly task, that’s a time savings of:

20 hours a quarter and 80 hours a year (10 days)

I know, not as impressive as the weekly report, but a much better and more accurate process than going line-by-line.

Sold on learning excel yet? 

How could you not be after seeing that these two little examples, together, have an astounding time savings of almost 60 days a year. That’s 12 weeks!!!  3 MONTHS! 

What would you do with an extra 3 months a year? Go on vacation? Get more clients? Complete some of those projects that have been on your to-do list for forever? Be home for your family more?

Want to become your organization’s Excel Process Ninja and take extra vacation time with the time you’re saving them? 

If so, check out my FREE YouTube course:

Excel Magic Course: IGNITE your PROCESS NINJA POWERS

The tools I teach you in this course are literally the same tools I used in the above examples. LITERALLY!

Want to amaze people with your Excel Magic? 

You, your co-workers, your boss and your family will thank you for it!!  And tell your boss Sarah said you get an extra vacation day or two for your hard work! After you show them the time savings numbers, it will be hard for them to say NO!

Comments

Post a Comment

Popular posts from this blog

Worst 5 Outcomes of Covering Up Bad Processes with Additional Employees

Image
Bad processes can easily be mistaken for employee shortages. As systems fail to work well, it’s pretty common for employees to complain that they are overworked or unable to focus on their “real” duties due to focusing on an inefficient workflows. A standard response to the employee dissatisfaction is to hire more people to shoulder the load. But, without delving into the problem to determine is your employees are truly overworked, you are only masking a problem that may become a bigger problem, in time. Consider these worst 5 outcomes for adding employees, instead of solving bad processes: You will waste money. Recently, it was uncovered that the Pentagon has over $125 billion in bureaucratic waste, involving many unnecessary positions and employees. How did they get to that point? Many inefficient processes probably demanded the hire of new employees to make things run more “smoothly.” However, what has resulted is a gross display of waste. As you hire additional employees to cove
Read more

Manage yourself first: A guide to reduce workplace stress

Image
  Manageable demands and workplace stress are often spoken about in the same breath. And it's no wonder - with the ever-increasing pace of life, it can be difficult to keep up. For many people, the demands of work are becoming increasingly unmanageable, leading to feelings of stress and anxiety. It's important to remember that we all have a different threshold for what we can handle. What might be a manageable workload for one person could be overwhelming for another. The key is to find a balance that works for you. If you're starting to feel overwhelmed, talk to your boss or HR department about ways to lighten your load. You may also want to consider making some changes in your personal life to reduce the amount of stress you're under. By taking proactive steps to manage your workload and reduce stress, you can help ensure a healthy work/life balance. In today's business world, it's all too easy to get caught up in the culture of "hustle." With the al
Read more

How to Improve Employee Efficiency

Image
  As a business owner, you want to get the most value out of your employees. After all, one of the biggest expenses a business can incur is labor. However, you won’t get the most out of your employees’ efforts by making them work harder.  Instead, you should help them achieve the best results for your business by helping them work smarter and with the greatest possible ease. This is what improving employee efficiency is all about. Efficiency is doing things the right way, with minimal waste of time and effort. It is a key ingredient of productivity. So how do you improve employee efficiency? Here are 10 ways to do this: 1. Set clear goals with your team.  Goals give direction to your team’s efforts. Your employees need to be clear about what’s important so they will know where to focus their attention, time, and energy.  2. Make sure that employees have tasks that match their skills. Employees tend to be efficient with the tasks they’re good at. Also, they are more motivated when they
Read more